Ändra sökning
RefereraExporteraLänk till posten
Permanent länk

Direktlänk
Referera
Referensformat
  • apa
  • harvard1
  • ieee
  • modern-language-association-8th-edition
  • vancouver
  • Annat format
Fler format
Språk
  • de-DE
  • en-GB
  • en-US
  • fi-FI
  • nn-NO
  • nn-NB
  • sv-SE
  • Annat språk
Fler språk
Utmatningsformat
  • html
  • text
  • asciidoc
  • rtf
Schema Integration: How to Integrate Static and Dynamic Database Schemata
Karlstads universitet, Fakulteten för ekonomi, kommunikation och IT, Avdelningen för informatik och projektledning.ORCID-id: 0000-0002-0419-1647
2010 (Engelska)Doktorsavhandling, sammanläggning (Övrigt vetenskapligt)
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.

Ort, förlag, år, upplaga, sidor
Karlstad: Karlstads universitet , 2010. , s. 346
Serie
Karlstad University Studies, ISSN 1403-8099 ; 2010:13
Nyckelord [en]
Schema Integration, Conceptual Database Design, Database Schemata, Enterprise Modeling
Nationell ämneskategori
Data- och informationsvetenskap
Forskningsämne
Informatik
Identifikatorer
URN: urn:nbn:se:kau:diva-5541ISBN: 978-91-7063-299-0  (tryckt)OAI: oai:DiVA.org:kau-5541DiVA, id: diva2:309916
Disputation
2010-05-28, Frödingsalen 1B 364, Karlstads universitet, Karlstad, 13:15 (Engelska)
Opponent
Handledare
Tillgänglig från: 2010-05-06 Skapad: 2010-04-09 Senast uppdaterad: 2019-07-12Bibliografiskt granskad
Delarbeten
1. Towards an Understanding of the Meaning and the Contents of a Database through Design and Reconstruction
Öppna denna publikation i ny flik eller fönster >>Towards an Understanding of the Meaning and the Contents of a Database through Design and Reconstruction
2004 (Engelska)Ingår i: Information Systems Development: Advances in Theory, Practice and Education / [ed] Vasilecas, O., Caplinskas, A., Wojtkowski, W., Wojtkowski, W.G., Zupancic, J. & Wrycza, S., 2004, s. 283-293Konferensbidrag, Publicerat paper (Refereegranskat)
Nationell ämneskategori
Systemvetenskap, informationssystem och informatik
Forskningsämne
Informatik
Identifikatorer
urn:nbn:se:kau:diva-5531 (URN)0387250263;978-0387250267 (ISBN)
Konferens
Thirteenth International Conference on Information Systems Development Advances in Theory, Practice and Education, August 26th-28th 2004, Vilnius Gediminas Technical University, Vilnius, Lithuania.
Tillgänglig från: 2010-04-09 Skapad: 2010-04-09 Senast uppdaterad: 2019-07-12Bibliografiskt granskad
2. Using Enterprise Modeling for Identification and Resolution of Homonym Conflicts in View Integration
Öppna denna publikation i ny flik eller fönster >>Using Enterprise Modeling for Identification and Resolution of Homonym Conflicts in View Integration
2005 (Engelska)Ingår i: 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, s. 265-276Konferensbidrag, Publicerat paper (Refereegranskat)
Nationell ämneskategori
Systemvetenskap, informationssystem och informatik
Forskningsämne
Informatik
Identifikatorer
urn:nbn:se:kau:diva-5533 (URN)10.1007/0-387-28809-0_24 (DOI)
Konferens
13th International Conference on Information Systems Development (ISD'2004)
Tillgänglig från: 2010-04-09 Skapad: 2010-04-09 Senast uppdaterad: 2019-07-12Bibliografiskt granskad
3. Towards a Generic and Integrated Enterprise Modeling Approach to Designing Databases and Software Components
Öppna denna publikation i ny flik eller fönster >>Towards a Generic and Integrated Enterprise Modeling Approach to Designing Databases and Software Components
2006 (Engelska)Ingår i: 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, s. 635-646Konferensbidrag, Publicerat paper (Refereegranskat)
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].

Ort, förlag, år, upplaga, sidor
Boston: Springer, 2006
Nationell ämneskategori
Systemvetenskap, informationssystem och informatik
Forskningsämne
Informatik
Identifikatorer
urn:nbn:se:kau:diva-5012 (URN)10.1007/978-0-387-36402-5_55 (DOI)978-0-387-36402-5 (ISBN)
Konferens
The 14th International conference on Information Systems Development (ISD2005), Karlstad, 14-17 August 2005
Tillgänglig från: 2009-12-08 Skapad: 2009-12-08 Senast uppdaterad: 2019-07-12Bibliografiskt granskad
4. Bridging the Gap between Comparison and Conforming the Views in View Integration
Öppna denna publikation i ny flik eller fönster >>Bridging the Gap between Comparison and Conforming the Views in View Integration
2006 (Engelska)Ingår i: Local Proceedings of the 10th East-European Conference on Advances in Databases and Information Systems / [ed] Manolopoulos, Y., Pokorný, J. & Sellis, T., 2006, s. 184-199Konferensbidrag, Publicerat paper (Refereegranskat)
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.

Nationell ämneskategori
Systemvetenskap, informationssystem och informatik
Forskningsämne
Informatik
Identifikatorer
urn:nbn:se:kau:diva-5534 (URN)
Konferens
10th East-European Conference on Advances in Databases and Information Systems
Tillgänglig från: 2010-04-09 Skapad: 2010-04-09 Senast uppdaterad: 2019-07-12Bibliografiskt granskad
5. Language Aspects of Conceptual Database Design
Öppna denna publikation i ny flik eller fönster >>Language Aspects of Conceptual Database Design
2006 (Engelska)Ingår i: 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, s. 211-223Konferensbidrag, Publicerat paper (Refereegranskat)
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

Ort, förlag, år, upplaga, sidor
Borås: University College of Borås, 2006
Nyckelord
Language, Conceptual Database Design, View Integration, Semantic Loss, Understandability
Nationell ämneskategori
Systemvetenskap, informationssystem och informatik
Forskningsämne
Informatik
Identifikatorer
urn:nbn:se:kau:diva-5535 (URN)91-631-9674-3 (ISBN)
Konferens
4th International Conference on Action in Language, Organisations and Information Systems, Borås, 1-2 November 2006
Tillgänglig från: 2010-04-09 Skapad: 2010-04-09 Senast uppdaterad: 2019-07-12Bibliografiskt granskad
6. Recognition and Resolution of Linguistic Conflicts: The Core to a Successful View and Schema Integration
Öppna denna publikation i ny flik eller fönster >>Recognition and Resolution of Linguistic Conflicts: The Core to a Successful View and Schema Integration
2007 (Engelska)Ingår i: 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, s. 77-87Konferensbidrag, Publicerat paper (Refereegranskat)
Nationell ämneskategori
Data- och informationsvetenskap
Forskningsämne
Informatik
Identifikatorer
urn:nbn:se:kau:diva-5540 (URN)10.1007/978-0-387-70802-7_7 (DOI)
Tillgänglig från: 2010-04-09 Skapad: 2010-04-09 Senast uppdaterad: 2019-07-12Bibliografiskt granskad
7. Designing Software Components for Database Consistency: An Enterprise Modeling Approach
Öppna denna publikation i ny flik eller fönster >>Designing Software Components for Database Consistency: An Enterprise Modeling Approach
2007 (Engelska)Ingår i: 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, s. 37-47Konferensbidrag, Publicerat paper (Refereegranskat)
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].

Ort, förlag, år, upplaga, sidor
Boston: Springer Science+Business Media, 2007
Nationell ämneskategori
Systemvetenskap, informationssystem och informatik
Forskningsämne
Informatik
Identifikatorer
urn:nbn:se:kau:diva-5013 (URN)10.1007/978-0-387-70802-7_4 (DOI)978-0-387-70802-7 (ISBN)
Konferens
The 15th International conference on Information Systems Development ISD 2006, 31 August - 2 September, Budapest
Tillgänglig från: 2009-12-08 Skapad: 2009-12-08 Senast uppdaterad: 2019-07-12Bibliografiskt granskad
8. On the Problem of Semantic Loss in View Integration
Öppna denna publikation i ny flik eller fönster >>On the Problem of Semantic Loss in View Integration
2009 (Engelska)Ingår i: Information Systems Development Challenges in Practice, Theory, and Education, 2009, s. 963-974Konferensbidrag, Publicerat paper (Refereegranskat)
Nationell ämneskategori
Data- och informationsvetenskap
Forskningsämne
Informatik
Identifikatorer
urn:nbn:se:kau:diva-5537 (URN)10.1007/978-0-387-78578-3_29 (DOI)
Tillgänglig från: 2010-04-09 Skapad: 2010-04-09 Senast uppdaterad: 2019-07-12Bibliografiskt granskad
9. Guidelines for Modeling Language Independent Integration of Dynamic Schemata
Öppna denna publikation i ny flik eller fönster >>Guidelines for Modeling Language Independent Integration of Dynamic Schemata
2008 (Engelska)Ingår i: Proceedings of the IASTED International Conference on Software Engineering / [ed] Pahl, C., 2008, s. 112-117Konferensbidrag, Publicerat paper (Refereegranskat)
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.

Nationell ämneskategori
Data- och informationsvetenskap
Forskningsämne
Informatik
Identifikatorer
urn:nbn:se:kau:diva-5538 (URN)978-0-88986-716-1 (ISBN)
Konferens
IASTED International Conference on Software Engineering
Tillgänglig från: 2010-04-09 Skapad: 2010-04-09 Senast uppdaterad: 2019-07-12Bibliografiskt granskad
10. Analyzing and Defining Active Database Rules on a Conceptual Level
Öppna denna publikation i ny flik eller fönster >>Analyzing and Defining Active Database Rules on a Conceptual Level
2009 (Engelska)Ingår i: Proceedings of the Eight International Balric Conterence on Databases and Information Systems, Haav, 2009, s. 361-372Konferensbidrag, Publicerat paper (Refereegranskat)
Nationell ämneskategori
Data- och informationsvetenskap
Forskningsämne
Informatik
Identifikatorer
urn:nbn:se:kau:diva-5014 (URN)
Tillgänglig från: 2009-12-08 Skapad: 2009-12-08 Senast uppdaterad: 2019-07-12Bibliografiskt granskad
11. Toward Modeling-Language Independent Integration of Dynamic Schemata
Öppna denna publikation i ny flik eller fönster >>Toward Modeling-Language Independent Integration of Dynamic Schemata
2009 (Engelska)Ingår i: Information Systems Development: Towards a Service Provision Society / [ed] Papadopoulos, G. A., Wojtkowski, W., Wojtkowski, W. G., Wrycza, S., & Zupančič, J., 2009, s. 21-29Konferensbidrag, Publicerat paper (Refereegranskat)
Nationell ämneskategori
Data- och informationsvetenskap
Forskningsämne
Informatik
Identifikatorer
urn:nbn:se:kau:diva-5539 (URN)10.1007/b137171_3 (DOI)
Tillgänglig från: 2010-04-09 Skapad: 2010-04-09 Senast uppdaterad: 2019-07-12Bibliografiskt granskad

Open Access i DiVA

fulltext(1951 kB)659 nedladdningar
Filinformation
Filnamn FULLTEXT01.pdfFilstorlek 1951 kBChecksumma SHA-512
69c046acf3fb85eb72ba00199d8cf43498939d1b0f159c4cb49b0727274e5967cb79ecee5b8e662bbdf6e8157f6ed6d4c9875a01fff55154e30f163046c8f523
Typ fulltextMimetyp application/pdf

Personposter BETA

Bellström, Peter

Sök vidare i DiVA

Av författaren/redaktören
Bellström, Peter
Av organisationen
Avdelningen för informatik och projektledning
Data- och informationsvetenskap

Sök vidare utanför DiVA

GoogleGoogle Scholar
Totalt: 659 nedladdningar
Antalet nedladdningar är summan av nedladdningar för alla fulltexter. Det kan inkludera t.ex tidigare versioner som nu inte längre är tillgängliga.

isbn
urn-nbn

Altmetricpoäng

isbn
urn-nbn
Totalt: 2472 träffar
RefereraExporteraLänk till posten
Permanent länk

Direktlänk
Referera
Referensformat
  • apa
  • harvard1
  • ieee
  • modern-language-association-8th-edition
  • vancouver
  • Annat format
Fler format
Språk
  • de-DE
  • en-GB
  • en-US
  • fi-FI
  • nn-NO
  • nn-NB
  • sv-SE
  • Annat språk
Fler språk
Utmatningsformat
  • html
  • text
  • asciidoc
  • rtf