Skip to main content

Integration of Schemas on the Pre-Design Level Using the KCPM-Approach

  • Conference paper
Advances in Information Systems Development

Abstract

Integration is a central research and operational issue in information system design and development. It can be conducted on the system, schema, and view or data level. On the system level, integration deals with the progressive linking and testing of system components to merge their functional and technical characteristics and behavior into a comprehensive, interoperable system. Schema integration comprises the comparison and merging of two or more schemas, usually conceptual database schemas. The integration of data deals with merging the contents of multiple sources of related data. View integration is similar to schema integration, however focuses on views and queries on these instead of schemas. All these types of integration have in common, that two or more sources are merged and previously compared, in order to identify matches and mismatches as well as conflicts and inconsistencies. The sources may stem from heterogeneous companies, organizational units or projects. Integration enables the reuse and combined use of source components.

The work underlying that paper has been financed partly by the Klaus-Tschira-Stiftung Heidelberg

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 169.00
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 219.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info
Hardcover Book
USD 219.99
Price excludes VAT (USA)
  • Durable hardcover 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.

Similar content being viewed by others

References

  • Bouzeghoub M, Comyn-Wattiau I, Kedad Z, Métais E (1996) Implementation ofa Third Generation View Integration Tool. Proc of the 2nd International Workshop on Applications ofNatural Language to Data Bases

    Google Scholar 

  • Buchholz E, Düsterhöft A, Thalheim B (1996) Capturing Information on Behaviour with the RADD-NLI: A Linguistic and Knowledge Based Approach. Applications of Natural Language to Information Systems. Proc of the Second International Workshop

    Google Scholar 

  • Cali A, Calvanese D, De Giacomo G, Lenzerini M (2001) A Framework for Ontology Integration. Proc ofthe 1st Semantic Web Working Symposium

    Google Scholar 

  • Comyn-Wattiau I, Métais E (1997) View Integration as a Way to Build a Semantic Dictionary for a Data Warehouse. Proc of the 3rd NLDB Workshop, NLDB’97

    Google Scholar 

  • Eder J, Frank H (1997) Integration of Behaviour Models. ER’97 Workshop on Behavioural Models and Design Transformations

    Google Scholar 

  • Ekenberg L, Johannesson P (1996) A Formal Basis for Dynamic Schema Integration. Proc ofER 96, 15th International Conference on Conceptual Modeling

    Google Scholar 

  • Fliedl G, Kop C, Mayr HC, Mayerthaler W, Winkler C (2000) From Natural Language to Conceptual Predesign (Static and Dynamic Aspects of Language Engineering). ÖGAI Journal, vol 20, no 1

    Google Scholar 

  • Fliedl G, Kop C, Mayr HC (2002) The NIBA Workflow. ICSSEA’2002 International Conference “Software & Systems Engineering and their Applications”

    Google Scholar 

  • Gal A, Trombetta A (2003) A Model for Schema Integration in Heterogeneous Databases. Proc of IDEAS 2003

    Google Scholar 

  • He Q, Ling TW (2004) Resolving Schematic Discrepancy in the Integration of Entity-Relationship Schemas. Proc of the 23rd International Conference on Conceptual Modeling ER 2004

    Google Scholar 

  • Kop C (2002) Rechnergestützte Katalogisierung von Anforderungsspezifikationen und deren Transformation in ein konzeptuelles Modell. Doctoral Thesis

    Google Scholar 

  • Kop C, Mayr HC (2002) Mapping Functional Requirements: from Natural Language to Conceptual Schemata. Proc of the 6th lASTED International Conference on Software Engineering and Applications

    Google Scholar 

  • Kop C, Mayr HC, Zavinska T (2004) Using KCPM for Defining and Integrating Domain Ontologies. Proc of the International Workshop on Fragmentation versus Integration — Perspectives of the Web Information Systems Discipline

    Google Scholar 

  • Nijssen GM, Halpin TA (1989) Conceptual Schema and Relational Database Design — A Fact Oriented Approach. Prentice Hall Publ Comp

    Google Scholar 

  • Martins JP, Pinto HS (2001) Ontology Integration: How to Perform the Process. Proc of IJCAI2001, Workshop on Ontologies and Information Sharing

    Google Scholar 

  • Parent C, Spaccapietra S (1998) Issues and Approaches of Database Integration. Communications of the ACM, vol 41, no 5, pp 166–178

    Article  Google Scholar 

  • Storey VC (2000) Understanding and Representing Relationship Semantics in Database Design. Proc of the 5th International Conference on Applications of Natural Language to Information Systems

    Google Scholar 

  • Winiwarter W, Zillner S (2004) Integrating Ontology Knowledge into a Query Algebra for Multimedia Meta Objects. Proc of the 5th International Conference on Web Information Systems Engineering WISE 2004

    Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Editor information

Editors and Affiliations

Rights and permissions

Reprints and permissions

Copyright information

© 2006 Springer Science-Business Media, LLC

About this paper

Cite this paper

Vöhringer, J., Mayr, H.C. (2006). Integration of Schemas on the Pre-Design Level Using the KCPM-Approach. In: Nilsson, A.G., Gustas, R., Wojtkowski, W., Wojtkowski, W.G., Wrycza, S., Zupančič, J. (eds) Advances in Information Systems Development. Springer, Boston, MA. https://doi.org/10.1007/978-0-387-36402-5_54

Download citation

  • DOI: https://doi.org/10.1007/978-0-387-36402-5_54

  • Publisher Name: Springer, Boston, MA

  • Print ISBN: 978-0-387-30834-0

  • Online ISBN: 978-0-387-36402-5

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics