Dimensional Modeling Method Discussion for the Profits from Mineral Rights Transfer Management

Journal: Modern Economics & Management Forum DOI: 10.32629/memf.v3i2.771

Jun Tang

Kunming Geofly Technology Co., LTD., Kunming 650041, Yunnan, China

Abstract

In the informatization process of the profits from mineral rights transfer management, it is of great practical significance to establish a data warehouse with easy to understand, efficient query performance and strong scalability, so as to provide good decision support services for managers. As an important method of data warehouse modeling, dimensional modeling method has significant advantages over others in data understandability, scalability and data access performance compared with other data warehouse modeling methods. Combined with the business needs of mineral rights transfer income (mineral rights price) assessment and collection decision analysis, the key design ideas of dimensional modeling are expounded from the perspectives of dimension content change processing design, dimension role-playing, shared dimension design and audit dimension design. Taking the actual engineering project as an example, dimension modeling results can be queried easily in order to help domestic peers in the construction of DW/BI projects.

Keywords

the profits from mineral rights transfer, data warehouse, dimensional modeling, dimension role-playing, shared dimension

Full Text

PDF - Viewed/Downloaded: 3 Times

Indexation

Download Index Record

References

[1]Bianchengxiaochao. Basic characteristics of data warehous[EB/OL]. (2019-12-04)[2022-01-28]. https://blog.csdn.net/u012955829/article/details/103396155.
[2]1024 Xiaoshen. Easy to understand warehouse modeling: Paradigm modeling and dimensional modeling[EB/OL].(2021-12-13)[2022-01-28].https://blog.csdn.net/weixin_44786530/article/details/121910025.
[3]Beilamei. Data warehouse modeling method and modeling case[EB/OL]. (2021-12-13)[2022-01-28]. https://blog.csdn.net/ytp552200ytp/article/details/107629384.
[4]Ralph Kimball, Margy Ross. The Data Warehouse Toolkit: The Definitive Guide to Demensional Modeling, Thrid Edition[M]. Beijing: Tsinghua University Press, 2015.
[5]Liu Jun, Yang Hongquan. Research on data warehouse scheme for dispatching and maintenance analysis of EMU Depot[J]. Railway Transport and Economy, 2018, 40(3):6.
[6]Xiang Shiyao. Research on the construction, analysis and application of multi-dimensional attribute space data cube of moving objects[D]. China University of mining and Technology (Beijing).
[7]Wu Qunyong, Liu Mengxin, Li Xijie, et al. Spatial OLAP system integration for environmental data set[J]. Journal of Earth Information Science. 2013, 15(01):90-96.
[8]Chen Jun, Zhuang Yifei, Cun Meili, et al. Multidimensional analysis model and method of urban public transport travel based on APTS big data[J]. Transportation system engineering and information, 2019, 19(1):7.
[9]Liu Yanjun, Feng Yu, Wu Qianhui, et al. Construction technology of distributed real-time data warehouse for state analysis of large equipment[J]. Computer integrated manufacturing system, 2017, 23(10):10.
[10]He Chengang. Research on late data in data warehouse[J]. Computer applications and software, 2013, 30(12):4.
[11]Gao Liang. Research on the construction of data warehouse in Colleges and Universities[J]. Journal of Wuhan University: Science Edition, 2012(S1):6.

Citing this article:

This work is licensed under a Creative Commons Attribution-NonCommercial 4.0 International License