Design And Implementation Of The Data Access Layer For Financial Application System

With the rapid development of informatization construction of the financial business, more and more application systems are in service of the different financial information managements. A variety of the financial business lead to the different application systems corresponding business data are relatively dependent and business data access interface are difficult to maintain.In order to solve these problems, the paper imlements controlling the users'data access through adding a data access layer in the application system. The data access layer consists of database middleware pgpool-II and pgbouncer, and communicates frontend-backend by database access interface libpq. The paper increase the safety management mechanisms of frontend connection based on the existing features of pgpool-II, including identification authentication, form authentication, permissions authentication and message returns processing. Meanwhile, as the budget execution system at the county level to the background of study, select one of the budget management module to develop a client application instance using the wxWidgets technology.Through design and implement the data access layer for the financial application, the research of project had satisfied the require controlling the user's data access.It provides a practical effect for the financial information management of Shaanxi Province.