Flat file database
Flat file database is a database that stores information in a single file or table. In a text file, every line contains one record where fields either have fixed length or; they separated by commas, whitespaces, tabs or any other character. In a flat-file database, there is no structural relationship among the records, and they cannot contain multiple tables as well.
The hierarchical database contains data in a hierarchically-arranged data. Its hierarchical structure contains levels or segments which are equivalent to the file system’s record type.
The inventor of the network model is Charles Bachmann. Unlike the hierarchical database model, network database allows multiple parent and child relationships, i.e., it maintains a many-to-many relationship. A network database is a graph structure. The network database model created to achieve three main objectives:
- To represent complex data relationships more effectively.
- To improve the performance of the database.
- To implement a database standard.
E.F. Codd proposed the relational database model. After the hierarchical and network model, the birth of this model was a huge step ahead. It allows the entities to related through a common attribute. Relational databases established using a computer language, Structured Query Language (SQL). This language forms the basis of all the database applications available today, from Access to Oracle.
The object-oriented database management system is that database system in which the data or information presented in the form of objects, much like in object-oriented programming language.
An object-relational database management system displays a modified object-oriented user-display over the already implemented relational database management system.
The web-enabled database put a database with a web-based interface. The web-enabled database uses three layers to function: a presentation layer, a middle layer and the database layer.