D. Beech. Collections of Objects in SQL3. In Proceedings of International Conference on Very Large Data Bases, 1993, pages 244-255.  Home/Search   Document Not in Database   Summary   Related Articles   Check

....functions. Support for both complex values and user defined functions is important in DBMSs. In response to these requirements, SQL3 generalizes the relational model into an object model offering abstract data types and therefore allows users to define data types which suit their applications [4]. Tables can contain collections of objects (complex values) as well as tuples. DBMSs like Postgres and Informix allow users to register user defined external functions, written in a programming language, into the system and to use them as built in functions. However, most query languages such as ....

D. Beech. Collections of Objects in SQL3. In Proceedings of International Conference on Very Large Data Bases, 1993, pages 244-255.

....implementation of a system called FEAMOS, which is an integration of a main memory OR DBMS, AMOS [4] with a FEA program, TRINITAS [5] AMOSQL, the query language of AMOS, is used to represent and manage the FEA domain model. AMOSQL is a derivative of OSQL [6] but is also influenced by SQL3 [7]. TRINITAS, representing the state of the art within the field of FEA software, completely integrates the entire analysis process and is completely controlled through a graphical user interface. A typical TRINITAS session includes a generation of a finite element model from a specification of ....

....is contained in main memory and uses disk for backup only. It includes an object oriented extensible query language, AMOSQL, a derivative of OSQL [6] that is used to model and interface the database. AMOSQL is a functional language, originating from DAPLEX [29] and is also influenced by SQL3 [7]. The data model consists of the basic constructs objects, types, and functions. The AMOSQL language is also extensible by calling external programming languages like C or LISP, and AMOSQL statements can also be embedded within program procedures. Objects, Types, and Functions. Concepts in an ....

Beech, D.: Collections of Objects in SQL3. Proceedings of the 19th VLDB Conference, Dublin, Ireland, August 24-27, 1993, 244-255.

.... closely resembles the query language of the O2 OODBMS [Deu90] We chose OQL because even though it is a small language, and hence easier to comprehend, it contains most of the language features that are showing up in other object query languages and proposed relational extensions, such as SQL3 [Bee93] now called SQL:1999 [EM99] If we are able to handle OQL in full generality, we believe our work will be widely applicable to other query languages. OQL queries in our framework are translated into a calculus format that serves as an intermediate form, and then are translated into a version of ....

D. Beech. Collections of Objects in SQL3. In Proceedings of the 19th VLDB Conference, Dublin, Ireland, pages 244-255, August 1993.

....not have facilities for manipulating metadata. Hence features such as restructuring views that transform data into metadata and vice versa, dynamic schema definitions, and extended aggregation facilities supported in SchemaSQL are not available in SQL M. The emerging standard for SQL3 ( SQL96, Bee93] supports ADTs and oid s, and thus shares some features with higher order languages. However, even though it is computationally complete, to our knowledge it does not directly support the kind of higher order features in SchemaSQL. Krishnamurthy and Naqvi [KN88] and Krishnamurthy, Litwin, and ....

Beech, D. Collections of objects in SQL3. In Proc. 19th VLDB Conference, 1993.

....to define methods. For example, we should be able to define a relation of the form: EMPL(name; ssn; position; salary; dept; picture) where the attribute picture could be of the type gif blob , and we should be able to define operations on pictures and possibly other attributes. SQL3 5 [Bee93, MS] and many of the recent models in object relational database products such as Illustra [Sto96] Odapter, UniSQL, DB2, Omniscience have this and additional features useful for multi media databases. Moreover, with the current effort in object oriented database standards such as ODMG 93 [Cat96] and ....

D. Beech. Collections of Objects in SQL3. In VLDB 93, pages 244--255, 1993.

....not been addressed by its authors. Both HOSQL and OSQL do not allow ad hoc queries that refer to more than one component database in one shot. Finally, it is not clear that the semantics of HOSQL, OSQL, and XSQL are downward compatible with SQL. The powerful emerging standard for SQL3 ( SQL96, Bee93] supports ADTs, oid s, and external functions, but to our knowledge, does not directly support the kind of higher order features for meta data manipulation as in nD SQL; programming such features would thus be too low level and tedious. Some of the expressions for extracting domain values and ....

Beech, D. Collections of Objects in SQL3. In Proc. 19th VLDB Conf., 1993.

....have committed to supporting an OQL interface to their systems in the near term. The second is that it is a small language, hence easier to comprehend, but contains most of the language features that are showing up in other object query languages and proposed relational extensions, such as SQL3 [Bee93] If we are able to handle OQL in full generality, we believe our work will be widely applicable to other query languages. OQL queries in our framework are translated into a calculus format that serves as an intermediate form, and then are translated into a version of the nested relational ....

D. Beech. Collections of Objects in SQL3. In Proceedings of the 19th VLDB Conference, Dublin, Ireland, pages 244--255, August 1993.

....not have facilities for manipulating metadata. Hence features such as restructuring views that transform data into metadata and vice versa, dynamic schema definitions, and extended aggregation facilities supported in SchemaSQL are not available in SQL M. The emerging standard for SQL3 ( SQL96, Bee93] supports ADTs and oid s, and thus shares some features with higher order languages. However, even though it is computationally complete, to our knowledge it does not directly support the kind of higherorder features in SchemaSQL. Krishnamurthy and Naqvi [KN88] and Krishnamurthy, Litwin, and ....

Beech, D. Collections of objects in SQL3. In Proc. 19th VLDB Conference, 1993.

....iterators over data. The second generation of OO databases, called Object Relational Database Systems(ORDBMS) will include relationally complete query languages. Such systems are already emerging and will probably be based on standards for OO extensions of relational query languages such as SQL 3[7]. The next generation databases, both relational and OO, will also include extended capabilities for constraint management, event triggering, and database application interaction. The cooperation between the database and applications can consist of monitoring specific changes in the database that ....

....plans in an OO logical language called ObjectLog [51] The query language of AMOS, AMOSQL, is a derivative of OSQL. AMOSQL extends OSQL with active rules, a richer type system and multidatabase functionality. In the development of AMOSQL there is also an ambition to adapt to the future SQL 3[7] standard, but with the extensions mentioned above. The AMOS architecture (fig. 2.3) is a layered architecture consisting of seven levels. The external interface level can handle synchronous requests through a clientserver interface for loosely coupled applications and through a fast path ....

Beech D.: Collections of Objects in SQL3, VLDB conf. Dublin 1993, pp. 244-255

....have committed to supporting an OQL interface to their systems in the near term. The second is that it is a small language, hence easier to comprehend, but contains most of the language features that are showing up in other object query languages and proposed relational extensions, such as SQL3 [2]. Those features include multiple collection types, arbitrary nesting of type constructors, method invocation, complex object state, path expressions, object identity, subqueries at arbitrary points in query expressions, and a subtype hierarchy. If we are able to handle OQL, we believe our work ....

....and then impose these properties on the set and list constructors. One way of constructing sets is to union together a number of singleton set elements, e.g. f1g [ f2g [ f3g constructs the set f1; 2; 3g. Similarly, one way of constructing lists is to append singleton list elements, e.g. 1] [2] [3] constructs the list [1; 2; 3] where is the list append function) Both [ and are associative operations, but only [ is commutative and idempotent (i.e. 8x : x [ x = x) It is the commutativity and idempotence properties of [ that make sets different from lists. As to their ....

[Article contains additional citation context not shown here]

D. Beech. Collections of Objects in SQL3. In VLDB'93, pp 244--255.

....language standard being developed by both ANSI and ISO committees together for the last three years, aims to address this requirement. SQL3 is upward compatible with, and extends SQL 92, in many significant ways, one of the major extensions being the addition of an extensible object data model [13, 86]. This work is still evolving, with much work still need to be done. On the other hand, the Object Database Management Group (ODMG) as part of the OMG Organisation (an industrial consortium established to promote object technology) has proposed an industry standard for object databases [33] The ....

D. Beech. Collections of objects in SQL3. In Proc. Intl' Conf. on Very Large Data Bases, page 244, Dublin, Ireland, August 1993.

Online articles have much greater impact   More about CiteSeer.IST   Add search form to your site   Submit documents   Feedback  

CiteSeer.IST - Copyright Penn State and NEC