*** Welcome to piglix ***

Unnormalized form


Unnormalized form (UNF), sometimes also known as an unnormalized relation or non first normal form (NF2) 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.

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. 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.

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.IBM organized the first international workshop exclusively on this topic in 1987 which was held in Darmstadt,Germany. 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.


...
Wikipedia

...