Hands-on Activity #6

Hands-on Activity #6

What are some database models?

Some different database models are: Flat model which is a plain text or mixed text and binary file which usually contains one record per line or 'physical' record (example on disc).

Network model is a database model conceived as a flexible way of representing objects and their relationships.

Hierarchical is a data model in which the data is organized into a tree like structure implying a single upward link in each record to describe the nesting, and a sort field to keep the records in a particular order in each same-level list.

Dimensional model is a specialized adaptation of the relational model used to represent data in data warehouse in a way that data can be easily summarized using OLAP queries.

Object-oriented model attempt to bring the database world and the application programming world closer together, in particular by ensuring that the database uses the same type system as the application program.

Multi-dimensional is a variation of the relational model that uses multidimensional structures to organize data and express the relationships between data.

Relational database models are data elements that are placed in two dimensional tables called relations and provides a declarative method for specification of data and queries.