As a pioneer in the field of relational database, IBM completed the prototype of System R in 1977, and began to provide integrated database server-System/38 in 1980, followed by SQL/DSforVSE and VM. Its initial version is closely related to the research prototype of system R, and DB2 forMVSV 1 was launched in 1983. The goal of this version is to provide the simplicity, data independence and user productivity promised by this new scheme. DB2 for MVS provides powerful online transaction processing (OLTP) support in 1988, and implements distributed database support in 1989 and 1993 respectively. The recently launched DB2 Universal Database 6. 1 is a model of Universal Database, the first multimedia relational database management system with online function, and supports a series of platforms including Linux.
oracle
Oracle Bone Inscriptions, formerly known as SDL, was founded by Larry Ellision and two other programmers in 1977. They developed their own fist products and sold them in large quantities in the market. 1979, Oracle launched the first commercial SQL relational database management system. Oracle Company is one of the earliest manufacturers to develop relational databases, and its products support the most extensive operating system platforms. At present, the market share of Oracle relational database products is among the best.
Informix
Informix was founded in 1980, providing professional relational database products for Unix and other open operating systems. The company name Informix is taken from the combination of Information and Unix. Informix's first relational database product that really supported SQL language was Informix SE(StandardEngine). InformixSE was the main database product under the microcomputer Unix environment at that time. It is also the first commercial database product transplanted to Linux.
Sebes
Sybase company was founded in 1984. The company name "Sybase" comes from the combination of "system" and "database". Bob Epstein, one of the founders of Sybase Company, is the main designer of Ingres University Edition (a relational database model product at the same time as System/R). The first relational database product of this company is Sybase SQLServer 1.0, which was launched in May 1987. Sybase first put forward the idea of client/server database architecture, and took the lead in implementing it in Sybase SQLServer.
SQL Server
1987, Microsoft cooperated with IBM to develop OS/2, and IBM bundled OS/2Database Manager in its OS/2 ExtendedEdition system, but Microsoft product line still lacked database products. Therefore, Microsoft turned its attention to Sybase and signed a cooperation agreement with Sybase to develop a relational database based on OS/2 platform by using Sybase technology. 1989, Microsoft released the 1.0 version of SQL Server.
A database system
PostgreSQL is a free software object with complete characteristics-Relational Database Management System (ORDBMS), and many of its characteristics are the predecessors of many commercial databases today. PostgreSQL originally started with the Ingres project of BSD. The features of PostgreSQL cover SQL-2/SQL-92 and SQL-3. First of all, it contains the support of the richest data types in the world. Secondly, PostgreSQL is the only free software database management system that supports transaction, sub-query, multi-version parallel control system and data integrity check.
relational database
MySQL is a small relational database management system, which was developed by MySQL AB Company in Sweden. It was acquired by Sun Company on June 65438+ 10/6, 2008. At present, MySQL is widely used in small and medium-sized websites on the Internet. Because of its small size, high speed and low total cost of ownership, especially open source, many small and medium-sized websites choose MySQL as the website database to reduce the total cost of ownership.
Access database
1994 microcomputer database management system introduced by Microsoft company in the United States. It has the characteristics of friendly interface, easy to learn and use, simple development and flexible interface, and is a typical new generation desktop database management system. Its main features are as follows:
(1) manages all kinds of database objects perfectly, and has powerful functions such as data organization, user management and security check.
(2) Powerful data processing function. In the workgroup-level network environment, the multi-user database management system developed by Access has the client/server structure and the corresponding database security mechanism that the traditional XBASE (collectively referred to as XBASE(DBASE and FoxBASE) database system cannot achieve. Access has many characteristics of advanced large-scale database management system, such as transaction processing/error rollback function.
(3) Various data objects can be generated conveniently, and tables and reports can be established by using the stored data, with good visibility.
(4) As a part of Office suite, it can be integrated with Office to realize seamless connection.
(5) Be able to use the Web to retrieve and publish data and realize the connection with the Internet. Access is mainly suitable for small and medium-sized application systems, or as a client database in client/server systems.
FoxPro database
It was first introduced by Fox Company of the United States in 1988, and after Fox Company was acquired by Microsoft Company in 1992, FoxPro2.5, 2.6 and VisualFoxPro were successively introduced, and their functions and performance were greatly improved. FoxPro2.5 and 2.6 are divided into DOS and Windows versions, which run in DOS and Windows environments respectively. Compared with FoxBASE, FoxPro has greatly improved its function and performance, mainly by introducing windows, buttons, list boxes, text boxes and other controls, which further improves the development ability of the system.