An intelligent information dictionary for semantic manipulation of relational databases

  • Stephanie J. Cammarata
Database Administration
Part of the Lecture Notes in Computer Science book series (LNCS, volume 303)

Abstract

This paper describes an intelligent information dictionary (IID) which serves as a knowledge-based interface between a database user and the query language of a relational database management system. IID extends the traditional roles of a data dictionary by enabling a user to view, manipulate, and verify semantic aspects of relational data. Our use of IID focuses on the interactive creation of simulation-specific databases from large "public" databases in the domain of military simulation and modeling. We have identified classes of database-related activities performed by a simulation developer when preparing databases as input to simulation models. Three categories of IID capabilities supporting these activities are explanation and browsing, customized data manipulation, and interactive consistency checking. In this paper we detail specific features of these categories and present examples of their use.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. [Alle82]
    Allen, F. W., Loomis, M. E., and Manning, M. V., “The integrated dictionary/directory system,” ACM Computing Surveys 14(2), pp.245–286 (June 1982).Google Scholar
  2. [Chan81]
    Chan, P. and Shoshani, A., “Subject: A directory driven system for organizing and accessing large statistical databases,” pp. 553–563 in Proceedings of the seventh international conference on very large Data Bases, Cannes, France (1981).Google Scholar
  3. [Curt81]
    Curtice, R.M., “Data dictionaries: An assessment of current practice and problems,” pp. 564–570 in Proceedings of 7th conference on very large data bases, Cannes, France (September 1981).Google Scholar
  4. [Dolk87]
    Dolk, D. and II, R. Kirsch, “A relational information resource dictionary system,” Communications of the ACM 30(1), pp.48–61 (January 1987).Google Scholar
  5. [Gold85]
    Goldfine, A., “The information resource dictionary system,” pp. 114–122 in Proceedings of the fourth international conference Entity-Relationship approach, Chicago, IL (October 1985).Google Scholar
  6. [Inte87]
    Intellinews3(2), Intellicorp (January 1987).Google Scholar
  7. [Kers83]
    Kerschberg, L., Marchand, D., and Sen, A., “Information system integration: A metadata management approach,” pp. 223–239 in Proceedings of the fourth international conference on Information Systems, Houston, TX (1983).Google Scholar
  8. [Koss87]
    Kossman, R., “An active information resource dictionary,” in Proceedings of Ingres user association meetings, San Francisco, CA (April 1987).Google Scholar
  9. [Mark86]
    Mark, L. and Roussopoulos, N., “Metadata management,” Computer 19(12), pp.26–35 (December 1986).Google Scholar
  10. [Mark87]
    Mark, L. and Roussopoulos, N., “Information interchange between self-describing data-bases,” Data Engineering 10(3), pp.46–52 (September 1987).Google Scholar
  11. [Mart86]
    Martin, D., Advanced database techniques, The MIT Press, Cambridge, MA (1986).Google Scholar
  12. [McCa82]
    McCarthy, J.L., “Metadata management for large statistical databases,” in Proceedings of 8th conference on very large databases (September 1982).Google Scholar
  13. [Nava86]
    Navathe, S. and Kerschberg, L., “Role of dictionaries in information resource management,” Information and Management 10(1), pp.21–46 (January 1986).Google Scholar
  14. [Shep86]
    Shephard, A. and Kerschberg, L., “Constraint management in expert database systems,” pp. 309–331 in Expert database systems, ed. L. Kerschberg, Benjmain/Cummings Publishing Company, Inc., Menlo Park, CA (1986).Google Scholar
  15. [Ston85]
    Stonebraker, M. and Rowe, L.A., “The design of POSTGRES,” Memorandum No. UCB/ERL 85/95, University of California, Berkeley, Berkeley, CA (November 15, 1985).Google Scholar
  16. [Tou82]
    Tou, F. N., Williams, M. D., Fikes, R., Henderson, A., and Malone, T., “Rabbit: An intelligent database assistant,” pp. 314–318 in Proceedings of the third annual national conference on artificial intelligence, Pittsburg (1982).Google Scholar

Copyright information

© Springer-Verlag 1988

Authors and Affiliations

  • Stephanie J. Cammarata
    • 1
  1. 1.The RAND CorporationSanta Monica

Personalised recommendations