Book Chapter10.1007/BFB0020532
Database Schema Transformation and Optimization
Terry Halpin,Henderik A. Proper +1 more
- 12 Dec 1995
- pp 191-203
55
TL;DR: This paper discusses recent advances in the theory of schema transformation and optimization within the framework of ORM (Object-Role Modeling).
read more
Abstract: An application structure is best modeled first as a conceptual schema, and then mapped to an internal schema for the target DBMS. Different but equivalent conceptual schemas often map to different internal schemas, so performance may be improved by applying conceptual transformations prior to the standard mapping. This paper discusses recent advances in the theory of schema transformation and optimization within the framework of ORM (Object-Role Modeling). New aspects include object relativity, complex types, a high level transformation language and update distributivity.
read more
Chat with Paper
AI Agents for this Paper
Find similar papers on Google Scholar, PubMed and Arxiv
Write a critical review of this paper
Analyze citations of this paper to find unaddressed research gaps
Citations
Object-Role Modeling (ORM/NIAM)
Terry Halpin
- 01 Jan 1998
TL;DR: An overview of ORM is provided, and its advantages over Entity Relationship and traditional Object-Oriented modeling are noted.
Data modeling in UML and ORM: a comparison
Terry Halpin,Anthony C. Bloesch +1 more
TL;DR: The relative strengths and weaknesses of ORM and UML for data modeling are examined, and how models in one notation can be translated into the other are indicated.
ConQuer: A Conceptual Query Language
Anthony C. Bloesch,Terry Halpin +1 more
- 07 Oct 1996
TL;DR: While most conceptual query languages are based on the Entity-Relationship approach, ConQuer is based on Object-Role Modeling (ORM), which exposes semantic domains as conceptual object types, thus allowing queries to be formulated in terms of paths through the information space.
•Journal Article
Conceptual queries using ConQuer-II
Anthony C. Bloesch,Terry Halpin +1 more
TL;DR: ConQuer as discussed by the authors is a conceptual query language that allows users to formulate queries naturally in terms of elementary relationships, such as and, of', snot' and maybe contextual forclauses and object-correlation.
82
Orm 2
Terry Halpin
- 31 Oct 2005
TL;DR: The ORM 2 tool as discussed by the authors provides tool support for a second generation of ORM, which has significant advances over current ORM technology and is a fact-oriented modeling approach for specifying, transforming, and querying information at conceptual level.
73
References
The OO-binary relationship model : A truly object-oriented conceptual model
O.M.F. de Troyer
- 01 Jan 1991
TL;DR: This paper shows that it is possible to turn a conventional conceptual model (in particular the Binary Relationship Model) into a truly object oriented conceptual model which combines the assets of the conventional model with the advantages of the object oriented approach.
32
The OO-Binary relationship model: a truly object oriented conceptual model
O.M.F. de Troyer
- 01 May 1991
TL;DR: In this article, the authors show that it is possible to turn a conventional conceptual model (in particular the Binary Relationship Model) into a truly object oriented conceptual model which combines the assets of the conventional model with the advantages of the object oriented approach.
31
Resolving Fragmentation Conflicts in Schema Integration
Yann Dupont
- 13 Dec 1994
TL;DR: Research on schema integration leads to the identification of many different conflict types, but literature usually focuses on traditional problems, whilst new kinds of schema discrepancies, due to the object orientation or the generalization concept, are not really treated.
30
•Proceedings Article
Abstraction techniques for Conceptual Schema.
Linda Campbell,Terry A. Halpin +1 more
- 01 Jan 1994
19
Related Papers (5)
Terry Halpin
- 01 Jan 1998
Anthony C. Bloesch,Terry Halpin +1 more
- 07 Oct 1996
Michael R. Blaha,William James Premerlani +1 more
- 27 Jul 1997