Change search
CiteExportLink to record
Permanent link

Direct link
Cite
Citation style
  • apa
  • harvard1
  • ieee
  • modern-language-association-8th-edition
  • vancouver
  • Other style
More styles
Language
  • de-DE
  • en-GB
  • en-US
  • fi-FI
  • nn-NO
  • nn-NB
  • sv-SE
  • Other locale
More languages
Output format
  • html
  • text
  • asciidoc
  • rtf
Schema Integration: How to Integrate Static and Dynamic Database Schemata
Karlstad University, Faculty of Economic Sciences, Communication and IT, Avdelningen för informatik och projektledning.
2010 (English)Doctoral thesis, comprehensive summary (Other academic)
Abstract [en]

Schema integration is the task of integrating several local schemata into one global database schema. It is a complex, error-prone and time consuming task. Problems arise in recognizing and resolving problems, such as differences and similarities, between two schemata. Problems also arise in integrating static and dynamic schemata. In this thesis, three research topics are addressed: Maintaining Vocabulary in Schema Integration, Integration of Static Schemata and Integration of Static and Dynamic Schemata, while applying the notation in the Enterprise Modeling approach.

In Maintaining Vocabulary in Schema Integration an analysis of what semantic loss is and why it occurs in schema integration is conducted. Semantic loss is a problem that should be avoided because both concepts and dependencies might be lost. In the thesis, it is argued that concepts and dependencies should be retained as long as possible in the schemata. This should facilitate user involvement since the users’ vocabulary is retained even after resolving similarities and differences between two schemata.

In Integration of Static Schemata two methods are developed. These methods facilitate recognition and resolution of similarities and differences between two conceptual database schemata.  By applying the first method, problems between two schemata can be recognized that otherwise could pass unnoticed; by applying the second method, problems can be resolved without causing semantic loss by retaining concepts and dependencies in the schemata.

In Integration of Static and Dynamic Schemata a method on how to integrate static and dynamic schemata is developed. In the method, focus is put on pre- and post-conditions and how to map these to states and state changes in the database. By applying the method, states that are important for the database can be designed and integrated into the conceptual database schema. Also, by applying the method, active database rules can be designed and integrated into the conceptual database schema.

Place, publisher, year, edition, pages
Karlstad: Karlstads universitet , 2010. , p. 346
Series
Karlstad University Studies, ISSN 1403-8099 ; 2010:13
Keywords [en]
Schema Integration, Conceptual Database Design, Database Schemata, Enterprise Modeling
National Category
Computer and Information Sciences
Research subject
Information Systems
Identifiers
URN: urn:nbn:se:kau:diva-5541ISBN: 978-91-7063-299-0  (print)OAI: oai:DiVA.org:kau-5541DiVA, id: diva2:309916
Public defence
2010-05-28, Frödingsalen 1B 364, Karlstads universitet, Karlstad, 13:15 (English)
Opponent
Supervisors
Available from: 2010-05-06 Created: 2010-04-09 Last updated: 2018-01-12Bibliographically approved
List of papers
1. Towards an Understanding of the Meaning and the Contents of a Database through Design and Reconstruction
Open this publication in new window or tab >>Towards an Understanding of the Meaning and the Contents of a Database through Design and Reconstruction
2004 (English)In: Information Systems Development: Advances in Theory, Practice and Education / [ed] Vasilecas, O., Caplinskas, A., Wojtkowski, W., Wojtkowski, W.G., Zupancic, J. & Wrycza, S., 2004, p. 283-293Conference paper, Published paper (Refereed)
National Category
Information Systems
Research subject
Information Systems
Identifiers
urn:nbn:se:kau:diva-5531 (URN)0387250263;978-0387250267 (ISBN)
Conference
Thirteenth International Conference on Information Systems Development Advances in Theory, Practice and Education, August 26th-28th 2004, Vilnius Gediminas Technical University, Vilnius, Lithuania.
Available from: 2010-04-09 Created: 2010-04-09 Last updated: 2018-01-12Bibliographically approved
2. Using Enterprise Modeling for Identification and Resolution of Homonym Conflicts in View Integration
Open this publication in new window or tab >>Using Enterprise Modeling for Identification and Resolution of Homonym Conflicts in View Integration
2005 (English)In: Information Systems Development: Advances in Theory, Practice, and Education / [ed] Vasilecas, O., Caplinskas, A., Wojtkowski, W., Wojtkowski, W.G., Zupančič, J. & Wrycza, S., 2005, p. 265-276Conference paper, Published paper (Refereed)
National Category
Information Systems
Research subject
Information Systems
Identifiers
urn:nbn:se:kau:diva-5533 (URN)10.1007/0-387-28809-0_24 (DOI)
Conference
13th International Conference on Information Systems Development (ISD'2004)
Available from: 2010-04-09 Created: 2010-04-09 Last updated: 2018-01-12Bibliographically approved
3. Towards a Generic and Integrated Enterprise Modeling Approach to Designing Databases and Software Components
Open this publication in new window or tab >>Towards a Generic and Integrated Enterprise Modeling Approach to Designing Databases and Software Components
2006 (English)In: Advances in Information Systems Development: Bridging the Gap between Academia and Industry  / [ed] Anders G. Nilsson, Remigijus Gustas, Wita Wojtkowski, W. Gregory Wojtkowski, Stanisław Wrycza, Jože Zupančič, Boston: Springer , 2006, p. 635-646Conference paper, Published paper (Refereed)
Abstract [en]

In order to design databases and software components that are fulfilling the customers requirements, modeling languages that define them at a high level of abstraction are needed e.g. [2, 12, 15, 18]. Several modeling languages and methods have been proposed but most of them put focus on the implementation level and the technical parts of the future information system [15].

Place, publisher, year, edition, pages
Boston: Springer, 2006
National Category
Information Systems
Research subject
Information Systems
Identifiers
urn:nbn:se:kau:diva-5012 (URN)10.1007/978-0-387-36402-5_55 (DOI)978-0-387-36402-5 (ISBN)
Conference
The 14th International conference on Information Systems Development (ISD2005), Karlstad, 14-17 August 2005
Available from: 2009-12-08 Created: 2009-12-08 Last updated: 2018-01-12Bibliographically approved
4. Bridging the Gap between Comparison and Conforming the Views in View Integration
Open this publication in new window or tab >>Bridging the Gap between Comparison and Conforming the Views in View Integration
2006 (English)In: Local Proceedings of the 10th East-European Conference on Advances in Databases and Information Systems / [ed] Manolopoulos, Y., Pokorný, J. & Sellis, T., 2006, p. 184-199Conference paper, Published paper (Refereed)
Abstract [en]

View integration is a complex, error-prone and time-consuming task.Therefore there is a need to decompose the integration methods into smallerwell defined phases where different techniques are applied. Most of themethods used today is composed of, or at least is a mixture of, the followingfour phases: pre-integration, comparison of the views, conforming the viewsand merging and restructuring, and most of the methods put focus on phase 2and 3. Despite of this there is a gap between these two phases. To bridge thisgap a framework has been developed. In the framework Inference Rules (IR)are used, together with Enterprise Modeling (EM) as the canonical modelinglanguage, to deduce dependencies that are not conflicting from dependenciesthat are or have been identified as an inter-schema property. Three researchquestions regarding why, how and when IR should be applied in viewintegration are analyzed and discussed and it is argued that the framework maynot only improve view integration as such but also improve the applied conflictand inter-schema resolution techniques.

National Category
Information Systems
Research subject
Information Systems
Identifiers
urn:nbn:se:kau:diva-5534 (URN)
Conference
10th East-European Conference on Advances in Databases and Information Systems
Available from: 2010-04-09 Created: 2010-04-09 Last updated: 2018-01-12Bibliographically approved
5. Language Aspects of Conceptual Database Design
Open this publication in new window or tab >>Language Aspects of Conceptual Database Design
2006 (English)In: Proceedings of the 4th International Conference on Action in Language, Organisations and Information Systems: Borås, Sweden, 1-2 November 2006 / [ed] Lind, M., Goldkuhl, G. & Hjalmarsson, A., Borås: University College of Borås , 2006, p. 211-223Conference paper, Published paper (Refereed)
Abstract [en]

We view the database as a part of a living language and therefore put focus on the dialectical relation between the spoken language and a database represented as a conceptual database schema. We assert that the discrepancy between the spoken language and a database needs to be addressed and minimized. Wealso assert that all concept names need to be retained as long as possible in conceptual database design because otherwise we may end up with a state of concept name compression and semantic loss

Place, publisher, year, edition, pages
Borås: University College of Borås, 2006
Keywords
Language, Conceptual Database Design, View Integration, Semantic Loss, Understandability
National Category
Information Systems
Research subject
Information Systems
Identifiers
urn:nbn:se:kau:diva-5535 (URN)91-631-9674-3 (ISBN)
Conference
4th International Conference on Action in Language, Organisations and Information Systems, Borås, 1-2 November 2006
Available from: 2010-04-09 Created: 2010-04-09 Last updated: 2018-01-12Bibliographically approved
6. Recognition and Resolution of Linguistic Conflicts: The Core to a Successful View and Schema Integration
Open this publication in new window or tab >>Recognition and Resolution of Linguistic Conflicts: The Core to a Successful View and Schema Integration
2007 (English)In: Advances in Information Systems Development New Methods and Practice for the Networked Society / [ed] Magyar, G., Knapp, G., Wojtkowski, W., Wojtkowski, W.G. & Zupančič, J., 2007, p. 77-87Conference paper, Published paper (Refereed)
National Category
Computer and Information Sciences
Research subject
Information Systems
Identifiers
urn:nbn:se:kau:diva-5540 (URN)10.1007/978-0-387-70802-7_7 (DOI)
Available from: 2010-04-09 Created: 2010-04-09 Last updated: 2018-01-12Bibliographically approved
7. Designing Software Components for Database Consistency: An Enterprise Modeling Approach
Open this publication in new window or tab >>Designing Software Components for Database Consistency: An Enterprise Modeling Approach
2007 (English)In: Advances in Information Systems Development: New Methods and Practice for the Networked Society / [ed] Wita Wojtkowski, W. Gregory Wojtkowski, Jože Zupancic, Gabor Magyar, Gabor Knapp, Boston: Springer Science+Business Media , 2007, p. 37-47Conference paper, Published paper (Refereed)
Abstract [en]

The ubiquitous use of databases (DB) in information systems (IS) today is a direct result of complex and enormous amounts of data processing required in modern businesses. The complexity of the data processing requires software to support the organization in being competitive in an increasingly demanding business climate. The software must support the organization in creating business advantages, thus the need for robust, yet flexible software solutions is increasingly important to maintain or gain effectiveness [1].

Place, publisher, year, edition, pages
Boston: Springer Science+Business Media, 2007
National Category
Information Systems
Research subject
Information Systems
Identifiers
urn:nbn:se:kau:diva-5013 (URN)10.1007/978-0-387-70802-7_4 (DOI)978-0-387-70802-7 (ISBN)
Conference
The 15th International conference on Information Systems Development ISD 2006, 31 August - 2 September, Budapest
Available from: 2009-12-08 Created: 2009-12-08 Last updated: 2018-01-12Bibliographically approved
8. On the Problem of Semantic Loss in View Integration
Open this publication in new window or tab >>On the Problem of Semantic Loss in View Integration
2009 (English)In: Information Systems Development Challenges in Practice, Theory, and Education, 2009, p. 963-974Conference paper, Published paper (Refereed)
National Category
Computer and Information Sciences
Research subject
Information Systems
Identifiers
urn:nbn:se:kau:diva-5537 (URN)10.1007/978-0-387-78578-3_29 (DOI)
Available from: 2010-04-09 Created: 2010-04-09 Last updated: 2018-01-12Bibliographically approved
9. Guidelines for Modeling Language Independent Integration of Dynamic Schemata
Open this publication in new window or tab >>Guidelines for Modeling Language Independent Integration of Dynamic Schemata
2008 (English)In: Proceedings of the IASTED International Conference on Software Engineering / [ed] Pahl, C., 2008, p. 112-117Conference paper, Published paper (Refereed)
Abstract [en]

View and schema integration have been a research topic for approximately three decades now. Several integration approaches were developed over the time for dynamic modeling (e.g. integration of state charts, business process models, enterprise models etc.). The integration strategies of these approaches are based on language specific features of a certain modeling language. But what happens if the source schemata are available in different languages? In this paper we research if there are some language independent integration guidelines for behavior modeling. In other words which approaches have been proved to be successful in the past which can be applied on all modeling languages dealing with behavior modeling? Thus our approach will be a first step towards an integration strategy for dynamic schemata independent of modeling languages.

National Category
Computer and Information Sciences
Research subject
Information Systems
Identifiers
urn:nbn:se:kau:diva-5538 (URN)978-0-88986-716-1 (ISBN)
Conference
IASTED International Conference on Software Engineering
Available from: 2010-04-09 Created: 2010-04-09 Last updated: 2018-01-12Bibliographically approved
10. Analyzing and Defining Active Database Rules on a Conceptual Level
Open this publication in new window or tab >>Analyzing and Defining Active Database Rules on a Conceptual Level
2009 (English)In: Proceedings of the Eight International Balric Conterence on Databases and Information Systems, Haav, 2009, p. 361-372Conference paper, Published paper (Refereed)
National Category
Computer and Information Sciences
Research subject
Information Systems
Identifiers
urn:nbn:se:kau:diva-5014 (URN)
Available from: 2009-12-08 Created: 2009-12-08 Last updated: 2018-01-12Bibliographically approved
11. Toward Modeling-Language Independent Integration of Dynamic Schemata
Open this publication in new window or tab >>Toward Modeling-Language Independent Integration of Dynamic Schemata
2009 (English)In: Information Systems Development: Towards a Service Provision Society / [ed] Papadopoulos, G. A., Wojtkowski, W., Wojtkowski, W. G., Wrycza, S., & Zupančič, J., 2009, p. 21-29Conference paper, Published paper (Refereed)
National Category
Computer and Information Sciences
Research subject
Information Systems
Identifiers
urn:nbn:se:kau:diva-5539 (URN)10.1007/b137171_3 (DOI)
Available from: 2010-04-09 Created: 2010-04-09 Last updated: 2018-01-12Bibliographically approved

Open Access in DiVA

fulltext(1951 kB)612 downloads
File information
File name FULLTEXT01.pdfFile size 1951 kBChecksum SHA-512
69c046acf3fb85eb72ba00199d8cf43498939d1b0f159c4cb49b0727274e5967cb79ecee5b8e662bbdf6e8157f6ed6d4c9875a01fff55154e30f163046c8f523
Type fulltextMimetype application/pdf

Authority records BETA

Bellström, Peter

Search in DiVA

By author/editor
Bellström, Peter
By organisation
Avdelningen för informatik och projektledning
Computer and Information Sciences

Search outside of DiVA

GoogleGoogle Scholar
Total: 612 downloads
The number of downloads is the sum of all downloads of full texts. It may include eg previous versions that are now no longer available

isbn
urn-nbn

Altmetric score

isbn
urn-nbn
Total: 2408 hits
CiteExportLink to record
Permanent link

Direct link
Cite
Citation style
  • apa
  • harvard1
  • ieee
  • modern-language-association-8th-edition
  • vancouver
  • Other style
More styles
Language
  • de-DE
  • en-GB
  • en-US
  • fi-FI
  • nn-NO
  • nn-NB
  • sv-SE
  • Other locale
More languages
Output format
  • html
  • text
  • asciidoc
  • rtf