DB2 9 Data server Development 3 music

It is hard to imagine that there are any applications that are irrelevant to the database. Even Microsoft's next-generation OS Vista uses its database to organize its new file system. It can be said that after years of development, the data has become the entire information process and the next stage of development of the most valuable resources, while the preservation and management of data resources of the database, its technology development and progress, has become the most worthy of concern and attention. From the hierarchical database to the management relational database, and even the current hybrid database DB2 9, which supports both relational and XML, the database management technology has experienced more than 3 stages in the course of its development for nearly 40 years.

IMS: An early hierarchical database

Database management system before the emergence of a very primitive data management, data processing relies on punched cards to carry out, when the data management, only the card for physical storage and processing. The storage and management of data is extremely cumbersome and complex, and it simply cannot reflect efficiency. After IBM produced its first disk drive (Model 305 ramac) in 1956, it triggered a revolution in data management and was thus able to store data randomly. Since then, the earliest version of the database, the Network database management system (DBMS), was successfully developed by GE in 1961 and its IDs (integrated Datastore, integrated data storage) are the world's first networked DBMS and the first DBMS. But it can only run on the General Electric Mainframe, and the database has only one file, all tables must be generated by hand-coded, has great limitations. To this end, the IBM developed hierarchical database IMS (Information Management system, information management systems) has been greatly welcomed, become the most famous and most typical of the hierarchical database management system.

In 1966, IBM, in collaboration with its customers (Rockwell and Caterpillar), developed a new database to help NASA manage the cumbersome data of the ambitious Apollo program, and was completed by IBM engineers in 1968. The database was renamed "IMS" (Information Management system, information management systems) when it was released as an IBM product in 1969. NASA continued to use the product in its space shuttle program in 1969, after NASA successfully launched Apollo 11th to make the first moon landing for humans. Until today, the database has always been useful, in today's Internet application connectivity, business intelligence applications such as the new role found.

RDBMS: Emergence of relational databases

Although the hierarchical database has been a good solution to the problem of data centralization and sharing, it still lacks in data independence and abstraction level. Fortunately, just in 1970, IBM researcher e.f.codd The concept of the relational model, thus laying the theoretical foundation of the relational model. His paper "A Relational Model of data for Large Shared data Banks" is also considered a landmark milestone in the history of database systems. After continuous development and argumentation, finally make the more advantageous relational database becomes the mainstream of the market. Then, in 1974, Ray Boyce and Don Chamberlin of IBM presented the SQL language, which implemented all the operations of the database lifecycle and laid another milestone for the relational database.

In 1979, IBM completed the first DBMS to implement SQL. In the early 80 of the 20th century, IBM took advantage of the second phase of RDBMS and SQL technology to create a new database product named DB2, a database product with second-generation technologies. Over the years, DB2 has evolved from important mainframe products to products that run on a variety of server platforms. Especially in System 390, now called System Z, DB2 has become the core of distributed computing.

In spite of the constant competition of the database products of the same period manufacturer, DB2 is still widely used and praised in the high-end enterprise application market. After years of development and progress, nearly 500,000 DB2 data servers have been running on System z and on the Intel platform where Linux systems are installed.

IBM DB2 9: The first hybrid data server

With the development of informatization process and the need of enterprise and internal information exchange, XML, as a standardized data storage format, is facing a huge increase in data volume. In fact, every industry is implementing XML data standards, and the new Microsoft Office software will also store documents in XML format. In addition, more and more companies are turning to XML technology to help them progressively implement SOA by exchanging data between different systems and applications and adapting to fast-changing environments. DB2 9 (code-named Viper), which combines the characteristics of relational and hierarchical databases, introduces another possible-hybrid database that can support XML data very well, while supporting other technologies including SQL, tabular data structures, and various DBMS features.