Design And Implementation Of Data Service Oriented Financial Budget Execution System

With more frequent demand for upgrading and expanding financial information systemfunctionalities, the real time constraint for expanding functionalities becomes more and moredemanding. During the process of expanding functionalities of existing systems, we alwaysencounter problems that expanding new functionalities is not in timely manner, dysfunctionalcomponents is not fixed timely, and the new and old functional semantics are inconsistent,which causes a phenomenon that software systems construction drags the change andupgrade of business. Therefore, improving the scalability and maintainability of financialinformation system is an urgent problem that needs to be resolved. Moreover, the selection ofapplication system architecture is the key problem that needs to be addressed for financialinformation system.After thorough analysis of budgeting business of financial department, this paperproposes a data service oriented architecture of financial budget execution system. It designsfunctional modules of financial budget execution system, uses stored-procedure technique ofPostgreSQL to implement the data service of financial budget execution system, and usesC++dynamic libraries to implement business services of the core modules of the system. Italso uses Delphi development to implement user interface. Based on the concepts andadvantages of Service Oriented Architecture, the proposed data service oriented systemarchitecture and the solution which is based on mature stored procedure technique not onlykeep the loosely-coupled and easy-to-expand system feature, but also it brings the advantagesof easy development and with great performance.The implemented financial budget execution system has been tested and in production.The system runs quite stable.