The Processing of business resources using data warehouse based on Hybrid Methodology

Quan Yuan

COMPUTER MODELLING & NEW TECHNOLOGIES 2014 18(12C) 1044-1048

Hubei University of Technology Engineering and Technology College, Hubei, 430068, China

In computing, a data warehouse (DW, DWH), or an enterprise data warehouse (EDW), is a system used for reporting and data analysis. In working environment resources are commonly shared between tasks, and sometime multiple resources are necessary to commence a single task, this scenario makes the resource utilization complex. Making it simple to understand this, we classify resources into human resources, because the two types of resources behave differently leaving different impact on process performance. Quality of data produces is evaluated though an empirical study, that is confirming the claim of highly relevant information generation. Data warehouse conceptual design is based on the metaphor of the cube, which can be derived from either requirement-driven or data-driven methodologies. Each methodology has its own advantages. The first allows designers to obtain a conceptual schema very close to the user needs but it may be not supported by the effective data availability. On the contrary, the second ensures a perfect trace ability and consistence with the data sources—in fact, it guarantees the presence of data to be used in analytical processing—but does not preserve from missing business user needs. To face this issue, the necessity emerged in the last years to define hybrid methodologies for conceptual design.