Abstract
In this paper we briefly overview a suite of tools developed at Lawrence Berkeley Laboratory (LBL) for aiding users in defining, querying, and browsing databases developed with commercial relational database management systems (DBMS), using object-oriented constructs. These tools are based on a version of the Extended Entity-Relationship (EER) model and a 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 LBL/EER database tools users are insulated from the underlying DBMS, and thus can avoid learning DBMS specific concepts and query languages.
This work was 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.
This is a preview of subscription content, log in via an institution to check access.
Preview
Unable to display preview. Download preview PDF.
Similar content being viewed by others
References
Chen, P. P., The Entity-Relationship Model-Towards a Unified View of Data, ACM Transactions on Database Systems, 1, 1, (March 1976), pp. 9–36.
Czejdo, B., Elmasri, R., Embley, D. W., and Rusinkiewicz, M., A Graphical Data Manipulation Language for an Extended Entity-Relationship Model, IEEE Computer 23, 3 (March 1990), pp. 26–36.
Foresite Systems, Evaluating and Comparing CASE Tools, 1989.
Markowitz, V. M., Problems Underlying the Use of Referential Integrity in Relational Database Management Systems, Proc. of the 7th Int. Conference on Data Engineering, 1991.
Markowitz, V. M., Safe Referential Integrity and Null Constraint Structures in Relational Databases, Information Systems, Vol. 19, No. 4, pp. 359–378, 1994.
Markowitz, V. M., Merging Relations in Relational Databases, Proc. of the 8th Int. Conference on Data Engineering, 1992.
Markowitz, V. M., and Makowsky, J. A., Identifying Extended Entity-Relationship Object Structures in Relational Schemas, IEEE Transactions on Software Engineering, 16, 8 (August 1990), pp. 777–790.
Markowitz, V. M., and Raz, Y., ERROL: An Entity-Relationship Role Oriented Query Language, Entity-Relationship Approach to Software Engineering, Davis,G. C. and al (eds), North-Holland, 1983, pp. 329–345.
Markowitz, V. M., and Shoshani, A., Representing Extended Entity-Relationship Structures in Relational Databases: A Modular Approach, ACM Transactions on Database Systems, 17, 3, (September 1992), pp. 423–464.
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.
Markowitz, V. M., and Szeto, E., The COQL Translator. Design Document, Lawrence Berkeley Laboratory Technical Report LBL-31451, 1992.
Markowitz, V. M., Wang, J., and Fang.,W., SDT 6.3. A Schema Definition and Translation Tool for Extended Entity-Relationship Schemas, Lawrence Berkeley Laboratory Technical Report LBL-27843, 1993.
Markowitz, V. M., and Wang, J., Updating Relational Databases via an Extended Entity-Relationship Interface: Language and Implementation, Lawrence Berkeley Laboratory Technical Report LBL-35868, 1994.
Shoshani, A., CABLE: A Language Based on the Entity-Relationship Model, Lawrence Berkeley Laboratory Technical Report LBL-22033, 1978.
Shoshani, A., ERVIEW: Defining Object Views over Extended Entity-Schemas, Lawrence Berkeley Laboratory Technical Report LBL-35870, 1994.
Shoshani, A., Hsiao-Chiu, J., Markowitz, V. M., and Wang, J., ERVALS 2.2. A Value Set Editor for Extended Entity-Relationship Schemas, Lawrence Berkeley Laboratory Technical Report LBL-35151, 1994.
Szeto, E., and Markowitz, V. M., ERDRAW 5.3. A Graphical Editor for Extended Entity-Relationship Schemas, Lawrence Berkeley Laboratory Technical Report LBL-PUB-3084, 1993.
Teorey, T. J., Yang, D., and Fry, J. P., A Logical Design Methodology for Relational Databases Using the Extended Entity-Relationship Model, ACM Computing Surveys, 18, 2, (June 1986), pp. 197–222.
Author information
Authors and Affiliations
Editor information
Rights and permissions
Copyright information
© 1994 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Markowitz, V.M., Shoshani, A. (1994). An overview of the Lawrence Berkeley Laboratory extended entity-relationship database tools. In: Loucopoulos, P. (eds) Entity-Relationship Approach — ER '94 Business Modelling and Re-Engineering. ER 1994. Lecture Notes in Computer Science, vol 881. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-58786-1_89
Download citation
DOI: https://doi.org/10.1007/3-540-58786-1_89
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-58786-6
Online ISBN: 978-3-540-49100-2
eBook Packages: Springer Book Archive