A Comparative Review of Approaches for Database Schema Integration

  • Aiste Aleksandraviciene
  • Rimantas Butleris
Conference paper

Any useful information system (IS) needs a conceptual schema, which produces an abstract, global view of all data, managed in the organization. Even though conceptual modeling represents only a small portion of the total information system development effort, its influence on the quality of the final result is probably greater than any other phase. Database (DB) schema is a major determinant of system development costs, system flexibility, integration with other systems and the ability of the system to meet user requirements [13]. This leads to the conclusion that conceptual data-base design is an essential activity of IS development [12].


Schema Integration Local Schema Comparative Review Information System Development Semantic Conflict 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 1.
    Adam NR, Gangopadhyay A (1995) An Nary View Integration Method Using Conceptual Dependencies. In: Proc. of 28th Hawaii Intl. Conf. on System Sciences. IEEE Computer Society, Washington, pp 391-397Google Scholar
  2. 2.
    Batini C, Lanzerini M, Navathe SB (1986) A Comparative Analysis of Methodologies for Database Schema Integration. ACM Computing Surveys 18(4):323-363CrossRefGoogle Scholar
  3. 3.
    Bellström P (2004) Using Enterprise Modeling for Identification and Resolution of Homonym Conflicts in View Integration. In: Vasilecas O (ed) Information Systems Development: Advances in Theory, Practice and Education. Springer, pp 266-276Google Scholar
  4. 4.
    Boman B, Bubenko J, Johanesson P, Wangler B (1993) Models, Concepts, and Information: An Introduction to Conceptual Modelling for Information Systems Development. Royal Institute of Technology, StockholmGoogle Scholar
  5. 5.
    Butkiene R, Butleris R, Danikauskas T (2002) The Approach of Consistency Checking of Functional Requirements Specification. In: Proc. of 6th World Multiconference on Systemics, Cybernetics and Informatics, vol XVIII. Orlando, pp 67-72Google Scholar
  6. 6.
    Butleris R, Danikauskas T (2004) Conceptual Data Model Using Functional Requirements Specification Method. In: Proc. of 16th Conference on Advanced Information Systems Engineering (CAiSE), vol 1. Riga Technical University, Riga, pp 221-232Google Scholar
  7. 7.
    Chao Ch-M (2001) Schema Integration between Object Oriented Data bases. Tamkang. Journal of Science and Engineering 4(1):37-44Google Scholar
  8. 8.
    Danikauskas T, Butleris T, Drąsutis S (2005) Graphical User Interface Development on the Basis of Data Flows Specification. In: Proc of 20th International Symposium on Computer and Information Sciences, LNCS 3733. Springe-Verlag, Berlin Heidelberg, pp 904-914Google Scholar
  9. 9.
    Halpin T (2002) Metaschemas for ER, ORM and UML Data Models: A Comparison. Journal of Database Management 13(2):20-29Google Scholar
  10. 10.
    Johannesson P (1993) Schema Integration, Schema Translation and Interoperability in Federated Information Systems. Ph.D. thesis, Stockholm UniversityGoogle Scholar
  11. 11.
    Lawrence R (2001) Automatic Conflict Resolution to Integrate Relational Schema. Ph.D. thesis, University of ManitobaGoogle Scholar
  12. 12.
    Olivé A (2005) Conceptual Schema Centric Development: A Grand Challenge for Information Systems Research. In: Pastor O, Cunha JF (eds) CAiSE ’2005, LNCS 3520. Springer-Verlag, Berlin Heidelberg, pp 1-15Google Scholar
  13. 13.
    Moody DL, Shanks GG (2003) Improving the quality of data models: empirical validation of a quality management framework. Information systems 28:619-660MATHCrossRefGoogle Scholar
  14. 14.
    Navathe SB, Sashidhar T, Elmasri R (1984) Relationship Merging in Schema Integration. In: Proc. of 10th Intl. Conf. on VLDB. Singapore, pp 78-90Google Scholar
  15. 15.
    Rahm E, Bernstein PhA (2001) A survey of approaches to automatic schema matching. The VLDB Journal 10:334-350MATHCrossRefGoogle Scholar
  16. 16.
    Sattler KU, Conrad S, Saake G (2003) Interactive example driven inte-gration and reconciliation for accessing database federations. Information systems 28:393-414MATHCrossRefGoogle Scholar

Copyright information

© Springer Science+Business Media, LLC 2007

Authors and Affiliations

  • Aiste Aleksandraviciene
    • 1
  • Rimantas Butleris
    • 1
  1. 1.Department of Information SystemsKaunas University of TechnologyLithuania

Personalised recommendations