1 / 6

The Clash of the (database) Cultures

The Clash of the (database) Cultures. Object- oriented. Relational. Two strategies in order to combine the „cultures“: Relational – object-oriented Example: Fastobjects‘ ODBC interface Object – relational Example: SQL 3 or SQL:2003.

lareina-giles
Download Presentation

The Clash of the (database) Cultures

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. The Clash of the (database) Cultures Object- oriented Relational

  2. Two strategies in order to combine the „cultures“: • Relational – object-oriented • Example: Fastobjects‘ ODBC interface • Object – relational • Example: SQL 3 or SQL:2003

  3. Object-relational databases based on SQL-3 are partwise according to the Manifesto:

  4. Structures table type CREATE TYPE PersonType AS (Name VARCHAR (30), Address VARCHAR (50)) NOT FINAL; Inherited type CREATE TYPE StaffMemberType UNDER PersonType AS (Salary DECIMAL (6)) NOT FINAL; CREATE TABLE StaffMember OF StaffMemberType (REF IS oid SYSTEM GENERATED); For more details see: http://www.objs.com/x3h7/sql3.htm Table definition based on a type; insertion of an OID Examples

  5. (2) Object-oriented database systems offer relational interfaces Example: Fastobjects‘ ODBC interface

  6. FastObjects database FastObjects Engine C++ Application (native API) Access database Object-oriented FastObjects ODBC driver Access Client Relational C++ Application (ODBC API) Access database Access Engine Access ODBC driver Architecture of FastObjects ODBC

More Related