With the continuous development of computer technology and information technology, the application systems of the enterprise are gradually increasing, however, the overall management of the enterprise need to integrate data information in the databases of different application system. These information tend to be diversity, heterogeneous, and complexity which prevent further use of information and comprehensive benefits. Integrate heterogeneous information resources to make the original of all kinds of heterogeneous database together. To give user a unitive user interface which make user fell they are using one database without considering the differences between all kinds of data.According to the urgent needs and demand in the project, this paper design and implement heterogeneous database access engine to shield differences between different database management system, and the different version of the same database management system. At the same time, the engine provide fine grain access control method based on roles and users, support 4 level of database access control authorization mechanism based on component, seats, roles, users to strengthen the security features and related auditing function of database access. |