Shulou(Shulou.com)05/31 Report--

This article mainly introduces the basic characteristics of the database, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, let the editor take you to understand it.

The data in the database is structural, independent and shared. The basic characteristics of the database are: structured data, connections between data, facing the whole system; high data sharing, low redundancy, easy to expand; high data independence.

The operating environment of this tutorial: windows7 system, mysql5.8 version, Dell G3 computer.

The data in the database is structural, independent and shared.

(recommended tutorial: mysql video tutorial)

A database is a warehouse that organizes, stores and manages data according to the data structure. It is a collection of organized, shareable and uniformly managed large amounts of data stored in a computer for a long time.

Database is a computer software system that stores and manages data according to data structure. The concept of a database actually has two meanings:

The main contents are as follows: (1) Database is an entity, it is a "warehouse" that can keep data reasonably, users store transaction data to be managed in this "warehouse", and the two concepts of "data" and "library" are combined to form a database.

(2) Database is a new method and technology of data management, which can organize data more appropriately, maintain data more conveniently, control data more closely and use data more effectively.

Characteristics of the database:

1. Data structure

The database system realizes the structure of the whole data, which is one of the most important features of the database. The "overall" structure here means that the data in the database is no longer only for an application, but for the whole organization; not only the data is structured internally, but also structured as a whole, and there are connections between the data.

2. High data sharing, low redundancy and easy expansion.

Because the data is oriented to the whole, the data can be shared by multiple users and applications, which can greatly reduce data redundancy, save storage space, and avoid incompatibility and inconsistency between data.

3. High data independence

Data independence includes physical independence and logical independence of data.

Physical independence means that how the data is stored in the database on disk is managed by DBMS, the user program does not need to understand, and the application only deals with the logical structure of the data, so that when the physical storage structure of the data changes, the user's program does not have to change.

Logical independence means that the logical structure of the user's application and database are independent of each other, that is to say, the logical structure of the data has changed, and the user program can not be changed.

The independence of the data and the program separates the definition of the data from the program, and the access data is provided by DBMS, which simplifies the compilation of the application program and greatly reduces the maintenance and modification of the application program.

4. The data is managed and controlled by DBMS.

Database sharing is concurrency sharing, that is, multiple users can access data in the database at the same time, or even the same data in the database at the same time.

DBMS must provide the following data control functions:

Data security protection (security)

Data integrity check (integrity)

Concurrent access Control (concurrency) of Database

Database failure recovery (recovery)

Thank you for reading this article carefully. I hope the article "what are the basic features in the 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.