We also look at situations where olap might not be a fit. Etl refers to a process in database usage and especially in data warehousing. Olap online analytical processing o major task of data warehouse system. Fact table consists of the measurements, metrics or facts of a business process. Olap systems are used by knowledge workers such as executives, managers and analysts. Olap and data warehouse typically, olap queries are executed over a separate copy of the working data over data warehouse data warehouse is periodically updated, e. Concepts and fundaments of data warehousing and olap. Pdf concepts and fundaments of data warehousing and olap. Olap operations pivoting, slice and dice, rollup and drilldown data warehouse lectures duration.
Operational dbms oltp online transaction processing o major task of traditional relational dbms o daytoday operations. A data cube, such as sales, allows data to be modeled and viewed in multiple dimensions. Arifin, sistem informasi udinus 30 datamining dan teknologi databases dari gambar di atas terlihat bahwa teknologi data warehouse digunakan untuk melakukan olap online. Oltp systems are used by clerks, dbas, or database professionals. A data warehouse is based on a multidimensional data model which views data in the form of a data cube. This video explores some of olap s history, and where this solution might be applicable. Organizations need large pile of data at their disposal before they take any decision which would improve the revenue over a period of time for example.