一种基于中间件的异构数据库融合访问方法及系统

在大数据时代,信息化数据呈爆炸式增长,传统关系型数据库和新兴的NoSQL数据库都难以全面且高效地面对这些挑战。因此,提出一种基于中间件的异构数据库访问方法(MingleDB),以结合NoSQL和传统关系型数据库的优点。MingleDB透明融合了NoSQL数据库和传统数据库的主要运行逻辑,同时又能够根据当前用户请求的读写特征,自动选取合适的处理路径以避免二者的不足；它还支持轻量级的事务处理框架,该框架按需实施以保证异构数据库数据的最终一致性和完整性。将MingleDB分别与MongoDB,MySQL数据库进行读写性能对比,实验证明了MingleDB方法的正确性和合理性。同时将MingleDB部署在实际的社交网络系统中进行实际验证,结果亦证明了其实用性和可移植性。

Design and Implemention of Accessing Hybrid Database Systems Based on Middleware

In the big data era,with the explosive growth of informational data,traditional relational databases(SQL) and emerging NoSQL databases are difficult to face these challenges in a comprehensive and efficient manner.Therefore,this paper proposed MingleDB,a high-efficient middleware for incorporating both merits of traditional database and NoSQL systems.MingleDB is transparent for the underlying hybrid database systems,namely SQL and NoSQL,without any intrusive modifications on the original systems.MingleDB can detect the specific characteristic inside a user query,for example,the data is either unstructured or structured.Then it puts this user query into the suitable procedure(SQL or NoSQL) presented by MingleDB,and also provides a lightweight transaction processing framework which is implemented on demand to ensure the final consistency and completeness of hybrid database data.Extensive experiments were conducted to test the effective of MingleDB.Furthermore,this paper used a realistic scenario to verify the advantage of our work.The results are positive.