Research and Application of Multi-Dimensional Model in 110 Incidents Data Warehouse

Abstract:

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.

• Periodical: Applied Mechanics and Materials (Volumes 490-491)
• Pages: 1386-1390
• DOI: https://doi.org/10.4028/www.scientific.net/AMM.490-491.1386
• Online since: January 2014
• Authors: Ze Jin, Li Jie Gao, Tong Ge Xu, Peng Wei
• Keywords: 110 Incident, Data Granularity, Data Warehouse, Multi-Dimensional Model, Slowly Changing Dimensions, Star Schema

References

[1] Chinese e-government network. Golden Shield Project Description [EB/OL]. Http: /www. e-gov. org. cn/news/news007/2011-03-27/117164. html. 2011-3-27.

[2] WH Inmon. Building the Data Warehouse [M]. 4th ed. Indianapolis, IN: Wiley, (2005).

[3] Sun Xiaohong, Shi Aichen, Zeng Xiaochun. Research and application of dimensional model in police intelligence analysis system [J]. Computer Engineering and Applications, 2007, 43 (special issue): 156.

[4] Chen, Hsinchun, et al. COPLINK: managing law enforcement data and knowledge[J]. Communications of the ACM, 2003: 28-34.

[5] D.E. Brown, The regional crime analysis program (RECAP): A frame work for mining data to catch criminals, in Proceedings of the IEEE International Conference on Systems, Man, and Cybernetics, Vol. 3, pp.2848-2853, (1998).

DOI: 10.1109/icsmc.1998.725094

[6] Matteo Golfarelli, Stefano Rizzi. Data Warehouse Design: Modern Principles and Methodologies [M]. McGraw-Hill Osborne Media, (2009).

[7] Ralph Kimball, Margy Ross. The Data Warehouse Toolkit: The Complete Guide to Di-mensional Modeling [M]. 2nd ed. IN: Wiley, (2002).

DOI: 10.1145/945721.945741

[8] Jiawei Han, Micheline Kamber. Data Mining: Concepts and Techniques [M]. Morgan Kaufmann, (2011).

[9] Surajit Chaudhuri, Umeshwar Dayal. An Overview of Data Warehousing and OLAP Technology [J]. ACM SIGMOD Record, 1997, 26 (1): 65-74.

DOI: 10.1145/248603.248616

[10] Claudia Imhoff, Nicholas Galemmo, Jonathan G. Geiger. Mastering Data Warehouse De-sign: Relational and Dimensional Techniques [M]. Indianapolis, Indiana: Wiley, (2003).

[11] Christopher Adamson. Star Schema: the complete reference [M]. McGraw-Hill, (2010).

[12] Tom Hammergren. Data warehouse technology [M]. Beijing: China Water Power Press, (1998).

[13] Matteo Golfarelli, Dario Maio, Stefano Rizzi. The Dimensional Fact Model: A Conceptual Model For Data Warehouses [J]. International Journal of Cooperative Information Systems, (1998).

DOI: 10.1142/s0218843098000118

[14] ZHANG Yu-fang, XIONG Zhong-yang. Data warehouse data model design [J]. Journal of Computer Applications, 1999, 19 (9).

[15] Feng Ling, Bo Wenyang. Data warehouse dimensional modeling technology and its application [J]. Journal of Nanjing University (Natural Sciences), 2005, 41 (4).

[16] Ralph Kimball, Margy Ross, et al. The Data Warehouse Lifecycle Toolkit [M]. 2nd ed. IN: Wiley, (2008).