In Oracle : Oracle Business Intelligence: Data Warehouse & BI

Oracle Applications EBS 11i, R12      Oracle Database      Data Warehouse & BI      Oracle Middleware      PL/SQL      Linux ...

Oracle Data Warehouse & BI

In-Oracle.com 

-> Oracle Data Warehouse & BI

 

Oracle Business Intelligence: Data Warehouse & BI

 

        For the management always is important to get accurate informations about the business they manage. There is a need to anticipate the market, the costs, the sales, etc. In these cases the management need the help of the IT. Why ? Because the information the management works with is huge. There is always the need of data consolidation.

        All the IT tools used for the data consolidation, reporting or data analysis are grouped in "Business Intelligence". In this case the data warehouse is a part of the "Business Intelligence". However, in many cases, the data warehouse is seen as the database conceived especially for reporting and the business intelligence tools are in fact the tools used for reporting or data analysis.

        On my site I will group my article related to the Business Intelligence in 2 groups:

 

        -  Oracle Data Warehouse : articles related to the data consolidation, data preparation for reporting;

        -  Oracle Business Intelligence (BI) : articles related to the reporting and data analysis.

 

A data warehouse is a consolidated view of your enterprise data, optimized for reporting and analysis.

 

Basically it is an aggregated, sometimes summarized copy of transaction and non-transaction data specifically structured for dynamic queries and analytics. In data warehousing, data and information are extracted from heterogeneous production data sources as they are generated or in periodic stages, making it simpler and more efficient to run queries over data that originally came from different sources. Data is turned into high-quality information to meet all enterprise reporting requirements for all levels of users. Interactive content can be delivered to anyone in the extended enterprise – customers, partners, employees, managers, and executives – anytime, anywhere.

 

Conclusion:

A DW (Data Warehouse) is a database:

- optimized for generating quick reports;

- where the data is not modified in real time;

- where the tables are denormalized (the information can be dupplicated in the same schema);

- which has a staging area with row information and an access area with prepared information (ready for reporting);

- generally bigger than 1 Tb of information;

- accessed by different tools for generating different reports;

- is used for strategic decision.

In-Oracle.com 

-> Oracle Data Warehouse & BI

Oracle Applications EBS 11i, R12      Oracle Database      Data Warehouse & BI      Oracle Middleware      PL/SQL      Linux ...

 

     Copyright (c) 2011-2015  www.in-oracle.com  |  Disclaimer: The views expressed on this web site are my own and do not reflect the views of Oracle Corporation. You may use the information from this site only at your risk.