Shulou(Shulou.com)06/02 Report--

This article mainly introduces what is the data model of using tree structure in mysql. It is very detailed and has certain reference value. Friends who are interested must read it!

The data model which uses the tree structure to represent all kinds of entities and the relationship between entities is the hierarchical model. The hierarchical model organizes the data into an one-to-many relationship structure, and the tree structure is used to represent the entity and the relationship between entities.

The data model that uses the tree structure is the hierarchical model.

The database model describes the methods of structuring and manipulating data in the database, and the structural part of the model defines how the data is described (such as trees, tables, etc.). The manipulation part of the model specifies the operations of adding, deleting, displaying, maintaining, printing, searching, selecting, sorting and updating data.

Database model can be divided into conceptual model and data model, in which the data model can be divided into hierarchical model, mesh model and relational model.

A data model that uses a tree structure to represent entity types and relationships between entities is called a hierarchical model.

The restriction in the hierarchical model is that there is one and only one node, there is no parent node, and this node is the root of the tree; other nodes have and only one parent node. The characteristic of the hierarchical model is that the relationship between records is realized through pointers, and the query efficiency is high. Its disadvantage is that it can only represent the connection of 1RU N.

The data structure model which uses the directed graph structure to represent the entity type and the relationship between entities is called the mesh model. The data structure of the mesh model mainly has the following two characteristics:

(1) allow more than one node to have no parents

(2) A node can have more than one parent.

Both the hierarchical model and the mesh model use pointers to represent the relationship between elements.

The relational model uses a two-dimensional table to represent the relationship between data. A two-dimensional table corresponds to a relationship, rows are often called records, and columns are called fields or properties.

The above is all the content of the article "what is the data model using tree structure in mysql". Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.