J. Ong, D. Fogg, and M. Stonebraker. Implementation of Data Abstraction in the Relational Database System Ingres. SIGMOD Record, 14(1):1--14, 1984.  Home/Search   Document Not in Database   Summary   Related Articles   Check

....can be organized. In Section 6 we briefly discuss the implementation of user interfaces on top of SEC ONDO, and Section 7 concludes the paper. 2 Related Work The first approach to open up the type system of a relational DBMS with abstract data types (ADTs) was pioneered by the Ingres project [OnFS84]. It was followed by Postgres [StR86] primarily focusing on query optimization with ADTs and support for complex objects. Another important project implementing an extensible relational system was Starburst [ScCF 86] with query processing and a clean architecture for storage and indexing of ....

J. Ong, D. Fogg, and M. Stonebraker. Implementation of Data Abstraction in the Relational Database System Ingres. SIGMOD Record, 14(1):1-14, March 1984.

....EXCESS provides a cleaner treatment of arrays than we have seen elsewhere. The only point for comparison here is POSTQUEL, which only operates on one dimensional arrays of base types. Finally, ADT and access method extensibility in EXTRA EXCESS were heavily influenced by the work of Stonebraker [Ong84, Ston86] and the resulting extension facilities in POSTGRES [Ston87b] Our work here differs mostly in minor respects. Because ADTs in our system are written E, the system s internal language, adding ADTs is perhaps simpler here. Another difference is that we view ADT operators as synonyms for function ....

....val2 fields together, producing a result of type Complex. Since some users may prefer a more symmetric function call syntax, EXCESS will also accept this expression in the form Add(CnumPair.val1, CnumPair.val2) In addition to supporting standard ADT function invocation, we follow the lead of [Ong84, Ston86, Ston87b] and support the registration of operators as an alternative function invocation syntax. For example, to define as a infix operator synonym for the Add member function of the Complex dbclass, we would enter: define adt op infix for Complex Add With this definition, the previous example s ....

J. Ong, D. Fogg, and M. Stonebraker, "Implementation of Data Abstraction in the Relational Database System INGRES," SIGMOD Record 14(1), March 1984.

....the system, an ADT could be used just like a built in type in defining the type of an attribute of a relation. ADT functions could be used in queries and would be dynamically loaded as needed at runtime. This approach was pioneered by the ADT Ingres effort at UC Berkeley in the early 1980 s [Ong84]. 1 In the mid 1980 s, the Postgres project began as a follow on to Ingres, initially laying out an approach to providing query optimizers with information about the properties of ADTs and their functions [Ston86a] Another goal of Postgres was to provide support for storing and querying complex ....

J. Ong, D. Fogg, and M. Stonebraker, "Implementation of Data Abstraction in the Relational Database System Ingres," SIGMOD Record 14(1), March 1984.

....and naturally addressed. In particular, we propose that a field in a data base be allowed to have a value which is a collection of commands in the query language supported by the DBMS (e.g. SQL [SORD84] or QUEL) Our proposal should augment a field oriented abstract data type (ADT) facility (e.g. [ONG84]) Such an ADT capability appears useful for supporting relatively simple objects which do not require shared subobjects (e.g. lines, points, complex numbers, etc. On the other hand, data base procedures are attractive for more complex objects, possibly with shared subobjects (e.g. forms, icons, ....

.... OBJECT (Oid, text, shape) LINE (Lid, l desc) TEXT (Tid, t desc) POLYGON (Pid, p desc) Subcomponents of objects would be inserted into the LINE, TEXT or POLYGON relation, and we assume that l desc and p desc are of type line and point respectively and utilize a fieldoriented ADT facility (e.g. [ONG84]) For example: append to LINE (Lid = 22, l desc = 0,0) 14,28) ############################# Of course, authorization must be done for the above command to support access control. It would be beneficial to avoid reauthorizing a command each time it is executed from an application ....

[Article contains additional citation context not shown here]

Ong, J., et. al., "Implementation of Data Abstraction in the Relational Database System INGRES," SIGMOD Record, March 1984.

No context found.

J. Ong, D. Fogg, and M. Stonebraker. Implementation of Data Abstraction in the Relational Database System Ingres. SIGMOD Record, 14(1):1--14, 1984.

No context found.

Ong84a Ong, J., Fogg, D., and Stonebraker, M., "Implementation of Data Abstraction in the Relational Database System INGRES," ACM SIGMOD Record, vol. 14, no. 1, 1984, pp. 114.

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