Automated mapping of conceptual schemas to relational schemas

J. I. McCormack, T. A. Halpin, P. R. Ritson

Research output: Chapter in Book/Report/Conference proceedingConference PaperResearchpeer-review

3 Citations (Scopus)

Abstract

Many CASE tools for information systems engineering can input a conceptual data model of an application and map this to a logical data model for implementation. Typically this involves mapping an ER (Entity-Relationship) conceptual schema to a relational database schema. Since the graphic notation of ER, or the mapping algorithm itself, fails to capture many constraints and derivation rules, these additional features must be coded up manually. Object-Role Modelling (ORM) provides a simpler and richer notation, enabling most of these additional features to be catered for in the mapping. The most well known version of ORM is NIAM, and a number of CASE tools now support this method. Recently, an extended ORM language called FORML has been developed which is even more expressive, and a complete mapping algorithm has been developed and automated. This paper provides an overview of the mapping algorithm and the use of role-graphs for automation.

Original languageEnglish
Title of host publicationAdvanced Information Systems Engineering - 5th International Conference, CAiSE 1993, Proceedings
EditorsColette Rolland, Francois Bodart, Corine Cauvet
PublisherSpringer
Pages432-448
Number of pages17
ISBN (Print)9783540567776
Publication statusPublished - 1993
Externally publishedYes
Event5th International Conference on Advanced Information Systems Engineering, CAiSE 1993 - Paris, France
Duration: 8 Jun 199311 Jun 1993

Publication series

NameLecture Notes in Computer Science
PublisherSpringer
Volume685
ISSN (Print)0302-9743
ISSN (Electronic)1611-3349

Conference

Conference5th International Conference on Advanced Information Systems Engineering, CAiSE 1993
CountryFrance
CityParis
Period8/06/9311/06/93

Cite this

McCormack, J. I., Halpin, T. A., & Ritson, P. R. (1993). Automated mapping of conceptual schemas to relational schemas. In C. Rolland, F. Bodart, & C. Cauvet (Eds.), Advanced Information Systems Engineering - 5th International Conference, CAiSE 1993, Proceedings (pp. 432-448). (Lecture Notes in Computer Science ; Vol. 685 ). Springer.
McCormack, J. I. ; Halpin, T. A. ; Ritson, P. R. / Automated mapping of conceptual schemas to relational schemas. Advanced Information Systems Engineering - 5th International Conference, CAiSE 1993, Proceedings. editor / Colette Rolland ; Francois Bodart ; Corine Cauvet. Springer, 1993. pp. 432-448 (Lecture Notes in Computer Science ).
@inproceedings{703db0d33a714297ae26643efafb92ee,
title = "Automated mapping of conceptual schemas to relational schemas",
abstract = "Many CASE tools for information systems engineering can input a conceptual data model of an application and map this to a logical data model for implementation. Typically this involves mapping an ER (Entity-Relationship) conceptual schema to a relational database schema. Since the graphic notation of ER, or the mapping algorithm itself, fails to capture many constraints and derivation rules, these additional features must be coded up manually. Object-Role Modelling (ORM) provides a simpler and richer notation, enabling most of these additional features to be catered for in the mapping. The most well known version of ORM is NIAM, and a number of CASE tools now support this method. Recently, an extended ORM language called FORML has been developed which is even more expressive, and a complete mapping algorithm has been developed and automated. This paper provides an overview of the mapping algorithm and the use of role-graphs for automation.",
author = "McCormack, {J. I.} and Halpin, {T. A.} and Ritson, {P. R.}",
year = "1993",
language = "English",
isbn = "9783540567776",
series = "Lecture Notes in Computer Science",
publisher = "Springer",
pages = "432--448",
editor = "Colette Rolland and Francois Bodart and Corine Cauvet",
booktitle = "Advanced Information Systems Engineering - 5th International Conference, CAiSE 1993, Proceedings",

}

McCormack, JI, Halpin, TA & Ritson, PR 1993, Automated mapping of conceptual schemas to relational schemas. in C Rolland, F Bodart & C Cauvet (eds), Advanced Information Systems Engineering - 5th International Conference, CAiSE 1993, Proceedings. Lecture Notes in Computer Science , vol. 685 , Springer, pp. 432-448, 5th International Conference on Advanced Information Systems Engineering, CAiSE 1993, Paris, France, 8/06/93.

Automated mapping of conceptual schemas to relational schemas. / McCormack, J. I.; Halpin, T. A.; Ritson, P. R.

Advanced Information Systems Engineering - 5th International Conference, CAiSE 1993, Proceedings. ed. / Colette Rolland; Francois Bodart; Corine Cauvet. Springer, 1993. p. 432-448 (Lecture Notes in Computer Science ; Vol. 685 ).

Research output: Chapter in Book/Report/Conference proceedingConference PaperResearchpeer-review

TY - GEN

T1 - Automated mapping of conceptual schemas to relational schemas

AU - McCormack, J. I.

AU - Halpin, T. A.

AU - Ritson, P. R.

PY - 1993

Y1 - 1993

N2 - Many CASE tools for information systems engineering can input a conceptual data model of an application and map this to a logical data model for implementation. Typically this involves mapping an ER (Entity-Relationship) conceptual schema to a relational database schema. Since the graphic notation of ER, or the mapping algorithm itself, fails to capture many constraints and derivation rules, these additional features must be coded up manually. Object-Role Modelling (ORM) provides a simpler and richer notation, enabling most of these additional features to be catered for in the mapping. The most well known version of ORM is NIAM, and a number of CASE tools now support this method. Recently, an extended ORM language called FORML has been developed which is even more expressive, and a complete mapping algorithm has been developed and automated. This paper provides an overview of the mapping algorithm and the use of role-graphs for automation.

AB - Many CASE tools for information systems engineering can input a conceptual data model of an application and map this to a logical data model for implementation. Typically this involves mapping an ER (Entity-Relationship) conceptual schema to a relational database schema. Since the graphic notation of ER, or the mapping algorithm itself, fails to capture many constraints and derivation rules, these additional features must be coded up manually. Object-Role Modelling (ORM) provides a simpler and richer notation, enabling most of these additional features to be catered for in the mapping. The most well known version of ORM is NIAM, and a number of CASE tools now support this method. Recently, an extended ORM language called FORML has been developed which is even more expressive, and a complete mapping algorithm has been developed and automated. This paper provides an overview of the mapping algorithm and the use of role-graphs for automation.

UR - http://www.scopus.com/inward/record.url?scp=84948954323&partnerID=8YFLogxK

M3 - Conference Paper

SN - 9783540567776

T3 - Lecture Notes in Computer Science

SP - 432

EP - 448

BT - Advanced Information Systems Engineering - 5th International Conference, CAiSE 1993, Proceedings

A2 - Rolland, Colette

A2 - Bodart, Francois

A2 - Cauvet, Corine

PB - Springer

ER -

McCormack JI, Halpin TA, Ritson PR. Automated mapping of conceptual schemas to relational schemas. In Rolland C, Bodart F, Cauvet C, editors, Advanced Information Systems Engineering - 5th International Conference, CAiSE 1993, Proceedings. Springer. 1993. p. 432-448. (Lecture Notes in Computer Science ).