Design And Implementation Of Object-relational Mapping Freamework For Hybrid Data Store

With the enterprise application becomes more and more complex, the requestchanges faster and faster, the data model becomes more and more diverse,developing applications with relational databases becomes so hard to handle suchchallenge. With the improving of cloud computing and non-relational databases,more and more applictions want to be developed based on non-realitional databases.But this will cause migrating of exist applications and maintainence challenges ofnew applications.How to transparently deal with the data persitence operations based onrelational databases and non-relational databases is the key problem. This studyfirstly analyses the data model and persistence characteristics of non-relationaldatabase Cassandra. Then, combining with existing mature ORM frameworks(Hibernate, iBatis, JPA, TopLink), desgin and implement an object-relationalmapping framework for hybrid storage.The main job of the study is to desgin and to implement an object-relationalmapping framework based on non-relational database, through the object-relationalmapping ideas and encapsulate the non-relational database persistence operations.Then, on this basis, combined with the already mature Hibernate framework, makingthe entire framework able to support the operation of the hybrid storage. Finally, inorder to improve the performance of applications based on the object-relationalmapping framework in the special environment that the SaaS applications use, usedistributed cache Memcached as an ORM framework global L2cache, dispersed oneach server’s idle memory resources to cache the query results of the applications, toimprove the performance of the SaaS application instances.This study also conductes a series of functions and performance testings on theobject-relational framework which is based on hybrid data store. Functional testingis based on equivalence classes testing methodology, the study desgins26caseswhich object-relational JPA standards may deal with, and the entire frameworkworks properly with all the cases. Performance test results indicate that the querybased on the ORM framework using a global cache can get better performance,when it comes to persistence operations for a large number of objects, it’s suitable touse the bulk operations of database directly.This study gives a viable way to achieve object-relational mapping frameworkbased on non-relational databases, and reduce the differences between relationaldatabases and non-relational databases when use them, and let the application’sbusiness logic can be achieved through a unified interface to application developers. This study also reduces the development and maintenance costs of the applicationswhich based on non-relational databases, and facilitate the existing relationaldatabase-based applications migrate to non-relational database-based applications.