Data Warehousing

Different Types of OLAP Systems Online Analytical Processing (OLAP)  is computer processing that empowers a client to effortlessly and specifically extricate and see information from various perspectives. The OLAP term originates from customary data warehousing from times when "big data" would fit into your present portable workstation and it was tedious to prepare even that little sum contrasted with today's principles. OLAP permits clients to dissect database data from numerous database frameworks at one time. OLAP data is stored in multidimensional databases. The different types of OLAP are: -          Relational OLAP (ROLAP). -          Multidimensional OLAP (MOLAP). -          Hybrid OLAP (HOLAP). ROLAP: ROLAP servers are located between the front-end client tools and relational back-end servers. Relational or extended database man...

Project Process Steps The key steps involved in building a data warehouse are: • Extracting the data from source systems and placing them in the staging area. • Transformation of data according to the requirements. • Creating a dimensional database • Loading the transformed data into it. • Creating assumptions and developing pre-calculated values to increase the process of report generation. • Developing a front-end tool for reporting. Let us now discuss in details each of the above mentioned steps. Extracting Data: A major contribution of  developing a data warehouse involves in extracting the data from source systems and placing them in the staging area. It can be the most complex part of the entire process depending on the sources available and the knowledge about the database. To overcome this issue, Microsoft has designed an extracting tool called the Data Transformation Services (DTS). The DTS is available as part of MS SQL Server and helps in importi...