Research Of OLAP Technology Based On Quantity And Charge Of Electricity Data Warehouse

Online analytical processing (OLAP) is a decision technology to support multi-dimensional analysis which is built on a basis of data warehouse, and foreign main database manufacturers have provided solutions and products about data warehouse and OLAP. In this paper, the theory of the data warehouse and OLAP has been studied in depth. We design and implement the quantity and charge of electricity data warehouse on a basis of data from the electrical enterprises and integrated the existing business data processing system. We learned the popular J2EE application framework technology and designed the system of the OLAP based on B/S structure for high-level decision-making using Oracle JDeveloper and Oracle BI Beans. We provide a convenient and efficient method for power enterprises to handle massive information and the establishment of an effective decision support system.