No normalization
Normalization is a process of organizing data efficiently in a relational database by eliminating redundant data, while at the same time ensuring that the data dependencies make sense. SimpleDB data models do not conform to any of the normalization forms, and tend to be completely de-normalized. The lack of need for normalization in SimpleDB allows you a great deal of flexibility with your model, and enables you to use the power of multi-valued attributes in your data.
Let's look at a simple example of a database starting with a basic spreadsheet structure and then design it for an RDBMS and a SimpleDB. In this example, we will create a simple contact database, with contact information as raw data.
ID |
First_Name |
Last_Name |
Phone_Num |
---|---|---|---|
101 |
John |
Smith |
555-845-7854 |
101 |
John |
Smith |
555-854-9885 |
101 |
John |
Smith |
555-695-7485 |
102 |
Bill |
Jones |
555-748-7854 |
102 |
Bill |
Jones |
555-874-8654 |
The obvious issue is the repetition of the name data. The table is inefficient and...