A database design methodology and tool for information systems

ABSTRACT

A model and methodology for describing the information objects in an office information system and how such objects flow among the components of such a system are presented. The model and methodology support the specification of information objects at multiple levels of abstraction. An interactive prototype design tool based on the methodology and model has been designed and experimentally implemented.

REFERENCES

• 1: BELL, M. L., BIXLER, D. C., AND DYER, M. E. An extendible approach to computer-aided software requirements engineering. IEEE Trans. Softw. Eng. SE~3 (Jan. 1977), 40-60.
• 2: BORGIDA, A., MYLOPOULOS, J., AND WONG, H. K.T. Generalization/specialization as a basis for software specification. In On Conceptual Modeling: Perspectives from Artificial Intelligence, Database, and Programming Languages, M. Brodie, J. Mylopoulos, and J. Schmidt, Eds. Springer- Verlag, New York, 1984.
• 3: Giampio Bracchi , Barbara Pernici, SOS: A Conceptual Model for Office Information Systems, Databases for Business and Office Applications, Database Week, p.108-116, May 23-26, 1983 [doi>10.1145/647004.711873]
• 4: BRODI~, M.L. On modelling behavioural semantics of data. In Proceedings of the 7th International Conference on Very Large Databases (Cannes, France, Sept. 9-11). ACM, New York, 1981, pp. 32-44.
• 5: BRODIE, M., AND RIDJANOVIC, D. On the design and specification of database transactions. In On Conceptual Modeling: Perspectives from Artificial Intelligence, Databases, and Programming Languages, M. Brodie, J. Mylopoulos, and J. Schmidt, Eds. Springer-Verlag, New York, 1984.
• 6: Mark R. Brown , Roderic G. G. Cattell , Norihisa Suzuki, The cedar DBMS: a preliminary report, Proceedings of the 1981 ACM SIGMOD international conference on Management of data, April 29-May 01, 1981, Ann Arbor, Michigan [doi>10.1145/582318.582350]
• 7: Peter Buneman , Robert E. Frankel, FQL: a functional query language, Proceedings of the 1979 ACM SIGMOD international conference on Management of data, May 30-June 01, 1979, Boston, Massachusetts [doi>10.1145/582095.582104]
• 8: BUNEMAN P., AND NIKHIL, R. The functional data model and its use for interaction with databases. In On Conceptual Modeling: Perspectives from Artificial Intelligence, Databases, and Programming Languages, M. Brodie, J. Mylopoulos, and J. Schmidt, Eds. Springer-Verlag, New York, 1984.
• 9: CATTELL, R. G. G. Design and implementation of a relationship-entity-datum data model. Tech. Rep. CSL-83-4, Xerox Parc, Palo Alto, Calif., 1983.
• 10: Peter Pin-Shan Chen, The entity-relationship model—toward a unified view of data, ACM Transactions on Database Systems (TODS), v.1 n.1, p.9-36, March 1976 [doi>10.1145/320434.320440]
• 11: Peter P. S. Chen , Robert M. Curtice , Lyrl Ahern, Entity-Relationship Approach to Logical Data Base Design, John Wiley & Sons, Inc., New York, NY, 1991
• 12: E. F. Codd, Extending the database relational model to capture more meaning, ACM Transactions on Database Systems (TODS), v.4 n.4, p.397-434, Dec. 1979 [doi>10.1145/320107.320109]
• 13: DAVlS, C. G., AND VICK, C.R. The software development system. IEEE Trans. Softw. Eng. SE- 3, 1 (Jan. 1977), 69-84.
• 14: Clarence A. Ellis , Gary J. Nutt, Office Information Systems and Computer Science, ACM Computing Surveys (CSUR), v.12 n.1, p.27-60, March 1980 [doi>10.1145/356802.356805]
• 15: FALKENBERG, E.D. Conceptualization of data. Infotech State-of-the-Art Report on Data Design. Pergamon Infotech Ltd., London 1980.
• 16: David Farmer , Roger King , David Myers, A Tool for the Implementation of Databases, Proceedings of the First International Conference on Data Engineering, p.386-393, April 24-27, 1984
• 17: GANE, C.P. Data design in structured system analysis. In Tutorial on Software Design Techniques, P. Freeman and A. I. Wasserman, Eds. IEEE Computer Society, Los Angeles, 1980, pp. 126-143.
• 18: Simon Gibbs , Dionysis Tsichritzis, A data modeling approach for office information systems, ACM Transactions on Information Systems (TOIS), v.1 n.4, p.299-319, Oct. 1983 [doi>10.1145/357442.357444]
• 19: Michael Hammer , W. Gerry Howe , Vincent J. Kruskal , Irving Wladawsky, A very high level programming language for data processing applications, Communications of the ACM, v.20 n.11, p.832-840, Nov. 1977 [doi>10.1145/359863.359886]
• 20: Michael Hammer , Dennis Mc Leod, Database description with SDM: a semantic database model, ACM Transactions on Database Systems (TODS), v.6 n.3, p.351-386, Sept. 1981 [doi>10.1145/319587.319588]
• 21: HOUSEL, B. C., WADDLE, V., AND YAO, S.B. Functional dependency model for logical database design. In Proceedings of the 5th International Conference on Very Large Databases (Rio de Janeiro, Oct. 3-5). ACM, New York, 1979, pp. 194-208.
• 22: KING, R. A semantics-based methodology for database design and evolution. Tech. Rep. TRl15, Computer Science Department, Univ. of Southern California, Los Angeles, Calif., 1982.
• 23: KING, R., AND MCLEOD, D. The event database specification model. In Proceedings of the 2nd International Conference on Databases: Improving Usability and Responsiveness (Jerusalem, Israel, June). 1982, pp. 299-322.
• 24: KING, R., AND MCLEOD, D. Semantic database models. In Database Design, S. B. Yao, Ed. Prentice-Hall, Englewood Cliffs, N.J., to appear.
• 25: KING, R., AND MCLEOD, D. A unified model and methodology for conceptual database design. In On Conceptual Modeling: Perspectives from Artificial Intelligence, Databases, and Programming Languages, M. Brodie, J. Mylopoulos, and J. Schmidt, Eds. Springer-Verlag, New York, 1984.
• 26: McLeod, D., Narayanaswamy, K., and Bapa Rao, K.V. An approach to Information management for CAD/VLSI applications. In Proceedings of the ACM SIGMOD International Conference on the Management of Data (San Jose, Calif., May ). ACM, New York, 1983, pp.
• 27: Dennis McLeod , John Miles Smith, Abstraction in databases, Proceedings of the 1980 workshop on Data abstraction, databases and conceptual modeling, p.19-25, June 23-26, 1980, Pingree Park, Colorado, United States
• 28: John Mylopoulos , Philip A. Bernstein , Harry K. T. Wong, A language facility for designing database-intensive applications, ACM Transactions on Database Systems (TODS), v.5 n.2, p.185-207, June 1980 [doi>10.1145/320141.320150]
• 29: ROSS, D.T. Structured Analysis (SA): A language for communicating ideas. IEEE Trans. Softw. Eng. SE-3, 1 (Jan. 1977), 16-34.
• 30: David W. Shipman, The functional data model and the data languages DAPLEX, ACM Transactions on Database Systems (TODS), v.6 n.1, p.140-173, March 1981 [doi>10.1145/319540.319561]
• 31: John Miles Smith , Diane C. P. Smith, Database abstractions: aggregation and generalization, ACM Transactions on Database Systems (TODS), v.2 n.2, p.105-133, June 1977 [doi>10.1145/320544.320546]
• 32: John Miles Smith , Diane C. P. Smith, Principles of Database Conceptual Design, Proceedings of the NYU Symposium on Data Base Design Techniques I: Requirements and Logical Structures, p.114-146, May 01, 1978
• 33: Stanley Y. W. Su , Der Her Lo, A Semantic Association Model for Conceptual Design, Proceedings of the 1st International Conference on the Entity-Relationship Approach to Systems Analysis and Design, p.169-192, January 1980
• 34: TEICHROEW, D., AND HERSHEY, E.A. PSA/PSL: A computer-aided technique for structured documentation and analysis of information processing systems. IEEE Trans. Softw. Eng. SE-3, 1 (Jan. 1977), 41-48.
• 35: Toby J. Teorey , James P. Fry, The Logical Record Access Approach to Database Design, ACM Computing Surveys (CSUR), v.12 n.2, p.179-211, June 1980 [doi>10.1145/356810.356815]

INDEX TERMS

Classification:
  D. Software
  D.2 SOFTWARE ENGINEERING
      D.2.1 Requirements/Specifications
          Subjects: Tools

  H. Information Systems
  H.2 DATABASE MANAGEMENT
      H.2.1 Logical Design
          Subjects: Data models
  H.4 INFORMATION SYSTEMS APPLICATIONS
      H.4.1 Office Automation

          Nouns: INSYDE

General Terms:
Design