Effects of local versus global schema diagrams on verification and communication conceptual data modeling

• 成果类型: Article
• 署名作者: Parsons, J
• 署名单位: Memorial University Newfoundland
• 刊物名称: JOURNAL OF MANAGEMENT INFORMATION SYSTEMS
• ISSN/ISSBN: 0742-1222
• 发表日期: 2002
• 页码: 155-183
• 关键词: design; views

摘要

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 i 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 L schema structure (local versus. global) on verification and communication. Local schemas are hypothesized to better support verify cation 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.