A Comparative Analysis of View Integration Methodologies
One of the most difficult tasks in logical database design is the analysis and the integration of the requirements different user groups have on the whole application. Once the requirements of each user group have been formally described by view database schemas, view integration methodologies are used to construct a conceptual database schema that can support all different user views.
Furthermore view integration methodologies are used in a domain which is similar to user view integration: in the design of multi database systems. There the problem is to define a single global view for several databases already in use.
Recently, several methodologies for user view integration and global view definition have been proposed in literature. The purpose of this paper is, first, to define comparison criteria for view integration methodologies and, secondly, to provide a comparative analysis of the features and main characteristics of the most important view integration methodologies with respect to the given criteria.
Unable to display preview. Download preview PDF.
- /BAT84/.Batini, C. and M. Lenzerini: “A Methodology for Data Schema Integration in the Entity — Relationship Model.” In IEEE Transactions on Software Engineering, Vol.10, No. 6, 1984, pp. 650–664.Google Scholar
- /BIS86/.Biskup J. and B. Convent: “A formal view integration method.” ACM SIGMOD International Conference on Management of Data, 1986.Google Scholar
- /BR084/.Brodie, M. and D. Ridjanovic: “On the Design and Specification of Database Transactions.” In: Brodie M., J. Mylopoulos, J. Schmidt (eds.): On Conceptual Modelling. Perspectives from Atrificial Intelligence, Databases, and Programming Languages Semantic Data Model Driven Design, Verification, Specification of Interactive Database Transactions. Springer-Verlag, Berlin, 1984., pp.277–307.Google Scholar
- /CAS83/.Casanova, M. and V. Vidal: “Towards a sound view integration methodology”, ACM-Sigact– Sigmod Symposium on Principles of Database Systems, 1983, pp. 36–47.Google Scholar
- /CHE76/.Chen, P.P-S.: “The Entity-Relationship Model — Toward a unified view of data”, ACM Transactions on Database Systems Vo. 1, No. 1, 1976, pp. 9–36.Google Scholar
- /COD79/.Codd, E.F.: “Extending the Database Relational Model to Capture more Meaning.” ACM Transactions on Database Systems, Vol.4, No. 4,1979, pp. 377–387.Google Scholar
- /CON86/.Convent, B.: “Unsolvable Problems Related to the View Integration Approach.”, International Conference of Database Theory, Roma, Italy, 1986.Google Scholar
- /DAY84/.Dayal U. and H. Wang: “View Definition and Generalization for Database Integration in a Multidatabase System.” In IEEE Transactions on Software Engineering, Vol. SE-10, No. 6, 1984, pp. 628–644.Google Scholar
- /ELM85/.Elmasri, R. and J. Weeldreyer, A. Hevner: “The category concept: An extension to the Entity — relationship model”. In Data & Knowledge Engineering 1, North Holland, 1985, pp. 75–116.Google Scholar
- /JAN85/.Jansen, C. G.: “A framework for representation.” in: Bubenko J. and O. Olive (eds.): Information Systems. Theoretical and Formal Aspects. North-Holland, Amsterdam 1985, pp.127–144Google Scholar
- /NAV86/.Navathe, S. and R. Elmasri, J. Larson: “Integrating User Views in Database Design. IEEE — Computer, Jan.1986Google Scholar
- /SHI81/.Shipman, D. W.: “The Functional Data Model and the Data Language DAPLEX. ACM Transactions on Database Systems, Vol. 6, No. 1, 1981, pp. 140–173.Google Scholar
- /SMl77b/.Smith, J.M. and D.C.P. Smith: Database Abstraction: Aggregation. Communications of the ACM, Vol. 20, No. 6 1977, pp. 405–433.Google Scholar
- /SCH84/.Schre, M. and A.M. Tjoa, R.R. Wagner: “Comparison criteria for semantic data models.” Proc. IEEE 1st International Conference on Data Engineering, Los Angeles, 1984, pp. 105–133.Google Scholar
- /SCH86/.Schek, H. and M. H. Scholl: “The Relational Model with Relation-Valued Attributes.” information Systems Vol. 11, No.2,1986, pp.137–147.Google Scholar
- /URB86/.Urban S. and L. Delcambre: “An analysis of the structural, dynamic and temporal aspects of semantic data models.” Proc. IEEE 2nd International Confernece on Data Engineering, Los Angeles, 1986, pp.382–389.Google Scholar
- /YA082/.Yao S.B. and V.E. Waddle, B.C. Housel: “View Modeling and Integration Using the Functional Data Model.” IEEE Transactions on Software Engineering, Vol.8, No.6, 1982, pp.544–553.Google Scholar