Group data base design: Addressing the view modeling problem

https://doi.org/10.1016/0164-1212(94)00048-RGet rights and content

Abstract

Today's organizations increasingly depend on the use of data base technology to manage their operations. Advances in technology have resulted in increasing the number and complexity of these data bases. Despite their growing complexity, all data bases have one thing in common: each must have gone through either a formal or an informal design process. Data bases must mirror reality accurately, and thus the design process must better capture that reality. The heart of the design process is the conceptual design, data model mapping, and physical design. Our research focuses on providing automated support for the first of these, e.g., conceptual design. Conceptual design is known to be a very difficult and time-consuming phase in the development of data base applications. This article describes the architecture, implementation, and use of a distributed graphical group data base design system. The group view modeling system (GVMS) is implemented in Microsoft Windows for networked personal computers. The main purpose of GVMS is to allow multiple designers (or users) to share conceptual design information in real time and resolve design conflicts through the electronic medium. The underlying data model, semantic data model, is extended to include distribution information as well as transactions and is represented as an extended entity relationship model. Diagram management techniques are implemented to aid in simplifying large complex designs. A small study demonstrated that groups of data base designers who define their view collectively outperform individuals.

References (61)

  • R. Elmasri et al.

    The Category Concept: An Extension to the Entity-Relationship Model

    Data Knowl. Eng.

    (1985)
  • J.S. Valacich et al.

    Electronic Meeting Support: The GroupSystems Concept

    Int. J. Man-Machine Stud.

    (1991)
  • S. Abiteboul et al.

    IFO: A formal semantic database model

    ACM Trans. Database Syst.

    (1987)
  • P. Atzeni et al.

    Incod (a system for interactive conceptual design) revisited after the implementation of a prototype

  • C. Batini et al.
  • D. Batra et al.

    Comparing Representations with Relational and EER models

    Commun. ACM

    (1990)
  • M.R. Blaha et al.

    Relational Database Design Using an Object-Oriented Methodology

    Commun. ACM

    (1988)
  • A. Braegger et al.

    Gambit: An Interactive Database Design Tool for Data Structures, Integrity Constraints, and Transactions

    IEEE Trans. Software Eng.

    (1985)
  • M.L. Brodie et al.

    On the design and specification of database transactions

  • F.P. Brooks

    Grasping reality through illusion-interactive graphics serving science

  • M.A. Casanova et al.

    A Software Tool for Modular Database Design

    ACM Trans. Database Syst.

    (1991)
  • E.P.R. Chan et al.

    A graphical database design aid using the entity-relationship model

  • P.P. Chen

    The Entity-Relationship Model: Toward a Unified View of Data

    ACM Trans. Database Syst.

    (1976)
  • T. Connolly et al.

    Effects of anonymity and Evaluate Tone on Idea Generation in Computer-Mediated Groups

    Manag. Sci.

    (1990)
  • G.B. Davis et al.
  • A.R. Dennis et al.

    Information Technology to Support Electronic Meetings

    MIS Q.

    (1988)
  • G. DeSanctis et al.

    Group Decision Support Systems: A New Frontier

    Data Base

    (1985)
  • G. DeSanctis et al.

    A Foundation for the Study of Group Decision Support Systems

    Manag. Sci.

    (1987)
  • J. Diederich et al.

    Oddessy: An object-oriented database design system

  • C.A. Ellis et al.

    Groupware: Some Issues and Experiences

    Commun. ACM

    (1991)
  • R. Elmasri et al.
  • B. Gallupe et al.

    Facilitated Electronic Meetings: Higher Quality, Less Time

    CMA Manag. Account.

    (1992)
  • B. Gallupe et al.

    Computer-Based Support for Group Problem-Finding: An Experimental Investigation

    MIS Q.

    (1988)
  • B. Gallupe et al.

    Electronic Brainstorming and Group Size

    Acad. Manag. J.

    (1992)
  • B. Gallupe et al.

    The impact of computer-based support on the process and outcomes of group decision making

  • F.M. Ferrara

    Easy-ER: An integrated system for the design and documentation of database applications

  • B. Gallupe et al.

    Enhancing Computer-Mediated Communication: An Experimental Study into the Use of a GDSS for Face-to-Face Versus Remote Meetings

    Info. Manag.

    (1990)
  • P. Gray

    The user interface in group decision support systems

  • M. Hammer et al.

    Database Description with SDM: A Semantic Database Model

    ACM Trans. Database Syst.

    (1981)
  • S. Hayne

    The Application of Computer Supported Collaborative Work and Knowledge-Based Technology to the View Modeling and Integration Problems: A Multi-User View Integration System

  • View full text