Collaborative conceptual schema design: A process model and prototype system

Sudha Ram, V. Ramesh

Research output: Contribution to journalArticle

18 Citations (Scopus)

Abstract

Recent years have seen an increased interest in providing support for collaborative activities among groups of users participating in various information systems design tasks such as, requirements determination and process modeling. However, little attention has been paid to the collaborative conceptual database design process. In this article, we develop a model of the collaborative conceptual schema development process and describe the design and implementation of a graphical multiuser conceptual schema design tool that is based on the model. The system we describe allows a group of users to work collaboratively on the creation of database schemas in a synchronous (same-time) mode (either in a face-to-face or distributed setting). Extensive modeling support is provided to assist users in creating semantically correct conceptual schemas. The system also provides users with several graphical facilities such as, a large drawing workspace with the ability to scroll or "jump" to any portion of this workspace, zooming capabilities, and the ability to move object(s) to any portion of the workspace. The unique component of the system, however, is its built-in support for collaborative schema design. The system supports a relaxed WYSIWIS environment, i.e., each user can control the graphical layout of the same set of schema objects. The system ensures that changes/additions made by any user are immediately reflected at other user workstations and that all users' schemas are consistent. Any conflicts that may compromise the integrity of the shared schema are flagged and resolved by the system. The results from a preliminary experiment suggest that the use of our system in a collaborative mode improved information sharing among users, minimized conflicts, and led to a more comprehensive schema definition.

Original languageEnglish (US)
Pages (from-to)347-371
Number of pages25
JournalACM Transactions on Information Systems
Volume16
Issue number4
StatePublished - Oct 1998

Fingerprint

Conceptual design
Information systems
Systems analysis
Prototype
Process model
Experiments

Keywords

  • Collaboration
  • Conceptual modeling
  • Database design
  • Design
  • Graphical CASE tools
  • Groupware
  • H.2.1 [Logical Design]
  • H.4 [Information Systems]
  • K.6.3 [Software Development]
  • Management
  • Semantic modeling

ASJC Scopus subject areas

  • Information Systems

Cite this

Collaborative conceptual schema design : A process model and prototype system. / Ram, Sudha; Ramesh, V.

In: ACM Transactions on Information Systems, Vol. 16, No. 4, 10.1998, p. 347-371.

Research output: Contribution to journalArticle

@article{bbcf41c9f0bf435cb3bc39e0dfc02256,
title = "Collaborative conceptual schema design: A process model and prototype system",
abstract = "Recent years have seen an increased interest in providing support for collaborative activities among groups of users participating in various information systems design tasks such as, requirements determination and process modeling. However, little attention has been paid to the collaborative conceptual database design process. In this article, we develop a model of the collaborative conceptual schema development process and describe the design and implementation of a graphical multiuser conceptual schema design tool that is based on the model. The system we describe allows a group of users to work collaboratively on the creation of database schemas in a synchronous (same-time) mode (either in a face-to-face or distributed setting). Extensive modeling support is provided to assist users in creating semantically correct conceptual schemas. The system also provides users with several graphical facilities such as, a large drawing workspace with the ability to scroll or {"}jump{"} to any portion of this workspace, zooming capabilities, and the ability to move object(s) to any portion of the workspace. The unique component of the system, however, is its built-in support for collaborative schema design. The system supports a relaxed WYSIWIS environment, i.e., each user can control the graphical layout of the same set of schema objects. The system ensures that changes/additions made by any user are immediately reflected at other user workstations and that all users' schemas are consistent. Any conflicts that may compromise the integrity of the shared schema are flagged and resolved by the system. The results from a preliminary experiment suggest that the use of our system in a collaborative mode improved information sharing among users, minimized conflicts, and led to a more comprehensive schema definition.",
keywords = "Collaboration, Conceptual modeling, Database design, Design, Graphical CASE tools, Groupware, H.2.1 [Logical Design], H.4 [Information Systems], K.6.3 [Software Development], Management, Semantic modeling",
author = "Sudha Ram and V. Ramesh",
year = "1998",
month = "10",
language = "English (US)",
volume = "16",
pages = "347--371",
journal = "ACM Transactions on Information Systems",
issn = "1046-8188",
publisher = "Association for Computing Machinery (ACM)",
number = "4",

}

TY - JOUR

T1 - Collaborative conceptual schema design

T2 - A process model and prototype system

AU - Ram, Sudha

AU - Ramesh, V.

PY - 1998/10

Y1 - 1998/10

N2 - Recent years have seen an increased interest in providing support for collaborative activities among groups of users participating in various information systems design tasks such as, requirements determination and process modeling. However, little attention has been paid to the collaborative conceptual database design process. In this article, we develop a model of the collaborative conceptual schema development process and describe the design and implementation of a graphical multiuser conceptual schema design tool that is based on the model. The system we describe allows a group of users to work collaboratively on the creation of database schemas in a synchronous (same-time) mode (either in a face-to-face or distributed setting). Extensive modeling support is provided to assist users in creating semantically correct conceptual schemas. The system also provides users with several graphical facilities such as, a large drawing workspace with the ability to scroll or "jump" to any portion of this workspace, zooming capabilities, and the ability to move object(s) to any portion of the workspace. The unique component of the system, however, is its built-in support for collaborative schema design. The system supports a relaxed WYSIWIS environment, i.e., each user can control the graphical layout of the same set of schema objects. The system ensures that changes/additions made by any user are immediately reflected at other user workstations and that all users' schemas are consistent. Any conflicts that may compromise the integrity of the shared schema are flagged and resolved by the system. The results from a preliminary experiment suggest that the use of our system in a collaborative mode improved information sharing among users, minimized conflicts, and led to a more comprehensive schema definition.

AB - Recent years have seen an increased interest in providing support for collaborative activities among groups of users participating in various information systems design tasks such as, requirements determination and process modeling. However, little attention has been paid to the collaborative conceptual database design process. In this article, we develop a model of the collaborative conceptual schema development process and describe the design and implementation of a graphical multiuser conceptual schema design tool that is based on the model. The system we describe allows a group of users to work collaboratively on the creation of database schemas in a synchronous (same-time) mode (either in a face-to-face or distributed setting). Extensive modeling support is provided to assist users in creating semantically correct conceptual schemas. The system also provides users with several graphical facilities such as, a large drawing workspace with the ability to scroll or "jump" to any portion of this workspace, zooming capabilities, and the ability to move object(s) to any portion of the workspace. The unique component of the system, however, is its built-in support for collaborative schema design. The system supports a relaxed WYSIWIS environment, i.e., each user can control the graphical layout of the same set of schema objects. The system ensures that changes/additions made by any user are immediately reflected at other user workstations and that all users' schemas are consistent. Any conflicts that may compromise the integrity of the shared schema are flagged and resolved by the system. The results from a preliminary experiment suggest that the use of our system in a collaborative mode improved information sharing among users, minimized conflicts, and led to a more comprehensive schema definition.

KW - Collaboration

KW - Conceptual modeling

KW - Database design

KW - Design

KW - Graphical CASE tools

KW - Groupware

KW - H.2.1 [Logical Design]

KW - H.4 [Information Systems]

KW - K.6.3 [Software Development]

KW - Management

KW - Semantic modeling

UR - http://www.scopus.com/inward/record.url?scp=0032183858&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=0032183858&partnerID=8YFLogxK

M3 - Article

AN - SCOPUS:0032183858

VL - 16

SP - 347

EP - 371

JO - ACM Transactions on Information Systems

JF - ACM Transactions on Information Systems

SN - 1046-8188

IS - 4

ER -