Fixed Assets Investment Project Management System

Issue in the 2004 "Government Work Report", "the decision of the State Council on Reform of Investment System" policy, based on the "fixed assets investment projects approved provisional rules of procedure," "investment schedule," "construction market regulations," regulations system constraints, through a detailed user needs analysis, functional design and development.In this paper, the basic item database, mainly associated with the project data, supplemented by supporting documentation, the establishment of project data management system, build management system data management platform. Project data management system supports a variety of project data collection, loading, maintenance, office system of government property by project classification retrieval, statistical analysis and external release.This paper studies the management of fixed assets investment projects and the status of the background, through the system requirements analysis, system design, given the function of specific implementations. Background and current situation in parts of the country mainly on the fixed asset investment policies introduced in project management, the local system and the existing methods of operation, procedures were briefly introduced. Asset investment projects needs analysis and design part, the system business requirements Fenxi, data requirements analysis to do a basic overview, and detailed description of the system design architecture, database design, module design, business management processes, and systems reserved for interface design, full account of the protection of security of the system design. System described in detail fixed asset investment project management system to achieve the contents of each functional module, the business processes. Part in the system implementation, introduces the system design, development process applied to the relevant technologies and development tools.Fixed Assets Investment Management is a number of units and departments involved in the business, management object is the entire province, all the fixed assets investment projects. Management beyond the scope of the preliminary work from the project until the completion of the project began the whole process. Projects regularly in charge of investment at all stages of these projects to track information collection, and the results submitted to the municipal government. City the size of the project, the investment structure, funding sources and regulatory policies on investment, the implementation of the project to conduct supervision and inspection, and almost all kinds of budget funds and audit of all project tracking, monitoring, audit results Newspaper provincial, the provincial government on this basis are prepared by the city's long-term and annual types of fixed assets investment plan.In the management of information systems development, its core mission is to design and build the database, it is the system software design. Database quality is good or bad, will directly affect the function of the system and quality. The core database design is broken down into line with the data object database table specifications, and thus eliminate the original database, delete exception, insert the exceptions, update anomalies, minimized data redundancy and ensure consistency of data.Construction investment project database consists of two parts:a database within the network and external network databases, intranet database is the core network, including all data stored in the database; external network outside the network user database to store the new input data (the basis of these data a strategy of regular or real-time dump to the database within the network) and within the network database from the proposed release to the external network data.Current projects focus on the content, the provincial part of data center design, using data warehouse subject oriented approach to business logic design and physical design, uniform application of satellite-based data structure, said unified project data, future data sets to facilitate the expansion, modification and change, take the initiative to plan and guide the development of future data migration to the data warehouse; on commonly used indicators of regular dynamic data queries in order to design the index for statistical reporting; on the division of labor between the database and interface relations considerations for later software development the process of the interface between application software and data exchange.Fixed assets investment project management system implementation in the system makes full use of the data warehouse system provides excellent mechanisms, including:1) the establishment of enterprise data warehouse storage, and provides a unified view of enterprise information.2) logically independent of the analysis using data storage, data warehouse project management of investment and the existing business base isolation.3) The use of data warehouse model based on analysis of optimal design and storage design, statistical analysis and decision support to improve the performance and efficiency.The system consists of investments Input System, business processing subsystem, query statistics subsystem, decision analysis subsystem, system help, system management and maintenance of sub sections.Investment Input System main functions of project data validation, on the basis of data reported to verify investment projects. Direct extraction of investment projects, projects of basic information, investment information, building information and other data input, editing, repair, etc.. Project information updated review of the investment projects, approved after registration.Business processing subsystem, investment information register, the registration of investment projects, approved after registration. Business management agent for the conduct of business tips, save unfinished business for next to proceed further., On the record to classify the project record. Approval management, new or revised investment approval, and investment linkages. Search range, adjust the basic investment information, investment information, construction information, arrange investment, modify the main project, subproject relationship, modify the project to arrange a time series record system related projects.Query subsystem, including, by setting the search scope of queries investment projects, investment projects and project documents related documents, forms, etc.. Way through the different search queries, to support fuzzy queries, exact match queries in two ways, and can be combined query.Decision analysis subsystem includes data collection processing, management of investment projects on the summary of commonly used forms, including investment, construction scale, aggregate production capacity is calculated. Comparison of the data on the different between industries, regions, the project targets an investment such as a horizontal comparison, provides an intuitive graphical display. Meeting time series analysis of a class or a project investment and other indicators to conduct a longitudinal comparison of time series, providing an intuitive graphical display.Fixed assets investment project management system, many complex functions, the background database is based on the realization of these functions. The system database using Oracle 10g, Oracle is the world's leading database management system is a scalable, managed database systems, with a high degree of customization capability. Oracle has a very high stability in addition to a wealth of other supporting software, is adding a new version of the system deployment tools, greatly reducing the configuration work. SQL error since the diagnosis provides a mechanism to improve the database administrator to maintain the efficiency of the database.The system is built on the J2EE platform, B/S-type applications, using the standard front XHTML/DIV+CSS layout, have a good system compatibility and portability. Logic control layer based on the popular Java framework Struts1.1 achieved. System, the service layer by way of Spring Framework to configure the dynamic injection, by this way the system effectively reduces the coupling to the next level of change will not affect to the previous level of code to implement, effectively reducing the system maintenance burden.