Data table query method and device, terminal equipment and storage medium

A query method and data query technology, applied in the field of data processing, can solve problems such as long query response time and low query efficiency of data tables, and achieve the effect of improving efficiency

Inactive Publication Date: 2018-08-17
PING AN TECH (SHENZHEN) CO LTD
View PDF4 Cites 9 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] Embodiments of the present invention provide a data table query method, device, terminal equipment, and storage medium to solve the problem of low data table query efficiency and long query response time

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 table query method and device, terminal equipment and storage medium
  • Data table query method and device, terminal equipment and storage medium
  • Data table query method and device, terminal equipment and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0024] figure 1 A flow chart of the data table query method in this embodiment is shown. The data table query method is applied in a data management system to quickly query and analyze data stored in the data management system. Specifically, it can be applied in the financial group's institutional budget management system for quick query and statistical analysis of the data of the project budget statements of different institutions of the group, and can realize the purpose of fast and efficient query of the data of the institutional project budget statements.

[0025] Such as figure 1 As shown, the data table query method includes the following steps:

[0026] S10: Obtain a data query instruction, the data query instruction includes an intermediate table ID and a query index dimension.

[0027] Wherein, the data query instruction is an instruction for querying data. The data query instruction is specifically an instruction for querying data input by the user to the data ma...

Embodiment 2

[0073] Figure 5 A functional block diagram of a data table query device corresponding to the data table query method in Embodiment 1 is shown. Such as Figure 5As shown, the data table query device includes a data query instruction acquisition module 51 , a target intermediate table acquisition module 52 and an index dimension value acquisition module 53 . Among them, the implementation functions of the data query instruction acquisition module 51, the target intermediate table acquisition module 52, and the index dimension value acquisition module 53 correspond to the steps corresponding to the data table query method in Embodiment 1. To avoid redundant description, this embodiment is different. a detailed description.

[0074] The data query instruction acquisition module 51 is configured to acquire the data query instruction, and the data query instruction includes an intermediate table ID and a query index dimension.

[0075] The target intermediate table obtaining mod...

Embodiment 3

[0093] This embodiment provides a computer-readable storage medium, on which a computer program is stored. When the computer program is executed by a processor, the data table query method in Embodiment 1 is implemented. To avoid repetition, details are not repeated here. Alternatively, when the computer program is executed by the processor, the functions of each module / unit in the data table query device in Embodiment 2 are implemented, and to avoid repetition, details are not repeated here.

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 table query method and device, terminal equipment and a storage medium. The data table query method comprises the following steps of: obtaining a data query instruction,wherein the data query instruction comprises a middle table ID and a query index dimensionality; obtaining a target middle table corresponding to the middle table ID on the basis of the middle tableID, wherein the target middle table comprises at least two original index dimensionalities and index dimensionality numerical values corresponding to the original index dimensionalities; querying thetarget middle table on the basis of the query index dimensionality so as to obtain the index dimensionality numerical value of the original index dimensionality corresponding to the query index dimensionality, and taking the index dimensionality numerical value as a target dimensionality numerical value. The data table query method is capable of improving the response time while improving the datatable query efficiency.

Description

technical field [0001] The invention relates to the field of data processing, in particular to a data table query method, device, terminal equipment and storage medium. Background technique [0002] The system database is a warehouse for organizing, storing and managing data, and a huge amount of data is stored in the form of data tables in the system database. When querying different dimensions in the system database (such as time, region, and source), use database query statements to directly query all data in the system database. Due to the huge amount of data in the system database, data congestion is prone to occur during the query process , resulting in low efficiency of data table query, making the response time of data table query longer. Contents of the invention [0003] Embodiments of the present invention provide a data table query method, device, terminal equipment, and storage medium to solve the problem of low data table query efficiency and long query resp...

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/245G06F16/248G06F16/2282G06F16/902
Inventor 李伟媛谭志荣魏尧东
Owner PING AN TECH (SHENZHEN) 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