Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Olap data analysis migration method and system

A data analysis and data relationship technology, applied in database models, multidimensional databases, structured data retrieval, etc., can solve problems such as errors, labor costs, and difficulty in guaranteeing OLAP analysis performance, and achieve analysis performance assurance and efficiency improvement.

Active Publication Date: 2021-07-02
KUYUN SHANGHAI INFORMATION TECH CO LTD
View PDF3 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

A large number of repetitive manual creation of models and reports is very labor-intensive, and manual operations will inevitably make mistakes, and repeated revisions will also bring unpredictable time costs
And even if the data analysis application migration is completed, due to the increasing data volume, the performance of OLAP analysis is difficult to guarantee

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
  • Olap data analysis migration method and system
  • Olap data analysis migration method and system
  • Olap data analysis migration method and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0035] The following will clearly and completely describe the technical solutions in the embodiments of the present invention with reference to the drawings in the embodiments of the present invention.

[0036] The OLAP data analysis migration method provided by the embodiment of the present invention can be applied to an application scenario of migrating a business intelligence (BI) report from a traditional database platform to a big data platform.

[0037] The following will be combined with figure 1 , the method for analyzing and migrating OLAP data provided by the embodiment of the present invention is introduced in detail.

[0038] See figure 1 , which provides a schematic flowchart of a method for analyzing and migrating OLAP data according to an embodiment of the present invention. Such as figure 1 As shown, the method in the embodiment of the present invention may include the following steps S101-S103.

[0039] S101. Extract original information in the original an...

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 embodiment of the present invention discloses a method and system for OLAP data analysis and migration, wherein the method includes the following steps: extracting the original information in the original analysis application model, the original information includes original data source information and report information, and combining the original data source information and report information Information is converted into an analysis application model based on a new data source, and the original analysis application model based on an original data source is converted into an OLAP model based on a new data source. By adopting the present invention, by converting the analysis application model and the OLAP model, the efficiency of data migration can be improved, and the performance of OLAP analysis after migration can be guaranteed.

Description

technical field [0001] The invention relates to the technical field of Internet information data processing, in particular to an OLAP data analysis migration method and system. Background technique [0002] In this era of rapid data growth, people usually migrate data storage engines to store or process larger-scale data. With the change of the data engine, the online data analysis (OLAP data analysis) application based on this data engine also needs to be recreated; and with the increase of data storage volume, there are certain challenges in the performance of OLAP analysis. How to efficiently migrate OLAP data analysis applications is a very valuable technical issue. [0003] At present, a common practice in the industry is to manually create a model based on a new data source and a data analysis application by referring to a previous data source model and a data analysis application (such as a report). A large number of repetitive manual creation of models and reports ...

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
Patent Type & Authority Patents(China)
IPC IPC(8): G06F16/21G06F16/28
CPCG06F16/212G06F16/214G06F16/283
Inventor 刘文政李栋李扬韩卿
Owner KUYUN SHANGHAI INFORMATION TECH CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products