What exactly is data modeling?

Data modeling refers to the abstract organization of various types of data in the real world, determining the scope of the database, the organizational form of the data, etc. until it is transformed into a real database; abstracting concepts after systematic analysis After the model is converted into a physical model, the process of establishing database entities and relationships between entities in tools such as Visio or Erwin.

Data modeling refers to the abstract organization of various types of data in the real world, determining the scope of the database, the organizational form of the data, etc. until it is transformed into reality database. After converting the conceptual model abstracted after system analysis into a physical model, the process of establishing database entities and relationships between entities in tools such as Visio or Erwin (the entities are generally tables).

In software engineering, data modeling is the process of establishing a data model of an information system using formal data modeling techniques.

Basic introduction

Data modeling is a process used to define and analyze the data requirements and the corresponding supporting information systems it needs. Therefore, the professional data modeling work involved in the data modeling process is closely related to the interests of the enterprise and the user's information system.

From requirements to actual database, there are three different types. A data model for information systems, as a conceptual data model, is essentially a set of initial specification techniques for documenting data requirements. The data is first used to discuss the initial requirements suitable for the enterprise and is then transformed into a logical data model that can be implemented in a conceptual model of the data structure in the database. The implementation of a conceptual data model may require multiple logical data models. The final step in data modeling is to determine the specific requirements for data access performance and storage from the logical data model to the physical data model. Data modeling defines not just data elements, but also their structure and relationships between them.

Classification

1. Use computers to describe the behavior of a system. For example, spreadsheet programs can be used to process financial data and represent a company's actions; develop business plans; and evaluate the possible impact of changes to a company's operations.

2. Use computers to mathematically describe objects and the spatial relationships between them. For example, computer-aided design (CAD) programs generate objects on a screen, using equations to produce lines and shapes that are precisely placed according to their relationship to each other and to the two- or three-dimensional space in which they exist.

3. Application and data modeling is the process of identifying, documenting, and implementing data and process requirements for an application. This includes looking at existing data models and processes to determine if they can be reused, and creating new data models and processes to meet the unique requirements of the application.

The above is the detailed content of What exactly is data modeling?. For more information, please follow other related articles on the PHP Chinese website!