Unlock instant, AI-driven research and patent intelligence for your innovation.

Data query method, device, equipment and storage medium

A data query and data technology, applied in the field of database processing, can solve the problem of time-consuming data recording, and achieve the effect of solving excessive time-consuming, avoiding database accidents, and reducing operational risks

Active Publication Date: 2021-07-02
GUANGZHOU HUYA INFORMATION TECH CO LTD
View PDF5 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] Embodiments of the present invention provide a data query method, device, device, and storage medium to reduce user operation risks, and at the same time solve the problem of excessive time-consuming tracking of data records based on field names and corresponding field values

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

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0030] figure 1 It is a flow chart of a data query method provided by Embodiment 1 of the present invention. This embodiment can be applied to database query only for one or two field names and corresponding field values, so as to obtain the data matching the field names and corresponding field values. In the case of data recording, the method can be executed by the data query device provided in any embodiment of the present invention, the device can be composed of hardware and / or software, and can generally be integrated into a processor of a computer device.

[0031] In the process of software development and / or operation, various problems will inevitably be encountered. Therefore, it is necessary to locate the data related to the problem, obtain relevant data records, and then troubleshoot the problem. However, there may only be One or two field names and their corresponding field values. At this time, you can only query related data records in the database according to the...

Embodiment 2

[0070] This embodiment is embodied on the basis of the above-mentioned embodiments, wherein, considering the fact that there are sub-databases and sub-tables in the data source, the at least one database stored in the server that matches the information of the data source, the Data query information for data query, specifically:

[0071] Acquire databases that match the data source information in turn, and perform data query on the data query information in at least one data table included in the acquired database; if the currently acquired database and a query database are data sub-databases, then according to The query database matches the field name, and determines the query strategy corresponding to the currently acquired database for data query; and / or, if the current query data table and a query data table are data sub-tables, then according to the query data table For the hit situation of the field name, determine the query strategy corresponding to the current query da...

Embodiment 3

[0098] Figure 3A It is a flowchart of a data query method provided by Embodiment 3 of the present invention. Based on the above-mentioned embodiments, this embodiment provides a specific implementation mode, and still takes the data source to be queried as a data source for explanation, such as Figure 3A As shown, the data query method provided in this embodiment includes the following steps:

[0099] S310. Obtain data query information and at least one piece of data source information, where the data query information includes a field name and a field value corresponding to the field name.

[0100] S320. Access and connect at least one database matching the data source information according to the data source information.

[0101] S330. Construct a source database mapping data structure according to the data source name. The form of the source database mapping data structure is , and the initial value of the database name list is empty.

[0102] The significance of const...

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, device, equipment and storage medium. The method includes: obtaining data query information and at least one piece of data source information, the data query information including: a field name, and a field value corresponding to the field name; at least In a database, data query is performed on the data query information, and at least one data record matching the data query information is obtained; and a feedback result of the data query information is generated according to the data records. When data query is performed through the above method, the user's operation risk to the database can be reduced, and the problem of too much time-consuming tracking of data records based on field names and corresponding field values ​​can be solved.

Description

technical field [0001] Embodiments of the present invention relate to database processing technologies, and in particular, to a data query method, device, equipment, and storage medium. Background technique [0002] A database is a warehouse that organizes and stores a large amount of data according to the data structure, where the data structure refers to the organizational form of the data or the connection between the data. Users can query, add, intercept, update, delete and other operations on the data in the database according to specific needs. [0003] When it is necessary to query some data in the database, but there are only one or two field names and corresponding field values ​​related to these data, the user can search for the corresponding data records according to the relevant query codes, and the time-consuming query is related to the data storage capacity of the database. In direct proportion, it can also be directly searched with the data stored in the memo...

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 Patents(China)
IPC IPC(8): G06F16/2458
Inventor 蔡土云
Owner GUANGZHOU HUYA INFORMATION TECH CO LTD