Data index storage method, system and device capable of randomly expanding dimensions

A technology for expanding data and indicators, applied in database indexing, structured data retrieval, special data processing applications, etc., can solve problems such as increased computing resources and consumption, complexity, and low storage access efficiency

Pending Publication Date: 2021-05-07
NIO TECH ANHUI CO LTD
View PDF0 Cites 3 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

In this way, the operation of converting data indicators into storage forms in two-dimensional tables (calculation of dimensions and measures), writing data (storage), and reading data (retrieval, access) are relatively complex, data processing efficiency, storage access The efficiency is low, and the flexibility of arbitrarily scalable is s...

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
  • Data index storage method, system and device capable of randomly expanding dimensions
  • Data index storage method, system and device capable of randomly expanding dimensions
  • Data index storage method, system and device capable of randomly expanding dimensions

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0152] In order to facilitate the understanding of the invention, the present invention will be described more comprehensively and in detail below in conjunction with the accompanying drawings and embodiments, but those skilled in the art should understand that these embodiments are only used to explain the technical principles of the present invention, and are not intended to Limit the protection scope of the present invention.

[0153] In the description of the present invention, "module" and "processor" may include hardware, software or a combination of both. A module may include hardware circuits, various suitable sensors, communication ports, memory, and may also include software parts, such as program codes, or a combination of software and hardware. The processor may be a central processing unit, a microprocessor, an image processor, a digital signal processor or any other suitable processor. The processor has data and / or signal processing functions. The processor can...

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 provides a data index storage method, system and device capable of randomly expanding dimensions. The method comprises the steps of obtaining corresponding data indexes by processing service data according to different service requirements, and querying a data table to construct index IDs of the data indexes; calling a storage table of a data index based on the index ID, and expanding the dimension of the data index by adding a data row in the storage table of the data index so as to store the data index according to a corresponding field. According to the scheme, dimension expansion is carried out at will by increasing data rows, the dimensions can be freely combined, and each row of data can be interpreted through different identified index IDs; for the indexes of the same measurement under different dimensions, the data indexes can be conveniently stored, simply expanded and easily called, and the uniformity of the indexes is ensured.

Description

technical field [0001] The present invention relates to the technical field of data index storage, in particular to a data index storage method, system and device that can expand dimensions arbitrarily. Background technique [0002] In the current big data background, various business scenarios will refine a large amount of business data into business data indicators; indicators are composed of metrics and dimensions, and metrics are "aggregated statistical values, which are the results of aggregation operations, usually continuous values, Such as: order quantity, etc., and the dimension is "the angle of observing data, usually a set of discrete values, such as: city, date, etc." Under the premise of the same measurement, the combination of dimensions can be endless. In the existing In terms of data index storage, the usual data index storage uses a two-dimensional table, adding index fields to columns and placing index values ​​at corresponding positions; this storage metho...

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): G06F16/22
CPCG06F16/2264G06F16/2282
Inventor 张雯洁赵梦娜吴毅成
Owner NIO TECH ANHUI CO LTD
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