Finance Based On Oracle Database Management System Design

With the social and economic development, internal organizational structurepresents a multi-level changes. The traditional accounting theory is facing enormouspressure, and the traditional curing process is difficult to meet the current accountingcash flow flexibility, and the traditional accounting model is difficult to now meet awide range of management, and the traditional accounting software can not meet themodern enterprise to changing business processes and so on. Admittedly, a goodfinancial management, enterprise management software is an important andindispensable part of the will, and is for business managers to better plan and managethe funds of the enterprise information technology tools.This article is based on the financial management software, database design andoptimization of the starting. Respectively, it relays on the overall system planning,requirements analysis, module analysis, system design, database design andoptimization, etc. This article analysis the process of financial management softwaredatabase design and optimization, for example, the database table design, databaseoptimization, stored procedures and design, data migration, database backup and logs,etc. As the focus of system design, the system aims to create an easy to use, powerful,the short response time, safe and accurate system.The main work of this article is the following. Firstly,in the realization of thetechnical, financial management system uses a three-tier development model, toachieve the browser-the application server-database server, application and datalayer separation and improve efficiency. Secondly, the overall financial managementsystem description and design of the system framework, and describes the generalfinancial management system modules, including certificate management, end oftreatment, book management, financial analysis, management, and set of bookscommonly used settings.Third, According to the financial management systembusiness requirements for the design of the database table, and the actual situation, thedatabase table to determine some key details of the database table design, including achart of accounts consistent with the current details of books, summary of currentbooks, the subjects table, the account balance sheet, table and record sheets and otherdocuments. Based on the actual situation of the old system’s data, it via TXT file tothe new financial management system. The last, the system analysis query optimization, index optimization and view of optimization, stored procedures, databasedesign, optimization of the establishment of comprehensive programs for the databaseto improve the overall efficiency goals.