期刊名称：International Journal of Advanced Research In Computer Science and Software Engineering
印刷版ISSN：2277-6451
电子版ISSN：2277-128X
出版年度：2013
卷号：3
期号：3
出版社：S.S. Mishra
摘要：Data warehousing is a phenomenon that grew from the huge amount of electronic data stored in recent years and from the urgent need to use that data to accomplish goals that go beyond the routine tasks linked to daily processing. Modeling data warehouses is a complex task focusing, very often, into internal structures and implementation issues. In this paper we discuss that, in order to accurately reflect the user's requirements into an out of error, easy to understand, and easily extendable data warehouse schema, special attention should be paid at the dimensional modeling phase. Based on a real mortgage business warehouse environment, we present a set of user modeling requirements and we discuss the involved concepts. Understanding the semantics of these concepts, allow us to build a conceptual model- namely, the starER model- for their efficient handling. According to William H. Inmon data warehouse is a subject-oriented, integrated, time- variant, nonvolatile collection of data in support of management decisions. Data warehouses store current as well as historical data and are used for creating trending reports for senior management reporting such as annual and quarterly comparisons. Data Warehousing is a recent technology that allows information to be easily and efficiently accessed for decision-making activities by collecting data from many operational, legacy and possibly heterogeneous data sources.
