AN EXTENDED SQL AND QBE WITH SEAMLESS INCORPORATION OF GENITIVE RELATION AND NATURAL QUANTIFIER CONSTRUCTS

Simple item page
dc.contributor.authorBradley, J.eng
dc.date.accessioned2008-02-27T23:01:10Z
dc.date.available2008-02-27T23:01:10Z
dc.date.computerscience1999-05-27eng
dc.date.issued1996-12-01eng
dc.description.abstractAn extended SQL, called E-SQL, is described, for use with an extended relational data model. The data model allows for restricted unnormalized relations; sets or lists of atomic attributes are allowed but not attributes that are relations, and there is support for both inheritance and composite entities. E-SQL permits the constructs of conventional SQL, but also permits use of genitive relations to model containment relationships and facilitate application of natural quantifiers to containment sets. A genitive relation is a relation that is the equivalent to the genitive case grammatical construct in natural language. The genitive relation construct and the conventional constructs of SQL can be mixed in a seamless manner. For example, the condition within a conventional SQL-IN-construct could contain a condition that is a quantified genitive relational condition, and vice versa. Use of conditions that involve comparison of a quantified genitive relation with a quantified base table is also permitted. E-SQL can also manipulate a set of composite entity instances modelled as a group of relations. E-SQL is essentially a seamless merger of conventional SQL and an experimental genitive relation language, called COOL, designed for efficient manipulation of containment sets. It is shown that an Extended Relational Algebra (ERA) can be used to reduce E-SQL expressions. E-SQL expressions are much more concise and much less error-prone than conventional SQL expressions. It is also shown how the quantified genitive relation concept can be used in an extension of the graphical query language QBE that greatly increases both its retrieval power and simplicity of use.eng
dc.description.notesWe are currently acquiring citations for the work deposited into this collection. We recognize the distribution rights of this item may have been assigned to another entity, other than the author(s) of the work.If you can provide the citation for this work or you think you own the distribution rights to this work please contact the Institutional Repository Administrator at digitize@ucalgary.caeng
dc.identifier.department1996-598-18eng
dc.identifier.doihttp://dx.doi.org/10.11575/PRISM/30417
dc.identifier.urihttp://hdl.handle.net/1880/46318
dc.language.isoEngeng
dc.publisher.corporateUniversity of Calgaryeng
dc.publisher.facultyScienceeng
dc.subjectComputer Scienceeng
dc.titleAN EXTENDED SQL AND QBE WITH SEAMLESS INCORPORATION OF GENITIVE RELATION AND NATURAL QUANTIFIER CONSTRUCTSeng
dc.typeunknown
thesis.degree.disciplineComputer Scienceeng
Files
Original bundle
Now showing 1 - 1 of 1
Thumbnail Image
Name:
1996-598-18.pdf
Size:
4.57 MB
Format:
Adobe Portable Document Format
Download
License bundle
Now showing 1 - 1 of 1
No Thumbnail Available
Name:
license.txt
Size:
1.86 KB
Format:
Plain Text
Description:
Download
Collections
Science Research & Publications