Object oriented relational database with SQL interface
Pages 497 - 504
Abstract
An object oriented relational database management system to support heterogeneous object classes of statistical (numeric and text), image, text and sound information is considered. By employing a user friendly interface and Structured Query Language (SQL) capability at the user level, this database with a three level architecture utilizes an extended SQL to operate on complex objects and to support database processing functions such as retrieve, join and overlay. These operations also support the conversion of statistical data into two or three dimensional images to assist in the decision making process. The C++ programming language is being utilized for implementation. By supporting heterogeneous object classes (files), this object oriented relational database design and implementation improves capabilities for multipurpose database systems to facilitate financial, medical and mathematical needs for diagnosis and comparative analysis by integrating and unifying information into one database system.
References
[1]
Abrial, J.,R., "Data Semantics," in Data Base Management, J.W. Klimbie and K.L. Koffeman, eds., North-Holland Publishing Co., New York 1974.
[2]
Blaha, M., R., et al., "Relational Database Design Using an Object-Griented Methodology", ACM Communications, Vol. 31, No. 4, April 1988.
[3]
Butterworth, P., Otis A. and Stein, J., "The Gemstone Object Database Management System", ACM. Communications, Vol. 34, No. 10, October 1991.
[4]
Cattell, R.G.G., Object Data Management, Addison Wesley, Reading, MA, 1991.
[5]
Chang, S., et. al., "A Relational System for Pictures", Proc. IEEE Workshop Picture Data Description Management, 1977.
[6]
Codd, E. F. "A Relational Model of Data for Large Shared Data Banks", CACM 13, No 6, June 1970.
[7]
Codd, E. F. The Relational Model for Database Management, Version 2, Addison Wesley, Reading, MA, 1990.
[8]
Dabrowski, C., Fong, E. and Yang, D., "Object Database Management Systems: Concepts and Features", NIST Special Publication 500-179, April 1990.
[9]
Date, C. J., An Introduction to Database Systems, Volume II, Addison Wesley, Reading, MA, 1985.
[10]
Date, C. J., Relational Database Selected Writings, Addison Wesley, Reading, MA, 1986.
[11]
Date, C. J., An Introduction to Database Systems, Fifth Edition, Addison Wesley, Reading, MA, 1990.
[12]
Deux, o. et al., "The 0, System", ACM Communications, Vol. 34, No. 10, October 1991.
[13]
Ellis, M. and Strousttup, b. The Annotated C++ Reference Manual, Addison-Wesley, Reading, MA, 1990.
[14]
Elmasri, R. and Navathe, S. B., Fundamentals of Database Systems, BenjaminZummings Publishing Company Inc., 1989.
[15]
Goldberg, A. and Robson. D., Smalltaut-SO: The Language and Its Implementation, Addison-Wesley, Reading, MA, 1983.
[16]
Hughes, John, Object-Oriented Databases, Prentice Hall, International, Hertfordshire HP2 4RG, 1991.
[17]
Joseph, Thomas and Cardenas, Altonso, "PICQUERY A High Level Query Language for Pictorial Database Management", IEEE Trans. on Software Engineering, Vol. 14, No. 5, May 1988.
[18]
Khoshatian, Setrag and Copeland, George, "Object Identity" GGPSLA '86 Proceedings, Sept. 1986.
[19]
Kung, Chenho, "Object Subclass Hierarchy in SQL: A Simple Approach", ACM Communications, Vol. 33, No. 7, July 1990.
[20]
Lamb, C., Landis, G., Grenstein, J. and Weinreb, D., "The Objectstore Database System", ACM Communications, Vol. 34, No. 10, October 1991.
[21]
Loomis, M.E.S., et al., "An Object Modeling Technique for Conceptual Design", Proceedings of the European Conference on Object-Oriented Programming. Paris, France, June 115-17, Lecture Notes in Computer Science, 276, Spring-Verlag, New York, 1987.
[22]
Morehouse, S., "ARC/INFO: A Geo-Relational Model for Spatial Information", Proc. 7th Int. Symp. Comp. Assisted Cartography, American Congress on Surveying and Mapping, 1985.
[23]
Orenstein, Jack and Manola, Frank, "PROBE Spatial Data Modeling and Query Processing in an Image Database Application", IEEE Trans. on Software Engineering, Vol. 14, No. 5, May 1988.
[24]
Premerlani. W., et al., "An Object-Oriented Relational Database", ACM Communications, Vol. 33, No. 11, November 1990.
[25]
Roussopoulos, Nick, et al., "An Efficient Pictorial Database System for PSQL", IEEE Trans. on Software Engineering, Vol. 14, No. 5, May 1988.
[26]
Shriver, B. and Wegner, P., Research Directions in Object-Oriented Programming, MIT press, Cambridge, Massachusetts, 1988.
[27]
Smith, J. M. and Smith, D., C.P., "Database Abstractions: Aggregation and Generalization", ACM Transactions on Database Systems, Vol. 2, No. 2, June 1977.
[28]
Stroustrup, b. The C++ Programming Language, 2nd Ed., Addison-Wesley, Reading, MA, 1991.
[29]
Stonebraker, M. and Kern&z, G., "The Postgres Next- Generation Database Management System", ACM Communications, Vol. 34, No. 10, October 1991.
[30]
Ullman, Jeffery D., Database and Knowledge- Base Systems, Vol I & II, Computer Science Press, Rockville, MD, 1988.
Index Terms
- Object oriented relational database with SQL interface
Recommendations
Translating object-oriented database transactions into relational transactions
In this paper, we present methods of translating transactions from object-oriented database (OODB) to relational database (RDB). The process involves schema mapping in data definition language and transaction translation in data manipulation language. ...
Model Transformation From Object Relational Database to NoSQL Document Database
NISS '19: Proceedings of the 2nd International Conference on Networking, Information Systems & SecurityWith the high increase of data growing, NoSQL databases play a key role in storing large amount of data, to gain flexibility and scalability many industries are now replacing their relational and object relational databases by adopting NoSQL database ...
Comments
Please enable JavaScript to view thecomments powered by Disqus.Information & Contributors
Information
Published In
Copyright © 1993 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]
Sponsors
Publisher
Association for Computing Machinery
New York, NY, United States
Publication History
Published: 01 March 1993
Check for updates
Qualifiers
- Article
Conference
CSC93
Sponsor:
Contributors
Other Metrics
Bibliometrics & Citations
Bibliometrics
Article Metrics
- 0Total Citations
- 1,087Total Downloads
- Downloads (Last 12 months)30
- Downloads (Last 6 weeks)2
Reflects downloads up to 11 Dec 2024
Other Metrics
Citations
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