All Questions
Tagged with database database-design
9,379
questions
924
votes
23
answers
733k
views
Database, Table and Column Naming Conventions? [closed]
Whenever I design a database, I always wonder if there is a best way of naming an item in my database. Quite often I ask myself the following questions:
Should table names be plural?
Should column ...
885
votes
15
answers
522k
views
What's the difference between identifying and non-identifying relationships?
I haven't been able to fully grasp the differences. Can you describe both concepts and use real world examples?
814
votes
10
answers
471k
views
Difference between scaling horizontally and vertically for databases [closed]
I have come across many NoSQL databases and SQL databases. There are varying parameters to measure the strength and weaknesses of these databases and scalability is one of them. What is the difference ...
764
votes
6
answers
316k
views
MongoDB vs. Cassandra [closed]
I am evaluating what might be the best migration option.
Currently, I am on a sharded MySQL (horizontal partition), with most of my data stored in JSON blobs. I do not have any complex SQL queries (...
566
votes
40
answers
129k
views
Database development mistakes made by application developers [closed]
What are common database development mistakes made by application developers?
479
votes
12
answers
1.1m
views
Can I have multiple primary keys in a single table?
Can I have multiple primary keys in a single table?
422
votes
10
answers
104k
views
Is storing a delimited list in a database column really that bad?
Imagine a web form with a set of check boxes (any or all of them can be selected). I chose to save them in a comma separated list of values stored in one column of the database table.
Now, I know ...
413
votes
17
answers
342k
views
Should each and every table have a primary key?
I'm creating a database table and I don't have a logical primary key assigned to it. Should each and every table have a primary key?
369
votes
4
answers
303k
views
What are OLTP and OLAP. What is the difference between them?
Actually what do they mean? All articles I find about them don't give me an idea, or my knowledge is too insufficient to understand it.
Will some one give me some resources with which I can learn ...
360
votes
14
answers
378k
views
Auto Generate Database Diagram MySQL [closed]
I'm tired of opening Dia and creating a database diagram at the beginning of every project. Is there a tool out there that will let me select specific tables and then create a database diagram for me ...
341
votes
4
answers
133k
views
What does character set and collation mean exactly?
I can read the MySQL documentation and it's pretty clear. But, how does one decide which character set to use? On what data does collation have an effect?
I'm asking for an explanation of the two and ...
313
votes
4
answers
183k
views
What does ON [PRIMARY] mean?
I'm creating an SQL setup script and I'm using someone else's script as an example. Here's an example of the script:
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[...
300
votes
8
answers
185k
views
Max length for client ip address [duplicate]
Possible Duplicate:
Maximum length of the textual representation of an IPv6 address?
What would you recommend as the maximum size for a database column storing client ip addresses? I have it set ...
297
votes
4
answers
252k
views
What are database normal forms and can you give examples? [closed]
In relational database design, there is a concept of database normalization or simply normalization, which is a process of organizing columns (attributes) and tables (relations) to reduce data ...
280
votes
38
answers
131k
views
What's wrong with foreign keys?
I remember hearing Joel Spolsky mention in podcast 014 that he'd barely ever used a foreign key (if I remember correctly). However, to me they seem pretty vital to avoid duplication and subsequent ...