As we all know, the emergence and development of database systems do not come along with computers, but with the continuous development of computer technology, it appears in a specific historical period and in a specific demand environment. In the 20 years since the first computer in the world was invented by humans in, the computer operating system was mainly limited to the generation and development of file database systems.
As we all know, database systems do not come along when computers are generated, but come along with the continuous development of computer technology in a specific historical period and a specific demand environment. In 1946, humans invented the world's first computer. in the 20 years since 1960s, computer operating systems were mainly confined to file operations. Similarly, data management is also implemented through the file system. Various data required for calculation are stored in their respective files. To use the data, open the file and read the data in the file to the memory. After the computation is completed, the computation results are still written to the file.
Although this method of storing data in files is still in use in many systems, such data was stored 30 or 40 years ago, it shows obvious shortcomings. These shortcomings are mainly due to the inability to effectively manage data in a unified manner. The details are shown in the following aspects:
It is inconvenient for programmers to write applications. The application designer needs to have a clear understanding of the logical and physical structures of the files used by the program. The computer operating system only provides very low-level operations such as opening, closing, and saving files. However, the modification and query operations on data must be implemented by applications, if the data required by the program is stored in different files, and the storage formats of these files are quite different. In this way, it brings great trouble to application development. programmers need to write corresponding interfaces for every file used in the program, and different file formats vary greatly, in this way, the programming workload is greatly increased, so that the efficiency of developing applications at the file level is very low, seriously affecting the development of application software.
Every modification to the file structure will lead to the modification of the application, so that the maintenance workload of the application is extremely large. People who have compiled programs all have this experience, that is, they have to re-modify, compile, and link the source program whenever the programs they have developed need to be modified. The trouble level can be imagined. Some people may say that programmers are "old-fashioned" people. it is difficult for outsiders to understand it.
File systems in computer operating systems generally do not support concurrent access to files. In modern computer systems, to make full use of the resource usage efficiency of computer systems, multiple programs are generally allowed to run simultaneously, that is, concurrency. The database system has the same concurrency requirements. Currently, large databases have very strong concurrent access mechanisms, which can fully utilize the software and hardware resources of the database server to avoid waste.
Due to the lack of integrity and uniformity in data management based on file systems, data structure, encoding, and representation formats cannot be standardized and standardized, different operating systems have different forms of representation, which leads to confusion in data management to a certain extent. In addition, data management based on file systems is difficult to take effective measures in terms of data security and confidentiality. in some scenarios with high security requirements, such security defects are totally unacceptable.
In view of these important shortcomings of file systems, people gradually develop a system featuring unified data management and sharing, which is a database system. The database system has developed in this context. In 1964, GE developed the world's first database system, IDS (Integrated Data Store ). IDS lays the foundation for the network-based database and has been widely released and applied. it has become a monument in the development history of database systems. In 1969, the United States international commercial Machine Company (IBM) also launched the world's first level database System IMS (Information Management System), also plays an important role in the development history of database systems.
In early 1970s, E. F. Codd proposed the concept of a relational data model based on the previous layers and the advantages and disadvantages of the mesh database. He proposed relational algebra and relational calculus (until today, in E. f. these basic theories of Codd are still about the development of this database system, and are still important to the computer professional classrooms in colleges and universities ). Throughout the 1970s S, relational database systems have achieved fruitful results both theoretically and practically. Theoretically, the complete relational model theory, data dependency theory, and relational database design theory are established (the basic theories of these relational databases will be described later). In practice, many famous relational database systems have emerged in the world, such as System R, INGRES, and Oracle.
Compared with the file system, the database system has a series of characteristics, which are embodied in the following aspects:
The database system provides users with advanced interfaces. In a file system, to access data, you must understand the file storage format and record structure. In the database system, this is not required. The database system handles these specific details and provides users with non-procedural database languages (commonly referred to as SQL languages). users only need to ask what data they need, you don't have to worry about how to obtain the data. Data Management is fully implemented by the Database Management System (DBMS: Database Management System.
Query processing and optimization. Query usually refers to some data operation requests submitted by the user to the database system. Because the database system provides users with a non-procedural data manipulation language, the query requests of users are completed by the DBMS, and the query optimization process becomes an important task of the DBMS.
Concurrency control. As mentioned above, file systems generally do not support concurrent operations, which greatly limits the effective use of system resources. In the database system, the situation is different. Modern database systems have a strong mechanism for concurrent operations. Multiple users can access the database at the same time, or even access different records in the same table at the same time. This greatly improves the efficiency of using computer system resources.
Data integrity constraints. All data must comply with certain constraints. The simplest example is the data type. for example, data defined as an integer cannot be a floating point number. Because the data in the database is persistent and shared, it is very important for the units that use the data to perform correct data rows. In relational database systems, important integrity constraints include entity integrity, domain integrity, referential integrity, and user-defined integrity, which will be highlighted in subsequent articles.
After 1980s, the computer hardware technology was rapidly improved. The improvement of computer technology has led to the continuous development of computer applications and the emergence of many new application fields, such as computer-aided design, computer-aided manufacturing, computer-assisted teaching, office automation, intelligent information processing, and decision-making support. These new fields impose new requirements on Database Systems. However, due to the diversity of applications, a unified data model cannot be designed to represent these new types of data and their relationships. as a result, there has been a situation of endless competition, it has produced the research and application of new databases such as deductive database, object-oriented database, distributed database, engineering database, temporal database, and fuzzy database.
So far, classic relational database systems have been widely used in the world, such as Sybase, Oracle, Informix, SQL Server, and DB2. In this series of special articles, we will also focus on the relational database system based on the actual application of the database system. Other database systems will also be briefly introduced.
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service