Abstract:
In an information system a key role is played by the underlying data schema. This article starts out from the view that the entire modelling process of an information system’s data schema can be seen as a schema transformation process. A transformation process that starts out with an initial draft conceptual schema and ends with an internal database schema for some implementation platform. This allows us to describe the transformation process of a database design as an evolution of a schema through a universe of data schemas. Doing so, allows for a better understanding of the actual design process, countering the problem of ‘software development under the lamppost’. Even when the information system design is finalised, the data schema can evolve further due to changes in the requirements on the system. We present a universe of data schemas that allows us to describe the underlying data schemas at all stages of their development. This universe of data schemas is used as a case study on how to describe the complete evolution of a data schema with all its relevant aspects. The theory is general enough to cater for more modelling concepts, or different modelling approaches. To actually model the evolution of a data schema, we present a versioning mechanism that allows us to model the evolutions of the elements of data schemas and their interactions, leading to a better understanding of a schema design process as a whole. Finally, we also discuss the relationship between this simple versioning mechanism and general purpose version management systems. 1
Citations
|
500
|
and SB Navathe, Fundamentals of Database Systems
– Elmasri
|
|
319
|
A field study of the software design process for large systems
– Curtis, Krasner, et al.
- 1988
|
|
263
|
Semantics and implementation of schema evolution in object-oriented databases
– Banerjee, Kim, et al.
- 1997
|
|
67
|
Semantics and verification of object-role models
– Bommel, Hofstede, et al.
- 1991
|
|
50
|
Reverse engineering of relational databases: extraction of an EER model from a relational database
– Chiang, Barron, et al.
- 1994
|
|
42
|
Formal program construction by transformations—computer-aided, intuition guided programming
– Bauer, Möller, et al.
- 1989
|
|
31
|
Conceptual Schemas with Abstractions: Making Flat Conceptual Schemas More Comprehensible
– Campbell, Halpin, et al.
- 1996
|
|
23
|
A Generic Model for 3-Dimensional Conceptual Modelling
– Creasy, Proper
- 1996
|
|
22
|
Reducing the search space for conceptual schema transformation
– Bommel, Weide
- 1992
|
|
22
|
Entity-generating Schema Transformation for Entity-Relationship Models
– Hainaut
- 1991
|
|
21
|
On Data Schema Transformation
– Troyer
- 1993
|
|
18
|
A Unifying Object Role Modelling Approach
– Bronts, Brouwer, et al.
- 1995
|
|
18
|
The OO-Binary Relationship Model: A Truly Object Oriented Conceptual Model
– Troyer
- 1991
|
|
15
|
An Approach to Eliciting the semantics of Relational Databases
– Fonkam, Gray, et al.
- 1992
|
|
14
|
On Building Software Process Models Under the Lamppost
– Krasner, Shen, et al.
- 1987
|
|
9
|
On Modularity for Conceptual Data Models and the Consequences for Subtyping, Inheritance & Overriding
– Troyer, Janssen
- 1993
|
|
7
|
Implementation Selection for Object-Role Models
– Bommel
- 1994
|
|
7
|
The Nested Entity-Relationship Model
– Carlson, Ji, et al.
- 1990
|
|
4
|
Systematics of transformation rules
– Bauer, Broy, et al.
- 1979
|
|
4
|
Database Optimization: An Evolutionary Approach
– Bommel
- 1995
|
|
3
|
A semantic data model as the basis for an automated database design tool
– Berman
- 1986
|
|
3
|
Two-level NIAM: A way to get it object-oriented
– Creasy, Hesse
- 1994
|
