ITMD526-Week13-Blog

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 management systems are used to store and retrieve data. They manipulate the data from the databases to portray them for OLAP’s slicing and dicing methodologies. Every slicing or dicing action is like including a WHERE clause. ROLAP is the fastest growing style among all the OLAP technologies. The scalability property of OLAP in handling large amount of data is more when compared to other styles. Due to access of large amount of data, performance is slower than that of other OLAP styles.



MOLAP:

Multidimensional OLAP is often considered as the classic style of OLAP. Data is stored in cubes of multiple dimensions rather than in a relational database. The data is pre-summarized and stored as per client’s requirements. MOLAP is best used for analysis purposes. The data are organized using the slicing and dicing technique. The performance of MOLAP is faster than other styles since calculations are predefined during creation of cubes. Data can also be written into data set quicker than other models. Compression techniques make this type less heavy. Although, scalability is less when compared to ROLAP since it is light making it to handle only limited data.



HOLAP:

HOLAP of Hybrid OLAP is the output of combining both ROLAP and MOLAP. It makes use of both relational and multidimensional database system. Since it is combination of ROLAP and MOLAP, HOLAP is capable of storing very large amount of data in the relational database while also storing pre-summarized aggregations in cubes. HOLAP is highly scalable and data processing is also high.

Comments

Post a Comment

Popular posts from this blog

ITMD 526-Week 6-Blog

Image
TDWI’s Business Intelligence Maturity Model TDWI’s Business Intelligence Maturity Model was designed in the year 2004 by Wayne Eckerson. The technical aspects of the maturity model were the main focus of this model. The key areas of this model are: ·         Scope ·         Sponsorship ·         Funding ·         Value ·         Architecture ·         Data ·         Development and ·         Delivery. These aspects are graded by the following: ·         Infant ·         Child ·         Teenager ·         Adult ·    ...
Read more

ITMD 526-Week 7-Blog

Image
Gartner’s BI Maturity Model Gartner’s Maturity Model has five different levels of maturity: Unaware Tactical Focused Strategic Pervasive This model is most utilized for the assessment of input effort, Business Intelligence (BI) and Performance Management (PM) maturity. The key areas of this assessment are people, metrics & technology and processes. Let us discuss each level of the model briefly: Unaware: This maturity level is regularly portrayed in the writing as "data anarchy", whose markers are conflicting data, erroneous and conflicting data interpretation, and consistent changes attempting to satisfy individual or departmental data needs. Utilization of spreadsheets is high, while utilization of reporting tool is constrained. An organization does not have characterized measurements for execution administration. An organization is not committed to and does not comprehend the significance of the BI and PM. Data administration is left to the IT offi...
Read more

ITMD526-Week1-Blog

Image
INTRODUCTION TO DATA WAREHOUSING Data resources are colossally profitable to any venture, and on account of this, these benefits must be legitimately put away and promptly available when they are required. Be that as it may, the accessibility of an excess of information makes the extraction of the most vital data troublesome, if not unimaginable.  A   Data Warehouse  is a database intended to empower business insight exercises: it exists to help clients comprehend and upgrade their association's execution. It is intended for query and analysis as opposed to for transaction handling, and as a rule contains historical data got from transaction information, however can incorporate data from different sources. Data warehouses isolate investigation workload from exchange workload and empower an association to solidify data from a few sources. The term "Data Warehouse" was first coined by Bill Inmon in 1990. Per Inmon, a data warehouse is a subject oriented, integr...
Read more