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

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.