The concept of online analysis processing (OLAP) was earliered by the parent E.codd of the relational database. CoDD, in 1993, he also proposed 12 guidelines on OLAP. OLAP has caused a large response, OLAP is distinguished from the online transaction processing (OLTP). Today's data processing can be roughly divided into two major classes: online transaction processing OLTP (On-line Transaction Processing), online analysis processes OLAP (On-line Analytical Processing). OLTP is the main application of traditional relational databases, primarily basic, daily transaction, such as bank transactions. OLAP is the main application of data warehouse systems, support complex analysis operations, focusing on decision support, and provides intuitive and easy query results. The following table lists the comparisons between OLTP and OLAP.
OLTP
OLAP
user
Operator, low-level management personnel
Decision makers, senior management
Features
Daily operation processing
Analysis decision
DB design
Application
Topic
data
Current, latest details, two-dimensional discrete
Historic, gathering, multi-dimensional integration, unified
access
Read / write dozens of records
Read millions of records
employer
Simple business
Complex query
User number
Thousands of
Hundred
DB size
100MB-GB
100GB-TB
OLAP is a class of software technology that enables analysts, managers, or executives to quickly, consistently, interactively access information from a multi-angle to obtain a more deep understanding of data. The goal of OLAP is to meet decision support or meet specific queries and report needs in a multidimensional environment, and its technical core is the concept of "dimension". "Dimension" is the perspective of people to observe the objective world and is a high-level type division. "Dimension" generally includes hierarchical relationship, which is sometimes quite complicated. By defining a number of important attributes of an entity as multiple dimensions, users can compare different dimensions. Therefore, OLAP can also be said to be a collection of multi-dimensional data analysis tools. OLAP's basic multi-dimensional analysis operates with Roll Up and DRILL DOWN, slice (SLICE), Dice, and rotation (Pivot), Drill Across, Drill Through et al. · Drilling is the level of changing the dimension, the particle size of the transformation. It includes a roll UP and drill down (DRILL DOWN). Roll Up is summarized on a certain dimension to summarize the low-level summary data, or reduce dimensions; while Drill Down is reversed from the summary data to detail or increase new dimension. · Slices and cutting blocks After a partial dimension, care is concerned about the distribution of metric in the remaining dimension. If there is only two remaining dimensions, it is slice; if there are three, it is cut. · Rotation is the direction of transform dimension, that is, rearrange the dimension in the table (such as ranks interchange). OLAP has a variety of implementation methods that can be divided into ROLAP, MOLAP, and HOLAP depending on storage data. ROLAP represents an OLAP implementation based on a relational database. The relationship database is the core, and the representation and storage of multi-dimensional data is performed in a relational structure. ROLAP divides the multidimensional structure of the multi-dimensional database into two types: a class is the fact table, used to store data and Qi Key key; the other is a dimension, that is, at least one table is used to store the level of the dimension, Description information such as a member class. The dimension tables and facts are associated with the primary keyword and the foreign keyword, forming "Star Mode". For hierarchical complex dimensions, in order to avoid redundant data, multiple tables can be used to describe that this star pattern is called "snowflake mode". MOLAP represents an OLAP implementation based on multi-dimensional data organizations (Multidimensional OLAP). The multi-dimensional data organization is the core, that is, MOLAP uses the multi-dimensional array stored data. The multi-dimensional data will form a "cube" structure in the storage, "Rotate" "Cube" in MOLAP, "cut", "Slices", "Slice" is the main technique for generating a multidimensional data report. HOLAP represents an OLAP implementation based on a hybrid data organization (Hybrid OLAP). If the low layer is a relational, the high layer is a multi-dimensional matrix type. This approach has better flexibility. There are other ways to implement OLAP, such as providing a dedicated SQL Server, providing special support for SQL queries for some storage modes (such as stars, snow-type). OLAP Tools are online data access and analysis of specific issues. It analyzes, queries and reports in a multi-dimensional manner. Dimension is a specific angle of people to observe the data. For example, a company is usually observing the sales of products from different perspectives of time, regional and products in consideration of product sales. The time, region and product here are dimension.