| grundprinzip's answer is good. I'd like to add a remark. In database systems it is important to distinguish between the logical and physical models. When you design a relational database, you focus on the correct logical model. "People can have multiple phone numbers". "Phone numbers belong to a single phone". "Mobile phones are possessed by one person. Landlines can be shared". And so on. You express this logical model to the database, most likely in SQL. Eventually you notice that query X is slow. Your first step is to check that your logical design was sound, because poorly designed schemata are hard for query planners to reason correctly about. Then you start doing things to the physical representation. You say stuff like: "I look up by phone numbers a lot." Or, in SQL terms, you add an index to a column. Similarly, as this article pointed out, there are times when grouping data by column rather than row is advantageous. So then you tell the database to use a columnar store. And so on. Modern RDBMSes all support the same major logical model descriptions; but they can vary widely on what physical directives you give. |