Questions tagged [database-design]

18

votes

9

answers

What's the point of a candidate key?

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

Questions tagged database-design