Research On The Centralized Access Control Of Central Database

With the developing of network technology and extensive application of computer, enterprise information construction has enormously developed. Enterprises, simultaneously, have accumulated a lot of data which is memorized with different forms and depended on different Database Management Systems. Also, they have got many application software, there have both C/S structure and B/S structure, which are made use for these databases and developed by different companies with different languages. It is very difficult for these enterprises that to maintain the data in this situation that data have been memorized dispersedly. What is more important is that we cannot guarantee the security of data. Fortunately, we have a suitable solution after the appearance of data access middleware technology.In this issue, which is the context of practical application, combined the actual needs of Logging Company and according to the thought of data access middleware, I have designed a Central Database Centralized Management Control System. First of all, I have analyzed the problem of information management in Logging Company and the necessity of solving the problem on the aspect of information management in the company with the use of data access middleware technology, and established a central database used for memorizing all of application software data information. I apply software to access the central database through data accessing middleware. Finally, I present the theoretical knowledge of data access middleware and some related technologies. With a comprehensive application of Java, XML technology, according to the data access middleware thought, I have designed a Central Database Centralized Access Management System specialized used for Logging company. I have depicted the detailed program and the realizing of the procedure.The system include two parts:uniform data access service and uniform data control service. The uniform data access service accept data service request, which the form is XML, of client application software. First, read the request information according to the XML uniform designed in advance. Then, connect and operate the database according to the request information. And change the backing results to XML file. At last, send the file to client application software. The major function of uniform data control service is to control competence. Before uniform data access service connecting database, we should connect data service control first and inquire whether current client software has the competence to run the data operation of the request. In this system, XML is used for common data model, at the same time, I adopt Java programming language and technologies like TCP/IP Socket, DOM4J, JDBC, database connection pool, thread pool and so on. The system shield the operation of database and provide a client software with a uniform data access interface, so that the new application software could access the data in central database through uniform data access interface and the current client software could access the data in central database through some simple modifying. So we can put the data information dispersed in each application database together in a huge relational database, that a company can centralized manage the data information, realize the data sharing. Meanwhile, we can make sure the security of all company's data information by the design of uniform access control service.