Oltp systems are used by clerks, dbas, or database professionals. Olap operations pivoting, slice and dice, rollup and drilldown data warehouse lectures duration. Olap online analytical processing o major task of data warehouse system. Fact table consists of the measurements, metrics or facts of a business process. We also look at situations where olap might not be a fit. Arifin, sistem informasi udinus 30 datamining dan teknologi databases dari gambar di atas terlihat bahwa teknologi data warehouse digunakan untuk melakukan olap online. A data cube, such as sales, allows data to be modeled and viewed in multiple dimensions. 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. A data warehouse is based on a multidimensional data model which views data in the form of a data cube. Pdf concepts and fundaments of data warehousing and olap. This video explores some of olap s history, and where this solution might be applicable.
1350 1390 302 1220 1067 43 295 1048 929 577 624 392 1355 1460 603 1111 1172 1206 1513 299 90 671 1337 1148 1212 507 503 1492 1014 35 1175 782 1097