![]() (Note that DRDA is based on objects and protocols defined by Distributed Data Management Architecture (DDM).)Įventually, IBM took the decision to completely rewrite the software. 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 80's. 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. Historically, and unlike other database vendors, IBM produced a platform-specific Db2 product for each of its major operating systems.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |