DB2, Transact-SQL and Object-Relational Model of Data
DB2, Transact-SQL and Object-Relational Model of Data

Author(s): Vladimir Dimitrov
Subject(s): Economy, Business Economy / Management, ICT Information and Communications Technologies
Published by: Университет за национално и световно стопанство (УНСС)
Keywords: DB2; Transact-SQL; Microsoft SQL Server; Relational model of data; Object-relational model of data
Summary/Abstract: At the beginning of the 90’s of the last century, many experts predicted that the new object-oriented model of data would displace the relational model of data in the world of database systems. The object-oriented model of data still dominates in currently available programming languages. This model of data is suitable for reliable programming. Further, object-oriented concepts permit more adequate modelling of real world. However, above-mentioned prediction did not happened - the relational model of data successfully evolved into the object-relational model of data. The last one has adopted all object-oriented concepts and at the same time supports backward compatibility with the relational model of data. The last one happened to be very important because there were no need old applications using relational database systems to be re-engineered and recoded to work with the new object-relational database systems. Many DBMS vendors have declared its intention to support object-relational model of data, but only few of currently available database management systems are object-relational. This paper outlines the main characteristics of object-relational model of data and then investigates DB2 and Microsoft SQL Server support of that model of data. These two database systems are examples of successful and unsuccessful implementation of the object-relational model of data.

• Details
• Contents