AN INTRODUCTION TO DATA WAREHOUSING AND OLAP: PROS & CONS

Abstract

OLTP (online transaction processing system), Data warehouse, and OLAP (on-line analytical processing) are fundamentally foremost require of the database set in big business, company fields with a lot of areas. At the present time various services, products as well as the latest techniques are accessible and submission a lot of thoughts inside the DBMS. This paper is research on the subject of the Introduction to data warehousing and OLAP through the essential requirements as well as major parts of the big business database organization. The major at this time reflect on with the purpose of Data warehouse practice, procedure, Data warehouse among Metadata, on-line analytical processing (OLAP) in addition to OLTP against OLAP through recompense also disadvantage and comparison of OLAP and data warehousing system.