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
Language Aspects of Conceptual Database Design
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.
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, 211-223 p.Conference 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. 211-223 p.
Keyword [en]
Language, Conceptual Database Design, View Integration, Semantic Loss, Understandability
National Category
Information Systems
Research subject
Information Systems
Identifiers
URN: urn:nbn:se:kau:diva-5535ISBN: 91-631-9674-3 (print)OAI: oai:DiVA.org:kau-5535DiVA: diva2:309903
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: 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

Open Access in DiVA

No full text

Other links

http://www.vits.org/uploads/alois2006/Bellstr%C3%B6m_Carlsson.pdf

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: 224 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