Research and Application of Multi-Dimensional Model in 110 Incidents Data Warehouse
Ze Jin, Li Jie Gao, Tong Ge Xu, Peng Wei · Applied Mechanics and Materials · 2014
This paper studied the multi-dimensional model and designed a 110 incidents data warehouse application system based on above mentioned model and Oracle database for further 110 incidents data analysis and mining. It provides a more flexible and efficient statistical analysis environment for decision-makers with timely and reliable reports. Firstly, we studied multi-dimensional model used to construct the 110 incidents data warehouse, and then detailed the design of fact table and dimension tables in star schema. Finally, we implemented the 110 incidents data warehouse analysis system which included the processing of slowly changing dimensions, data extraction, transformation, loading process and performance analysis.