ACM SIGMOD Anthology TODS dblp.uni-trier.de

A Methodology for Creating User Views in Database Design.

Veda C. Storey, Robert C. Goldstein: A Methodology for Creating User Views in Database Design. ACM Trans. Database Syst. 13(3): 305-338(1988)
@article{DBLP:journals/tods/StoreyG88,
  author    = {Veda C. Storey and
               Robert C. Goldstein},
  title     = {A Methodology for Creating User Views in Database Design},
  journal   = {ACM Trans. Database Syst.},
  volume    = {13},
  number    = {3},
  year      = {1988},
  pages     = {305-338},
  ee        = {http://doi.acm.org/10.1145/44498.45064, db/journals/tods/StoreyG88.html},
  bibsource = {DBLP, http://dblp.uni-trier.de}
}
BibTeX

Abstract

The View Creation System (VCS) is an expert system that engages a user in a dialogue about the information requirements for some application, develops an Entity-Relationship model for the user's database view, and then converts the E-R model to a set of Fourth Normal Form relations. This paper describes the knowledge base of VCS. That is, it presents a formal methodology, capable of mechanization as a computer program, for accepting requirements from a user, identifying and resolving inconsistencies, redundancies, and ambiguities, and ultimately producing a normalized relational representation. Key aspects of the methodology are illustrated by applying VCS's knowledge base to an actual database design task.

Copyright © 1988 by the ACM, Inc., used by permission. Permission to make digital or hard copies is granted provided that copies are not made or distributed for profit or direct commercial advantage, and that copies show this notice on the first page or initial screen of a display along with the full citation.


Joint ACM SIGMOD / IEEE Computer Society Anthology

CDROM Version: Load the CDROM "Volume 3 Issue 1, TODS 1976-1990" and ... DVD Version: Load ACM SIGMOD Anthology DVD 2" and ... BibTeX

References

[1]
C. Baldissera, Stefano Ceri, Giuseppe Pelagatti, Giampio Bracchi: Interactive Specification and Formal Verification of User's Views in Data Bases Design. VLDB 1979: 262-272 BibTeX
[2]
...
[3]
...
[4]
Peter P. Chen: The Entity-Relationship Model - Toward a Unified View of Data. ACM Trans. Database Syst. 1(1): 9-36(1976) BibTeX
[5]
...
[6]
...
[7]
C. J. Date: An Introduction to Database Systems, Volume I, 4th Edition. Addison-Wesley 1986
BibTeX
[8]
...
[9]
...
[10]
...
[11]
Shamkant B. Navathe, Ramez Elmasri, James A. Larson: Integrating User Views in Database Design. IEEE Computer 19(1): 50-62(1986) BibTeX
[12]
Shamkant B. Navathe, Suresh G. Gadgil: A Methodology for View Inegration in Logical Database Design. VLDB 1982: 142-164 BibTeX
[13]
Shamkant B. Navathe, Mario Schkolnick: View Representation in Logical Database Design. SIGMOD Conference 1978: 144-156 BibTeX
[14]
Kamran Parsaye: Database Management, Knowledge Base Management, and Expert System Development in PROLOG. Databases for Business and Office Applications 1983: 159-178 BibTeX
[15]
...
[16]
John Miles Smith, Diane C. P. Smith: Database Abstractions: Aggregation and Generalization. ACM Trans. Database Syst. 2(2): 105-133(1977) BibTeX
[17]
...
[18]
...

Referenced by

  1. Veda C. Storey, Roger H. L. Chiang, Debabrata Dey, Robert C. Goldstein, Shankar Sundaresan: Database Design with Common Sense Business Reasoning and Learning. ACM Trans. Database Syst. 22(4): 471-512(1997)
  2. Wen-Syan Li, Chris Clifton: Semantic Integration in Heterogeneous Databases Using Neural Networks. VLDB 1994: 1-12
  3. Veda C. Storey: Understanding Semantic Relationships. VLDB J. 2(4): 455-488(1993)
  4. Veda C. Storey, Robert C. Goldstein, Roger H. L. Chiang, Debabrata Dey: A Commonsense Reasoning Facility Based on the Entity-Relationship Model. ER 1993: 218-229
  5. Joobin Choobineh, Michael V. Mannino, Veronica P. Tseng: A Form-Based Approach for Database Analysis and Design. Commun. ACM 35(2): 108-120(1992)
  6. Hong-Mei Chen Garcia, Olivia R. Liu Sheng: An Entity-Relationship-Based Methodology for Distributed Database Design: An Integrated Approach Towards Combined Logical and Distribution Designs. ER 1992: 178-193
  7. Robert C. Goldstein, Veda C. Storey: Commonsense Reasoning in Database Design. ER 1991: 77-91
  8. Stephen Hayne, Sudha Ram: Multi-User View Integration System (MUVIS): An Expert System for View Integration. ICDE 1990: 402-409
  9. Robert C. Goldstein, Veda C. Storey: Some Findings on the Intuitivness of Entity-Relationship Constructs. ER 1989: 9-23
  10. Jürgen Diet, Frederick H. Lochovsky: Interactive Specification and Integration of User Views Using Forms. ER 1989: 171-185
BibTeX
ACM SIGMOD Anthology - DBLP: [Home | Search: Author, Title | Conferences | Journals]
TODS, ACM SIGMOD Anthology: Copyright © by ACM (info@acm.org), Corrections: anthology@acm.org
DBLP: Copyright © by Michael Ley (ley@uni-trier.de), last change: Tue Jun 24 18:39:04 2008