Simple query comparison between a relational database and an object-oriented database

Pierre Didelon; Bertrand Morin

doi:10.1117/12.456732

24 December 2002 Simple query comparison between a relational database and an object-oriented database

Pierre Didelon, Bertrand Morin

Proceedings Volume 4836, Survey and Other Telescope Technologies and Discoveries; (2002) https://doi.org/10.1117/12.456732
Event: Astronomical Telescopes and Instrumentation, 2002, Waikoloa, Hawai'i, United States

Abstract

We compare the efficiencies of a relational database, MySQL, and an object oriented database, Objectivity, for simple functionalities, like handling data produced by a reduction pipeline. For each test, we then challenge two designs as similar as possible, both capable to handle the same amount of useful data, and which both have the same functionalities implemented on top of the design. From this study, we then discuss which system is more suited or more efficient for these types of applications. In particular, the impact of the design on the global application efficiency is addressed, as well as the advantages and limitations of the two systems. The tests show that relational system are more efficient for simple queries. The absence of a global query syntax for object oriented database turns out to be a disadvantage when dynamic behavior is needed or required. Moreover, it implies an additional effort in API (Application Programming Interface) development, which reduces the strength of object oriented system when handling complex data structure and related queries.

Citation Download Citation

Pierre Didelon and Bertrand Morin "Simple query comparison between a relational database and an object-oriented database", Proc. SPIE 4836, Survey and Other Telescope Technologies and Discoveries, (24 December 2002); https://doi.org/10.1117/12.456732

ACCESS THE FULL ARTICLE

INSTITUTIONAL
Select your institution to access the SPIE Digital Library.

SELECT YOUR INSTITUTION

PERSONAL
Sign in with your SPIE account to access your personal subscriptions or to use specific features such as save to my library, sign up for alerts, save searches, etc.

PERSONAL SIGN IN

No SPIE Account? Create one

PURCHASE THIS CONTENT

SUBSCRIBE TO DIGITAL LIBRARY

50 downloads per 1-year subscription

Members: $195

Non-members: $335 ADD TO CART

25 downloads per 1 - year subscription

Members: $145

Non-members: $250 ADD TO CART

PURCHASE SINGLE ARTICLE

Includes PDF, HTML & Video, when available