Understanding corporate data models

• Published in: Information & management 1999-01, Vol.35 (1), p.19-30
• Main Authors: Shanks, Graeme, Darke, Peta
• Format: Article
• Language: English
• Subjects: Applied sciences; Case studies; Computer science; control theory; systems; Computer systems and distributed systems. User interface; Corporate data models; Data administration; Data management; Data mining; Data models; Data warehouses; Data warehousing; Exact sciences and technology; Information systems; Information systems methodologies; Methods; Software; Studies
• ISSN: 0378-7206; 1872-7530
• DOI: 10.1016/S0378-7206(98)00078-0

Corporate data models are widely used to support data management within organisations. However, both IS professionals and business users find them difficult to understand. This paper describes a methodology for designing and representing corporate data models that uses explanation and visualisation mechanisms to improve understanding, and reports a case study of the use of the methodology in the development of a data warehouse. The methodology was shown to be effective in that a high quality corporate data model was designed and then understood and utilised by all the participants. The model was used as an active, hypertext interface to the first prototype of the data warehouse. The case study findings indicated that: scenarios are useful for eliciting information requirements and explaining abstract concepts in the model to business users; graphical icons and subject area partitions are effective means of visualising the model and lead to improved understanding of the model by business users; and design rationale is an effective means of explaining the evolution of concepts in the model for specialist data modellers.