his.sePublications
Change search
CiteExportLink to record
Permanent link

Direct link
Cite
Citation style
  • apa
  • 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
Active Support for ER Modelling
University of Skövde, School of Humanities and Informatics.
University of Skövde, School of Humanities and Informatics.
1993 (English)Report (Other academic)
Abstract [en]

A commonly used methodology in the design of a database system is to use the ER Model for the conceptual design together with the RDM during the implementation phase. This methodology requires that a mapping between the two data models be performed.

This paper addresses the `lost semantics' problem caused by the impedance mismatch between the two models and reports on a prototype system which has been developed in order to bridge this gap. The aim of the system is to provide a tool for preserving the semantics of a conceptually rich model when automatically translating it into a working system.

The graph oriented approach suggested by Dogac [Dog90] makes use of the implicit information from the ER Schema when identifying the correct update propagations. They suggest a preprocessor which must be run on all applications for this automatic generation of relational code. We take this a stage further and suggest how, using the

emerging active technology of new DBMS, the techniques can be used to provide full, automatic and centralised support for an ER design. Details of an initial prototype (for non-active systems) and a refined prototype (for the latest release of a system, with triggers) are provided.

There are a number of aspects to the architecture which has been developed: it is multi-level, for targeting different database systems; it preserves the ER Model in the working system; it can be used for both active and passive database systems. The early (passive) prototype has been designed to run on top of the commercial RDBMS

INFORMIX. Work on both the passive and active designs targets the commercial RDBMS INFORMIX; the active design uses a general intermediate form of ECA rule as a target for translation.

Place, publisher, year, edition, pages
Skövde: Institutionen för kommunikation och information , 1993.
Series
IKI Technical Reports, HS-IDA-TR-93-004
Keyword [en]
Database design, ER Model, Integrity constraints, Active
National Category
Information Science
Identifiers
URN: urn:nbn:se:his:diva-1197OAI: oai:DiVA.org:his-1197DiVA: diva2:2325
Available from: 2008-06-17 Created: 2008-06-17 Last updated: 2010-04-08

Open Access in DiVA

No full text

Search in DiVA

By author/editor
Lundell, BjörnLings, Brian
By organisation
School of Humanities and Informatics
Information Science

Search outside of DiVA

GoogleGoogle Scholar

Total: 63 hits
CiteExportLink to record
Permanent link

Direct link
Cite
Citation style
  • apa
  • 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