Computing Reviews
Today's Issue Hot Topics Search Browse Recommended My Account Log In
Review Help
Search
Performance comparison of relational database with object database (DB4o)
Roopak K., Rao K., Ritesh S., Chickerur S.  CICN 2013 (Proceedings of the 5th International Conference on Computational Intelligence and Communication Networks, Mathura, India, Sep 27-29, 2013)512-515.2013.Type:Proceedings
Date Reviewed: Jul 10 2014

The results of a performance comparison between relational MySQL and object-based database for objects (DB4o) database systems are presented in this paper. The comparison was restricted to insert, select, and delete operations. The data used was flight information characterized by 29 attributes. For insert operations, DB4o was found best. Otherwise, MySQL was found best.

Unfortunately, much criticism can be made of this research. Other than naming the two database systems used, the technology platforms are otherwise not described. There is no discussion of benchmark approaches. In particular, there is no discussion of an earlier, more comprehensive study, which made use of the PolePosition benchmark to compare DB4o with relational databases [1]. There is no discussion or use of indexes, which can dramatically impact performance times. The authors describe having used import mechanisms for the insertions, yet provide MySQL and DB4o code examples for the insertion of a single record only. It is unclear what kind of bulk loading operation was used when inserting thousands of records. The authors describe using strings for all 29 attributes, yet no real database would encode data like this.

The performance graphs do not explicitly indicate the units of time. The graphs and tables suggest only single trials were run, making it important to know how accurately time was measured. Unfortunately, information about how time was measured and the timing accuracy achieved is not provided.

Many researchers will regard this study as weakly conducted and poorly reported. This paper will be of interest only to those conducting performance comparisons of database systems.

Reviewer:  Andy Brooks Review #: CR142495 (1410-0880)
1) Paterson, J.; Edlich, S.; Hörning , H.; Hörning , R. The definitive guide to db4o. Apress, , 2006.
Bookmark and Share
  Reviewer Selected
Featured Reviewer
 
 
Object-Oriented Databases (H.2.4 ... )
 
Would you recommend this review?
yes
no
Other reviews under "Object-Oriented Databases": Date
Object databases in practice
Chaudhri A. (ed), Loomis M., Prentice-Hall, Inc., Upper Saddle River, NJ, 1998. Type: Book (9780138997250)
Aug 1 1998
Managing heterogeneous information systems through discovery and retrieval of generic concepts
Srinivasan U., Ngu A., Gedeon T. Journal of the American Society for Information Science 51(8): 707-723, 2000. Type: Article
Jun 1 2000
MOVIE: an incremental maintenance system for materialized object views
Ali M., Fernandes A., Paton N. Data & Knowledge Engineering 47(2): 131-166, 2003. Type: Article
Feb 3 2004
more...

E-Mail This Printer-Friendly
Send Your Comments
Contact Us
Reproduction in whole or in part without permission is prohibited.   Copyright 1999-2024 ThinkLoud®
Terms of Use
| Privacy Policy