What are the data models supported by the Access2010 database management system?

The data model supported by the Access2010 database management system is the "relational model". The relational model organizes data in the form of record groups or data tables to facilitate storage and transformation using the relationships between various entities and attributes. It does not have hierarchies or pointers. It is a way to establish the relationship between spatial data and attribute data. A very effective way to organize data.

The operating environment of this article: Windows 7 system, Dell G3 computer, Microsoft Office Access2019.

Related recommendations: "Access Tutorial"

The data model supported by the Access2010 database management system is the "relational model".

Access is a relational database management system released by Microsoft. It combines the two features of MicrosoftJet Database Engine and graphical user interface, and is one of the system programs of Microsoft Office.

Data Model is an abstraction of data characteristics. It describes the static characteristics, dynamic behavior and constraints of the system from an abstract level, and provides an abstract framework for the information representation and operation of the database system. The content described by the data model has three parts, namely data structure, data operations and data constraints.

Types of data models

Three basic data models have been produced during the data development process, which are hierarchical model, network model and relational model. These three models are named according to their data structures. The first two use formatted structures. In this type of structure, entities are represented by records, and records are abstracted as vertices of the graph. The connection between record types is abstracted as the connection arc between vertices. The entire data structure corresponds to the graph. The basic structure of the hierarchical model is a tree structure; the basic structure of the network model is an undirected graph without any restrictions. The relational model is an unformatted structure that uses a single two-dimensional table structure to represent entities and the relationships between entities. The relational model is a commonly used data model in current databases.

1. Hierarchical model

organizes data into a one-to-many relationship structure, and uses a tree structure to represent entities and the relationships between entities.

2. Network model

Use connection instructions or pointers to determine the network connection relationship between data, which is a many-to-many data organization method.

3. Relational model

Organize data in the form of record groups or data tables to facilitate storage and transformation using the relationships between various entities and attributes, without hierarchies or pointers. , is a very effective data organization method to establish the relationship between spatial data and attribute data.

For more programming-related knowledge, please visit: Programming Teaching! !

The above is the detailed content of What are the data models supported by the Access2010 database management system?. For more information, please follow other related articles on the PHP Chinese website!