Share Email Print

Proceedings Paper

Simple query comparison between a relational database and an object-oriented database
Author(s): Pierre Didelon; Bertrand Morin
Format Member Price Non-Member Price
PDF $17.00 $21.00

Paper 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.

Paper Details

Date Published: 24 December 2002
PDF: 10 pages
Proc. SPIE 4836, Survey and Other Telescope Technologies and Discoveries, (24 December 2002); doi: 10.1117/12.456732
Show Author Affiliations
Pierre Didelon, CEA Saclay (France)
Bertrand Morin, CEA Saclay (France)

Published in SPIE Proceedings Vol. 4836:
Survey and Other Telescope Technologies and Discoveries
J. Anthony Tyson; Sidney Wolff, Editor(s)

© SPIE. Terms of Use
Back to Top
Sign in to read the full article
Create a free SPIE account to get access to
premium articles and original research
Forgot your username?