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
View Integration in Conceptual Database Design: Problems, Approaches and Solutions
Karlstad University, Faculty of Economic Sciences, Communication and IT, Department of Information Systems and Project Management.
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: urn:nbn:se:kau:diva-14516ISBN: 9170630364 (print)OAI: oai:DiVA.org:kau-14516DiVA: diva2:545311
Available from: 2012-08-20 Created: 2012-08-20 Last updated: 2014-10-02Bibliographically 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, 283-293 p.Conference 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: 2013-10-17Bibliographically 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, 265-276 p.Conference 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: 2012-12-10Bibliographically 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, 635-646 p.Conference 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: 2012-08-20Bibliographically 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, 184-199 p.Conference 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: 2012-12-10Bibliographically approved

Open Access in DiVA

No full text

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

Total: 263 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