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

This article mainly introduces the form in which the relational database organizes and stores data, which has a certain reference value. Interested friends can refer to it. I hope you will gain a lot after reading this article. Let the editor take you to know it.

Relational databases organize and store data in the form of "two-dimensional tables". Tables in relational databases use two-dimensional tables to store data, which is a logical group with related information arranged by rows and columns, which is similar to Excel worksheets; a database can contain any number of data tables.

Relational databases organize and store data in the form of "two-dimensional tables".

A relational database is a database based on a relational model, which deals with the data in the database with the help of concepts and methods such as set algebra. at the same time, it is also a group of tables with formal description. The essence of this form of table is a special collection of data items. The data in these tables can be accessed or reconvened in many different ways without the need to reorganize database tables.

The definition of a relational database results in a table of metadata or a formal description of tables, columns, ranges, and constraints.

Each table (sometimes referred to as a relationship) contains one or more types of data represented by columns.

Each row contains a unique data entity, which is the category defined by the column.

When creating a relational database, you can define the range of possible values of a data column and further constraints that may be applied to that data value. The SQL language is the interface between standard users and applications to relational databases. Its advantage is that it is easy to expand, and after the initial database creation, a new data type can be added without the need to modify all existing applications.

Relational model structure

1. Single data structure-relationship (table file). Tables in relational databases use two-dimensional tables to store data, which is a logical group with relevant information arranged by rows and columns, which is similar to Excel worksheets. A database can contain any number of tables.

From the user's point of view, the logical structure of a relational model is a two-dimensional table, consisting of rows and columns. This two-dimensional table is called a relationship. In popular terms, a relationship corresponds to a table.

2. Tuple (record). A row in a table is a tuple, or a record.

3. Attributes (fields). Each column in the data table is called a field, and the table is defined by the various fields it contains. Each field describes the meaning of the data it contains. The design of the data table is actually the design of the field. When you create a data table, you assign a data type to each field and define their data length and other properties. Fields can contain a variety of characters, numbers, and even graphics. Like a mistake! The reference source was not found.

4. Attribute value. The intersection of rows and columns indicates an attribute value, for example, "Database principle" is the attribute value of the course name.

5. Main code. A master code (also known as a primary key or primary keyword) is the data in a table that is used to uniquely determine a tuple. Keyword is used to ensure the uniqueness of records in a table, can be one or more fields, and is often used as an index field for a table. Each record has a different keyword, so it can uniquely identify a record. The keyword is also called the primary keyword, or primary key for short. Like a mistake! The reference source was not found.

6. Domain. The range of values for the property.

7. Relationship model. The description of a relationship is called a relational schema. The description of the relationship is generally expressed as: relationship name (attribute 1, attribute 2. Attribute n). For example, the above relationship can be described as: course number, course name, credits, teacher).

However, this simple data structure of the relational model can express rich semantics and describe the entities and the relationships between entities in the real world.

Thank you for reading this article carefully. I hope the article "what is the form of organizing and storing data in a relational database" shared by the editor will be helpful to everyone? at the same time, I also hope that you will support and pay attention to the industry information channel. more related knowledge is waiting for you to learn!

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.