• Information Technology
  • Human Resources
  • Careers
  • Giving
  • Library
  • Bookstore
  • Active Living
  • Continuing Education
  • Go Dinos
  • UCalgary Maps
  • UCalgary Directory
  • Academic Calendar
My UCalgary
Webmail
D2L
ARCHIBUS
IRISS
  • Faculty of Arts
  • Cumming School of Medicine
  • Faculty of Environmental Design
  • Faculty of Graduate Studies
  • Haskayne School of Business
  • Faculty of Kinesiology
  • Faculty of Law
  • Faculty of Nursing
  • Faculty of Nursing (Qatar)
  • Schulich School of Engineering
  • Faculty of Science
  • Faculty of Social Work
  • Faculty of Veterinary Medicine
  • Werklund School of Education
  • Information TechnologiesIT
  • Human ResourcesHR
  • Careers
  • Giving
  • Library
  • Bookstore
  • Active Living
  • Continuing Education
  • Go Dinos
  • UCalgary Maps
  • UCalgary Directory
  • Academic Calendar
  • Libraries and Cultural Resources
View Item 
  •   PRISM Home
  • Science
  • Science Research & Publications
  • View Item
  •   PRISM Home
  • Science
  • Science Research & Publications
  • View Item
JavaScript is disabled for your browser. Some features of this site may not work without it.

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

Thumbnail
Download
1996-598-18.pdf (4.566Mb)
Download Record
Download to EndNote/RefMan (RIS)
Download to BibTex
Author
Bradley, J.
Accessioned
2008-02-27T23:01:10Z
Available
2008-02-27T23:01:10Z
Computerscience
1999-05-27
Issued
1996-12-01
Subject
Computer Science
Type
unknown
Metadata
Show full item record

Abstract
An 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.
Notes
We 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.ca
Corporate
University of Calgary
Faculty
Science
Doi
http://dx.doi.org/10.11575/PRISM/30417
Uri
http://hdl.handle.net/1880/46318
Collections
  • Science Research & Publications

Browse

All of PRISMCommunities & CollectionsBy Issue DateAuthorsTitlesSubjectsThis CollectionBy Issue DateAuthorsTitlesSubjects

My Account

LoginRegister

Download Results

Statistics

Most Popular ItemsStatistics by CountryMost Popular Authors

  • Email
  • SMS
  • 403.220.8895
  • Live Chat

Energize: The Campaign for Eyes High

Privacy Policy
Website feedback

University of Calgary
2500 University Drive NW
Calgary, AB T2N 1N4
CANADA

Copyright © 2017