基于JSON的异构数据库整合模型

JSON Based Heterogeneous Database Integration Model

目前很多软件应用的核心都是基于数据库,早期的应用模式都是一个应用对应一个数据库,随着应用之间的联系增多,经常出现多个应用之间需要互相访问彼此的数据库,而且这些数据库可能是异构的,也就是需要跨数据库进行异构数据库访问。但是跨数据库应用存在开发工作量大、后期维护困难、数据库有安全隐患等问题。通过使用以JSON作为数据交互格式的特殊应用作为各应用的中间件应用,让需要跨数据库的应用不再直接访问异构的数据库,而是访问该中间件应用。通过使用这种模型,既屏蔽异构数据库差异,又降低了开发和后期维护工作量,还提高了应用和数据库的安全性,实践证明该模型简单有效。

Nowadays the core of many software can’t live without the database,the model of early softwares were one software corresponds to one database,with the increase of relation between softwares,it’s common that multiple softwares needs to visit each other’s database,and these databases may be heterogeneous,so the visit of heterogeneous database are needed.However,there are many problems while one software visits another heterogeneous database,such as large development workload,difficulty in later maintenance,and security problems with database.By using a special software which uses JSON as the data interaction format as the middleware of each software,software that need visit the other’s database no longer directly access the database,but access the middleware.By using this model,it can not only shield the difference between the heterogeneous databases,but also reduce the development workload,make the later software maintenance easier,and upgrade the security of softwares and databases.It’s proved that this model is simple and effective.