Unnormalized form
Unnormalized form (UNF), sometimes also known as an unnormalized relation or non first normal form (NF2)[1] relation, is a way of representing data in data model. It is the simplest form of representing tables in a database and does not conform to any of the forms of normalization. It is characterized by data redundancy and often contains complex data structures within a single attribute.[2]
Overview
A relation in unnormalized form is used to represent the data entered by a user through a form. If the form contains atomic fields, then the model can be considered in 1NF form.[3] However, if the form contains dependent attributes, they are stored as a data structure (typically another table) within that attribute. Data in unnormalized form would not be considered under relational data model as latter consists of atomic data. Some basic uses of unnormalized relation include dealing with form data in offices. One form would correspond to one record in the database.[1]
History
In 1970, E.F. Codd proposed the relational data model which was widely accepted as the standard data model. At that time, office automation was the major use of data storage systems, which resulted in proposal of many NF2 data models like Schek model, Jaeschke models (Non-recursive and recursive algebra) and Nested Table Data (NTD) model.[1] IBM organized the first international workshop exclusively on this topic in 1987 which was held in Darmstadt,Germany.[1] Moreover, a lot of research has been done and journals have been published to address the shortcomings of relational model. Since the turn of the century, NoSQL databases have become more and more popular owing to the demands of Web 2.0.
Example
Students take courses:
| Id | Name | Course |
|---|---|---|
| 1. | Jack |
|
| 2. | Tim | Chemistry |
| 3. | Ana |
|
The above table represents data in unnormalized form as there are multiple values of an attribute (course) for one tuple unlike the data in first normal form.[4] Here, one student can take several courses and that data will be reflected in a single row in the database. Additionally, Chemistry is being stored two times in the database which results in a lot of memory consumption. Since atomicity is a prerequisite for a relational model this kind of table structure can never be represented with the same.[3]
Advantages and disadvantages
Advantages of unnormalized form over normalized forms are -
- It can deal with complex data structures like Objects, rows in a field.[5]
- Since there is no relation, querying this data model is simpler.[6]
- Restructuring data is easier.[7]
Disadvantages of unnormalized form are -
- Absence of relations means that data is often redundant.[6]
- CRUD operations are plagued by anomalies, and if they are not handled correctly, can result in data inconsistency.[2]
Modern applications
Today companies like Google, Amazon and Facebook deal with loads of data and storing that data in an efficient manner is always a big task. They use NoSQL database which is based on the principles of unnormalized relational model to deal with storage issue.[8] Some of the examples of NoSQL databases are MongoDB, Apache Cassandra and Redis. These databases are more scalable and easy to query with as they do not involve expensive operations like JOIN.
See also
- Denormalization
- Normalization
- First normal form
- Second normal form
- Boyce–Codd normal form
- Third normal form
- NoSQL
References
- 1 2 3 4 Kitagawa, Hiroyuki; Kunii, Tosiyasu L. The Unnormalized Relational Data Model. pp. 1, 5, 7, 10. ISBN 4-431-70049-8.
- 1 2 "1NF, 2NF, 3NF and BCNF in Database Normalization | DBMS Tutorial | Studytonight". www.studytonight.com. Retrieved 2016-09-14.
- 1 2 Codd, E. F. (1970-06-01). "A Relational Model of Data for Large Shared Data Banks". Commun. ACM. 13 (6): 377–387. ISSN 0001-0782. doi:10.1145/362384.362685.
- ↑ "Ridiculously Unnormalized Database Schemas – Part One". 2011-01-19. Retrieved 2016-09-14.
- ↑ "Limitations of the relational model" (PDF).
- 1 2 "Advantages & Disadvantages of Normalizing a Database | Techwalla.com". Retrieved 2016-09-14.
- ↑ Abiteboul, Serge; Bidoit, Nicole (1986-12-01). "Non First Normal Form relations: An algebra allowing data restructuring". Journal of Computer and System Sciences. 33 (3): 361–393. doi:10.1016/0022-0000(86)90058-9.
- ↑ Moniruzzaman, A B M; Hossain, Syed Akhter (2013). "NoSQL Database: New Era of Databases for Big data Analytics - Classification, Characteristics and Comparison". International Journal of Database Theory and Application. 6.