The Use of a Complex Object Language in Geographic Data Management

Geographic database systems are very demanding with respect to database systems, very much like engineering and other non-traditional DBMS applications. This paper describes a language called XSQL/2 which extends the facilities of SQL to provide better support for these applications in general, and geographic applications in particular.. Among the extensions, we find: the introduction of unique identifiers for tuples, the introduction of base (hierarchical) complex objects in a way compatible with the referential integrity feature of relational DBMS's, the possibility to define dynamically any complex object with a network structure and to navigate through such structures. The language also introduces abstract data types on scalar or structured columns, and on complex objects themselves.

[1]  David Maier,et al.  Development of an object-oriented DBMS , 1986, OOPSLA 1986.

[2]  Roger L. Haskin,et al.  On extending the functions of a relational database system , 1982, SIGMOD '82.

[3]  Sylvia L. Osborn,et al.  The design of a relational database system with abstract data types for domains , 1986, TODS.

[4]  Klaus Meyer-Wegener,et al.  PRIMA - a DBMS Prototype Supporting Engineering Applications , 1987, VLDB.

[5]  Wil Plouffe,et al.  Complex Objects and Their Use in Design Transactions , 1983, Engineering Design Applications.

[6]  Kevin Wilkinson,et al.  Overview of the Iris DBMS , 1989, Research Foundations in Object-Oriented and Semantic Database Systems.

[7]  Michael Stonebraker,et al.  Application of Abstract Data Types and Abstract Indices to CAD Data Bases , 1986, Engineering Design Applications.

[8]  Jay Banerjee,et al.  Composite object support in an object-oriented database system , 1987, OOPSLA 1987.

[9]  Michael Stonebraker,et al.  The design of POSTGRES , 1986, SIGMOD '86.

[10]  Hans-Jörg Schek,et al.  Data Structures for an Integrated Data Base Management and Information Retrieval System , 1982, VLDB.

[11]  Hans-Jörg Schek,et al.  On Dynamically Defined Complex Objects and SQL , 1988, OODBS.

[12]  Won Kim,et al.  Supporting Complex Objects in a Relational System for Engineering Databases , 1985, Query Processing in Database Systems.

[13]  David Maier,et al.  Development of an object-oriented DBMS , 1986, OOPLSA '86.

[14]  Ralf Hartmut Güting,et al.  Gral: An Extensible Relational Database System for Geometric Applications , 1989, VLDB.

[15]  Thomas Sidle,et al.  Weaknesses of Commercial Data Base Management Systems in Engineering Applications , 1980, 17th Design Automation Conference.