A Convenient Way From Normalized Database To Denormalized Database
Data warehouse is a denormalized and information oriented system used to convert business rules into useful information as it is the collection of archived operational data which is useful in tactical and strategic business decisions. A relational database consists of a collection of tables that store particular sets of data in a form of normalized database. The authors use ER Model in relational database to define their overall system on the other hand in data warehouse they use dimensional cubes. In this paper, they will discuss the techniques to transform the relational database into data warehouse.