Endre søk
RefereraExporteraLink to record
Permanent link

Direct link
Referera
Referensformat
  • apa
  • ieee
  • modern-language-association-8th-edition
  • vancouver
  • Annet format
Fler format
Språk
  • de-DE
  • en-GB
  • en-US
  • fi-FI
  • nn-NO
  • nn-NB
  • sv-SE
  • Annet 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 (engelsk)Doktoravhandling, med artikler (Annet vitenskapelig)
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.

sted, utgiver, år, opplag, sider
Karlstad: Karlstads universitet , 2010. , s. 346
Serie
Karlstad University Studies, ISSN 1403-8099 ; 2010:13
Emneord [en]
Schema Integration, Conceptual Database Design, Database Schemata, Enterprise Modeling
HSV kategori
Forskningsprogram
Informatik
Identifikatorer
URN: urn:nbn:se:kau:diva-5541ISBN: 978-91-7063-299-0  (tryckt)OAI: oai:DiVA.org:kau-5541DiVA, id: diva2:309916
Disputas
2010-05-28, Frödingsalen 1B 364, Karlstads universitet, Karlstad, 13:15 (engelsk)
Opponent
Veileder
Tilgjengelig fra: 2010-05-06 Laget: 2010-04-09 Sist oppdatert: 2019-07-12bibliografisk kontrollert
Delarbeid
1. Towards an Understanding of the Meaning and the Contents of a Database through Design and Reconstruction
Åpne denne publikasjonen i ny fane eller vindu >>Towards an Understanding of the Meaning and the Contents of a Database through Design and Reconstruction
2004 (engelsk)Inngå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-293Konferansepaper, Publicerat paper (Fagfellevurdert)
HSV kategori
Forskningsprogram
Informatik
Identifikatorer
urn:nbn:se:kau:diva-5531 (URN)0387250263;978-0387250267 (ISBN)
Konferanse
Thirteenth International Conference on Information Systems Development Advances in Theory, Practice and Education, August 26th-28th 2004, Vilnius Gediminas Technical University, Vilnius, Lithuania.
Tilgjengelig fra: 2010-04-09 Laget: 2010-04-09 Sist oppdatert: 2019-07-12bibliografisk kontrollert
2. Using Enterprise Modeling for Identification and Resolution of Homonym Conflicts in View Integration
Åpne denne publikasjonen i ny fane eller vindu >>Using Enterprise Modeling for Identification and Resolution of Homonym Conflicts in View Integration
2005 (engelsk)Inngå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-276Konferansepaper, Publicerat paper (Fagfellevurdert)
HSV kategori
Forskningsprogram
Informatik
Identifikatorer
urn:nbn:se:kau:diva-5533 (URN)10.1007/0-387-28809-0_24 (DOI)
Konferanse
13th International Conference on Information Systems Development (ISD'2004)
Tilgjengelig fra: 2010-04-09 Laget: 2010-04-09 Sist oppdatert: 2019-07-12bibliografisk kontrollert
3. Towards a Generic and Integrated Enterprise Modeling Approach to Designing Databases and Software Components
Åpne denne publikasjonen i ny fane eller vindu >>Towards a Generic and Integrated Enterprise Modeling Approach to Designing Databases and Software Components
2006 (engelsk)Inngå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-646Konferansepaper, Publicerat paper (Fagfellevurdert)
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].

sted, utgiver, år, opplag, sider
Boston: Springer, 2006
HSV kategori
Forskningsprogram
Informatik
Identifikatorer
urn:nbn:se:kau:diva-5012 (URN)10.1007/978-0-387-36402-5_55 (DOI)978-0-387-36402-5 (ISBN)
Konferanse
The 14th International conference on Information Systems Development (ISD2005), Karlstad, 14-17 August 2005
Tilgjengelig fra: 2009-12-08 Laget: 2009-12-08 Sist oppdatert: 2019-07-12bibliografisk kontrollert
4. Bridging the Gap between Comparison and Conforming the Views in View Integration
Åpne denne publikasjonen i ny fane eller vindu >>Bridging the Gap between Comparison and Conforming the Views in View Integration
2006 (engelsk)Inngå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-199Konferansepaper, Publicerat paper (Fagfellevurdert)
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.

HSV kategori
Forskningsprogram
Informatik
Identifikatorer
urn:nbn:se:kau:diva-5534 (URN)
Konferanse
10th East-European Conference on Advances in Databases and Information Systems
Tilgjengelig fra: 2010-04-09 Laget: 2010-04-09 Sist oppdatert: 2019-07-12bibliografisk kontrollert
5. Language Aspects of Conceptual Database Design
Åpne denne publikasjonen i ny fane eller vindu >>Language Aspects of Conceptual Database Design
2006 (engelsk)Inngå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-223Konferansepaper, Publicerat paper (Fagfellevurdert)
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

sted, utgiver, år, opplag, sider
Borås: University College of Borås, 2006
Emneord
Language, Conceptual Database Design, View Integration, Semantic Loss, Understandability
HSV kategori
Forskningsprogram
Informatik
Identifikatorer
urn:nbn:se:kau:diva-5535 (URN)91-631-9674-3 (ISBN)
Konferanse
4th International Conference on Action in Language, Organisations and Information Systems, Borås, 1-2 November 2006
Tilgjengelig fra: 2010-04-09 Laget: 2010-04-09 Sist oppdatert: 2019-07-12bibliografisk kontrollert
6. Recognition and Resolution of Linguistic Conflicts: The Core to a Successful View and Schema Integration
Åpne denne publikasjonen i ny fane eller vindu >>Recognition and Resolution of Linguistic Conflicts: The Core to a Successful View and Schema Integration
2007 (engelsk)Inngå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-87Konferansepaper, Publicerat paper (Fagfellevurdert)
HSV kategori
Forskningsprogram
Informatik
Identifikatorer
urn:nbn:se:kau:diva-5540 (URN)10.1007/978-0-387-70802-7_7 (DOI)
Tilgjengelig fra: 2010-04-09 Laget: 2010-04-09 Sist oppdatert: 2019-07-12bibliografisk kontrollert
7. Designing Software Components for Database Consistency: An Enterprise Modeling Approach
Åpne denne publikasjonen i ny fane eller vindu >>Designing Software Components for Database Consistency: An Enterprise Modeling Approach
2007 (engelsk)Inngå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-47Konferansepaper, Publicerat paper (Fagfellevurdert)
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].

sted, utgiver, år, opplag, sider
Boston: Springer Science+Business Media, 2007
HSV kategori
Forskningsprogram
Informatik
Identifikatorer
urn:nbn:se:kau:diva-5013 (URN)10.1007/978-0-387-70802-7_4 (DOI)978-0-387-70802-7 (ISBN)
Konferanse
The 15th International conference on Information Systems Development ISD 2006, 31 August - 2 September, Budapest
Tilgjengelig fra: 2009-12-08 Laget: 2009-12-08 Sist oppdatert: 2019-07-12bibliografisk kontrollert
8. On the Problem of Semantic Loss in View Integration
Åpne denne publikasjonen i ny fane eller vindu >>On the Problem of Semantic Loss in View Integration
2009 (engelsk)Inngår i: Information Systems Development Challenges in Practice, Theory, and Education, 2009, s. 963-974Konferansepaper, Publicerat paper (Fagfellevurdert)
HSV kategori
Forskningsprogram
Informatik
Identifikatorer
urn:nbn:se:kau:diva-5537 (URN)10.1007/978-0-387-78578-3_29 (DOI)
Tilgjengelig fra: 2010-04-09 Laget: 2010-04-09 Sist oppdatert: 2019-07-12bibliografisk kontrollert
9. Guidelines for Modeling Language Independent Integration of Dynamic Schemata
Åpne denne publikasjonen i ny fane eller vindu >>Guidelines for Modeling Language Independent Integration of Dynamic Schemata
2008 (engelsk)Inngår i: Proceedings of the IASTED International Conference on Software Engineering / [ed] Pahl, C., 2008, s. 112-117Konferansepaper, Publicerat paper (Fagfellevurdert)
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.

HSV kategori
Forskningsprogram
Informatik
Identifikatorer
urn:nbn:se:kau:diva-5538 (URN)978-0-88986-716-1 (ISBN)
Konferanse
IASTED International Conference on Software Engineering
Tilgjengelig fra: 2010-04-09 Laget: 2010-04-09 Sist oppdatert: 2019-07-12bibliografisk kontrollert
10. Analyzing and Defining Active Database Rules on a Conceptual Level
Åpne denne publikasjonen i ny fane eller vindu >>Analyzing and Defining Active Database Rules on a Conceptual Level
2009 (engelsk)Inngår i: Proceedings of the Eight International Balric Conterence on Databases and Information Systems, Haav, 2009, s. 361-372Konferansepaper, Publicerat paper (Fagfellevurdert)
HSV kategori
Forskningsprogram
Informatik
Identifikatorer
urn:nbn:se:kau:diva-5014 (URN)
Tilgjengelig fra: 2009-12-08 Laget: 2009-12-08 Sist oppdatert: 2019-07-12bibliografisk kontrollert
11. Toward Modeling-Language Independent Integration of Dynamic Schemata
Åpne denne publikasjonen i ny fane eller vindu >>Toward Modeling-Language Independent Integration of Dynamic Schemata
2009 (engelsk)Inngå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-29Konferansepaper, Publicerat paper (Fagfellevurdert)
HSV kategori
Forskningsprogram
Informatik
Identifikatorer
urn:nbn:se:kau:diva-5539 (URN)10.1007/b137171_3 (DOI)
Tilgjengelig fra: 2010-04-09 Laget: 2010-04-09 Sist oppdatert: 2019-07-12bibliografisk kontrollert

Open Access i DiVA

fulltekst(1951 kB)667 nedlastinger
Filinformasjon
Fil FULLTEXT01.pdfFilstørrelse 1951 kBChecksum SHA-512
69c046acf3fb85eb72ba00199d8cf43498939d1b0f159c4cb49b0727274e5967cb79ecee5b8e662bbdf6e8157f6ed6d4c9875a01fff55154e30f163046c8f523
Type fulltextMimetype application/pdf

Personposter BETA

Bellström, Peter

Søk i DiVA

Av forfatter/redaktør
Bellström, Peter
Av organisasjonen

Søk utenfor DiVA

GoogleGoogle Scholar
Totalt: 667 nedlastinger
Antall nedlastinger er summen av alle nedlastinger av alle fulltekster. Det kan for eksempel være tidligere versjoner som er ikke lenger tilgjengelige

isbn
urn-nbn

Altmetric

isbn
urn-nbn
Totalt: 2492 treff
RefereraExporteraLink to record
Permanent link

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