ACM SIGMOD Anthology TODS dblp.uni-trier.de

Database Design with Common Sense Business Reasoning and Learning.

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)
@article{DBLP:journals/tods/StoreyCDGS97,
  author    = {Veda C. Storey and
               Roger H. L. Chiang and
               Debabrata Dey and
               Robert C. Goldstein and
               Shankar Sundaresan},
  title     = {Database Design with Common Sense Business Reasoning and Learning},
  journal   = {ACM Trans. Database Syst.},
  volume    = {22},
  number    = {4},
  year      = {1997},
  pages     = {471-512},
  ee        = {http://doi.acm.org/10.1145/278245.278246, db/journals/tods/StoreyCDGS97.html},
  bibsource = {DBLP, http://dblp.uni-trier.de}
}
BibTeX

Abstract

Automated database design systems embody knowledge about the database design process. However, their lack of knowledge about the domains for which databases are being developed significantly limits their usefulness. A methodology for acquiring and using general world knowledge about business for database design has been developed and implemented in a system called the Common Sense Business Reasoner, which acquires facts about application domains and organizes them into a a hierarchical, context-dependent knowledge base. This knowledge is used to make intelligent suggestions to a user about the entities, attributes, and relationships to include in a database design. A distance function approach is employed for integrating specific facts, obtained from individual design sessions, into the knowledge base (learning) and for applying the knowledge to subsequent design problems (reasoning).

Copyright © 1997 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.


ACM SIGMOD Anthology

CDROM Version: Load the CDROM "Volume 4 Issue 1, Books, VLDB-j, TODS, ..." and ... DVD Version: Load ACM SIGMOD Anthology DVD 2" and ... BibTeX

Corrigenda

TODS 23(1): 112-112a (1998)

Online Edition: ACM Digital Library

[Abstract and Index Terms]
[Full Text in PDF Format, 1269 KB]

References

[Batini et al. 1992]
Carlo Batini, Stefano Ceri, Shamkant B. Navathe: Conceptual Database Design: An Entity-Relationship Approach. Benjamin/Cummings 1992, ISBN 0-8053-0244-1
BibTeX
[Batini et al. 1986]
Carlo Batini, Maurizio Lenzerini, Shamkant B. Navathe: A Comparative Analysis of Methodologies for Database Schema Integration. ACM Comput. Surv. 18(4): 323-364(1986) BibTeX
[Bergamaschi and Sartori 1992]
Sonia Bergamaschi, Claudio Sartori: On Taxonomic Reasoning in Conceptual Design. ACM Trans. Database Syst. 17(3): 385-422(1992) BibTeX
[Bourrelly and Savelli 1991]
...
[Bouzeghoub 1992]
...
[Burg and van de Riet 1995]
J. F. M. Burg, Reind P. van de Riet: COLOR-X: Linguistically-based Event Modeling: A General Approach to Dynamic Modeling. CAiSE 1995: 26-39 BibTeX
[Chen 1976]
Peter P. Chen: The Entity-Relationship Model - Toward a Unified View of Data. ACM Trans. Database Syst. 1(1): 9-36(1976) BibTeX
[Chiang et al. 1994]
Roger H. L. Chiang, Terence M. Barron, Veda C. Storey: Reverse Engineering of Relational Databases: Extraction of an EER Model from a Relational Database. Data Knowl. Eng. 12(2): 107-142(1994) BibTeX
[Dahlgren 1988]
...
[Date 1986]
C. J. Date: An Introduction to Database Systems, Volume I, 4th Edition. Addison-Wesley 1986
BibTeX
[de Troyer 1989]
Olga De Troyer: RIDL*: A Tool for the Computer-Assisted Engineering of Large Databases in the Presence of Integrity Constraints. SIGMOD Conference 1989: 418-429 BibTeX
[Dey et al. 1998]
...
[Dik 1989]
...
[Dogac et al. 1989]
Asuman Dogac, Birol Yürüten, Stefano Spaccapietra: A Generalized Expert System for Database Design. IEEE Trans. Software Eng. 15(4): 479-491(1989) BibTeX
[Elmasri and Navathe 1994]
Ramez Elmasri, Shamkant B. Navathe: Fundamentals of Database Systems, 2nd Edition. Benjamin/Cummings 1994, ISBN 0-8053-1748-1
Contents BibTeX
[Goh et al. 1994]
Cheng Hian Goh, Stuart E. Madnick, Michael Siegel: Context Interchange: Overcoming the Challenges of Large-Scale Interoperable Database Systems in a Dynamic Environment. CIKM 1994: 337-346 BibTeX
[Goldstein et al. 1994]
...
[Goldstein and Storey 1995]
...
[Gomez-Perez 1995]
...
[Gruber 1993]
...
[Gruber 1991]
Thomas R. Gruber: The Role of Common Ontology in Achieving Sharable, Reusable Knowledge Bases. KR 1991: 601-602 BibTeX
[Guha and Lenat 1994]
Ramanathan V. Guha, Douglas B. Lenat: Enabling Agents to Work Together. Commun. ACM 37(7): 126-142(1994) BibTeX
[Gust 1991]
Helmar Gust: Representing Word Meanings. Text Understanding in LILOG 1991: 127-142 BibTeX
[Hayes 1998]
...
[Herzog and Rollinger 1991]
Claus-Rainer Rollinger, Otthein Herzog: Introducing LILOG. Text Understanding in LILOG 1991: 3-13 BibTeX
[Holyoak and Thagard 1986]
...
[Lenat and Guha 1990]
...
[Lenat et al. 1990]
Douglas B. Lenat, Ramanathan V. Guha, Karen Pittman, Dexter Pratt, Mary Shepherd: CYC: Toward Programs With Common Sense. Commun. ACM 33(8): 30-49(1990) BibTeX
[Lloyd-Williams and Beynon-Davis 1992]
...
[Loucopoulos and Theodoulidis 1992]
...
[Lord and Dahlgren 1990]
...
[Maes 1994]
Pattie Maes: Agents that Reduce Work and Information Overload. Commun. ACM 37(7): 30-40(1994) BibTeX
[McCarthy 1990]
...
[Michalski 1991]
...
[Minsky 1994]
Marvin Minsky, Doug Riecken: A Conversation with Marvin Minsky About Agents. Commun. ACM 37(7): 22-29(1994) BibTeX
[Mussi 1993]
Silvano Mussi: A Method for Putting Common Sense into an Expert Systems. IEEE Trans. Knowl. Data Eng. 5(3): 369-385(1993) BibTeX
[Nijssen and Halpin 1989]
...
[Neches et al. 1991]
...
[Reiner 1992]
...
[Riecken 1994]
Doug Riecken: Intelligent Agents - Introduction to the Special Issue. Commun. ACM 37(7): 18-21(1994) BibTeX
[Rob and Coronel 1993]
...
[Shavlik and Dietterich 1990]
...
[Shoval and Even-Chaime 1987]
Peretz Shoval, Moshe Even-Chaime: ADDS: A System for Automatic Database Schema Design Based on the Binary-Relationship Model. Data Knowl. Eng. 2: 123-144(1987) BibTeX
[Simon 1983]
...
[Sowa 1991]
...
[Spaccapietra and Parent 1994]
Stefano Spaccapietra, Christine Parent: View Integration: A Step Forward in Solving Structural Conflicts. IEEE Trans. Knowl. Data Eng. 6(2): 258-274(1994) BibTeX
[Storey 1988]
...
[Storey 1993]
Veda C. Storey: A Selective Survey of the Use of Artificial Intelligence for Database Design Systems. Data Knowl. Eng. 11(1): 61-(1993) BibTeX
[Storey and Goldstein 1993]
...
[Storey and Goldstein 1990]
...
[Storey and Goldstein 1988]
Veda C. Storey, Robert C. Goldstein: A Methodology for Creating User Views in Database Design. ACM Trans. Database Syst. 13(3): 305-338(1988) BibTeX
[Storey et al. 1996]
...
[Thanassas 1992]
...
[van der Vos et al. 1995]
Bram van der Vos, Jon Atle Gulla, Reind P. van de Riet: Verification of Conceptual Models based on Linguistic Knowledge. NLDB 1995: 0- BibTeX
[Wagner 1989]
...
[Walther et al. 1992]
...
[Wu et al. 1994]
...

Referenced by

  1. Meike Klettke: Reuse of Database Design Decisions. ER (Workshops) 1999: 213-224
  2. Veda C. Storey, Harald Ullrich, Shankar Sundaresan: An Ontology for Database Design Automation. ER 1997: 2-15
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:21 2008