Using object database as a cache for relational database - performance and usage considerations

Ewa Płuciennik-Psota, Tomasz Płuciennik

Abstract


Every non trivial application cooperates with database, usually of relational type. In most cases this cooperation decreases the performance. The fastest, but not too handy, way to access a relational data from an object application is SQL. As alternative one can use object-relational mapping and/or object or NoSQL database. Object database paradigm is the same as object application uses. This makes it possible to avoid characteristic concept dualism (so called impedance mismatch) and resulting from this need to transform relations into objects and vice versa. This article presents an attempt to use ORM and object database to increase performance of accessing relational database.

Keywords


object application; relational database; object database; impedance mismatch; object relational mapping; caching; JPA; Hibernate; db4objects; data replication system

Full Text:

PDF

References


Garcia-Molina H., Ullman J. D., Widom J.: Database System Implementation. Prentice Hall, 2000.

Ullman J. D., Widom J.: First Course in Database Systems, 3rd Edition. Prentice Hall, 2007.

Lausen G., Vossen G.: Models and Languages of Object-Oriented Databases. Addison- Wesley, 1997.

Kim W.: Introduction to Object-Oriented Databases. The MIT Press, 2008.

Bauer C., King G.: Hibernate in Action. Manning Publications, 2005.

Linwood J., Minterd.: Beginning Hibernate, Second Edition. Apress, 2010.

Płuciennik-Psota E., Płuciennik T.: Object Database-Based Optimization of Relational Database Access. Proceedings of the VIth International Conference on Computer Science and Information Technologies, Lviv, Ukraine 2011.

Versant db4o Object Database, http://www.versant.com/products/db4o-object-database [online, 2013-01-05].

DataNucleus, http://www.datanucleus.org/ [online, 2013-01-05].

db4o Reference, http://community.versant.com/documentation/reference/db4o-8.1/ java/reference/ [online, 2013-01-05].

Longley P. A., Goodchild M. F., Maguire D. J., Rhind D. W.: Geographic Information Systems and Science. John Wiley & Sons Ltd, 2005.

db4o Issue Tracker, http://tracker.db4o.com/browse/COR-1409 [online, 2013-01-05].

db4o Issue Tracker, http://tracker.db4o.com/browse/DRS-106 [online, 2013-01-05].

DataNucleus AccessPlatform v.3.2 User Guide, http://www.datanucleus.org/products/ accessplatform_3_2/datanucleus-accessplatform-docs.pdf [online, 2013-01-12].




DOI: http://dx.doi.org/10.21936/si2013_v34.n2A.26