商用数据库的统一管理设计

Design of Unified Commercial Database Management

在计算机软件开发中,当多个相关产品都用到了商用数据库时,由于不同数据库驱动和不同数据库的配置,且不同数据库在操作语法上不尽相同,从数据库的选型到应用层接口可能都不统一。为解决这个问题,本文设计开发了统一商用数据库,根据不同的平台给出不同的实现,对外提供统一访问接口。通过实现对业务表的管理,不涉及具体业务,实现了跨系统使用,并且为避免大量的数据库连接时导致服务不堪负荷,影响访问效率,采用数据库连接池的方式实现数据库的连接库的连接访问,使用户可以专注于业务实现。

In computer software development, when the commercial database is used by multiple related products, due to the dif- ferent database driven, different configuration and different operating grammar of the databases, it may be different from the data- base selection to the application layer interface. To solve this problem, a unified commercial database is designed and developed. Different implementation is given for different platform when a uniform access interface is provided. By implementing the manage- ment of the business table, not involving the specific business, the use for across various systems is realized. And in order to a- void collapse to affect the access efficiency when a large number of databases are connected, the database connection pool is used to implement for connecting and accessing the database connection repository, and it makes the users can focus on business.