This page is part of the book SQL-99 Complete, Really, by Peter Gulutzan & Trudy Pelzer. The authors have graciously allowed us to reproduce the contents of the book here. Because the book is about the SQL-99 standard, the contents of this and other pages in the book may not directly apply to MariaDB. Use the navigation bar to navigate the book.

Some SQL vendors have already introduced Object/Relational features. We give especial note to:

UniSQL A smaller group, which gained note in 1992 for being the first to introduce an Object/Relational SQL (though some O/R features can be traced all the way back to 1980s versions of DB2 and Ingres).

IBM Offers "relational extenders", which are packages containing UDTs, user-defined functions, triggers and constraints. At the moment, IBM's "universal database" is probably the implementation which is closest to the SQL3 Object/Relational spec.

Informix Bought Illustra (one of the Object/Relational pioneers) and since then has won some praise for its DataBlades plug-ins, which are described as data-type extensions that is, Informix emphasizes the utility of defining your own data types, rather than the purported benefits of OO.

Oracle Oracle8's "cartridges" are another name for what we might call "class libraries" in pure OO contexts. So far, most cartridges have been multimedia packages, for example "Video cartridges" and "Spatial cartridges". For performance reasons, Oracle's Object/Relational features have not been popular among its users, till recently.

And finally, watch Sun. The world is waiting to see the impact of JavaBlend, which purportedly will merge Java with SQL3's Object/Relational extensions.

Comments

Comments loading...