Role of data dictionaries in information resource management

Abstract The role of information resource dictionary systems (data dictionary systems) is important in two important phases of information resource management: First, information requirements analysis and specification, which is a complex activity requiring data dictionary support: the end result is the specification of an “Enterprise Model,” which embodies the major activities, processes, information flows, organizational constraints, and concepts. This role is examined in detail after analyzing the existing approaches to requirements analysis and specification. Second, information modeling which uses the information in the Enterprise Model to construct a formal implementation independent database specification: several information models and support tools that may aid in transforming the initial requirements into the final logical database design are examined. The metadata — knowledge about both data and processes — contained in the data dictionary can be used to provide views of data for the specialized tools that make up the database design workbench. The role of data dictionary systems in the integration of tools is discussed.

[1]  Shamkant B. Navathe,et al.  1978 New Orleans Data Base Design Workshop Report , 1979, Fifth International Conference on Very Large Data Bases, 1979..

[2]  Douglas T. Ross,et al.  Structured Analysis for Requirements Definition , 1977, IEEE Transactions on Software Engineering.

[3]  Herman Lam,et al.  Transformation of data traversals and operations in application programs to account for semantic changes of databases , 1981, TODS.

[4]  Shamkant B. Navathe,et al.  Distribution Design of Logical Database Schemas , 1983, IEEE Transactions on Software Engineering.

[5]  Donald D. Chamberlin,et al.  SEQUEL 2: A Unified Approach to Data Definition, Manipulation, and Control , 1976, IBM J. Res. Dev..

[6]  J. Daniel Couger,et al.  Evolution of Business System Analysis Techniques , 1973, CSUR.

[7]  Yc Lee,et al.  A Relational Approach to the Integrated Database Management System for Computer-Aided Manufacturing , 1985 .

[8]  Shamkant B. Navathe,et al.  An Integrated Approach to Database Design , 1978, Data Base Design Techniques I.

[9]  David W. Chilson,et al.  Database design: a survey of logical and physical design techniques , 1983, DATB.

[10]  Michael Stonebraker,et al.  The design and implementation of INGRES , 1976, TODS.

[11]  Michael L. Brodie,et al.  A Prototyping Approach to Database Applications Development , 1984, IEEE Database Eng. Bull..

[12]  Michael E. Senko,et al.  Data Structures and Accessing in Data-Base Systems. I: Evolution of Information Systems , 1973, IBM Syst. J..

[13]  Maurizio Lenzerini,et al.  A computer-aided methodology for conceptual data-base design , 1982, Inf. Syst..

[14]  Alfonso F. Cardenas,et al.  Data base communication in a heterogeneous data base management system network , 1980, Inf. Syst..

[15]  Toby J. Teorey,et al.  The Database Designer's Workbench , 1984, Inf. Sci..

[16]  Daniel Teichroew,et al.  An introduction to computer-aided documentation of user requirements for computer-based Information Processing Systems , 1975 .

[17]  Diane C. P. Smith,et al.  Database abstractions: aggregation and generalization , 1977, TODS.

[18]  Randy H. Katz.  Database design and translation for multiple data models , 1980 .

[19]  James A. Larson,et al.  Integrating User Views in Database Design , 1986, Computer.

[20]  Shamkant B. Navathe,et al.  View representation in logical database design , 1978, SIGMOD Conference.

[21]  Dennis McLeod,et al.  Database description with SDM: a semantic database model , 1981, TODS.

[22]  Michael Stonebraker,et al.  Embedding expert knowledge and hypothetical data bases into a data base system , 1980, SIGMOD '80.

[23]  Ramez Elmasri,et al.  Object integration in logical database design , 1984, 1984 IEEE First International Conference on Data Engineering.

[24]  Maurizio Lenzerini,et al.  A Methodology for Data Schema Integration in the Entity Relationship Model , 1984, IEEE Transactions on Software Engineering.

[25]  Toby J. Teorey,et al.  The Logical Record Access Approach to Database Design , 1980, CSUR.

[26]  Douglas T. Ross,et al.  Structured Analysis (SA): A Language for Communicating Ideas , 1977, IEEE Transactions on Software Engineering.

[27]  John Mylopoulos,et al.  A language facility for designing database-intensive applications , 1980, TODS.

[28]  SHAMKANT B. NAVATHE,et al.  On the implementation of a conceptual schema model within a three-level DBMS architecture* , 1979, 1979 International Workshop on Managing Requirements Knowledge (MARK).

[29]  Maurizio Lenzerini,et al.  INCOD: A System for Conceptual Design of Data and Transactions in the Entity-Relationship Model , 1981, ER.

[30]  Eckhard D. Falkenberg,et al.  CSL: A Language for Defining Conceptual Schemas , 1979, IFIP TC-2 Working Conference on Data Base Architecture.

[31]  E. Wight Bakke,et al.  The human resources function , 1961 .

[32]  Patricia G. Selinger,et al.  Access path selection in a relational database management system , 1979, SIGMOD '79.

[33]  Vincent Y. Lum,et al.  EXPRESS: a data EXtraction, Processing, and Restructuring System , 1977, TODS.

[34]  John W. Backus,et al.  Can programming be liberated from the von Neumann style?: a functional style and its algebra of programs , 1978, CACM.

[35]  Y. Edmund Lien,et al.  On the Semantics of the Entity-Relationship Data Model , 1979, ER.

[36]  Peter Scheuermann,et al.  Abstraction Capabilities and Invariant Properties Modelling within the Entity-Relationship Approach , 1979, ER.

[37]  Richard L. Nolan,et al.  Managing the data resource function , 1974 .

[38]  S. Bing Yao,et al.  The Functional Dependency Model For Logical Database Design , 1979, Fifth International Conference on Very Large Data Bases, 1979..

[39]  Eckhard D. Falkenberg,et al.  Concepts for Modelling Information , 1976, IFIP Working Conference on Modelling in Data Base Management Systems.

[40]  Dennis McLeod,et al.  Abstraction in databases , 1981, SIGMOD 1981.

[41]  Shamkant B. Navathe,et al.  A Methodology for View Inegration in Logical Database Design , 1982, VLDB.

[42]  Shamkant B. Navathe,et al.  Schema analysis for database restructuring , 1977, TODS.

[43]  Gio Wiederhold,et al.  Database Design , 1977 .

[44]  Rob Gerritsen.  Cost Effective Database Design: An Integrated Model. , 1977 .

[45]  Paolo Tiberio,et al.  Considerations in developing a design tool for a relational DBMS , 1979, COMPSAC.

[46]  Stanley Y. W. Su,et al.  SAM*: A Semantic Association Model for Corporate and Scientific/Statistical Databases , 1983, Inf. Sci..

[47]  Rob Gerritsen.  Tools for the Automation of Database Design , 1978, Data Base Design Techniques I.

[48]  Shamkant Bhalchandra Navathe.  A methodology for generalized database restructuring. (volumes i and ii) , 1976 .

[49]  Rob Gerritsen,et al.  A Data Base Design Decision Support System , 1977, VLDB.

[50]  Randy H. Katz,et al.  An access path model for physical database design , 1980, SIGMOD '80.

[51]  Roger King,et al.  Semantic Data Models , 1985, Principles of Database Design.

[52]  Dennis McLeod,et al.  A federated architecture for database systems , 1899 .

[53]  S. B. Yao,et al.  View Modeling and Integration Using the Functional Data Model , 1982, IEEE Transactions on Software Engineering.

[54]  E. SenkoM.,et al.  Data structures and accessing in data-base systems , 1973 .

[55]  W. Shipman David,et al.  The functional data model and the data language DAPLEX , 1988 .

[56]  L. S. Schneider.  A relational view of the data independent accessing model , 1976, SIGMOD '76.

[57]  Ramez Elmasri,et al.  Data model integration using the structural model , 1979, SIGMOD '79.

[58]  Harry Katzan.  Systems design and documentation : an introduction to the HIPO method , 1976 .

[59]  Shamkant B. Navathe,et al.  Vertical partitioning algorithms for database design , 1984, TODS.

[60]  Ramez Elmasri,et al.  Relationship Merging in Schema Integration , 1984, VLDB.

[61]  Eugene Wong,et al.  Multibase: integrating heterogeneous distributed database systems , 1981, AFIPS '81.

[62]  Toby J. Teorey,et al.  A Designer For DBMS-Processable Logical Database Structures , 1979, Fifth International Conference on Very Large Data Bases, 1979..

[63]  Peter Buneman,et al.  FQL: a functional query language , 1979, SIGMOD '79.

[64]  David W. Shipman,et al.  The functional data model and the data languages DAPLEX , 1981, TODS.

[65]  Larry Kerschberg,et al.  A Taxonomy of Data Models , 1976, VLDB.

[66]  Philip A. Bernstein,et al.  Concurrency control in a system for distributed databases (SDD-1) , 1980, TODS.

[67]  E. F. Codd,et al.  Extending the database relational model to capture more meaning , 1979, ACM Trans. Database Syst..

[68]  Edgar H. Sibley,et al.  Data architecture and data model considerations , 1899 .

[69]  Dennis McLeod.  On Conceptual Database Modelling , 1980, Workshop on Data Abstraction, Databases and Conceptual Modelling.

[70]  E. F. CODD,et al.  A relational model of data for large shared data banks , 1970, CACM.

[71]  Michael E. Senko,et al.  Specification of stored data structures and desired output results in DIAM II with FORAL , 1975, VLDB '75.

[72]  Larry Kerschberg,et al.  A Synthetic English query language for a relational associative processor , 1976, ICSE '76.

[73]  Dennis Tsichritzis,et al.  OFS: An Integrated Form Management System , 1980, VLDB.

[74]  Michael L. Brodie.  Data Abstraction, Databases and Conceptual Modelling , 1980, VLDB.

[75]  Larry Kerschberg,et al.  Information System Integrati on: A Metadata Management Approach , 1983, ICIS.

[76]  Irving L. Traiger,et al.  System R: relational approach to database management , 1976, TODS.

[77]  Keki B. Irani,et al.  Automatic data base schema design and optimization , 1975, VLDB '75.

[78]  Chris Gane,et al.  Structured Systems Analysis: Tools and Techniques , 1977 .

[79]  Peter Buneman,et al.  Constructing superviews , 1981, SIGMOD '81.