Effects of Local Versus Global Schema Diagrams on Verification and Communication in Conceptual Data Modeling

Abstract Much research in conceptual data modeling has focused on developing techniques for view integration, or combining local conceptual schemas into a global schema. Local schemas are argued to be important in verifying conceptual data requirements before proceeding to database design. View integration is claimed to fulfill two purposes. First, a global conceptual schema is a prerequisite to logical design and implementation. Second, global schemas are thought to be useful in improving organizational communication among diverse user groups with different perspectives and information needs. However, performing view integration is difficult. Moreover, there is no empirical evidence that global schemas either impede local verification or support communication. Drawing on classification research, this paper develops and tests claims about the impact of schema structure (local versus global) on verification and communication. Local schemas are hypothesized to better support verification than global schemas. When different local views contain conflicting structure, local schemas are expected to be superior in supporting communication. However, when local views contain complementary structure, global schemas are expected to be superior in supporting communication. A laboratory experiment was conducted to test these predictions. The results support the hypotheses. Implications for the practice of database design and for further research are considered. Keywords: CLASSIFICATION THEORYCONCEPTUAL DATABASE MODELSDATABASE SCHEMASEMPIRICAL DATA MODELING RESEARCHVIEW INTEGRATION

• 저널Journal of Management Information Systems · 19(3) · 155–183
• 토픽Advanced Database Systems and Queries · Computer Networks and Communications
• DOI10.1080/07421222.2002.11045730
• 저자Jeffrey Parsons