Extended Entity-Relationship Data Management Tools
The Extended Entity-Relationship (EER) data management tools
are meant to aid users in defining, querying, and browsing
databases developed with commercial relational database
management systems (DBMS).
These tools are based on a version of the EER model and
query language developed by us. They allow users to deal
with concise EER structures and queries rather than relational
database definitions and queries which are usually large,
hard to maintain, and involve terms that obscure the semantics of
the application.
Using the EER data management tools users are
insulated from the underlying
DBMS, and thus can avoid learning DBMS specific concepts
and query languages.
The suite of EER data management tools consists:
- a tool for determining ( reverse engineering)
the EER schema of an existing relational database,
called REL2EER; this tool can be used together with
an editor called ADD_REF
that allows adding missing referential (foreign key)
information to existing relational databases;
- a graphical EER schema editor called ERDRAW;
- a graphical EER value set editor called ERVALS;
- an EER schema into relational DBMS
database (definitions and procedures) translator called SDT;
- an EER query specification and browsing tool called QBT;
- an EER query to SQL translator called COQL Translator; and
- an EER update to SQL translator called EER Update Translator.
Examples of EER Schemas
-
Chromosome 22 schema, Genome Center for Chromosome 22,
University of Pennsylvania, Philadelphia.
Documents
- Markowitz, V.M., and Shoshani, A.,
An Overview of the Lawrence Berkeley Laboratory
Extended Entity-Relationship Database Tools,
TR LBL-34932, Lawrence Berkeley Laboratory, 1993.
- Markowitz, V.M., Wang, J., and Fang.,W.,
SDT 6.3. A Schema Definition and Translation Tool for Extended
Entity-Relationship Schemas,
TR LBL-27843, Lawrence Berkeley Laboratory, 1993.
- Markowitz, V.M., and Shoshani, A.,
Object Queries over Relational Databases:
Language, Implementation, and Applications,
Proc. of the 9th Int. Conference
on Data Engineering, 1993, pp. 71-80.
- Shoshani, A., Hsiao-Chiu, J., Markowitz, V.M., and Wang, J.,
ERVALS 2.2. A Value Set Editor for Extended Entity-Relationship
Schemas, TR LBL-35151, Lawrence Berkeley Laboratory, 1994.
- Szeto, E., and Markowitz, V.M.,
ERDRAW 5.3. A Graphical Editor for Extended Entity-Relationship
Schemas, TR LBL-PUB-3084, Lawrence Berkeley Laboratory, 1993.
This work is supported by the Applied
Mathematical Sciences Research Program
and the Office of Health and
Environmental Research Program, of the Office of
Energy Research, U.S. Department of Energy,
under Contract DE-AC03-76SF00098.
Data Management Research & Development Group
Information and Computing Sciences Division
Lawrence Berkeley Laboratory, Berkeley, CA 94720.
Victor M. Markowitz (VMMarkowitz@lbl.gov), February 1994.