CN110874364B - Query statement processing method, device, equipment and storage medium - Google Patents

Query statement processing method, device, equipment and storage medium Download PDF

Info

Publication number
CN110874364B
CN110874364B CN201911134800.1A CN201911134800A CN110874364B CN 110874364 B CN110874364 B CN 110874364B CN 201911134800 A CN201911134800 A CN 201911134800A CN 110874364 B CN110874364 B CN 110874364B
Authority
CN
China
Prior art keywords
query statement
query
updated
data table
efficiency
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Active
Application number
CN201911134800.1A
Other languages
Chinese (zh)
Other versions
CN110874364A (en
Inventor
张银山
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Beijing Qidi Block Chain Technology Development Co ltd
Original Assignee
Beijing Qidi Block Chain Technology Development Co ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Beijing Qidi Block Chain Technology Development Co ltd filed Critical Beijing Qidi Block Chain Technology Development Co ltd
Priority to CN201911134800.1A priority Critical patent/CN110874364B/en
Publication of CN110874364A publication Critical patent/CN110874364A/en
Application granted granted Critical
Publication of CN110874364B publication Critical patent/CN110874364B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24—Querying
    • G06F16/242—Query formulation
    • G06F16/2433—Query languages
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/22—Indexing; Data structures therefor; Storage structures
    • G06F16/2228—Indexing structures
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24—Querying
    • G06F16/245—Query processing
    • G06F16/2453—Query optimisation
    • Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
    • Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
    • Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management

Abstract

The embodiment of the invention discloses a query statement processing method, a query statement processing device, query statement processing equipment and a storage medium. Wherein, the method comprises the following steps: detecting state information of elements in the query statement; and if the element is determined to be updated according to the state information, adjusting the query statement according to the updated element. The embodiment of the invention determines the elements needing to be updated in the query statement by detecting the state information of the elements in the query statement, thereby adjusting and generating a new query statement. The problem of error caused by manual detection of the updating condition of the query statement is solved, the updating and optimizing efficiency of the query statement is improved, and manpower and time are saved.

Description

Query statement processing method, device, equipment and storage medium
Technical Field
The embodiment of the invention relates to the internet technology, in particular to a query statement processing method, a query statement processing device, query statement processing equipment and a storage medium.
Background
With the development of the information age, people are not satisfied with manual search when obtaining information, more and more information needs to be stored in a database through Structured Query Language (SQL) statements, and when the information needs to be modified, the SQL statements need to be modified correspondingly.
In the prior art, when modifying or optimizing an SQL statement, a developer is often required to check the SQL statement one by one, analyze whether the SQL statement is reasonable, and manually modify the SQL statement with an execution error.
However, the SQL statements are analyzed and optimized manually one by one, so that the optimization efficiency of the SQL statements is low, the code maintenance is difficult, code errors are easily caused, and manpower and time are wasted.
Disclosure of Invention
The embodiment of the invention provides a query statement processing method, a query statement processing device, query statement processing equipment and a storage medium, wherein whether a query statement is updated or not is determined by detecting state information of elements in the query statement, so that the updating and optimizing efficiency of the query statement is improved, and manpower and time are saved.
In a first aspect, an embodiment of the present invention provides a query statement processing method, where the method includes:
detecting state information of elements in the query statement;
and if the element is determined to be updated according to the state information, adjusting the query statement according to the updated element.
In a second aspect, an embodiment of the present invention further provides a query statement processing apparatus, where the apparatus includes:
the state information detection module is used for detecting the state information of the elements in the query statement;
and the query statement adjusting module is used for adjusting the query statement according to the updated element if the element is determined to be updated according to the state information.
In a third aspect, an embodiment of the present invention further provides a computer device, which includes a memory, a processor, and a computer program stored in the memory and executable on the processor, where the processor executes the computer program to implement the query statement processing method according to any embodiment of the present invention.
In a fourth aspect, embodiments of the present invention further provide a storage medium containing computer-executable instructions, which when executed by a computer processor, are used to perform the query statement processing method according to any of the embodiments of the present invention.
The embodiment of the invention determines the elements needing to be updated in the query statement by detecting the state information of the elements in the query statement, and further adjusts the query statement. The problem that query statements need to be checked and modified manually one by one in the prior art is solved, errors generated during code maintenance are reduced, manpower and time are saved, and the optimization and updating efficiency of the query statements is improved.
Drawings
Fig. 1 is a schematic flowchart of a query statement processing method according to a first embodiment of the present invention;
FIG. 2 is a flowchart illustrating a query statement processing method according to a second embodiment of the present invention;
fig. 3 is a block diagram of a query statement processing apparatus according to a third embodiment of the present invention;
fig. 4 is a schematic structural diagram of a computer device in the fourth embodiment of the present invention.
Detailed Description
The present invention will be described in further detail with reference to the accompanying drawings and examples. It is to be understood that the specific embodiments described herein are merely illustrative of the invention and are not to be construed as limiting the invention. It should be further noted that, for the convenience of description, only some of the structures related to the present invention are shown in the drawings, not all of the structures.
Example one
Fig. 1 is a flowchart illustrating a query statement processing method according to an embodiment of the present invention, where the method is applicable to a case of processing a query statement, and the method can be executed by a query statement processing apparatus. As shown in fig. 1, the method specifically includes the following steps:
step 110, detecting state information of elements in the query statement.
The state information of the elements in the query statement may be detected by the server, where the elements in the query statement may include data table information associated with the query statement and a function in the query statement, and the state information may include a change condition of the data table information and a query efficiency of the query statement when the function runs. The change information of the data table can be obtained through a probe technology, the probe technology can search the data change information and the structure change information of the data table, and if the data table is searched to be changed, the data table information is updated. The data table information may include field names, field data, headers, and table structures. For example, if the field name in the data table searched by the probe changes, the server detects the change information acquired by the probe, analyzes the data table information associated in the query statement, and searches for the corresponding state information of the data table in the query statement. The server can set the time period for the probe to search the data table information and acquire the data table information at regular time.
The server may detect a change condition of the data table associated in the query statement, and may also detect a query efficiency of the function in the query statement. The server analyzes the query statement to obtain the functions in the query statement, detects the query efficiency of each function, and counts the query efficiency values of each function to obtain the state information of each function in the query statement.
And step 120, if the element is determined to be updated according to the state information, adjusting the query statement according to the updated element.
If the server detects that the data table information associated with the query statement changes, the server updates the query statement where the data table information is located, and the accuracy of association of the query statement to the data table information is improved.
Optionally, if it is detected that the data table information associated with the query statement is updated, adjusting the query statement according to the updated data table information; wherein the data table information includes at least one of: field name, field data, and header.
Specifically, the server detects the search result of the probe, and if the data table information is updated, the server adjusts the query statement associated with the data table, where the data table information may include field names, field data, a header, a table structure, and other information. Before updating the query statement, the server may analyze the query statement to obtain the query statement associated with the change information of the data table, and modify the original information of the location of the change information of the data table in the query statement into the updated change information according to the change information of the data table, thereby completing updating the change information of the data table. For example, when the server detects that a field name in the data table is changed from a to B, the server parses the query statement to obtain a statement in the query statement associated with the field name, changes a in the statement to B, and generates a new query statement. By detecting the data table information and automatically updating the changed data table information, the problem of query statement errors caused by manual change is avoided, the situation that the changed information is omitted when the data table is manually queried is reduced, and the updating efficiency of the query statement is improved.
If the server detects that a function with low query efficiency exists in the query statement, the server selects from the replacement functions stored in the server to replace the function, so that the query statement is adjusted, and the query efficiency of the query statement is improved.
Optionally, if any function in the query statement is detected to be a low-efficiency function, the query statement is updated by adopting a replacement function of the function; wherein the low-efficiency function is determined by the query efficiency statistics of the query statement.
Specifically, the server may detect the query efficiency value of any function in the query statement at regular time. The server analyzes the query sentences to obtain sentences in which the functions are located, records the query efficiency values of the function sentences, if the functions with larger query efficiency value difference exist, the inefficient functions exist, and replaces the inefficient function sentences with the query efficiency values obviously smaller than the rest query efficiency values. The server stores at least one replacement function, randomly selects one function from the replacement functions to replace, rerun the query statement, and if the query efficiency is normal, the replacement is successful; and if the query efficiency is not obviously improved, replacing again. The function needing to be replaced is automatically searched and replaced through the server, working time of workers is effectively saved, checking efficiency of query sentences is improved, errors caused by manual input of the query sentences are avoided, and optimization efficiency of the query sentences is improved.
According to the technical scheme of the embodiment, whether the query statement is updated or not is determined by detecting the state information of the elements in the query statement, so that the query statement is adjusted. The problem of among the prior art, need artifical to detect and handle the inquiry sentence is solved, avoid artifical investigation inaccuracy, reduced the artifical code error that produces when handling the inquiry sentence, improve the renewal and the optimization efficiency of inquiry sentence, effectively practice thrift manpower and time.
Example two
Fig. 2 is a flowchart illustrating a query statement processing method according to a second embodiment of the present invention, and the method may be executed by a query statement processing apparatus according to the second embodiment of the present invention. As shown in fig. 2, the method specifically includes the following steps:
step 210, detecting state information of elements in the query statement.
Step 220, if it is determined that the element is to be updated according to the state information, adjusting the query statement according to the updated element.
Step 230, executing the query statement to obtain a query result, and selecting at least two inefficient fields from the fields included in the query statement according to the query result.
After the server updates the query statement, the server executes the new query statement to obtain a query result, that is, an output result of each field in the associated data table and output efficiency of data of each field are obtained. Counting the output efficiency of data of each field, and searching whether at least two low-efficiency fields with abnormally low output efficiency exist in the data table fields associated with the query statement, wherein the low-efficiency fields are determined by counting the output efficiency of the data of the fields. If the field with the abnormally low output efficiency exists, the field is an inefficient field, and the related information of the field needs to be adjusted; and if not, finishing the adjustment of the query statement. For example, there are three fields in the data table, which are "name", "gender", and "age", respectively, and the three fields are arranged in sequence in the data table, and when the query statement is executed, the output time of the "name" field is 0.07 seconds, the output time of the "gender" field is 0.8 seconds, the output time of the "age" field is 0.9 seconds, and the "gender" field and the "age" field are inefficient fields.
Step 240, matching the inefficient field with the associated data table index according to the arrangement order of the inefficient field in the data table to determine whether the index of the inefficient field exists.
Wherein, the fields are arranged in sequence according to the sequence in the data table. If an inefficient field exists, the database is checked for the presence of a data table index that matches the field. In general, if a field in a data table has no matching index, resulting in inefficient output of data for that field, the efficiency of output of data for subsequent fields will be low regardless of whether there is a matching index. Therefore, if the field data output efficiency of only one field is low and the field is the last field, only the field needs to be detected whether the matched data table index exists.
And if the data output efficiency of at least two fields is low, matching the fields with the associated data table indexes in sequence from back to front to determine whether the indexes of the low-efficiency fields exist. For example, three fields of "name", "gender" and "age" are arranged in the data table in sequence, and in the data table index, there is no index of the "gender" field, so that the data output efficiency of the "gender" field and the "age" field is significantly lower than that of the "name" field when the query statement is executed, i.e. there are two inefficient fields. When detecting the matching of the field and the index, the detection is started from the age, and then the index of the gender field is detected.
After determining that the low-efficiency field matched with the index does not exist, the server acquires the field information, adds the field index into the data table index, re-executes the query statement and ensures the normal operation of the query statement.
The embodiment of the invention determines whether the query statement needs to be updated or not according to the state information by detecting the state information of the elements in the query statement, and adjusts the query statement. The query statement can be automatically detected and updated, the difficulty degree of code maintenance is reduced, the omission condition during manual investigation is avoided, and the optimization and update efficiency of the query statement is improved. The method comprises the steps of obtaining a query result of a query statement, selecting an inefficient field from a data table field, determining whether a data table index matched with the inefficient field exists in a database, and if the data table index does not exist, adding the index of the inefficient field into the database, so that automatic examination of the field index is realized, and the query efficiency of the query statement is improved.
EXAMPLE III
Fig. 3 is a block diagram of a query processing apparatus according to a third embodiment of the present invention, which is capable of executing a query processing method according to any embodiment of the present invention, and has functional modules and beneficial effects corresponding to the execution method. As shown in fig. 3, the apparatus specifically includes:
a state information detection module 301, configured to detect state information of an element in a query statement;
a query statement adjusting module 302, configured to adjust the query statement according to the updated element if it is determined that the element is to be updated according to the state information.
Optionally, the query statement adjusting module 302 is specifically configured to:
if the data table information associated with the query statement is detected to be updated, adjusting the query statement according to the updated data table information;
wherein the data table information includes at least one of: field name, field data, and header.
Optionally, the query statement adjusting module 302 is further specifically configured to:
if any function in the query statement is detected to be a low-efficiency function, adopting a replacement function of the function to update the query statement; wherein the inefficiency function is determined by a query efficiency statistic of the query statement.
Optionally, the apparatus further comprises:
the low-efficiency field selection module is used for executing the query statement to obtain a query result, and selecting at least two low-efficiency fields from fields included in the query statement according to the query result;
and the index determining module is used for matching the low-efficiency fields with the associated data table indexes according to the arrangement sequence of the low-efficiency fields in the data table so as to determine whether the indexes of the low-efficiency fields exist.
The embodiment of the invention adjusts the query statement by detecting the state information of the elements in the query statement and determining whether the query statement needs to be updated according to the state information. The embodiment of the invention solves the problem that the query sentences need to be sequentially detected manually in the prior art, further avoids the problem of inaccurate manual troubleshooting, reduces the difficulty degree of code maintenance when the query sentences are processed manually, improves the updating and optimizing efficiency of the query sentences, and effectively saves manpower and time.
Example four
Fig. 4 is a schematic structural diagram of a computer device according to a fourth embodiment of the present invention. FIG. 4 illustrates a block diagram of an exemplary computer device 400 suitable for use in implementing embodiments of the present invention. The computer device 400 shown in fig. 4 is only an example and should not bring any limitations to the functionality or scope of use of the embodiments of the present invention.
As shown in fig. 4, computer device 400 is in the form of a general purpose computing device. The components of computer device 400 may include, but are not limited to: one or more processors or processing units 401, a system memory 402, and a bus 403 that couples the various system components (including the system memory 402 and the processing unit 401).
Bus 403 represents one or more of any of several types of bus structures, including a memory bus or memory controller, a peripheral bus, an accelerated graphics port, and a processor or local bus using any of a variety of bus architectures. By way of example, such architectures include, but are not limited to, industry Standard Architecture (ISA) bus, micro-channel architecture (MAC) bus, enhanced ISA bus, video Electronics Standards Association (VESA) local bus, and Peripheral Component Interconnect (PCI) bus.
Computer device 400 typically includes a variety of computer system readable media. Such media can be any available media that is accessible by computer device 400 and includes both volatile and nonvolatile media, removable and non-removable media.
The system memory 402 may include computer system readable media in the form of volatile memory, such as Random Access Memory (RAM) 404 and/or cache memory 405. The computer device 400 may further include other removable/non-removable, volatile/nonvolatile computer system storage media. By way of example only, storage system 406 may be used to read from and write to non-removable, nonvolatile magnetic media (not shown in FIG. 4, and commonly referred to as a "hard drive"). Although not shown in FIG. 4, a magnetic disk drive for reading from and writing to a removable, nonvolatile magnetic disk (e.g., a "floppy disk") and an optical disk drive for reading from or writing to a removable, nonvolatile optical disk (e.g., a CD-ROM, DVD-ROM, or other optical media) may be provided. In these cases, each drive may be connected to the bus 403 by one or more data media interfaces. Memory 402 may include at least one program product having a set (e.g., at least one) of program modules that are configured to carry out the functions of embodiments of the invention.
A program/utility 408 having a set (at least one) of program modules 407 may be stored, for example, in memory 402, such program modules 407 including, but not limited to, an operating system, one or more application programs, other program modules, and program data, each of which examples or some combination thereof may comprise an implementation of a network environment. Program modules 407 generally perform the functions and/or methods of the described embodiments of the invention.
The computer device 400 may also communicate with one or more external devices 409 (e.g., keyboard, pointing device, display 410, etc.), with one or more devices that enable a user to interact with the computer device 400, and/or with any devices (e.g., network card, modem, etc.) that enable the computer device 400 to communicate with one or more other computing devices. Such communication may be through input/output (I/O) interface 411. Moreover, computer device 400 may also communicate with one or more networks (e.g., a Local Area Network (LAN), a Wide Area Network (WAN), and/or a public network such as the Internet) through network adapter 412. As shown, network adapter 412 communicates with the other modules of computer device 400 over bus 403. It should be appreciated that although not shown in the figures, other hardware and/or software modules may be used in conjunction with computer device 400, including but not limited to: microcode, device drivers, redundant processing units, external disk drive arrays, RAID systems, tape drives, and data backup storage systems, to name a few.
The processing unit 401 executes various functional applications and data processing by running the program stored in the system memory 402, for example, implementing a query statement processing method provided by the embodiment of the present invention, including:
detecting state information of elements in the query statement;
and if the element is determined to be updated according to the state information, adjusting the query statement according to the updated element.
EXAMPLE five
The fifth embodiment of the present invention further provides a storage medium containing computer-executable instructions, where a computer program is stored on the storage medium, and when the computer program is executed by a processor, the method for processing a query statement according to the fifth embodiment of the present invention is implemented, where the method includes:
detecting state information of elements in the query statement;
and if the element is determined to be updated according to the state information, adjusting the query statement according to the updated element.
Computer storage media for embodiments of the invention may employ any combination of one or more computer-readable media. The computer readable medium may be a computer readable signal medium or a computer readable storage medium. A computer readable storage medium may be, for example, but not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination of the foregoing. More specific examples (a non-exhaustive list) of the computer readable storage medium would include the following: an electrical connection having one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing. In the context of this document, a computer readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device.
A computer readable signal medium may include a propagated data signal with computer readable program code embodied therein, for example, in baseband or as part of a carrier wave. Such a propagated data signal may take any of a variety of forms, including, but not limited to, electro-magnetic, optical, or any suitable combination thereof. A computer readable signal medium may also be any computer readable medium that is not a computer readable storage medium and that can communicate, propagate, or transport a program for use by or in connection with an instruction execution system, apparatus, or device.
Program code embodied on a computer readable medium may be transmitted using any appropriate medium, including but not limited to wireless, wireline, optical fiber cable, RF, etc., or any suitable combination of the foregoing.
Computer program code for carrying out operations for aspects of the present invention may be written in any combination of one or more programming languages, including an object oriented programming language such as Java, smalltalk, C + + or the like and conventional procedural programming languages, such as the "C" programming language or similar programming languages. The program code may execute entirely on the user's computer, partly on the user's computer, as a stand-alone software package, partly on the user's computer and partly on a remote computer or entirely on the remote computer or server. In the latter scenario, the remote computer may be connected to the user's computer through any type of network, including a Local Area Network (LAN) or a Wide Area Network (WAN), or the connection may be made to an external computer (for example, through the Internet using an Internet service provider).
It is to be noted that the foregoing is only illustrative of the preferred embodiments of the present invention and the technical principles employed. It will be understood by those skilled in the art that the present invention is not limited to the particular embodiments described herein, but is capable of various obvious changes, rearrangements and substitutions as will now become apparent to those skilled in the art without departing from the scope of the invention. Therefore, although the present invention has been described in greater detail by the above embodiments, the present invention is not limited to the above embodiments, and may include other equivalent embodiments without departing from the spirit of the present invention, and the scope of the present invention is determined by the scope of the appended claims.

Claims (6)

1. A query statement processing method, comprising:
detecting state information of elements in the query statement;
if the element is determined to be updated according to the state information, adjusting the query statement according to the updated element;
executing the query statement to obtain a query result, and selecting at least two low-efficiency fields from fields included in the query statement according to the query result;
matching the inefficient fields with associated data table indexes according to the arrangement sequence of the inefficient fields in a data table to determine whether indexes of the inefficient fields exist or not;
if it is determined according to the state information that the element is to be updated, adjusting the query statement according to the updated element includes:
if the data table information associated with the query statement is detected to be updated, adjusting the query statement according to the updated data table information;
wherein the data table information comprises at least one of: field name, field data, and header.
2. The method of claim 1, wherein if it is determined that the element is to be updated according to the state information, adjusting the query statement according to the updated element further comprises:
if any function in the query statement is detected to be an inefficient function, adopting a replacement function of the function to update the query statement; wherein the inefficiency function is determined by a query efficiency statistic of the query statement.
3. A query statement processing apparatus, comprising:
the state information detection module is used for detecting the state information of the elements in the query statement;
a query statement adjusting module, configured to adjust the query statement according to the updated element if it is determined that the element is to be updated according to the state information;
the low-efficiency field selection module is used for executing the query statement to obtain a query result, and selecting at least two low-efficiency fields from fields included in the query statement according to the query result;
the index determining module is used for matching the low-efficiency fields with the associated data table indexes according to the arrangement sequence of the low-efficiency fields in the data table so as to determine whether the indexes of the low-efficiency fields exist or not;
the query statement adjustment module is specifically configured to:
if the fact that the data table information related to the query statement is updated is detected, the query statement is adjusted according to the updated data table information;
wherein the data table information includes at least one of: field name, field data, and header.
4. The apparatus of claim 3, wherein the query statement adjustment module is further specifically configured to:
if any function in the query statement is detected to be a low-efficiency function, adopting a replacement function of the function to update the query statement; wherein the inefficiency function is determined by a query efficiency statistic of the query statement.
5. A computer device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, wherein the processor implements the query statement processing method according to any one of claims 1-2 when executing the program.
6. A storage medium containing computer-executable instructions for performing the query statement processing method of any one of claims 1-2 when executed by a computer processor.
CN201911134800.1A 2019-11-19 2019-11-19 Query statement processing method, device, equipment and storage medium Active CN110874364B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201911134800.1A CN110874364B (en) 2019-11-19 2019-11-19 Query statement processing method, device, equipment and storage medium

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201911134800.1A CN110874364B (en) 2019-11-19 2019-11-19 Query statement processing method, device, equipment and storage medium

Publications (2)

Publication Number Publication Date
CN110874364A CN110874364A (en) 2020-03-10
CN110874364B true CN110874364B (en) 2023-04-11

Family

ID=69718323

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201911134800.1A Active CN110874364B (en) 2019-11-19 2019-11-19 Query statement processing method, device, equipment and storage medium

Country Status (1)

Country Link
CN (1) CN110874364B (en)

Families Citing this family (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN111708804B (en) * 2020-06-11 2024-03-01 中国建设银行股份有限公司 Data processing method, device, equipment and medium
CN111782667A (en) * 2020-06-22 2020-10-16 成都校精灵科技有限公司 MongoDB updating data driving method, system and storage medium
CN113535773B (en) * 2021-07-27 2022-08-12 工银科技有限公司 Database optimization method, database optimization device, electronic device and storage medium

Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101609473A (en) * 2009-07-30 2009-12-23 金蝶软件（中国）有限公司 A kind of method of Structured Query Language (SQL) of reconstruct report query and device
CN104408134A (en) * 2013-11-28 2015-03-11 中国科学院计算技术研究所 SQL to cloud environment mapping method and system
CN107241914A (en) * 2014-11-19 2017-10-10 电子湾有限公司 The system and method rewritten for search inquiry

Family Cites Families (11)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US8666970B2 (en) * 2011-01-20 2014-03-04 Accenture Global Services Limited Query plan enhancement
US20170024433A1 (en) * 2014-04-29 2017-01-26 Hewlett Packard Enterprise Development Lp Query plan post optimization analysis and reoptimization
US11461319B2 (en) * 2014-10-06 2022-10-04 Business Objects Software, Ltd. Dynamic database query efficiency improvement
CN105653607B (en) * 2015-12-23 2019-05-07 北京奇虎科技有限公司 SQL log collection analysis method and device
CN105912594B (en) * 2016-04-05 2020-01-07 深信服科技股份有限公司 SQL statement processing method and system
CN107784032B (en) * 2016-08-31 2020-06-16 华为技术有限公司 Progressive output method, device and system of data query result
CN108509530A (en) * 2018-03-14 2018-09-07 武汉斗鱼网络科技有限公司 A kind of slow query statement automatic optimization method of MySQL, computer equipment and storage medium
CN108509805A (en) * 2018-03-21 2018-09-07 深圳天源迪科信息技术股份有限公司 Data encrypting and deciphering and desensitization runtime engine and its working method
CN109408565B (en) * 2018-10-19 2021-09-28 浪潮软件科技有限公司 Data synchronous interaction method, system and data interaction platform
CN109508339B (en) * 2018-11-12 2020-10-09 上海达梦数据库有限公司 Data query method and device, terminal equipment and storage medium
CN110399386B (en) * 2019-07-15 2022-05-10 南威软件股份有限公司 Presto-based SQL UPDATE method and control system

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101609473A (en) * 2009-07-30 2009-12-23 金蝶软件（中国）有限公司 A kind of method of Structured Query Language (SQL) of reconstruct report query and device
CN104408134A (en) * 2013-11-28 2015-03-11 中国科学院计算技术研究所 SQL to cloud environment mapping method and system
CN107241914A (en) * 2014-11-19 2017-10-10 电子湾有限公司 The system and method rewritten for search inquiry

Non-Patent Citations (3)

* Cited by examiner, † Cited by third party
Title
Query Rewrites with Views for XML in DB2;P. Godfrey 等;《2009 IEEE 25th International Conference on Data Engineering》;20090410;1339-1350 *
一种扩充语义的实视图重写查询技术;荀亚玲 等;《计算机工程与应用》;20080421(第12期);157-160 *
基于标记的不一致数据查询处理框架;吴爱华;《上海海事大学学报》;20130331;第34卷(第01期);84-89 *

Also Published As

Publication number Publication date
CN110874364A (en) 2020-03-10

Similar Documents

Publication Publication Date Title
CN108959564B (en) Data warehouse metadata management method, readable storage medium and computer device
US10885000B2 (en) Repairing corrupted references
CN110874364B (en) Query statement processing method, device, equipment and storage medium
US20110154117A1 (en) Methods and apparatus to perform log file analyses
US8302086B2 (en) System and method for overflow detection using symbolic analysis
JP5791149B2 (en) Computer-implemented method, computer program, and data processing system for database query optimization
US10402310B1 (en) Systems and methods for reducing storage required for code coverage results
CN109471851B (en) Data processing method, device, server and storage medium
US9658834B2 (en) Program visualization device, program visualization method, and program visualization program
CN107766353B (en) Method and device for migrating statistical information of database
US9990268B2 (en) System and method for detection of duplicate bug reports
US20210318864A1 (en) Methods and arrangements to process comments
US20160259825A1 (en) Discovery of potential problematic execution plans in a bind-sensitive query statement
CN109582906B (en) Method, device, equipment and storage medium for determining data reliability
CN112445775A (en) Fault analysis method, device, equipment and storage medium of photoetching machine
CN108694172B (en) Information output method and device
CN111367813B (en) Automatic testing method and device for decision engine, server and storage medium
CN110175128B (en) Similar code case acquisition method, device, equipment and storage medium
CN108959454B (en) Prompting clause specifying method, device, equipment and storage medium
CN112507075A (en) Case data searching method, system, equipment and storage medium
US10664464B2 (en) Self-maintaining effective value range synopsis in presence of deletes in analytical databases
US11392371B2 (en) Identification of a partial code to be refactored within a source code
US20070214166A1 (en) Program analysis method and apparatus
CN111813749A (en) File filtering method and device, electronic equipment and storage medium
US20150169707A1 (en) Representative sampling of relational data

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
GR01 Patent grant
GR01 Patent grant