KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Questions tagged
database-design
249 questions · page 3 of 5
Follow Tag
Sort by:
Newest
Votes
Active
18
votes
9
answers
What's the point of a candidate key?
database
database-design
entity-relationship
relational-database
asked 2010-10-18T17:01:56.543
9
votes
7
answers
How to model complex data
sql
database-design
data-modeling
asked 2010-10-16T02:20:27.570
14
votes
2
answers
Social web application database design: how can I improve this schema?
mysql
database
database-design
schema
social-networking
asked 2010-10-02T05:11:40.463
9
votes
3
answers
Making a Twitter-like timeline with MongoDB
database-design
mongodb
asked 2010-10-01T10:50:11.243
30
votes
5
answers
Float or decimal for prices?
mysql
sql
sql-server
database
database-design
asked 2010-09-22T11:24:48.117
16
votes
10
answers
Relational database design question - Surrogate-key or Natural-key?
sql
database-design
data-modeling
surrogate-key
natural-key
asked 2010-09-19T22:27:07.943
14
votes
6
answers
Bad real-world database schemas
sql-server
database-design
postgresql
anti-patterns
asked 2010-09-11T09:55:43.943
11
votes
2
answers
Database modeller for JPA with visual diagrams
java
jpa
database-design
asked 2010-08-27T06:47:49.883
10
votes
5
answers
how to represent symmetric many to many relationship
database-design
asked 2010-08-23T17:31:58.590
23
votes
11
answers
Should referential integrity be enforced?
database
database-design
referential-integrity
asked 2010-08-23T05:23:55.340
19
votes
9
answers
How to generate a diagram of a very large database schema (SQL Server)
sql-server
database-design
schema
database-diagramming
asked 2010-08-17T14:01:21.513
16
votes
5
answers
Most efficient database design for a blog (posts and comments)
database
database-design
asked 2010-08-16T19:09:16.687
44
votes
9
answers
Is there a performance decrease if there are too many columns in a table?
mysql
database
database-design
schema
asked 2010-08-13T07:44:21.853
36
votes
3
answers
How are bitmap indexes helpful?
database
algorithm
database-design
indexing
bitmap
asked 2010-08-10T18:58:59.967
11
votes
4
answers
How Do I aggregate Data By Day and Still Respect Timezone?
sql
database
database-design
data-warehouse
asked 2010-08-06T22:30:06.987
16
votes
5
answers
SQL Data Type to store build versions
sql
mysql
database
database-design
asked 2010-07-31T18:15:12.377
15
votes
6
answers
performance between varchar(1) vs char(1)
database-design
data-modeling
asked 2010-07-30T02:13:27.547
46
votes
4
answers
Where should I store a foreign key?
mysql
database
database-design
data-modeling
asked 2010-07-20T19:50:48.750
10
votes
6
answers
How would you implement twitter using a noSQL kind of DB?
database-design
caching
twitter
nosql
asked 2010-07-12T12:00:40.650
99
votes
8
answers
MySQL - how to front pad zip code with "0"?
sql
mysql
database
database-design
asked 2010-07-08T04:56:31.577
11
votes
6
answers
Best Practice for Foreign Key column position in table
sql
database
design-patterns
database-design
asked 2010-07-06T01:14:31.990
11
votes
3
answers
How to implement a super class, sub class relationship in the database?
database
database-design
class-table-inheritance
asked 2010-07-05T16:19:56.437
11
votes
2
answers
Table design for user's information as well as login credentials?
database
performance
database-design
information-schema
asked 2010-06-29T00:27:32.390
11
votes
6
answers
Guid Primary /Foreign Key dilemma SQL Server
sql
database-design
guid
asked 2010-06-08T09:12:37.543
14
votes
4
answers
(Database Design - products attributes): What is better option for product attribute database design?
relational-database
entity-attribute-value
database-design
asked 2010-05-31T17:23:16.073
17
votes
3
answers
How to move an element in a sorted list and keep the CouchDb write "atomic"
database-design
data-structures
transactions
couchdb
atomic
asked 2010-05-30T21:10:36.243
22
votes
4
answers
Database with "Open Schema" - Good or Bad Idea?
database
database-design
schema
database-schema
asked 2010-05-18T02:59:24.407
23
votes
5
answers
Foreign keys and NULL in mySQL
mysql
sql
database-design
foreign-keys
database-relations
asked 2010-05-10T12:26:25.000
11
votes
4
answers
Where are all the native revisioned databases?
database
database-design
version-control
revision
asked 2010-04-27T19:06:31.623
24
votes
6
answers
Does introducing foreign keys to MySQL reduce performance
sql
mysql
database-design
asked 2010-04-11T19:27:30.500
10
votes
3
answers
how to guarantee atomicity across two databases (the filesystem and your RDBMS)?
database-design
asked 2010-03-26T18:40:07.743
11
votes
2
answers
postgresql: foreign key to either tableA or tableB
sql
database
database-design
postgresql
asked 2010-03-24T17:28:51.927
59
votes
2
answers
Database schema design for a double entry accounting system?
database
database-design
accounting
asked 2010-03-22T17:24:47.450
16
votes
6
answers
How to properly name record creation(insertion) datetime field?
sql
sql-server
database-design
naming-conventions
naming
asked 2010-03-16T17:55:43.597
18
votes
5
answers
Help a CRUD programmer think about an "approval workflow"
database-design
database-schema
asked 2010-03-11T19:04:28.063
28
votes
5
answers
Good place to look for example Database Designs - Best practices
database
database-design
data-modeling
asked 2010-03-09T10:05:23.660
9
votes
4
answers
One table mixing different entities or separate table for each?
database-design
asked 2010-03-01T15:40:26.773
24
votes
6
answers
While doing TDD and adding features incrementally, do I design database ahead or add tables and columns while coding?
database-design
tdd
asked 2010-02-27T09:48:13.087
249
votes
11
answers
First-time database design: am I overengineering?
mysql
database
database-design
schema
database-normalization
asked 2010-02-23T18:18:07.317
48
votes
6
answers
Database design to store notifications to users
ruby-on-rails
database-design
asked 2010-02-09T19:30:27.113
15
votes
5
answers
Which is a better method for storing images - folder or SQL Server as binary?
sql-server
database-design
image
asp.net-3.5
asked 2010-02-09T15:09:27.923
17
votes
1
answers
Delivering activity feed items in a moderately scalable way
database
database-design
social-networking
asked 2010-02-06T22:15:47.813
146
votes
4
answers
How to create a multi-tenant database with shared table structures?
sql
mysql
database-design
multi-tenant
asked 2010-02-06T12:02:35.440
37
votes
7
answers
Is it bad to rely on foreign key cascading?
sql
mysql
database-design
cascade
asked 2010-02-05T03:10:45.520
13
votes
4
answers
Techniques for reducing database queries in a Rails app
ruby-on-rails
database
database-design
optimization
query-optimization
asked 2010-01-28T12:54:16.657
37
votes
6
answers
Can we create multicolumn unique indexes on MS access databases?
database-design
ms-access
asked 2010-01-24T16:11:55.823
14
votes
4
answers
Does Anyone Use Address Line 2
database
database-design
schema
asked 2010-01-20T08:30:32.280
9
votes
2
answers
Is there a .NET Polymorphic Data Framework
c#
.net
database-design
ado.net
polymorphism
asked 2010-01-14T16:40:56.880
77
votes
2
answers
MySQL - Conditional Foreign Key Constraints
mysql
sql
database-design
foreign-keys
polymorphic-associations
asked 2010-01-04T23:12:56.487
54
votes
9
answers
How many significant digits should I store in my database for a GPS coordinate?
mysql
database
database-design
gps
rdbms
asked 2009-12-22T16:29:19.887
← Prev
page 3 of 5
Next →