The Query Analysis System, The Revenue And Expenditure Based On Data Warehouse Technology

Data warehouse is produced with development of the technology of the computer. Because of the wide application of computer and network, the computer begins to expand in 2 directions: the scope and the depth.The computer be hoped to participate in data analysis and formulate the decision more and more, in order to develop into the system enviroment based on the data warehouse.Data warehouse is a theme-oriented,integraded, not easy losing but changing with time,it supports the administrative staff s decision. The data warehouse taking theme as direction was designed around basic entities of enterprises.for example the local financial departments data wareouse can consider financial receipts and expenditures situation such as the income situations of national tax, local tax and financial allocations etc. They connect each oter closely. This helps to realize the relation and the rule of te data,offer dynamic,multidimensional data statistics, set up relational data model, predict development trend. Data integrate need to be designed to realize named protcol, key words, relationship and code .Not easy losing means data in data warehouse do not be updated. Data be entered into data warehouse after complicated abstraction procession,and can not be updated after entering data warehouse.OLAP is the widest and the most perfect analysical method in the field of data warehouse. in the other word, is is a integrate of multidimensional data analysis tool.It is the important gurantee that the large capacity data can be utilized effictively in the data warehouse. The basic thought is that the administrators of enterprises should control the data flexibilty, observe the state and changes of enterprises.The thesis structure is divided into the following parts, the first,to introduce the research background of the subject,to analyse the research dynamic status of the data warehouse from theories and applications,through analysis of this course,atypical data warehouse system model is provided and analysized. the second,to explain the important research meanings of applying the data warehouse technology to the financial revenue and expenditure,and also to explain the concept and method of data warehouse.the third,to build the financial revenue and expenditure query and analysical system,and to give detailed description to corresponding technology and model, and the system is used to analyse the data of financial revenue and expenditure, the lase but not least,to summarize the whole thesis and the prospect of the research.