Cited By
View all- Ehlmann BMenezes R(2006)Incorporating Object Relationship Notation (ORN) into SQLProceedings of the 44th annual ACM Southeast Conference10.1145/1185448.1185535(389-394)Online publication date: 10-Mar-2006
A new UML-compatible object relationship notation (ORN)
Pages 179 - 183
Abstract
Object Relationship Notation (ORN) is a declarative scheme that permits the semantics of a variety of relationships to be conveniently modeled and then defined to a Database Management System (DBMS), which then allows the DBMS to automatically enforce these semantics. The Unified Modeling Language (UML), which has gained much popularity since its beginning in 1994, provides another notation for describing the semantics of relationships. We have revised ORN to be compatible with this notation. This paper presents the new UML-compatible ORN.
References
[1]
G. Booch, J. Rumbaugh and I. Jacobson. The Unified Modeling Language User Guide. Addison Wesley Longman, 1999.
[2]
S.G. Brown, "The ORN Simulator: A Practical Tool for Modeling Relationship Behavior," student paper (B.K. Ehlmann, advisor), Proceeding ADMI'97---Increasing Diversity in Research and Education: The Symposium on Computing at Minority Institutions, ADMI, Washington D.C., May 29 - June 1, 1997, pp. 130--135.
[3]
P.P. Chen, "The Entity-relationship Model: Towards a Unified View of Data," ACM Trans. on Database Systems, 1(1), 1976, pp. 1--36.
[4]
B. K. Ehlmann, G. A. Riccardi, and L. C. Dennis, "Representing non-inheritance relationships in an object-oriented, scientific database," Proc. of the Sixth Int. Working Conference on Scientific and Statistical Database Management ETH Zurith, June 1992, pp 99--109.
[5]
B. K. Ehlmann and G. A. Riccardi, "A Comparison of ORN to Other Declarative Schemes for Specifying Relationship Semantics," Info. and Software Technology, Elsevier Science, 38(7), July 1996, pp. 455--465.
[6]
B. K. Ehlmann and M. A. Stewart, "Incorporating Object Relationship Notation (ORN) into SQL," Proc. 35th ACM Southeast Conference, Murfreesboro, TN, April 2-4, 1997, pp. 282--289.
[7]
B. K. Ehlmann and G. A. Riccardi, "Object Relater Plus: A Practical Tool for Developing Enhanced Object Data-bases," 13th Int'l Conference on Data Engineering, Birmingham, England, April 7--11, 1997, pp. 412--421.
[8]
B. K. Ehlmann and G. A. Riccardi, "An Integrated and Enhanced Methodology for Modeling and Implementing Object Relationships," Journal of Object-Oriented Programming, SIGS Publications, 10(2), May, 1997, pp. 47--55.
[9]
B. K. Ehlmann and A. I. Bowers, "An Introduction to Designing Database Relationships with ORN," Proceedings of the Workshop on Next-Generation Database Design and Applications, High Performance Database Research Center (HPDRC), Florida International Univ., April 30-May 1, 1998.
[10]
B. K. Ehlmann and G. A. Riccardi, "The Formal Specification of ORN Semantics," Info. and Software Technology, Elsevier Science, February 2000.
[11]
S. K. Hardeman, "Relationship Behavior in Object Data-bases: Subtleties and Inconsistencies," student paper (B.K. Ehlmann, advisor), Proc. of the 34th ACM Southeast Conference, Tuskegee, AL, 1996, pp. 224--229.
[12]
W. Kim, "Object-Oriented Databases: Definition and Research Directions," IEEE Trans. on Knowledge and Data Eng., 2(3), Sept. 1990, pp. 327--341.
Recommendations
Incorporating Object Relationship Notation (ORN) into SQL: revisited
ACMSE '06: Proceedings of the 44th annual ACM Southeast ConferenceDiagrams widely used to model databases capture important semantics about the associations between objects. Additional association semantics can be captured when these diagrams are extended with Object Relationship Notation (ORN). Yet, the association ...
Incorporating object relationship notation (ORN) into SQL
ACMSE '97: Proceedings of the 35th annual ACM Southeast ConferenceEntity-Relationship (ER) Diagrams are widely used in information requirements analysis and database modeling and capture much knowledge of relationship semantics. Even more such knowledge is captured when ER Diagrams are extended with Object Relationship ...
Comments
Information & Contributors
Information
Published In
Copyright © 2000 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: 07 April 2000
Check for updates
Qualifiers
- Article
Conference
ACM-SE00
ACM-SE00: ACM-SE '00 - 38th Annual ACM Southeast Regional Conference 2000
April 7 - 8, 2000
South Carolina, Clemson
Acceptance Rates
ACMSE '00 Paper Acceptance Rate 46 of 46 submissions, 100%;
Overall Acceptance Rate 502 of 1,023 submissions, 49%
Contributors
Other Metrics
Bibliometrics & Citations
Bibliometrics
Article Metrics
- View Citations1Total Citations
- 234Total Downloads
- Downloads (Last 12 months)15
- Downloads (Last 6 weeks)3
Reflects downloads up to 25 Dec 2024
Other Metrics
Citations
Cited By
View all- Ehlmann BMenezes R(2006)Incorporating Object Relationship Notation (ORN) into SQLProceedings of the 44th annual ACM Southeast Conference10.1145/1185448.1185535(389-394)Online publication date: 10-Mar-2006
View Options
Login options
Check if you have access through your login credentials or your institution to get full access on this article.
Sign in