Also known as database schema, database model is the structure of a database, depicted in a formal language backed by DBMS. Usually, database models are stored in data dictionaries. Database models are categorized in the following categories:
1. Flat model – The model comprises a single two-dimensional array of data elements in which it was assumed that all elements of a given column consists same values and all elements of a row are related with each other.
2. Hierarchical model – Widely used in previous mainframe database management systems, in hierarchical model, data is managed in a tree like structure. In the structure, single upward link in each record depicts the nesting. Describing 1:N relationship, the model is very helpful in many real world applications.
3. Network model – The model manages data by using 2 prime constitutes, records and sets. It is constructed with a notion of multiple branches emerging from one or more nodes. Branches of the model can be linked with multiple nodes.
4. Relational model – The model is a mathematical model, based on set theory and predicate logic. It makes DBMS more independent and autonomous, related with specified application.
5. Dimensional model – The model is an example of specialized remodeling done in relational model used to exhibit data in data warehouses. The data can be easily summarized and abstracted in data warehouse by using OLAP queries. The database comprises a large table, which is best depicted by measures and dimensions.
6. Object database model – Now days, object oriented prototype is applied to database technology, constructing a new programming model known as object databases. This endeavor is made to bring the database and application programming world closer by assuring that the database system uses same kind of system as used by the application module.
1. Flat model – The model comprises a single two-dimensional array of data elements in which it was assumed that all elements of a given column consists same values and all elements of a row are related with each other.
2. Hierarchical model – Widely used in previous mainframe database management systems, in hierarchical model, data is managed in a tree like structure. In the structure, single upward link in each record depicts the nesting. Describing 1:N relationship, the model is very helpful in many real world applications.
3. Network model – The model manages data by using 2 prime constitutes, records and sets. It is constructed with a notion of multiple branches emerging from one or more nodes. Branches of the model can be linked with multiple nodes.
4. Relational model – The model is a mathematical model, based on set theory and predicate logic. It makes DBMS more independent and autonomous, related with specified application.
5. Dimensional model – The model is an example of specialized remodeling done in relational model used to exhibit data in data warehouses. The data can be easily summarized and abstracted in data warehouse by using OLAP queries. The database comprises a large table, which is best depicted by measures and dimensions.
6. Object database model – Now days, object oriented prototype is applied to database technology, constructing a new programming model known as object databases. This endeavor is made to bring the database and application programming world closer by assuring that the database system uses same kind of system as used by the application module.
No comments:
Post a Comment