• 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.

CO-RELATIONSHIPS, LEVELS OF SIGNIFICANCE AND THE SOURCE OF THE CONNECTION TRAPIN RELATIONAL DATA BASES

Thumbnail
Download
1986-250-24.pdf (1.764Mb)
Download Record
Download to EndNote/RefMan (RIS)
Download to BibTex
Author
Bradley, James
Accessioned
2008-02-27T22:58:42Z
Available
2008-02-27T22:58:42Z
Computerscience
1999-05-27
Issued
1986-12-01
Subject
Computer Science
Type
unknown
Metadata
Show full item record

Abstract
We propose to attribute one or more precisely defined levels of semantic significance to every co-relationship in a relational data base. We also propose a precise definition of a relationship, and define a co-relationship as one of the two non trivial primitive relationship types, that is, a co-relationship occurs between two relations when a relationship relation can be formed with a single join on join attributes of the two relations that are neither primary nor candidate key attributes. It is shown that a co-relationship will give rise to a connection trap when users assume either a level of significance for the co-relationship that is too high, or which is correct but not supported by the data in the data base. Furthermore, anticipation by data base designers of user assumptions about levels of significance for co-relationships, and consequent data base modifications to avoid connection traps, will be very much a matter of judgement of user behavioral probabilities, thus rendering both automated data base design algorithms and universal relation generation algorithms prone to failure.
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/30432
Uri
http://hdl.handle.net/1880/46288
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