Data query method and device, equipment and medium

A data and data table technology, applied in the database field, can solve problems such as large amount of abnormal data, increased data query workload, and inability to meet individual business needs, and achieve the effect of improving data query efficiency

Pending Publication Date: 2021-06-18
GUANGDONG POWER GRID CO LTD +1
View PDF0 Cites 4 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

At present, the inquiry about the abnormal data of marketing archives mainly relies on the online inspection module of the marketing system developed by each provincial company. The inspection rules involved in it may not meet the individual business needs of some regions, and may be Changes lead to the failure to update the audit rules in the provincial marketing system in time, resulting in too many abnormal data queries, which increases the workload of data query and reduces the audit work efficiency of the power supply bureau

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

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0025] figure 1 It is a flowchart of a data query method provided by Embodiment 1 of the present invention. This embodiment of the present invention is applicable to the situation where the table lookup field is automatically determined according to the query formula input by the user and the query rule is generated. This method can be provided by the embodiment of the present invention It is executed by a data query device, which can be implemented in the form of software and / or hardware, and generally can be integrated into computer equipment.

[0026] Such as figure 1 As shown, a data query method provided in this embodiment specifically includes:

[0027] S110. Obtain a target query input by the user, and determine at least one query object and associated query conditions in the target query.

[0028] The target query type refers to the query condition entered by the user.

[0029] Query object refers to the key fields in the target query formula.

[0030] The associat...

Embodiment 2

[0061] figure 2 It is a flowchart of a data query method provided by Embodiment 2 of the present invention. This embodiment is embodied on the basis of the above-mentioned embodiments, where it is possible to search in the data table association relationship knowledge base whether there is an associated data table that satisfies the associated query condition with each original query data table, specifically:

[0062] Obtain an original query data table in turn as the current processing data table;

[0063] In the data table association relationship knowledge base, obtain an alternative association data table that has a direct connection relationship with the currently processed data table, and / or has at least one level of cascading relationship;

[0064] In the data table association relationship knowledge base, obtain the standard query conditions between each candidate associated data table and the currently processed data table;

[0065] Computing the similarity between...

Embodiment 3

[0112] image 3 It is a schematic structural diagram of a data query device provided by Embodiment 3 of the present invention. This embodiment of the present invention is applicable to the situation where the table lookup fields are automatically determined according to the query formula input by the user and query rules are generated. The device can use software and / or It is implemented in the form of hardware, and generally can be integrated in computer equipment.

[0113] Such as image 3 As shown, the data query device specifically includes: a target query acquisition module 310 , an associated data table determination module 320 , a joint query field determination module 330 , and a target query rule generation and data query module 340 . in,

[0114] A target query acquisition module 310, configured to acquire a target query input by a user, and determine at least one query object in the target query, and associate query conditions;

[0115] The associated data table ...

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 data query method and device, equipment and a medium. The method comprises the steps of obtaining a target query formula input by a user, and determining at least one query object and an associated query condition in the target query formula, obtaining at least one original query data table matched with the query object, and searching whether an associated data table meeting the associated query condition with each original query data table exists in a data table association relationship knowledge base, according to the search result, generating at least one data table association structure pair, and querying in the data table structure knowledge base to obtain a joint query field corresponding to each data table association structure pair, and according to each joint query field, generating a target query rule corresponding to the target query formula, and querying to obtain query result data matched with the target query rule. According to the technical scheme, the personalized data query rule is formulated, and the data query efficiency is improved.

Description

technical field [0001] The embodiments of the present invention relate to the technical field of databases, and in particular, to a data query method, device, equipment, and medium. Background technique [0002] With the continuous development of power grid construction, more and more application systems are included in the power grid, and the data related to power distribution and consumption generated in the operation of various systems has also grown exponentially. [0003] The power supply service center is the supervisory organization of marketing business and service quality, responsible for checking the business handling of the marketing system and on-site service. At present, the inquiry about the abnormal data of marketing archives mainly relies on the online inspection module of the marketing system developed by each provincial company. The inspection rules involved in it may not meet the individual business needs of some regions, and may be As a result of the cha...

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): G06F16/9532G06F16/22G06F16/2453G06F16/2455G06F16/9535G06Q50/06
CPCG06Q50/06G06F16/2282G06F16/2453G06F16/24564G06F16/9532G06F16/9535
Inventor 张文冰邱翠玲何伟刚魏建荣
Owner GUANGDONG POWER GRID 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