skip to main content
article
Free Access

Relational database design using an object-oriented methodology

Published:01 April 1988Publication History
Skip Abstract Section

Abstract

Of the many approaches to relational database design, the Object Modeling Technique (OMT) is particularly effective. A comprehensive explanation and two applications show the semantic improvement of OMT over other approaches.

References

  1. 1 Chen, P.P. The entity-relationship model: Toward a unified view of data. ACM TODS 1, I (Mar. 1976). Google ScholarGoogle ScholarDigital LibraryDigital Library
  2. 2 Date, C.}. Relational Database: Selected Writings. Addison.Wesley, Reading, Mass., 1986. Google ScholarGoogle ScholarDigital LibraryDigital Library
  3. 3 Goldberg, A., and Robson, D. SmaIltalk-80: The Language and Its Implementation. Addison-Wesley, Reading, Mass., 1984. Google ScholarGoogle ScholarDigital LibraryDigital Library
  4. 4 Khoshafian, S.N., and Copeland, G.P. Object identity. In Proceedings oJ the ACM Conference on Object-Oriented Programming Systems, Languages, and Applications. {Portland, Oregon). SIGPLAN Not. 21, 11 {1 986}. Google ScholarGoogle ScholarDigital LibraryDigital Library
  5. 5 Loomis, M.E.S., Shah, A.V.S., and Rumbaugh, I.E. An object modeling technique for conceptual design. In Proceedings of the European Conference on Object-Oriented Programming. (Paris, France, June 15- 17). Lecture Notes in Computer Science, 276. Springer-Verlag, New York, 1987. Google ScholarGoogle ScholarDigital LibraryDigital Library
  6. 6 MIMER Information Systems AB. Uppsala, Sweden.Google ScholarGoogle Scholar
  7. 7 Rumbaugh, J.E. Data Structure Manager Reference Manual. GE internal document. Schenectady, New York, 1987.Google ScholarGoogle Scholar
  8. 8 Rumbaugh, J.E. Relations as semantic constructs in an objectoriented language. In Proceedings of the ACM Conference on Object- Oriented Programming Systems, Languages, and Applications. (Orlando, Fla., Oct.). SIGPLAN Not. 22, 12 (1987). Google ScholarGoogle ScholarDigital LibraryDigital Library
  9. 9 Teorey, T.J., Yang, D., and Fry, J.P. A logical design methodology for relational databases using the extended entity-relationship model. ACM Comput. Surv. 18, 2 (June 1986). Google ScholarGoogle ScholarDigital LibraryDigital Library
  10. 10 Wiederhold, G. Modeling databases. Inform. Sci. 29, 2 (1983}.Google ScholarGoogle ScholarCross RefCross Ref

Index Terms

  1. Relational database design using an object-oriented methodology

              Recommendations

              Reviews

              Alfs T. Berztiss

              This paper should be required reading for all designers of information systems. I myself now use its object modeling technique (OMT) diagrams as an input in the development of formal specifications of information systems. Since OMT was introduced earlier [1], the primary purpose of this paper is to show how OMT diagrams can be converted into relational database schemas. However, it also provides a stand-alone introduction to OMT, which combines logical relational design methodology [2] with the property and operation inheritance of object orientation. An initial design is a diagram containing three kinds of constructs: a hierarchy of generalization relationships between object classes, entity-relationship associations between objects, and parts explosion trees that represent the aggregation of objects into composite objects. Examples show how the different constructs are combined into a single diagram.

              Access critical reviews of Computing literature here

              Become a reviewer for Computing Reviews.

              Comments

              Login options

              Check if you have access through your login credentials or your institution to get full access on this article.

              Sign in

              Full Access

              • Published in

                cover image Communications of the ACM
                Communications of the ACM  Volume 31, Issue 4
                April 1988
                88 pages
                ISSN:0001-0782
                EISSN:1557-7317
                DOI:10.1145/42404
                Issue’s Table of Contents

                Copyright © 1988 ACM

                Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

                Publisher

                Association for Computing Machinery

                New York, NY, United States

                Publication History

                • Published: 1 April 1988

                Permissions

                Request permissions about this article.

                Request Permissions

                Check for updates

                Qualifiers

                • article

              PDF Format

              View or Download as a PDF file.

              PDF

              eReader

              View online with eReader.

              eReader