Skip to main content

Part of the book series: Informatik-Fachberichte ((INFORMATIK,volume 143))

Abstract

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.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 44.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 59.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. 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 

  2. Biskup J. and B. Convent: “A formal view integration method.” ACM SIGMOD International Conference on Management of Data, 1986.

    Google Scholar 

  3. 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 

  4. 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 

  5. 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 

  6. 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 

  7. Convent, B.: “Unsolvable Problems Related to the View Integration Approach.”, International Conference of Database Theory, Roma, Italy, 1986.

    Google Scholar 

  8. 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 

  9. 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 

  10. 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–144

    Google Scholar 

  11. Navathe, S. and R. Elmasri, J. Larson: “Integrating User Views in Database Design. IEEE — Computer, Jan.1986

    Google Scholar 

  12. 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 

  13. Smith, J.M. and D.C.P. Smith: “Database Abstraction: Aggregation and Generalization.” ACM Transactions on Database Systems, Vol. 2, No. 2, 1977, pp. 105–133.

    Article  Google Scholar 

  14. 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 

  15. 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 

  16. 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 

  17. 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 

  18. 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 

Download references

Author information

Authors and Affiliations

Authors

Editor information

Editors and Affiliations

Rights and permissions

Reprints and permissions

Copyright information

© 1987 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Schrefl, M. (1987). A Comparative Analysis of View Integration Methodologies. In: Wagner, R.R., Traunmüller, R., Mayr, H.C. (eds) Informationsbedarfsermittlung und -analyse für den Entwurf von Informationssystemen. Informatik-Fachberichte, vol 143. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-72821-1_5

Download citation

  • DOI: https://doi.org/10.1007/978-3-642-72821-1_5

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-18052-4

  • Online ISBN: 978-3-642-72821-1

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics