Subject Hierarchy Structure Modeling in Data Warehouse

Abstract

Data warehouse is subject-oriented organized. However, when data warehousing, the hierarchy structure of subject is currently only decided by decision makers' intuition. Faced with complicated business data mining cases, it is hard to establish hierarchy structure of subject just according to intuition. Thus a method based on ISM is present to make subject level structure establishment more measurable and illustrative. In this article, the "Subject" level structure establishment process is presented firstly. Then the method is put forward. Finally, the rationality and validity of this method are verified by a case on university financial data warehouse's subject level establishment.

Etl Data Warehouse on Performance Measurement

“…Transforming is the process of cleaning and changing the data structure from its original to a form that suits the needs of the data warehouse. Load Extracting is the last process that functions to enter data into the Data Warehouse [1] The use of the warehouse data in companies aims to assist the process of storing and presenting data so that the companies can record all structured transactions. The application of the data warehouse is a place for data synchronization in which data structure equalization occurs so that the transaction data can be received in the data warehouse.…”

“…The balanced scorecard is a strategic management system that translates the organization's vision and strategy into operational objectives and measures. These operational objectives and measures are then stated in four objectives, specifically financial 1 Corresponding Author. objectives, customers, internal business processes, and learning and growth.…”