Questions tagged [database-design]

9

votes

5

answers

Is it a good idea to design database with inheritance?

asked 2011-09-12T06:55:58.303

14

votes

4

answers

Why specify a length for character varying types

database database-design postgresql types varchar

asked 2011-09-06T13:01:44.147

439

votes

4

answers

How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?

sql database-design foreign-keys relational-database relationship

asked 2011-09-04T01:17:36.723

10

votes

3

answers

Store objects with common base class in database

c# .net sql-server-2008 database-design inheritance

asked 2011-09-03T15:06:10.733

11

votes

5

answers

How to model a database with many m:n relations on a table

database-design relational-database entity-relationship database-schema

asked 2011-08-16T19:13:57.570

17

votes

5

answers

Best practices for migrating database content from one very poor structure to one very logical?

mysql database database-design migration relational-database

asked 2011-08-07T14:44:01.560

14

votes

6

answers

Get table and column "owning" a sequence

postgresql database-design

asked 2011-08-04T11:59:56.540

9

votes

4

answers

Database design: lots of rows vs lots of tables?

mysql sql database-design

asked 2011-07-28T12:57:13.757

21

votes

5

answers

How can graph databases scale horizontally, if at all?

database-design graph nosql scalability

asked 2011-07-20T14:42:53.823

10

votes

4

answers

Sqlalchemy: Latitude and Longitude Float Precision?

database database-design geolocation sqlalchemy pylons

asked 2011-07-07T00:32:08.417

11

votes

6

answers

Best way to store hierarchical tags

database-design language-agnostic architecture data-structures

asked 2011-06-14T14:45:17.170

18

votes

3

answers

MongoDB embedded vs. reference from performance perspective

performance database-design mongodb

asked 2011-06-14T14:34:44.570

25

votes

4

answers

MySQL PRIMARY KEYs: UUID / GUID vs BIGINT (timestamp+random)

mysql sql database performance database-design

asked 2011-06-14T04:08:55.233

13

votes

3

answers

CouchDB create database per document type?

database-design nosql couchdb

asked 2011-06-13T05:47:31.890

15

votes

1

answers

Can I regenerate .designer.cs based on a manually edited .dbml?

.net visual-studio database-design linq-to-sql

asked 2011-06-02T05:26:05.927

132

votes

2

answers

Index on multiple columns in Ruby on Rails

ruby-on-rails ruby-on-rails-3 database-design indexing

asked 2011-05-29T19:42:35.703

60

votes

6

answers

MongoDB vs. Cassandra vs. MySQL for real-time advertising platform

mongodb database-design cassandra database nosql

asked 2011-05-28T16:06:46.273

24

votes

3

answers

Storing enum values in database

sql-server database-design enums

asked 2011-05-25T16:30:41.053

9

votes

1

answers

Creating a MySQL index on a Varchar always makes 2 indexes?

mysql database database-design optimization indexing

asked 2011-05-24T18:59:02.793

9

votes

2

answers

Tracking User activity log - SQL vs NoSQL?

mysql mongodb database-design relational-database nosql

asked 2011-05-22T22:40:16.313

9

votes

1

answers

Redis multi column range query

database-design data-modeling redis

asked 2011-05-21T20:38:49.320

11

votes

2

answers

Single Table Inheritance or Class Table Inheritance?

ruby-on-rails ruby database-design single-table-inheritance

asked 2011-05-20T14:45:59.677

16

votes

3

answers

Calendar tables in PostgreSQL 9

database-design postgresql data-warehouse rails-postgresql

asked 2011-04-28T16:28:40.680

37

votes

9

answers

Maintaining Referential Integrity - Good or Bad?

sql database-design referential-integrity audit-trail

asked 2011-04-26T17:54:11.417

41

votes

3

answers

Storing HTML in SQL Server

html sql-server database-design

asked 2011-04-24T19:59:11.417

18

votes

3

answers

How are varchar values stored in a SQL Server database?

sql-server database sql-server-2008 database-design sqldatatypes

asked 2011-04-18T14:45:31.463

10

votes

3

answers

Data modelling draft/quote/order/invoice

sql database-design data-modeling invoice

asked 2011-04-17T10:15:13.550

9

votes

3

answers

Understanding COMPATIBILITY_LEVEL in SQL Server

sql-server database database-design compatibility

asked 2011-04-11T16:13:55.423

41

votes

7

answers

How to design a multi tenant mysql database

mysql database database-design multi-tenant

asked 2011-04-06T16:54:44.707

51

votes

5

answers

What column data type should I use for storing large amounts of text or html

mysql sql database-design

asked 2011-03-28T11:33:35.923

23

votes

1

answers

How do database vendors implement transactions?

database database-design transactions

asked 2011-03-19T22:37:28.967

34

votes

1

answers

mongodb schema design for blogs

database-design mongodb

asked 2011-03-07T20:22:59.320

13

votes

2

answers

how can i create a tagging system using php and mysql?

php mysql database-design tags tagging

asked 2011-03-01T21:02:50.100

11

votes

2

answers

Data Modeling: Logical Modeling Exercise

database database-design relational-database database-schema identifying-relationship

asked 2011-01-23T00:23:45.367

10

votes

4

answers

database design for dictionary application

database database-design

asked 2011-01-21T12:22:48.157

10

votes

8

answers

SQL table design: Should I store addresses with orders or in separate table?

sql database-design

asked 2011-01-19T20:10:37.907

49

votes

3

answers

Why would you want to put an index on a view?

sql sql-server indexing database-design sql-view

asked 2011-01-19T15:59:24.493

24

votes

4

answers

Composite primary key or not?

database-design composite-primary-key

asked 2011-01-19T15:35:19.743

14

votes

9

answers

How can I ensure that there is one-and-only-one row in DB table?

mysql database database-design privileges

asked 2011-01-17T16:03:07.450

27

votes

9

answers

What's the best way to store the bible in SQL?

sql mysql database-design

asked 2011-01-14T04:01:36.243

9

votes

1

answers

DB Design Question - Storing International People Names

database-design

asked 2011-01-06T05:15:55.143

11

votes

6

answers

INT vs VARCHAR in search

sql mysql database database-design search

asked 2011-01-05T18:29:14.660

20

votes

2

answers

Recommended database structure for OAuth Provider

database-design oauth oauth-provider devdefined-oauth

asked 2010-12-26T15:26:00.063

19

votes

4

answers

Database Upserts - Good or Bad Practice?

mysql sql-server oracle-database database-design

asked 2010-12-22T09:59:03.837

17

votes

3

answers

Historical / auditable database

sql database database-design temporal-database

asked 2010-12-20T15:39:37.913

17

votes

4

answers

is EAV - Hybrid a bad database design choice

database database-design postgresql entity-attribute-value

asked 2010-12-19T04:59:47.633

52

votes

2

answers

Best way to store working hours and query it efficiently

sql mysql database database-design

asked 2010-12-16T20:07:45.540

33

votes

7

answers

Does VARCHAR size limit matter?

php mysql database-design varchar

asked 2010-12-01T13:35:53.170

151

votes

7

answers

Storing sex (gender) in database

sql database-design

asked 2010-11-14T02:25:01.003

62

votes

9

answers

Is it good database design to have admin users in the same table as front-end users?

sql sql-server database database-design data-modeling

asked 2010-11-12T23:18:24.437

Questions tagged database-design