24 December 2002 Simple query comparison between a relational database and an object-oriented database
Author Affiliations +
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.
© (2002) COPYRIGHT Society of Photo-Optical Instrumentation Engineers (SPIE). Downloading of the abstract is permitted for personal use only.
Pierre Didelon, Pierre Didelon, Bertrand Morin, 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); doi: 10.1117/12.456732; https://doi.org/10.1117/12.456732


Requirement analysis for PACS database system
Proceedings of SPIE (July 31 1990)
J-PAS data management pipeline and archiving
Proceedings of SPIE (September 23 2012)
Astro-WISE information system
Proceedings of SPIE (September 23 2012)

Back to Top