![]() ![]() IBM now refers to this product as the Database Partitioning Feature (DPF) and bundles it with their flagship DB2 Enterprise product. This DB2 edition was eventually ported to all Linux, UNIX, and Windows (LUW) platforms, and was renamed to DB2 Extended Enterprise Edition (EEE). This edition allowed scalability by providing a shared-nothing architecture, in which a single large database is partitioned across multiple DB2 servers that communicate over a high-speed interconnect. In the mid-1990s, IBM released a clustered DB2 implementation called DB2 Parallel Edition, which initially ran on AIX. The next iteration of the mainframe and the server-based products were named DB2 Universal Database (or DB2 UDB). IBM lawyers stopped this handy naming convention from being used, and decided that all products needed to be called "product FOR platform" (for example, DB2 for OS/390). Other versions of DB2, with different code bases, followed the same '/' naming convention and became DB2/400 (for the AS/400), DB2/VSE (for the DOS/VSE environment), and DB2/VM (for the VM operating system). The new version of Database Manager was called DB2/2 and DB2/6000 respectively. (Note that DRDA is based on objects and protocols defined by Distributed Data Management Architecture (DDM).)Įventually, IBM decided to rewrite the software completely. IBM extended the functionality of Database Manager a number of times, including the addition of distributed database functionality by means of Distributed Relational Database Architecture (DRDA) that allowed shared access to a database in a remote location on a LAN. An earlier version of the code that would become DB2 LUW (Linux, Unix, Windows) was part of an Extended Edition component of OS/2 called Database Manager. An implementation of DB2 is also available for z/VSE and z/VM. Later, IBM brought DB2 to other platforms, including OS/2, UNIX, and MS Windows servers, and then Linux (including Linux on IBM Z) and PDAs. įor some years DB2, as a full-function DBMS, was exclusively available on IBM mainframes. The name DB2 (IBM Database 2), was first given to the Database Management System or DBMS in 1983 when IBM released DB2 on its MVS mainframe platform. The inspiration for the mainframe version of DB2's architecture came in part from IBM IMS, a hierarchical database, and its dedicated database-manipulation language, IBM DL/I. Later, the QMF feature of DB2 produced real SQL, and brought the same "QBE" look and feel to DB2. In 1976, IBM released Query by Example for the VM platform where the table-oriented front-end produced a linear-syntax language that drove transactions to its relational database. IBM's first commercial relational-database product, SQL/DS, was released for the DOS/VSE and VM/CMS operating systems in 1981. ![]() In parallel with the development of SQL, IBM also developed Query by Example (QBE), the first graphical query language. IBM bought Metaphor Computer Systems to utilize their GUI interface and encapsulating SQL platform that had already been in use since the mid-80s. When IBM released its first relational-database product, they wanted to have a commercial-quality sublanguage as well, so it overhauled SEQUEL and renamed the revised language Structured Query Language (SQL) to differentiate it from SEQUEL, and also because the acronym "SEQUEL" was a trademark of the UK-based Hawker Siddeley aircraft company. This led to an inexact interpretation of Codd's relational model that matched only part of the prescriptions of the theory the result was Structured English QUEry Language or SEQUEL. ![]() At the time, IBM didn't believe in the potential of Codd's ideas, leaving the implementation to a group of programmers not under Codd's supervision. To apply the relational model, Codd needed a relational-database language he named DSL/Alpha. A key development of the System R project was the Structured Query Language ( SQL). In 1974, the IBM San Jose Research center developed a relational DBMS, System R, to implement Codd's concepts. Codd, a researcher working for IBM, described the theory of relational databases, and in June 1970 published the model for data manipulation. ĭB2 traces its roots back to the beginning of the 1970s when Edgar F. However, in the 1990s IBM changed track and produced a Db2 common product, designed with a mostly common code base for L-U-W (Linux-Unix-Windows) DB2 for System z and DB2 for IBM i are different. Unlike other database vendors, IBM previously produced a platform-specific Db2 product for each of its major operating systems. The brand name was originally styled as DB/2, then DB2 until 2017 and finally changed to its present form. ![]() It initially supported the relational model, but was extended to support object–relational features and non-relational structures like JSON and XML. Db2 is a family of data management products, including database servers, developed by IBM. ![]()
0 Comments
Leave a Reply. |