Questions tagged [database-design]

12

votes

2

answers

Best Database structure for storing RSS feeds

database-design rss

asked 2009-03-09T00:21:26.480

566

votes

40

answers

Database development mistakes made by application developers

database database-design

asked 2009-03-07T14:12:06.140

34

votes

8

answers

Backup MySQL users

mysql database database-design migration backup

asked 2009-02-28T08:09:07.897

34

votes

2

answers

What tag schema(s) are the most efficient/effective?

database-design tags

asked 2009-02-27T23:00:54.453

38

votes

4

answers

Where is the line between DAL and ORM?

orm terminology data-access-layer database-design

asked 2009-02-24T03:39:48.917

26

votes

12

answers

What are the most important considerations when designing a database?

database database-design

asked 2009-02-24T02:31:41.033

25

votes

6

answers

Something like inheritance in database design

database-design polymorphic-associations class-table-inheritance

asked 2009-02-16T20:55:44.813

131

votes

15

answers

Best way to store time (hh:mm) in a database

sql-server database database-design datetime

asked 2009-02-11T20:57:04.300

10

votes

5

answers

Why would you NOT set IGNORE_DUP_KEY to ON?

sql-server t-sql database-design

asked 2009-02-10T18:57:26.797

192

votes

27

answers

Is there ever a time where using a database 1:1 relationship makes sense?

sql database-design one-to-one database-normalization

asked 2009-02-05T19:08:42.630

10

votes

5

answers

How to build a simple recommendation system?

c# asp.net database algorithm database-design

asked 2009-01-31T17:03:12.293

14

votes

7

answers

Best beginner resources for understanding the EAV database model?

database database-design magento entity-attribute-value

asked 2009-01-30T01:18:42.827

22

votes

10

answers

How to design a movie database?

mysql database-design rdbms relationship

asked 2009-01-29T04:18:03.703

24

votes

13

answers

SQL Optimization: how many columns on a table?

sql-server database-design

asked 2009-01-28T19:35:27.143

43

votes

11

answers

How can an object-oriented programmer get his/her head around database-driven programming?

sql linq database-design oop

asked 2009-01-26T22:08:04.247

76

votes

15

answers

Should you enforce constraints at the database level as well as the application level?

database-design

asked 2009-01-21T03:59:54.750

29

votes

1

answers

Table Module vs. Domain Model

database design-patterns database-design entity-attribute-value

asked 2009-01-11T22:03:37.560

153

votes

20

answers

Good tool to visualise database schema?

mysql database database-design schema visualization

asked 2009-01-11T15:15:16.150

13

votes

10

answers

Maintaining sort order of database table rows

database-design

asked 2008-12-29T19:30:58.640

12

votes

3

answers

Problem With Database Design For MVC - 1 Table Per Model

model-view-controller database-design

asked 2008-12-24T14:35:50.440

12

votes

5

answers

Should a Composite Primary Key be clustered in SQL Server?

sql database database-design primary-key

asked 2008-12-23T16:29:34.720

192

votes

6

answers

What's wrong with nullable columns in composite primary keys?

database database-design

asked 2008-12-22T11:33:55.363

162

votes

26

answers

Physical vs. logical (hard vs. soft) delete of database record?

sql database database-design soft-delete hard-delete

asked 2008-12-18T16:09:32.897

18

votes

5

answers

Mysql Visualization Tools

mysql database database-design visualization

asked 2008-12-12T18:11:22.907

25

votes

3

answers

What happens when an auto-incrementing column runs out?

mysql database-design

asked 2008-12-12T07:28:08.083

68

votes

5

answers

MySQL ENUM type vs join tables

mysql database-design enums

asked 2008-12-12T06:34:36.443

10

votes

1

answers

Database Schema - Booking/Availability System

database database-design schema

asked 2008-12-11T10:28:41.523

17

votes

7

answers

Combining UNION ALL and ORDER BY in Firebird

sql database database-design firebird

asked 2008-12-09T21:00:58.940

12

votes

8

answers

Query vs. View

database database-design

asked 2008-11-27T16:30:12.847

48

votes

14

answers

In terms of databases, is "Normalize for correctness, denormalize for performance" a right mantra?

database database-design database-normalization denormalization

asked 2008-11-16T03:24:55.773

12

votes

8

answers

What is the best practice for naming database tables to provide natural organization?

mysql database database-design

asked 2008-10-24T19:13:14.797

39

votes

2

answers

Optimal data architecture for tagging, clouds, and searching (like StackOverflow)?

database-design tags full-text-search tag-cloud

asked 2008-10-24T18:38:33.120

9

votes

8

answers

What is some good software for designing MySQL databases?

database-design

asked 2008-10-21T02:47:29.233

21

votes

18

answers

Database design for database-agnostic applications

sql database database-design

asked 2008-10-15T08:28:21.857

135

votes

8

answers

Best design for a changelog / auditing database table?

database database-design audit

asked 2008-10-14T15:00:56.137

18

votes

10

answers

How do you deal with m..n relationships in a relational database?

sql database database-design

asked 2008-10-08T16:47:01.537

502

votes

23

answers

What is the ideal data type to use when storing latitude / longitude in a MySQL database?

mysql database-design maps mapping latitude-longitude

asked 2008-10-01T19:18:13.960

49

votes

16

answers

Primary Key versus Unique Constraint?

database database-design

asked 2008-10-01T16:10:15.770

297

votes

6

answers

Relational Database Design Patterns?

design-patterns database-design rdbms

asked 2008-09-28T11:29:56.980

69

votes

7

answers

How do I store a directory / hierarchy / tree structure in a database?

sql-server sql-server-2005 database-design tree-structure

asked 2008-09-27T19:59:24.923

15

votes

3

answers

varchar(255) v tinyblob v tinytext

sql mysql database-design

asked 2008-09-27T16:20:01.270

10

votes

6

answers

Database structure to track change history

ruby-on-rails database-design

asked 2008-09-26T20:00:24.057

32

votes

11

answers

What are the different types of indexes, what are the benefits of each?

sql database database-design indexing

asked 2008-09-25T20:12:25.530

45

votes

9

answers

Versioning Database Persisted Objects, How would you?

database database-design versioning auditing

asked 2008-09-24T07:41:40.833

68

votes

13

answers

How do you deal with polymorphism in a database?

database-design oop

asked 2008-09-05T12:16:12.933

27

votes

6

answers

Effective strategy for leaving an audit trail/change history for DB applications?

database postgresql database-design crud audit-trail

asked 2008-08-23T00:05:58.210

18

votes

12

answers

Database triggers

sql-server database-design triggers

asked 2008-08-18T00:01:19.203

941

votes

21

answers

Database, Table and Column Naming Conventions?

database database-design language-agnostic naming-conventions

asked 2008-08-11T10:27:22.780

359

votes

14

answers

Auto Generate Database Diagram MySQL

mysql database database-design diagram

asked 2008-08-05T15:45:02.930

Questions tagged database-design