CN110633300A - Breakpoint continuous operation method and device for nested query - Google Patents
Breakpoint continuous operation method and device for nested query Download PDFInfo
- Publication number
- CN110633300A CN110633300A CN201910786416.3A CN201910786416A CN110633300A CN 110633300 A CN110633300 A CN 110633300A CN 201910786416 A CN201910786416 A CN 201910786416A CN 110633300 A CN110633300 A CN 110633300A
- Authority
- CN
- China
- Prior art keywords
- query
- layer
- nested
- instruction
- instructions
- 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.)
- Withdrawn
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/245—Query processing
- G06F16/2455—Query execution
- G06F16/24553—Query execution of query operations
- G06F16/24561—Intermediate data storage techniques for performance improvement
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Computational Linguistics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention relates to a method and a device for breakpoint continuous operation of nested query, wherein the method comprises the following steps: analyzing the nested query instruction to divide the nested query instruction into query instructions of each layer by layer, and storing the query instructions of each layer and the layer numbers of each layer into a query comparison table; executing the nested query instruction and storing the query result corresponding to the query instruction of each layer into a query comparison table according to the layer number; in response to an interrupt occurring during execution of the nested query instruction, checking a last-bit query result in the query look-up table and determining an interrupt layer; and replacing the sub query statement of the part corresponding to the query instruction of the interrupt layer in the nested query instruction by the last-bit query result, and continuously executing the replaced nested query instruction. When the method is used for restarting the nested query, only the query process is needed to be continued from the interrupt point, so that the problem of continuous operation after the nested query is interrupted is solved, the nested query time is effectively shortened, resources are saved, and the query efficiency is improved.
Description
Technical Field
The invention relates to the technical field of databases. The invention further relates to a method and a device for breakpoint continuous operation of nested query.
Background
In the field of databases, data for a database often needs a large number of nested queries, for example, business applications regularly report a report every month, wherein a large number of data tables are related and the data in the data tables is large. In such a case, such nested query times tend to be particularly long and can occupy significant system resources. When problems occur in the running process of the nested query, the query is required to be started again from the beginning, time and labor are wasted, and normal work can be delayed.
For the above problems, the solutions in the prior art are generally to try to avoid the risk of nested queries. For example, when the night service is idle, the inquiry is carried out, and the contention of system resources can not occur. For another example, a read-only query library is separately created, and the query library only undertakes the task of data query after synchronizing the data of the original database. As another example, Query sql (Structured Query Language) is optimized to reduce Query time, etc.
Although the methods mostly ensure the normal operation of the nested query to a certain extent by actively avoiding the risk, the methods still have the problem of nested query interruption, that is, when the interruption occurs in the process of the nested query operation, the nested query sql must be executed from the beginning by restarting the nested query task, which causes the occupation of system resources and the waste of time.
Therefore, a technical solution for solving the above problems in the prior art is needed, which optimizes the execution process of the nested query so that when an interrupt occurs during the execution process of the nested query, the task of restarting the nested query does not need to execute the nested query sql from the beginning, thereby saving system resources and query time.
Disclosure of Invention
In one aspect, the present invention provides a method for breakpoint continuous operation of nested queries, where the method includes the following steps:
analyzing the nested query instruction to divide the nested query instruction into query instructions of each layer by layer, and storing the query instructions of each layer and the layer numbers of each layer into a query comparison table;
executing the nested query instruction and storing the query result corresponding to the query instruction of each layer into a query comparison table according to the layer number;
in response to an interrupt occurring during execution of the nested query instruction, checking a last-bit query result in the query look-up table and determining an interrupt layer;
and replacing the sub query statement of the part corresponding to the query instruction of the interrupt layer in the nested query instruction by the last-bit query result, and continuously executing the replaced nested query instruction.
According to an embodiment of the method for breakpoint continuous operation of nested query of the present invention, parsing the nested query instruction to split the nested query instruction into query instructions of each layer by layer, and storing the query instructions of each layer and the layer numbers of each layer in the query comparison table further includes: and resolving the query identifier in the nested query instruction, and splitting the nested query instruction by taking the query identifier as a keyword.
According to an embodiment of the method for breakpoint continuous operation of nested query of the present invention, parsing the nested query instruction to split the nested query instruction into query instructions of each layer by layer, and storing the query instructions of each layer and the layer numbers of each layer in the query comparison table further includes: and splitting the nested query instruction layer by taking the query statement which does not contain the sub-query statement in the nested query instruction as the first layer of query instruction.
According to the embodiment of the method for breakpoint continuous operation of nested query of the present invention, parsing the nested query instruction, splitting the nested query instruction into query instructions of each layer by layer, and storing the query instructions of each layer and the layer numbers of each layer in the query comparison table further includes: and storing the query instructions of all layers and the layer numbers of all layers into a query comparison table, so that the query instructions of the upper layer in the query comparison table are sub query statements of the query instructions of the lower layer.
In an embodiment of the method for breakpoint continuous operation of nested query according to the present invention, in response to an interrupt occurring during execution of the nested query instruction, checking a last-bit query result in the query lookup table and determining an interrupt layer further includes: and checking the query comparison table in sequence, and taking the first layer without the corresponding query result as an interruption layer.
On the other hand, the invention also provides a device for breakpoint continuous running of nested query, wherein the device comprises:
at least one processor; and
a memory storing processor executable program code which when executed by the processor performs the steps of:
analyzing the nested query instruction to divide the nested query instruction into query instructions of each layer by layer, and storing the query instructions of each layer and the layer numbers of each layer into a query comparison table;
executing the nested query instruction and storing the query result corresponding to the query instruction of each layer into a query comparison table according to the layer number;
in response to an interrupt occurring during execution of the nested query instruction, checking a last-bit query result in the query look-up table and determining an interrupt layer;
and replacing the sub query statement of the part corresponding to the query instruction of the interrupt layer in the nested query instruction by the last-bit query result, and continuously executing the replaced nested query instruction.
According to an embodiment of the apparatus for breakpoint continuous operation of nested query of the present invention, parsing the nested query instruction, splitting the nested query instruction into query instructions of each layer by layer, and storing the query instructions of each layer and the layer numbers of each layer in the query lookup table further includes: and resolving the query identifier in the nested query instruction, and splitting the nested query instruction by taking the query identifier as a keyword.
According to an embodiment of the apparatus for breakpoint continuous operation of nested query of the present invention, parsing the nested query instruction to split the nested query instruction into query instructions of each layer by layer, and storing the query instructions of each layer and the layer numbers of each layer in the query lookup table further includes: and splitting the nested query instruction layer by taking the query statement which does not contain the sub-query statement in the nested query instruction as the first layer of query instruction.
According to an embodiment of the apparatus for breakpoint continuous operation of nested query of the present invention, parsing the nested query instruction to split the nested query instruction into query instructions of each layer by layer, and storing the query instructions of each layer and the layer numbers of each layer in the query lookup table further includes: and storing the query instructions of all layers and the layer numbers of all layers into a query comparison table, so that the query instructions of the upper layer in the query comparison table are sub query statements of the query instructions of the lower layer.
In an embodiment of the apparatus for breakpoint continuous operation of nested query according to the present invention, in response to an interrupt occurring during execution of the nested query instruction, checking a last-bit query result in the query lookup table and determining an interrupt layer further includes: and checking the query comparison table in sequence, and taking the first layer without the corresponding query result as an interruption layer.
By adopting the technical scheme, the invention at least has the following beneficial effects: the method mechanism adopted by the invention is to split the nested query instruction and establish a query comparison table, then store the result obtained by each layer of query in the nested query process into the query comparison table, and when the query is interrupted, retrieve the data in the query comparison table, replace the corresponding sub-query statement with the last query result, and continue the query. In such a way, when the nested query is restarted, all sub-query statements are not required to be executed again, but the query process from the beginning to the interruption point is omitted, the problem of continuous operation after the nested query is interrupted is solved, the nested query time is effectively shortened, the occupation of system resources is saved, and the query efficiency is improved.
The present invention provides aspects of embodiments, which should not be used to limit the scope of the present invention. Other embodiments are contemplated in accordance with the techniques described herein, as will be apparent to one of ordinary skill in the art upon study of the following figures and detailed description, and are intended to be included within the scope of the present application.
Embodiments of the invention are explained and described in more detail below with reference to the drawings, but they should not be construed as limiting the invention.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the drawings that are required to be used in the description of the prior art and the embodiments will be briefly described below, parts in the drawings are not necessarily drawn to scale, and related elements may be omitted, or in some cases the scale may have been exaggerated in order to emphasize and clearly show the novel features described herein. In addition, the structural order may be arranged differently, as is known in the art.
FIG. 1 is a schematic block diagram illustrating an embodiment of a method of breakpoint resume for nested queries in accordance with the present invention;
FIG. 2 illustrates an exemplary embodiment of a nested query instruction;
FIG. 3 illustrates an exemplary embodiment of a method for breakpoint resume with nested queries of the present invention for a lookup table of the embodiment of the set of query instructions illustrated in FIG. 2 in an interrupted state.
Detailed Description
While the present invention may be embodied in various forms, there is shown in the drawings and will hereinafter be described some exemplary and non-limiting embodiments, with the understanding that the present disclosure is to be considered an exemplification of the invention and is not intended to limit the invention to the specific embodiments illustrated.
FIG. 1 shows a schematic block diagram of an embodiment of a method of breakpoint resume of a nested query in accordance with the present invention. As shown in fig. 1, an embodiment of the method comprises at least the following steps:
s1: analyzing the nested query instruction to divide the nested query instruction into query instructions of each layer by layer, and storing the query instructions of each layer and the layer numbers of each layer into a query comparison table;
s2: executing the nested query instruction and storing the query result corresponding to the query instruction of each layer into a query comparison table according to the layer number;
s3: in response to an interrupt occurring during execution of the nested query instruction, checking a last-bit query result in the query look-up table and determining an interrupt layer;
s4: and replacing the sub query statement of the part corresponding to the query instruction of the interrupt layer in the nested query instruction by the last-bit query result, and continuously executing the replaced nested query instruction.
In order to solve the problem that breakpoint continuous operation cannot be performed after the nested query is interrupted in the prior art, the invention provides the methods of the steps S1 to S4. The following explains the method for breakpoint continuous operation of nested queries according to the present invention, by taking the example of the nested query instruction shown in fig. 2 as an example. The nested query instruction shown in FIG. 2 is a 5-level nested query instruction. Step S1 is to analyze the nested query instruction (as shown in fig. 2), split the nested query instruction layer by layer according to the analysis of the nested query instruction, thereby obtaining query instructions of each layer, and store the query instructions of each layer and the layer numbers of each layer in a query comparison table, where, as shown in the example of the query comparison table in fig. 3, the first column is a layer number, and the second column is a query instruction of each layer. After the first and second columns of the lookup table are established, step S2 executes the nested lookup instruction (fig. 2) and stores the lookup result corresponding to the lookup instruction of each layer in the lookup table (fig. 3) according to the layer number, for example, the third column of the lookup table shown in fig. 3. Specifically, taking the nested query instruction in fig. 2 as an example, the result of executing the first layer "selet eee from t5 where t5.fff is xxx" is "g", so the result "g" of the query is stored in the third column of the "1" th layer of the query lookup table according to the layer number "1", and so on, the result "h" of executing the second layer query is stored in the third column of the "2" th layer of the query lookup table, the result "i" of executing the third layer query is stored in the third column of the "3" th layer of the query lookup table, and so on. In the execution of the nested query instruction (fig. 2), upon occurrence of an interrupt, step S3 checks the query result of the last bit in the query lookup table and determines the interrupt layer. For example, after an interrupt occurs, the query lookup table shown in fig. 3 is checked to obtain a query result with the last query result "j" at the "4" th layer. Then, in step S4, the sub-query statement of the portion of the nested query instruction corresponding to the query instruction of the interrupt layer is replaced with the last-bit query result, and the replaced nested query instruction continues to be executed. Taking the foregoing example as an example, replacing the corresponding sub-query statement with the query result "j
(selet bbb from t2
where t2.ccc＝(selet ccc from t3
where t3.ddd＝(selet ddd from t4
where t4.eee＝(selet eee from t5
where t5.fff＝xxx))))，
Such that nested query instructions (FIG. 2) are replaced with
select aaa from t1
where t1.bbb＝j。
And the restarted nested query only needs to execute the replaced nested query instruction, and all the sub-query statements do not need to be re-executed.
Further embodiments of the present invention will be described below, it being noted that the numbering of the steps mentioned therein is used only for the convenience of unambiguously indicating the step without any particular indication, and does not limit the order of the steps described.
In some embodiments of the method for breakpoint continuous operation of nested query according to the present invention, the parsing the nested query instruction in step S1, splitting the nested query instruction into query instructions of each layer by layer, and storing the query instructions of each layer and the layer numbers of each layer in the query lookup table further includes: and resolving the query identifier in the nested query instruction, and splitting the nested query instruction by taking the query identifier as a keyword. For example, splitting of nested query instructions is preferably, but not limited to, with "selet" as a key.
In some embodiments of the method for breakpoint continuous operation of nested query of the present invention, the parsing the nested query instruction in step S1, splitting the nested query instruction into query instructions of each layer by layer, and storing the query instructions of each layer and the layer numbers of each layer in the query lookup table further includes: and splitting the nested query instruction layer by taking the query statement which does not contain the sub-query statement in the nested query instruction as the first layer of query instruction. Since the nested query will first execute the innermost query sql during execution, that is, the sql statement without the sub-query statement, when splitting the nested query instruction, the method according to the present invention splits the nested query instruction layer by layer outward using the innermost query statement (e.g., "selet eee from 5 where 5.fff ═ xxx" shown in fig. 2 and fig. 3) that does not contain the sub-query statement as the first layer of query instruction. At the same time, the last layer of query instructions contains the completed nested query instructions.
In one or more embodiments of the method for breakpoint continuous operation of nested query of the present invention, the step S2 executing the nested query instruction and storing the query result corresponding to the query instruction of each layer in the query lookup table according to the layer number further includes: and analyzing to obtain database fragments related to the query instructions of each layer in the database, and executing the query instructions of each layer on the related database fragments respectively. And analyzing the query instructions of each layer according to the format and the identifier of the query sql, then obtaining the related corresponding database fragment according to the corresponding identifier, and then respectively executing the query instructions of each layer on the related database fragment to obtain a query result.
In some embodiments of the method for breakpoint resumption of nested queries according to the present invention, the step S3, in response to an interrupt occurring during execution of the nested query instruction, checks the last query result in the query lookup table and determines the interrupt layer further includes: and checking the query comparison table in sequence, and taking the first layer without the corresponding query result as an interruption layer. After the interrupt occurs, the position of the interrupt needs to be determined, so that the starting point of the query is definitely continued when the breakpoint continues to operate can be determined. According to the embodiment of the method, after each layer of query is executed, the corresponding query result is stored in the query comparison table, and the interrupted layer cannot obtain the query result and cannot store the corresponding query result in the query comparison table. Therefore, when checking the query look-up table after an interrupt occurs, some embodiments of the present invention take the first layer without the corresponding query result as the interrupt layer and feed back the information to the corresponding display device if necessary.
On the other hand, the invention also provides a device for breakpoint continuous running of nested query, wherein the device comprises: at least one processor; and a memory storing program code executable by the processor, the program code, when executed by the processor, performing the steps of:
s1: analyzing the nested query instruction to divide the nested query instruction into query instructions of each layer by layer, and storing the query instructions of each layer and the layer numbers of each layer into a query comparison table;
s2: executing the nested query instruction and storing the query result corresponding to the query instruction of each layer into a query comparison table according to the layer number;
s3: in response to an interrupt occurring during execution of the nested query instruction, checking a last-bit query result in the query look-up table and determining an interrupt layer;
s4: and replacing the sub query statement of the part corresponding to the query instruction of the interrupt layer in the nested query instruction by the last-bit query result, and continuously executing the replaced nested query instruction.
In some embodiments of the apparatus for breakpoint continuous operation of nested query of the present invention, the parsing the nested query command in step S1, splitting the nested query command into query commands of each layer by layer, and storing the query commands of each layer and the layer numbers of each layer in the query lookup table further includes: and resolving the query identifier in the nested query instruction, and splitting the nested query instruction by taking the query identifier as a keyword.
In some embodiments of the apparatus for breakpoint continuous operation of nested query of the present invention, the parsing the nested query instruction in step S1, splitting the nested query instruction into query instructions of each layer by layer, and storing the query instructions of each layer and the layer numbers of each layer in the query lookup table further includes: and splitting the nested query instruction layer by taking the query statement which does not contain the sub-query statement in the nested query instruction as the first layer of query instruction.
In one or more embodiments of the apparatus for breakpoint continuous operation of nested query in the present invention, the step S2 executing the nested query instruction and storing the query result corresponding to the query instruction of each layer in the query lookup table according to the layer number further includes: and analyzing to obtain database fragments related to the query instructions of each layer in the database, and executing the query instructions of each layer on the related database fragments respectively.
In some embodiments of the apparatus for breakpoint continuous operation of nested query of the present invention, the step S3, in response to an interrupt occurring during the execution of the nested query instruction, the checking the query result of the last bit in the query lookup table and determining the interrupt layer further comprises: and checking the query comparison table in sequence, and taking the first layer without the corresponding query result as an interruption layer.
The devices and apparatuses disclosed in the embodiments of the present invention may be various electronic terminal apparatuses, such as a mobile phone, a Personal Digital Assistant (PDA), a tablet computer (PAD), a smart television, and the like, or may be a large terminal apparatus, such as a server, and therefore the scope of protection disclosed in the embodiments of the present invention should not be limited to a specific type of device and apparatus. The client disclosed in the embodiment of the present invention may be applied to any one of the above electronic terminal devices in the form of electronic hardware, computer software, or a combination of both.
The computer-readable storage media (e.g., memory) described herein may be either volatile memory or nonvolatile memory, or may include both volatile and nonvolatile memory. By way of example, and not limitation, nonvolatile memory can include Read Only Memory (ROM), Programmable ROM (PROM), Electrically Programmable ROM (EPROM), Electrically Erasable Programmable ROM (EEPROM), or flash memory. Volatile memory can include Random Access Memory (RAM), which can act as external cache memory. By way of example and not limitation, RAM is available in a variety of forms such as synchronous RAM (DRAM), Dynamic RAM (DRAM), Synchronous DRAM (SDRAM), double data rate SDRAM (DDR SDRAM), Enhanced SDRAM (ESDRAM), Synchronous Link DRAM (SLDRAM), and Direct Rambus RAM (DRRAM). The storage devices of the disclosed aspects are intended to comprise, without being limited to, these and other suitable types of memory.
By adopting the technical scheme, the invention at least has the following beneficial effects: the method mechanism adopted by the invention is to split the nested query instruction and establish a query comparison table, then store the result obtained by each layer of query in the nested query process into the query comparison table, and when the query is interrupted, retrieve the data in the query comparison table, replace the corresponding sub-query statement with the last query result, and continue the query. In such a way, when the nested query is restarted, all sub-query statements are not required to be executed again, but the query process from the beginning to the interruption point is omitted, the problem of continuous operation after the nested query is interrupted is solved, the nested query time is effectively shortened, the occupation of system resources is saved, and the query efficiency is improved.
It is to be understood that the features listed above for the different embodiments may be combined with each other to form further embodiments within the scope of the invention, where technically feasible. Furthermore, the specific examples and embodiments described herein are non-limiting, and various modifications of the structure, steps and sequence set forth above may be made without departing from the scope of the invention.
In this application, the use of the conjunction of the contrary intention is intended to include the conjunction. The use of definite or indefinite articles is not intended to indicate cardinality. In particular, references to "the" object or "an" and "an" object are intended to mean one of many such objects possible. However, although elements of the disclosed embodiments of the invention may be described or claimed in the singular, the plural is contemplated unless limitation to the singular is explicitly stated. Furthermore, the conjunction "or" may be used to convey simultaneous features, rather than mutually exclusive schemes. In other words, the conjunction "or" should be understood to include "and/or". The term "comprising" is inclusive and has the same scope as "comprising".
The above-described embodiments, particularly any "preferred" embodiments, are possible examples of implementations, and are presented merely for a clear understanding of the principles of the invention. Many variations and modifications may be made to the above-described embodiments without departing substantially from the spirit and principles of the technology described herein. All such modifications are intended to be included within the scope of this disclosure.
Claims (10)
1. A method for breakpoint resume of nested queries, the method comprising the steps of:
analyzing the nested query instruction to divide the nested query instruction into query instructions of each layer by layer, and storing the query instructions of each layer and the layer numbers of each layer into a query comparison table;
executing the nested query instruction and storing a query result corresponding to the query instruction of each layer into the query comparison table according to the layer number;
in response to an interrupt occurring during execution of the nested query instruction, checking a last-bit query result in the query look-up table and determining an interrupt layer;
and replacing the sub query statement of the part corresponding to the query instruction of the interrupt layer in the nested query instruction by the last-bit query result, and continuously executing the replaced nested query instruction.
2. The method of claim 1, wherein parsing the nested query instruction to split the nested query instruction into query instructions for each layer, and storing the query instructions for each layer and the layer numbers for each layer in a query lookup table further comprises:
and resolving a query identifier in the nested query instruction, and splitting the nested query instruction by taking the query identifier as a keyword.
3. The method of claim 1, wherein parsing the nested query instruction to split the nested query instruction into query instructions for each layer, and storing the query instructions for each layer and the layer numbers for each layer in a query lookup table further comprises:
and splitting the nested query instruction layer by taking the query statement which does not contain the sub-query statement in the nested query instruction as the first layer of query instruction.
4. The method of claim 1, wherein said executing said nested query instructions and storing query results corresponding to query instructions for said respective layers in said query lookup table according to said layer numbers further comprises:
analyzing to obtain the related database fragments of the query instructions of each layer in the database, and respectively executing the query instructions of each layer on the related database fragments.
5. The method of claim 1, wherein, in response to an interrupt occurring during execution of the nested query instruction, checking a last bit of the query result in the query lookup table and determining a layer of interrupts further comprises:
and checking the query comparison table in sequence, and taking the first layer without the corresponding query result as the interrupt layer.
6. An apparatus for breakpoint resume of a nested query, the apparatus comprising:
at least one processor; and
a memory storing program code executable by the processor, the program code, when executed by the processor, performing the steps of:
analyzing the nested query instruction to divide the nested query instruction into query instructions of each layer by layer, and storing the query instructions of each layer and the layer numbers of each layer into a query comparison table;
executing the nested query instruction and storing a query result corresponding to the query instruction of each layer into the query comparison table according to the layer number;
in response to an interrupt occurring during execution of the nested query instruction, checking a last-bit query result in the query look-up table and determining an interrupt layer;
and replacing the sub query statement of the part corresponding to the query instruction of the interrupt layer in the nested query instruction by the last-bit query result, and continuously executing the replaced nested query instruction.
7. The apparatus of claim 6, wherein parsing the nested query instruction to split the nested query instruction into query instructions for each layer by layer, and storing the query instructions for each layer and the layer numbers for each layer in a query lookup table further comprises:
and resolving a query identifier in the nested query instruction, and splitting the nested query instruction by taking the query identifier as a keyword.
8. The apparatus of claim 6, wherein parsing the nested query instruction to split the nested query instruction into query instructions for each layer by layer, and storing the query instructions for each layer and the layer numbers for each layer in a query lookup table further comprises:
and splitting the nested query instruction layer by taking the query statement which does not contain the sub-query statement in the nested query instruction as the first layer of query instruction.
9. The apparatus of claim 6, wherein said executing the nested query instructions and storing the query results corresponding to the query instructions for each layer in the query lookup table according to the layer number further comprises:
analyzing to obtain the related database fragments of the query instructions of each layer in the database, and respectively executing the query instructions of each layer on the related database fragments.
10. The apparatus of claim 6, wherein the checking a last bit of the query result in the query lookup table and determining a interrupt layer in response to an interrupt occurring during execution of the nested query instruction further comprises:
and checking the query comparison table in sequence, and taking the first layer without the corresponding query result as an interruption layer.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910786416.3A CN110633300A (en) | 2019-08-23 | 2019-08-23 | Breakpoint continuous operation method and device for nested query |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910786416.3A CN110633300A (en) | 2019-08-23 | 2019-08-23 | Breakpoint continuous operation method and device for nested query |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN110633300A true CN110633300A (en) | 2019-12-31 |
Family
ID=68968946
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910786416.3A Withdrawn CN110633300A (en) | 2019-08-23 | 2019-08-23 | Breakpoint continuous operation method and device for nested query |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110633300A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113360495A (en) * | 2021-04-20 | 2021-09-07 | 山东英信计算机技术有限公司 | Database query interruption recovery method, device, equipment and readable medium |
| CN114443652A (en) * | 2022-01-07 | 2022-05-06 | 苏州浪潮智能科技有限公司 | Method, system and device for operating breakpoint SQL |
-
2019
- 2019-08-23 CN CN201910786416.3A patent/CN110633300A/en not_active Withdrawn
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113360495A (en) * | 2021-04-20 | 2021-09-07 | 山东英信计算机技术有限公司 | Database query interruption recovery method, device, equipment and readable medium |
| CN113360495B (en) * | 2021-04-20 | 2023-02-24 | 山东英信计算机技术有限公司 | Database query interruption recovery method, device, equipment and readable medium |
| CN114443652A (en) * | 2022-01-07 | 2022-05-06 | 苏州浪潮智能科技有限公司 | Method, system and device for operating breakpoint SQL |
| CN114443652B (en) * | 2022-01-07 | 2024-01-19 | 苏州浪潮智能科技有限公司 | Breakpoint SQL operation method, system and device |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US20180239800A1 (en) | Data query method and apparatus | |
| US11269902B2 (en) | Time series data management method, device, and apparatus | |
| US8122008B2 (en) | Joining tables in multiple heterogeneous distributed databases | |
| US20140298313A1 (en) | Method, server, client and system for updating data | |
| CN111309785B (en) | Database access method and device based on Spring framework, computer equipment and medium | |
| CN102129425B (en) | The access method of big object set table and device in data warehouse | |
| CN109542907B (en) | Database cache construction method and device, computer equipment and storage medium | |
| CN106407360B (en) | Data processing method and device | |
| US8812489B2 (en) | Swapping expected and candidate affinities in a query plan cache | |
| CN109379398B (en) | Data synchronization method and device | |
| CN107179940B (en) | Task execution method and device | |
| US20120102412A1 (en) | Synchronization of form fields in a client-server environment | |
| US20200142674A1 (en) | Extracting web api endpoint data from source code | |
| CN110633300A (en) | Breakpoint continuous operation method and device for nested query | |
| CN111914020A (en) | Data synchronization method and device and data query method and device | |
| CN112100152A (en) | Service data processing method, system, server and readable storage medium | |
| CN111240892A (en) | Data backup method and device | |
| WO2021068521A1 (en) | Data processing method, apparatus and device for local storage engine system | |
| CN107451203B (en) | Database access method and device | |
| CN113342839A (en) | Data processing method and device, terminal equipment and storage medium | |
| CN112434037A (en) | Data processing method, processing device, data processing apparatus, and storage medium | |
| CN107220265B (en) | Database statement compiling and executing method and device | |
| US10289710B2 (en) | Method for modifying root node, and modification apparatus | |
| US9679015B2 (en) | Script converter | |
| CN112818021B (en) | Data request processing method, device, computer equipment and storage medium |
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 | ||
| WW01 | Invention patent application withdrawn after publication | ||
| WW01 | Invention patent application withdrawn after publication |
Application publication date: 20191231 |