Visualized on-line analytical processing (OLAP) application realizing method and system

A technology for implementing methods and tools, applied in special data processing applications, structured data retrieval, instruments, etc., can solve problems such as online multi-dimensional analysis of TB-level data volume, and achieve the effect of optimizing performance and computing performance

Active Publication Date: 2014-07-30
科技谷(厦门)信息技术有限公司
View PDF6 Cites 65 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, it is still unable to solve the online

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Visualized on-line analytical processing (OLAP) application realizing method and system
  • Visualized on-line analytical processing (OLAP) application realizing method and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0025] In order to make the object, technical solution and advantages of the present invention clearer, the present invention will be further described in detail below in conjunction with the accompanying drawings and embodiments.

[0026] like figure 1 According to the invention, the invention discloses a visual OLAP application realization method.

[0027] The method comprises the steps of:

[0028] S1. Through ETL tools, mass relational data and data files are transferred and merged at high speed to form business data, and stored in a distributed, column-oriented Hadoop cluster;

[0029] In this step, the relational data and data files include media data, message data, log data, email data, relational data and the like. Extract, transform and load data sources through ETL technology in a big data environment. After the source data is ETL, the required business data is formed and stored in Hadoop's Hafs and Hbase.

[0030] S2. Define dimensions and measures from business...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

The invention discloses a visualized on-line analytical processing (OLAP) application realizing method and a visualized OLAP application realizing system. The visualized OLAP application realizing method and the visualized OLAP application realizing system store business data analyzed by OLAP in Hadoop cluster which supports the distributed and column-oriented mode, and the effective dock of an on-line analytical platform and a Hadoop storage platform is realized through a structured query language (SQL) query engine supported by Hive and Impala. The visualized OLAP application realizing method and the visualized OLAP application realizing system increase the storage volume, improve the storage expansibility and safety, and effectively operate the hundred billion or even thousand billion data level on-line multidimensional statistical analysis and machine learning.

Description

technical field [0001] The invention relates to a method and system for online analytical processing in a big data environment, in particular to a method and system that can directly model massive detailed data and analyze it in real time. Background technique [0002] OLAP is Online Analytical Processing. The Online Analytical Processing (OLAP) system is the most important application of the data warehouse system. It is specially designed to support complex analysis operations, focusing on decision support for decision makers and senior managers. According to the requirements of analysts Quickly and flexibly process complex queries with large amounts of data, and provide the query results to decision makers in an intuitive and easy-to-understand form, so that they can accurately grasp the operating conditions of enterprises (companies), understand the needs of objects, and formulate correct scheme. In recent years, OLAP has become a popular method for processing multidimen...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
IPC IPC(8): G06F17/30
CPCG06F16/283
Inventor 陈思恩林漳希郭星晖吴炎泉
Owner 科技谷(厦门)信息技术有限公司
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products