Swipe to navigate through the chapters of this book
One of the issues with data is that it has become more and more complex. As we saw in Chap. 2 there was a transition from early file based systems to more complex database systems which could be accessed using a query language. The format of data in relational systems is primarily alphabetic, numeric or alphanumeric with some special types such as date. In a relational database one is able to search, manipulate and select data with a powerful query language, SQL. As seen in Chap. 4, relational databases became the de facto standard for this type of data. However there is a growing demand to store complex objects and retrieve them. Databases are also being increasingly used in systems written in object oriented programming languages such as C++ and java which does not fit well with SQL. To overcome these problems standards for object oriented databases have been proposed. As a compromise solution some vendors, including Oracle have developed an object relational system where object structures have been incorporated into the relational model.
Please log in to get access to this content
To get access to this content you need the following product:
Atkinson M, Bancilhon F, DeWitt D, Dittrich K, Maier D, Zdonik S (1992) The object-oriented database system manifesto. In: Building an object-oriented database system. Morgan Kaufmann, San Mateo
Obe R, Hsu L (2012) PostgreSQL: up and running. O’Reilly, Sebastopol. ISBN 1-4493-2633-1
ODMG OQL (1998) User manual release 5.0. Available at http://www.csd.uwo.ca/courses/CS4411b/pdfO2manuals/oql.pdf. Last accessed 29/04/2013.
Oracle Corporation (2008) A sample application using object-relational features. Available at http://docs.oracle.com/cd/B28359_01/appdev.111/b28371/adobjxmp.htm#BABCCIBC. Last accessed 07/12/2012
Visual paradigm for UML community edition. http://www.visual-paradigm.com/solution/freeumltool/. Last accessed 29/04/2013
- Object and Object Relational Databases
- Springer London
- Sequence number
- Chapter number