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
Towards an Understanding of the Meaning and the Contents of a Database through Design and Reconstruction
Karlstad University, Faculty of Economic Sciences, Communication and IT, Department of Information Systems and Project Management. (Informatik och Projektledning)
Karlstad University, Faculty of Economic Sciences, Communication and IT, Department of Information Systems and Project Management.
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, 283-293 p.Conference paper, Published paper (Refereed)
Place, publisher, year, edition, pages
2004. 283-293 p.
National Category
Information Systems
Research subject
Information Systems
Identifiers
URN: urn:nbn:se:kau:diva-5531ISBN: 0387250263;978-0387250267 (print)OAI: oai:DiVA.org:kau-5531DiVA: diva2:309892
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: 2013-10-17Bibliographically approved
In thesis
1. Schema Integration: How to Integrate Static and Dynamic Database Schemata
Open this publication in new window or tab >>Schema Integration: How to Integrate Static and Dynamic Database Schemata
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. 346 p.
Series
Karlstad University Studies, ISSN 1403-8099 ; 2010:13
Keyword
Schema Integration, Conceptual Database Design, Database Schemata, Enterprise Modeling
National Category
Computer and Information Science
Research subject
Information Systems
Identifiers
urn:nbn:se:kau:diva-5541 (URN)978-91-7063-299-0  (ISBN)
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: 2011-10-05Bibliographically approved
2. View Integration in Conceptual Database Design: Problems, Approaches and Solutions
Open this publication in new window or tab >>View Integration in Conceptual Database Design: Problems, Approaches and Solutions
2006 (English)Licentiate thesis, comprehensive summary (Other academic)
Abstract [en]

View integration is a complex and time-consuming task because there are several problems that need to be addressed. Two such problems are conflict identification and conflict resolution. Conflicts occur because end users may define concepts on different levels of abstraction and because end users may name concepts differently. Therefore there is a need for methods that can cope with these problems when applying the chosen conceptual modeling language. The aim of this thesis is to develop a method for view integration in conceptual database design in which the dependencies of the Enterprise Modeling approach are applied. For this purpose four research studies have been conducted and each study is presented in one paper. In the first study the problem of semantic loss during view integration is addressed; in the second, the problems of identification and resolution of the homonym conflicts are addressed; in the third, the problem of how to define both databases and software components using Enterprise Modeling as a generic and integrated approach are addressed; and finally, in the fourth study, the problems of applying inference rules for conflict simplification or resolution and for interschema property simplification or resolution are addressed. These research studies together with the five introductory chapters contribute to answering the overall research question: In what way is view integration supported by applying the semantic dependencies of the Enterprise Modeling approach? In this thesis it is argued that using the dependencies of the Enterprise Modeling approach simplifies the view integration process and using the proposed resolution techniques for name conflicts reduces the possibility of semantic loss occurring.

Place, publisher, year, edition, pages
Karlstad: Karlstads universitet, 2006
Series
Karlstad University Studies, ISSN 1403-8099 ; 2006:5
National Category
Information Systems
Research subject
Information Systems
Identifiers
urn:nbn:se:kau:diva-14516 (URN)9170630364 (ISBN)
Available from: 2012-08-20 Created: 2012-08-20 Last updated: 2014-10-02Bibliographically approved

Open Access in DiVA

No full text

Authority records BETA

Bellström, Peter

Search in DiVA

By author/editor
Bellström, Peter
By organisation
Department of Information Systems and Project Management
Information Systems

Search outside of DiVA

GoogleGoogle Scholar

isbn
urn-nbn

Altmetric score

isbn
urn-nbn
Total: 1265 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