Data storage method and device and data query method and device

A data query and data storage technology, applied in the field of data processing, can solve problems such as long query time, and achieve the effect of solving long query time and improving speed

Inactive Publication Date: 2017-04-05
BEIJING GRIDSUM TECH CO LTD
View PDF5 Cites 36 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] The embodiment of the present application provides a data storage method and device as well as a data query method and device, so as to at least solve the technical problem of long query time in the process of querying the combination of dimensions of multiple dimensions

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 storage method and device and data query method and device
  • Data storage method and device and data query method and device
  • Data storage method and device and data query method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0022] In order to enable those skilled in the art to better understand the solution of the present application, the technical solution in the embodiment of the application will be clearly and completely described below in conjunction with the accompanying drawings in the embodiment of the application. Obviously, the described embodiment is only It is an embodiment of a part of the application, but not all of the embodiments. Based on the embodiments in this application, all other embodiments obtained by persons of ordinary skill in the art without creative efforts shall fall within the scope of protection of this application.

[0023] It should be noted that the terms "first" and "second" in the description and claims of the present application and the above drawings are used to distinguish similar objects, but not necessarily used to describe a specific sequence or sequence. It is to be understood that the data so used are interchangeable under appropriate circumstances such...

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 data storage method and device and a data query method and device. The method comprises the following steps of: combining the dimensions of index data to obtain a plurality of dimension combinations, wherein the index data corresponds to a plurality of dimensions; independently calculating the index data corresponding to each dimension combination of the plurality of dimension combinations; and storing the index data corresponding to each dimension combination of the plurality of dimension combinations to enable to inquire the index data corresponding to the dimension combination to be queried from stored data when data query is carried out by the dimension combination. By use of the method, the technical problem of long query time in a dimension combination query process of a plurality of dimensions is solved.

Description

technical field [0001] The present application relates to the field of data processing, in particular, to a data storage method and device, and a data query method and device. Background technique [0002] At present, queries based on dimensions and indicators usually first construct a fact table (Fact Table). Among them, the main feature of Fact Table is that it contains numerical data (facts), and these numerical information can be summarized to provide relevant units as historical data. Then establish the relationship between the dimension table (Dimension Table) and the Fact Table, and finally construct a dynamic query statement for query. This is a traditional online analytical processing (OLAP) analysis method, which has good query performance in single-dimensional analysis, and can also export reports according to multiple dimensions. [0003] However, the Fact Table is stored based on the largest set of dimension combinations. The query speed for a single dimension ...

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 Applications(China)
IPC IPC(8): G06F17/30
CPCG06F16/278G06F16/283
Inventor 池雷
Owner BEIJING GRIDSUM TECH 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

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