Database cursor query method and device, equipment and storage medium
A query method and database technology, applied in the field of devices, database cursor query methods, equipment and storage media, can solve the problems of database system resource waste, database consumption of large storage space, and reduce cursor operation execution time, etc., to achieve reduced time, Improve cursor query efficiency and reduce storage space
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
Method used
Image
Examples
Embodiment 1
[0029] image 3 It is a flow chart of a database cursor query method provided by Embodiment 1 of the present invention. This embodiment is applicable to the situation where the query result is obtained through the cursor in the database. The method can be executed by a database cursor query device, and the device can use hardware and / or software, see image 3 , the method provided by the embodiment of the present invention generally specifically includes the following steps:
[0030] Step 101, obtain query results according to the query statement, and return the query results in the cache in advance.
[0031] Wherein, the query statement is a structured statement for the database to query the data table, specifically, it may be an SQL query statement, and the syntax of the query statement corresponding to databases of different manufacturers may be different. The query result may be the data queried in the database table according to the query statement, and the query result...
Embodiment 2
[0041] Figure 4It is a flow chart of a database cursor query method provided by Embodiment 2 of the present invention. The embodiment of the present invention is based on the above-mentioned embodiments. Refer to Figure 4 , the database cursor query method provided by the embodiment of the present invention includes the following steps:
[0042] Step 201, obtain query results according to the query statement, and return the query results in the cache in advance.
[0043] In the embodiment of the present invention, due to the limitation of the cache space, the query statement acquires the query results in batches, and the size of the space occupied by each batch of query results may be smaller than or equal to the size of the threshold space. After the virtual machine obtains a batch of query results through the query statement, before generating the result data set, the batch of query results in the cache can be returned in advance.
[0044] Step 202. Determine whether the...
Embodiment 3
[0082] Figure 7 It is a schematic structural diagram of a database query device provided in Embodiment 3 of the present invention, which can execute the database query method provided in any embodiment of the present invention, and has corresponding functional modules and beneficial effects for executing the method. The device can be implemented by software and / or hardware, and specifically includes: a data query module 301 , a cursor setting module 302 and a result query module 303 .
[0083] The data query module 301 is configured to obtain query results according to query statements, and return the query results in the cache in advance.
[0084] The cursor setting module 302 is configured to set a cursor result set of the cursor according to the returned cache address of the query result.
[0085] The result query module 303 reads the query result according to the cursor.
[0086] In the embodiment of the present invention, the data query module obtains the query result ...
PUM
Abstract
Description
Claims
Application Information
- R&D Engineer
- R&D Manager
- IP Professional
- Industry Leading Data Capabilities
- Powerful AI technology
- Patent DNA Extraction
Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.
© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com