Oracle dba guide to data warehousing and star schemas pdf
Decision support systems have a long tradition in the world of business. Since the s companies have been using analysis methods with the aim of gaining dispositive data. The aim is to support management with the strategic direction of business processes using data-based reports, models, and prognoses. They can be difficult to distinguish from one another and have, in the areas of business practice as well as well as marketing, been categorised since the nineties under the collective term business intelligence BI. BI should generate knowledge that serves as a decision maker for the strategic direction and orientation of a company. The database of the decision support systems in the context of BI is nowadays usually provided by a central so-called data warehouse. We guide you through the basics of data warehousing, trace the reference architecture of such an information system, and suggest established providers of commercial DWH solutions as well as free open source alternatives.
Structure of a DWH: data warehouse architecture
This chapter explains how to create a logical design for a data warehousing environment and includes the following topics:. - In computing , the star schema is the simplest style of data mart schema and is the approach most widely used to develop data warehouses and dimensional data marts.
A Datawarehouse is the repository of a data and it is used for Management decision support system. Datawarehouse consists of wide variety of data that has high level of business conditions at a single point in time. In single sentence, it is repository of integrated information which can be available for queries and analysis. Even, it helps to see the data on the information itself. Dimension table is a table which contain attributes of measurements stored in fact tables.