The design of an integrated data dictionary directory system

  • Ryosuke Hotaka
Part 1. Data Base Design And Requirement Engineering
Part of the Lecture Notes in Computer Science book series (LNCS, volume 132)


As the processes of information system development and maintenance became complex, the needs for controlling and maintaing the processes themselves came out. Data Dictionary/Directory (DD/D) was developed after the experience of the database management system to complement the above needs.

Owing to its historical constraints, DD/D had to use the then available tools such as conventional files or databases. It turned out, however, that one cannot overcome some intrinstic deficiency so far as relying on existing tools. In particular, the departure of DD/D from DBMS causes theoretically unfavorable problems.

The integrated DD/D (GUIDE (1974)) overcomes these problems. The practical architecture of an integrated DD/D using the self-descriptive DBMS (Hotaka and Tsubaki (1977)) is described with a concrete example.

Some efficiency degradation, perhaps intrinsic in the integrated DD/D and DBMS, is observed and the practical method of optimization is stated.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. Arthur Andersen & Co. (1977), LEXICON General Description Manual, Arthur Andersen & Co., 1977.Google Scholar
  2. Cahill,J.J. (1970), A Dictionary/Directory Method for Building a Common MIS Data Base, Journal of Systems Management, Nov. 1970, pp.23–29.Google Scholar
  3. Canning,R. (1974), The Data Dictionary/Directory Function, EDP Analyzer, 1974.Google Scholar
  4. Canning,R. (1978), Installing a Data Dictionary, EDP Analyzer, 16,1, Jan. 1980.Google Scholar
  5. Cullinane Corporation (1980), Database Design and Definition Guide, Revision 1 Release 5.0, Cullinane Corporation, August 1978.Google Scholar
  6. Curtice,R.M. (1974), Some tools for Data Base Development, Datamation, July 1974, pp.102–106.Google Scholar
  7. Data Dictionary Systems Working Party (1977), The British Computer Society, Data Dictionary Systems Working Party Report, SIGMOD Record, 9,4, Dec. 1977.Google Scholar
  8. DDSWP: BCS Computer Society Data Dictionary Systems Working Party (1977), The British Computer Society Data Dictionary Systems Working Party Record, SIGMOD Record, 9, 4, Dec. 1977.Google Scholar
  9. Ehrensberger,M. (1977), Data dictionary — More on the impossible dream, NCC, 1977, pp.9–11.Google Scholar
  10. GUIDE Report for the GUIDE Dictionary/Directory Project (1974), Requirements for the Data Dictionary/Directory Within the GUIDE/SHARE Data Base Management System Concept, GUIDE Data Dictionary/Directory Project, GUIDE (1974).Google Scholar
  11. Hotaka,R. and Tsubaki,M. (1977), Self-descriptive Relational Data Base, Third International Conference on Very Large Data Bases, 1977, pp.415–426.Google Scholar
  12. Hotaka, R. (1981), Logical design of databases, in the monograph series of information processing, Information Processing Society of Japan, forthcoming in 1981.Google Scholar
  13. Lee, E.K.C. and Lee, E.Y.S. (1975), Development of a Data, Dictionary/Directory for Large Data Systems, Proceedings of International Computer Symposium, 1975 (Vol. II), pp.157–165.Google Scholar
  14. Lee,E.K.C. and Lee,E.Y.S. (1975), Development of a Data Dictionary/Directory Using a Data Base Management system, Second National Symposium on the Management of Data Element in Information Processing, Oct. 1975, pp.151–162.Google Scholar
  15. Lefkovits,H.C. (1978), Data Dictionary Systems, Q.E.D. Information Sciences, Inc., Wellesley, Massachusetts, Nov. 1978.Google Scholar
  16. Leong-Hong,B. and Marron,B. (1977), Technical Profile of Seven Data Element Dictionary/Directory Systems, NBS Special Publication 500-3, National Bureau of Standards, Department of Commerce, Feb. 1977.Google Scholar
  17. Leong-Hong,B. and Marron,B. (1978), Database Administration: Concepts Tools, Experiences, and Problems, NBS SP 500-28, National Bureau of Standards, Department of Commerce, March 1978.Google Scholar
  18. Lyon,J.K. (1976), The Database Administrator, John Wiley & Sons,Inc., 1976.Google Scholar
  19. MSP Inc. (1976), DATAMANAGER: Fact Book, Management Systems and Programming Limited, Dec. 1976.Google Scholar
  20. MBA Inc. (1977), Data dictionary/directory evaluation criteria, M.Bryce & Associates, 1977.Google Scholar
  21. Plagman,B.K. (1977 a), Data Dictionary/Directory System: A tool for data administration and control, 22-01-02, Data Base Management, Auerbach Publishers Inc. 1977, pp.1–10.Google Scholar
  22. Plagman,B.K. (1977 b), Criteria for the selection of data dictionary/directory system, 22-04-01, Data Base Management, Auerbach Publishers Inc., 1977, pp.1–10.Google Scholar
  23. Software A G (1972), Data Dictionary Reference Manual, ADD-110-000, Software A G of North America, 1978.Google Scholar
  24. SPARC/DBMS Study Group (1975), Interim Report, ANSI/X3/SPARC, American National Standards Institutes, 1975.Google Scholar
  25. Towner,L.E. (1977), Integrated Data Base Development and Design Guide, Naval Intelligence Processing System Support Activity, AD A050468, Dec. 1977.Google Scholar
  26. Tsubaki,M. (1979), Distributed Database and DD/D, DBMS-WG, Information Processing Society of Japan, Sept. 1979.Google Scholar
  27. Tsubaki,M and Hotaka,R. (1979), Distributed Multi-Database Environment with a Supervisory Data Dictionary Databases, in Entity-Relationship Approach to Systems Analysis and Design, edited by P.P.Chen, North-Holland Publishing Company, 1980, pp.553–574.Google Scholar
  28. Uhrowczik,P.P. (1973), Data Dictionary/Directories, IBM SYST. J, No.4, 1973, pp.332–350.Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 1982

Authors and Affiliations

  • Ryosuke Hotaka
    • 1
  1. 1.The University of TsukubaIbarakiJapan

Personalised recommendations