Multidimensional database query method and apparatus

A technology of multi-dimensional query and query method, which is applied in the field of multi-dimensional database query method and device, which can solve the problems of overlong maintainability and insufficient SQL statements, and achieve the effects of reducing maintenance difficulty, shortening the length, and improving execution efficiency

Active Publication Date: 2016-05-04
珠海多玩信息技术有限公司
View PDF7 Cites 28 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] Based on this, in order to solve the technical problem of insufficient maintainability caused by the long SQL statement written in the above-mentioned traditional technology for multi-dimensional query database, a multi-dimensional database query method is proposed.

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
  • Multidimensional database query method and apparatus
  • Multidimensional database query method and apparatus
  • Multidimensional database query method and apparatus

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0042] The following will clearly and completely describe the technical solutions in the embodiments of the present invention with reference to the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only some, not all, embodiments of the present invention. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without creative efforts fall within the protection scope of the present invention.

[0043] As mentioned above, in the multidimensional database query in the traditional technology, the input query parameters can be shown in Table 1, and Table 1 shows a query parameter matrix formed by the input query parameters in the multidimensional data query in an application scenario.

[0044] Table 1

[0045] date

province

product

indicators

2015-09

CA

drink

income

2015-09

CA

food

Sales

201...

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 invention discloses a multidimensional database query method which comprises the steps of: receiving input multidimensional query parameters; generating a tree object, traversing a keyword set, arranging keywords in the traversed keyword set according to a preset field sequence, generating paths from root nodes of the tree object to leaf nodes of the tree object, and adding the path into the tree object; merging tree nodes in the tree object, which recursively comprise the same child nodes and correspond to the same parent node; and traversing the paths from each root node to the leaf nodes in the merged tree object, acquiring keyword sets in the tree nodes on the traversed paths, generating query condition expressions corresponding to the traversed paths according to an in operator, and by an or operator, connecting the query condition expressions corresponding to all the paths to generate an SQL (Structured Query Language) statement. The multidimensional database query method disclosed by the invention can generate the short SQL statement, and is beneficial to maintenance.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a multi-dimensional database query method and device. Background technique [0002] With the demand for data persistence brought about by the development of computer technology, the application of database technology is becoming more and more extensive. In common database operations, database operators need to write SQL (Structured Query Language, Structured Query Language) statements to add, delete, modify, and query data items in the database. [0003] However, in existing database query operations, there is usually a need for multidimensional query databases, that is, there are multiple sets of query conditions that need to be queried, and the union of the query results corresponding to each set of query conditions is returned, and the corresponding data in each set of query conditions The keywords under some fields of the table may be the same. In the traditional technolo...

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/2453G06F16/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

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