Live briefing
Everything about Unnormalized form
Database data model
In database normalization, unnormalized form (UNF or 0NF), also known as an unnormalized relation or non-first normal form (N1NF or NF2), is a database data model (organization of data in a database) which does not meet any of the conditions of database normalization defined by the relational model. Database systems which support unnormalized data are sometimes called non-relational or NoSQL databases. In the relational model, unnormalized relations can be considered the starting point for a process of normalization. Wikipedia →
🧠Start here: a 6-step reading path
- Read the overview: Unnormalized formA 5-minute orientation
- Pick up a classic book: The unnormalized relational data modelThe most-reprinted book on the subject
- Read the landmark paper: Unnormalized and normalized forms of gefura measures in directed and undirected networksCited 5 times
- Go sideways: Database normalizationA closely related topic
- Go sideways: First normal formA closely related topic
đź“– Definitions
No dictionary entry for this exact phrase.
🗂️ The subject at a glance
🏆 Landmark papers (most cited)
đź“š Books worth reading
The unnormalized relational data modelH. Kitagawa, Hiroyuki Kitagawa · 1989
Coding the MatrixPhilip N. Klein · 2013
The Unnormalized Relational Data ModelHiroyuki Kitagawa · 1989
Ranked by number of editions on Open Library, a rough measure of how lasting a book is.
đź”— Related topics
- Database normalization Database normalization is the process of structuring a relational database in accordance with a series of normal forms to reduce data redundancy and improve…
- First normal form First normal form (1NF) is the most basic level of database normalization defined by English computer scientist Edgar F. Codd, the inventor of the relational…
- Relational database A relational database (RDB) is a database based on the relational model of data, as proposed by E. F. Codd in 1970. A Relational Database Management System…
- Denormalization Denormalization is a strategy used on a previously-normalized database to increase performance. In computing, denormalization is the process of trying…
- Second normal form Second normal form (2NF) is a level of database normalization defined by English computer scientist Edgar F. Codd. A relation (or a table, in SQL) is in…
- Relational model The relational model (RM) is an approach to managing data using a structure and language consistent with first-order predicate logic, first described in…
- Hierarchical database model A hierarchical database model is a data model in which the data is organized into a tree-like structure. The data are stored as records which is a collection…
- Boyce–Codd normal form Boyce–Codd normal form (BCNF or 3.5NF) is a normal form used in database normalization. It is a slightly stricter version of the third normal form (3NF)…