Method for rapidly collecting multi-layer fact data based on SQL statements

A fact and data technology, applied in the computer field, can solve problems such as large amount of calculation, occupying a lot of computer resources, complex function realization, etc., to achieve the effect of reducing the amount of calculation, reducing the workload and improving efficiency

Active Publication Date: 2014-09-03
武汉天量数据技术有限公司
View PDF3 Cites 11 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Although this method of layer-by-layer aggregation can solve the needs of multi-layer fact data aggregation, it has disadv

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
  • Method for rapidly collecting multi-layer fact data based on SQL statements
  • Method for rapidly collecting multi-layer fact data based on SQL statements
  • Method for rapidly collecting multi-layer fact data based on SQL statements

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0038] Below through specific examples, explain the specific implementation method of the patent of the present invention. The examples described here are used to explain the implementation steps of the invention patent.

[0039] 1. Explanation of terms

[0040] First, several technical terms used in the present invention are introduced, and the patent can be understood more clearly through the explanation of these terms.

[0041] Dimension: A parameter is used as a measure to describe and express variables. For example, the region dimension can be used to record the region attributes described by the measurement data.

[0042] Metric: A representation method used to describe a factual data, also known as an indicator. Metrics have specific units of measurement, and the measurement data can be further classified and described through dimensions.

[0043] Dimension table: In a relational database, a data table used to store dimension data. The data structure of a gen...

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 relates to a method for rapidly collecting multi-layer fact data based on SQL statements. The method includes the steps that fields for describing dimension levels are added to a dimension table, fields for recording upper layer dimension data are added to the dimension table, according to the collection requirement, the data collection SQL statements are compiled through data in a fact table according to the fields for describing the levels and the fields for recording the upper layer dimension data, and data collection is achieved. By the adoption of the method, cross-level data collection can be rapidly achieved, lower layer fact data can be collected to a targeted level in one step, and the method is different from a traditional collection method for collecting multi-layer fact data layer by layer.

Description

technical field [0001] The invention relates to the field of computers, in particular to a method for quickly summarizing multi-layer fact data based on SQL statements. Background technique [0002] Fact data is the result of recording and describing facts in the real world. A fact table is a data table used to store fact data. In order to clearly record fact data, various dimension data with hierarchical structure are usually used to describe fact data, such as time dimension, region dimension, and classification dimension information in different industries. Because these dimensions associated with fact data have a hierarchical structure, and the dimensions between different levels have a relationship between upper and lower layers, the fact data formed can be called multi-layer fact data. For example, the basic information data of an enterprise includes dimension information such as region, industry type, and registration type. [0003] Fact data is only used to record...

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/2433
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

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap