The design of an integrated data dictionary directory system
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.
- Arthur Andersen & Co. (1977), LEXICON General Description Manual, Arthur Andersen & Co., 1977.Google Scholar
- 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
- Canning,R. (1974), The Data Dictionary/Directory Function, EDP Analyzer, 1974.Google Scholar
- Canning,R. (1978), Installing a Data Dictionary, EDP Analyzer, 16,1, Jan. 1980.Google Scholar
- Cullinane Corporation (1980), Database Design and Definition Guide, Revision 1 Release 5.0, Cullinane Corporation, August 1978.Google Scholar
- Curtice,R.M. (1974), Some tools for Data Base Development, Datamation, July 1974, pp.102–106.Google Scholar
- Data Dictionary Systems Working Party (1977), The British Computer Society, Data Dictionary Systems Working Party Report, SIGMOD Record, 9,4, Dec. 1977.Google Scholar
- 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
- Ehrensberger,M. (1977), Data dictionary — More on the impossible dream, NCC, 1977, pp.9–11.Google Scholar
- 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
- 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
- Hotaka, R. (1981), Logical design of databases, in the monograph series of information processing, Information Processing Society of Japan, forthcoming in 1981.Google Scholar
- 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
- 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
- Lefkovits,H.C. (1978), Data Dictionary Systems, Q.E.D. Information Sciences, Inc., Wellesley, Massachusetts, Nov. 1978.Google Scholar
- 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
- 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
- Lyon,J.K. (1976), The Database Administrator, John Wiley & Sons,Inc., 1976.Google Scholar
- MSP Inc. (1976), DATAMANAGER: Fact Book, Management Systems and Programming Limited, Dec. 1976.Google Scholar
- MBA Inc. (1977), Data dictionary/directory evaluation criteria, M.Bryce & Associates, 1977.Google Scholar
- 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
- 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
- Software A G (1972), Data Dictionary Reference Manual, ADD-110-000, Software A G of North America, 1978.Google Scholar
- SPARC/DBMS Study Group (1975), Interim Report, ANSI/X3/SPARC, American National Standards Institutes, 1975.Google Scholar
- Towner,L.E. (1977), Integrated Data Base Development and Design Guide, Naval Intelligence Processing System Support Activity, AD A050468, Dec. 1977.Google Scholar
- Tsubaki,M. (1979), Distributed Database and DD/D, DBMS-WG, Information Processing Society of Japan, Sept. 1979.Google Scholar
- 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
- Uhrowczik,P.P. (1973), Data Dictionary/Directories, IBM SYST. J, No.4, 1973, pp.332–350.Google Scholar