Novel Architecture with Dimensional Approach of Data Warehouse
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, the authors 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, they present a set of user modeling requirements and they discuss the involved concepts.