Questions tagged [database-design]

31

votes

5

answers

Which provides better performance one big join or multiple queries?

asked 2009-12-19T05:05:53.500

20

votes

4

answers

Efficient implementation of faceted search in relational databases

sql database database-design tagging faceted-search

asked 2009-12-04T16:01:23.183

39

votes

12

answers

Do link tables need a meaningless primary key field?

sql database-design primary-key

asked 2009-12-03T21:57:19.647

32

votes

2

answers

Is it bad to use user name as primary key in database design?

mysql database-design primary-key unique-key

asked 2009-12-01T11:37:08.250

44

votes

11

answers

Database: Best performance way to query geo location data?

mysql database database-design performance

asked 2009-11-28T19:12:04.797

14

votes

2

answers

Adding a column to all user tables in t-sql

sql sql-server t-sql database-design metadata

asked 2009-11-22T19:45:40.057

32

votes

6

answers

Multitenant DB: Why put a TenantID column in every table?

database-design multi-tenant

asked 2009-11-16T15:07:34.727

126

votes

12

answers

Nullable Foreign Key bad practice?

database-design sql-null

asked 2009-11-12T17:07:39.517

13

votes

6

answers

When not to use surrogate primary keys?

database-design primary-key

asked 2009-11-11T09:49:36.170

12

votes

6

answers

Should a user's profile be a separate model?

ruby-on-rails database-design

asked 2009-11-09T22:43:48.057

25

votes

10

answers

Is it bad practice to use default values in a database?

database-design

asked 2009-11-09T15:20:11.277

12

votes

4

answers

Is it a good idea to use rowguid as unique key in database design?

sql-server database-design primary-key data-modeling

asked 2009-10-30T18:45:34.067

10

votes

6

answers

Does varchar result in performance hit due to data fragmentation?

sql database-design database

asked 2009-10-27T14:23:52.137

12

votes

5

answers

What is the best way to design database for Ruby on Rails?

ruby-on-rails database database-design

asked 2009-10-21T23:57:03.937

64

votes

5

answers

What's The Best Practice In Designing A Cassandra Data Model?

database-design nosql cassandra

asked 2009-10-01T08:51:16.490

10

votes

7

answers

Database Design: Circular dependency

database-design circular-dependency

asked 2009-09-07T01:52:18.087

105

votes

13

answers

Primary key/foreign Key naming convention

sql database-design naming-conventions

asked 2009-09-02T19:13:33.480

10

votes

4

answers

Database design to hold a person's information that changes with time?

sql sql-server database-design temporal-database

asked 2009-08-20T00:46:32.050

21

votes

10

answers

What size to pick for a (n)varchar column?

database-design size varchar nvarchar

asked 2009-08-11T16:18:02.860

20

votes

2

answers

CREATE OR REPLACE VIEW sql error

sql database sqlite database-design

asked 2009-08-05T21:57:29.047

114

votes

9

answers

What is the optimal length for an email address in a database?

database performance email database-design

asked 2009-07-29T10:10:43.387

74

votes

8

answers

What are design patterns to support custom fields in an application?

database-design data-modeling

asked 2009-07-14T17:18:20.717

57

votes

22

answers

First name, middle name, last name. Why not Full Name?

database database-design user-interface

asked 2009-07-13T22:00:01.937

24

votes

2

answers

How do I properly store data relationships with Microsoft Azure Table Storage?

design-patterns database-design azure

asked 2009-07-11T23:48:08.667

67

votes

10

answers

What databases do the World Wide Web's biggest sites run on?

database database-design web-applications scalability

asked 2009-07-11T10:07:29.453

10

votes

3

answers

App engine datastore: How to implement Posts and Tags without joins?

java google-app-engine database-design google-cloud-datastore

asked 2009-07-03T13:33:22.820

11

votes

9

answers

How to store meta-data on columns

database-design normalization entity-attribute-value

asked 2009-06-26T20:15:04.973

51

votes

7

answers

Database Architecture for "Badge" System & Arbitrary Criteria (MySQL/PHP)

database-design badge

asked 2009-06-26T13:44:31.123

20

votes

6

answers

How to stop thinking "relationally"

ruby database-design couchdb document-oriented-db couchpotato

asked 2009-06-25T13:12:42.490

23

votes

9

answers

Implementing a voting system without requiring registration

php database-design cookies project-planning voting-system

asked 2009-06-10T21:57:31.253

12

votes

1

answers

How to design a star schema

sql database-design star-schema

asked 2009-06-02T07:27:39.077

14

votes

3

answers

Django: Order a model by a many-to-many field

sql django database-design django-models

asked 2009-06-01T13:16:26.170

18

votes

9

answers

What data type is recommended for ID columns?

language-agnostic database-design types primary-key database-agnostic

asked 2009-05-31T14:12:50.010

417

votes

17

answers

Should each and every table have a primary key?

database database-design

asked 2009-05-08T14:49:14.963

12

votes

5

answers

What is the most efficient way to store and query trees?

database-design

asked 2009-05-07T20:21:14.743

10

votes

3

answers

Why so few full database schemas sample online?

database database-design schema sample

asked 2009-05-04T04:56:24.977

33

votes

11

answers

Getting events from a database

java database database-design events triggers

asked 2009-05-01T16:58:05.297

13

votes

4

answers

SQL Server: varbinary or int to store a bit mask?

sql sql-server database-design bitmask

asked 2009-04-30T22:17:03.620

17

votes

7

answers

SQL: Do you need an auto-incremental primary key for Many-Many tables?

sql database-design

asked 2009-04-26T06:13:42.003

16

votes

11

answers

In a database, what is the difference betwen a key and an index?

database-design

asked 2009-04-20T17:59:35.100

23

votes

6

answers

How to handle enumerations without enum fields in a database?

database-design enums

asked 2009-04-17T16:46:38.810

9

votes

3

answers

Can SQL Server views have primary and foreign keys?

.net sql-server entity-framework database-design ado.net-entity-data-model

asked 2009-04-13T20:46:22.403

300

votes

4

answers

What are database normal forms and can you give examples?

database database-design database-normalization

asked 2009-04-07T02:43:56.390

47

votes

11

answers

Database-wide unique-yet-simple identifiers in SQL Server

sql sql-server database database-design identity

asked 2009-04-06T13:41:13.617

27

votes

11

answers

Database design for point in time "snapshot" of data?

database-design

asked 2009-04-06T09:57:50.910

38

votes

6

answers

What are the principles behind, and benefits of, the "party model"?

sql database-design orm data-modeling

asked 2009-04-04T05:17:14.440

24

votes

13

answers

Picking the best primary key + numbering system

database database-design primary-key

asked 2009-04-01T22:55:08.063

25

votes

3

answers

What are some best practices and "rules of thumb" for creating database indexes?

database database-design indexing

asked 2009-03-26T23:55:10.713

28

votes

7

answers

How to pivot a MySQL entity-attribute-value schema

mysql database-design pivot entity-attribute-value

asked 2009-03-16T09:58:21.257

24

votes

12

answers

Best way to model Customer <--> Address

sql database-design orm data-modeling

asked 2009-03-15T20:14:44.187

Questions tagged database-design