CN117743399A - Result set caching method, medium and computer equipment of database - Google Patents
Result set caching method, medium and computer equipment of database Download PDFInfo
- Publication number
- CN117743399A CN117743399A CN202311754609.3A CN202311754609A CN117743399A CN 117743399 A CN117743399 A CN 117743399A CN 202311754609 A CN202311754609 A CN 202311754609A CN 117743399 A CN117743399 A CN 117743399A
- Authority
- CN
- China
- Prior art keywords
- database
- result set
- failure condition
- self
- caching
- 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.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 50
- 238000012545 processing Methods 0.000 claims abstract description 29
- 238000012544 monitoring process Methods 0.000 claims abstract description 27
- 230000008859 change Effects 0.000 claims description 19
- 230000008569 process Effects 0.000 description 13
- 238000010586 diagram Methods 0.000 description 7
- 230000007613 environmental effect Effects 0.000 description 4
- 238000007418 data mining Methods 0.000 description 2
- 238000005516 engineering process Methods 0.000 description 2
- 230000006870 function Effects 0.000 description 2
- 238000010801 machine learning Methods 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 230000001413 cellular effect Effects 0.000 description 1
- 238000004891 communication Methods 0.000 description 1
- 238000004883 computer application Methods 0.000 description 1
- 230000001419 dependent effect Effects 0.000 description 1
- 230000005055 memory storage Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 239000013307 optical fiber Substances 0.000 description 1
- 238000005457 optimization Methods 0.000 description 1
- 238000012546 transfer Methods 0.000 description 1
- 230000001960 triggered effect Effects 0.000 description 1
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides a result set caching method, medium and computer equipment of a database. Wherein the method comprises the following steps: acquiring a self-defined result set; caching the self-defined result set to a database, and configuring failure conditions for the caching of the self-defined result set; monitoring the running state of the database and judging whether the running state meets the failure condition or not; if yes, performing failure processing on the self-defined result set related to the running state meeting the failure condition. By the method, the database can support the self-defined result set and can automatically fail the self-defined result set cache, so that the use experience of the database is improved.
Description
Technical Field
The present invention relates to the field of databases, and in particular, to a method, medium, and computer device for caching a result set of a database.
Background
In the current database, the caching of the result set is generally automatically maintained by a system according to user sentences, a user cannot perform secondary processing on data in the result set to obtain a self-defined result set and cache the self-defined result set, and in order to solve the problems, applications such as Redis are generally adopted to cache the self-defined result set, but the applications cannot realize automatic invalidation of the self-defined result set according to the actual conditions of the database, and the user is required to manually perform invalidation processing.
Disclosure of Invention
In view of the foregoing, the present invention provides a method, medium and computer device for caching a result set of a database that overcomes or at least partially solves the foregoing problems.
It is an object of the present invention to enable automatic invalidation of a database supporting custom result sets.
It is a further object of the invention to enhance the use experience of a database.
In particular, the present invention provides a method for caching a result set of a database, which includes:
acquiring a self-defined result set;
caching the self-defined result set to a database, and configuring failure conditions for the caching of the self-defined result set;
monitoring the running state of the database and judging whether the running state meets the failure condition or not;
if yes, performing failure processing on the self-defined result set related to the running state meeting the failure condition.
Optionally, the step of caching the custom result set in the database and configuring the invalidation condition for the caching of the custom result includes:
caching the self-defined result set into a memory of a database;
and configuring failure conditions for the self-defined result set, and recording the running state corresponding to the self-defined result set into a preset data table.
Optionally, the step of configuring the invalidation condition for the cache of the custom result set includes:
configuring a failure condition for the cache of the self-defined result set;
setting a trigger for the database running state related to the failure condition, wherein the trigger is used for carrying out failure processing on the self-defined result set when triggering.
Optionally, the failure condition includes a database table change;
the step of monitoring the running state of the database and judging whether the running state meets the failure condition further comprises: and monitoring the database table through the trigger, and judging that the running state meets the failure condition when the database table changes.
Optionally, the failure condition includes a change in data within the database table;
the step of monitoring the running state of the database and judging whether the running state meets the failure condition further comprises: and monitoring the data in the database table through the trigger, and judging that the running state meets the failure condition when the data in the database table changes.
Optionally, the failure condition comprises a database environmental parameter;
the step of monitoring the running state of the database and judging whether the running state meets the failure condition further comprises: and monitoring the database environment parameters through the trigger, and judging that the running state meets the failure condition when the database environment parameters change.
Optionally, the failure condition includes a change in the execution plan;
the step of monitoring the running state of the database and judging whether the running state meets the failure condition further comprises: acquiring a database operation statement; analyzing the database operation statement to obtain a first execution plan; acquiring a target user-defined result set corresponding to the database operation statement and a second execution plan corresponding to the target user-defined result set; judging whether the contents of the first execution plan and the second execution plan are consistent; if not, judging that the running state meets the failure condition.
Optionally, the step of obtaining the target custom result set corresponding to the database operation statement and the second execution plan corresponding to the target custom result set includes:
searching a target self-defined result set corresponding to the database operation statement in a preset data table, and acquiring an execution plan corresponding to the target self-defined result set as a second execution plan.
According to yet another aspect of the present invention, there is also provided a machine-readable storage medium having stored thereon a machine-executable program which, when executed by a processor, implements a result set caching method of a database of any of the above.
According to still another aspect of the present invention, there is also provided a computer device including a memory, a processor, and a machine executable program stored on the memory and running on the processor, and the processor implementing a result set caching method of any one of the databases described above when executing the machine executable program.
After the self-defined result set is obtained, the self-defined result set is cached to the database, and the failure condition is configured for the caching of the self-defined result, then the running state of the database is monitored, and whether the running state meets the failure condition is judged; if yes, performing failure processing on the self-defined result set related to the running state meeting the failure condition. By the method, the database can support the self-defined result set and can automatically fail the self-defined result set cache, so that the use experience of the database is improved.
The above, as well as additional objectives, advantages, and features of the present invention will become apparent to those skilled in the art from the following detailed description of a specific embodiment of the present invention when read in conjunction with the accompanying drawings.
Drawings
Some specific embodiments of the invention will be described in detail hereinafter by way of example and not by way of limitation with reference to the accompanying drawings. The same reference numbers will be used throughout the drawings to refer to the same or like parts or portions. It will be appreciated by those skilled in the art that the drawings are not necessarily drawn to scale. In the accompanying drawings:
FIG. 1 is a flow diagram of a result set caching method of a database according to one embodiment of the invention;
FIG. 2 is a flow chart of a result set caching method of a database according to another embodiment of the present invention;
FIG. 3 is a schematic diagram of a machine-readable storage medium in a result set caching method of a database according to one embodiment of the invention; and
fig. 4 is a schematic diagram of a computer device in a result set caching method of a database according to an embodiment of the present invention.
Detailed Description
It should be understood by those skilled in the art that the embodiments described below are only some embodiments of the present invention, but not all embodiments of the present invention, and the some embodiments are intended to explain the technical principles of the present invention and are not intended to limit the scope of the present invention. All other embodiments, which can be obtained by a person skilled in the art without any inventive effort, based on the embodiments provided by the present invention, shall still fall within the scope of protection of the present invention.
FIG. 1 is a flow diagram of a result set caching method of a database according to one embodiment of the invention.
In this embodiment, the process may generally include:
step S101, obtaining a self-defined result set. In this embodiment, the user-defined result set refers to that, in the process of using the database, the user generally performs secondary processing on the result set due to the requirement of actual service, and especially for complex data processing requirements, other technologies or tools may be further required to perform deeper secondary processing and analysis on the result set, such as data mining, machine learning, and the like. In the process, if such secondary processing operation is often needed in the execution process, the result set after secondary processing can be directly set as the self-defined result set, so that complex secondary processing operation is removed, and the execution speed of the database is further improved. The specific content of the custom result set can be determined by a person skilled in the art according to the actual situation.
Step S102, caching the self-defined result set to a database, and configuring a failure condition for the cache of the self-defined result set. In this embodiment, in order to implement automatic failure of the custom result set, a corresponding failure condition needs to be configured. The specific content of the failure condition can be set by those skilled in the art according to the actual situation of the database.
Step S103, monitoring the running state of the database and judging whether the running state meets the failure condition. In this embodiment, after determining that the failure condition is configured, the running state of the database needs to be monitored by a set means, so as to determine whether the running state meets the failure condition at any time, so as to ensure timely failure of the custom result set. Some alternative ways in which the database operating state is monitored are for example: the operation of the change is determined by looking at the log, the change of the data is captured and recorded by the data capturing tool, or the running state is monitored by the monitoring tool of the database, etc.
Step S104, when step S103 determines yes, performing the invalidation process on the custom result set related to the operation state satisfying the invalidation condition. In this step, when step S103 determines that yes, at this time, a failure process needs to be performed on the custom result set related to the running state that satisfies the failure condition, where some optional manners of the failure process are as follows: deleting the cache of the related self-defined result set in the database or marking the self-defined result set with an invalidation mark so that the system automatically ignores the cache of the self-defined result set and the like. The specific mode of failure processing can be set by the person skilled in the art according to the actual situation.
By the method, the database can support the self-defined result set and can automatically fail the self-defined result set cache, so that the use experience of the database is improved.
In some alternative embodiments, the step of caching the custom result set in the database and configuring the invalidation condition for the caching of the custom result set may generally include: caching the self-defined result set into a memory of a database; and configuring failure conditions for the self-defined result set, and recording the running state corresponding to the self-defined result set into a preset data table. In this step, recording the running state corresponding to the custom result set in the preset data table refers to recording running state data corresponding to the current state of the custom result set, for example, table information related to the custom result set, current environmental parameters of the database, execution plans of corresponding database operation sentences, and the like, so that when the running state is monitored to be changed subsequently, the corresponding custom result set can be found in time according to the changed running state, and failure processing is performed.
In other alternative embodiments, the step of configuring the invalidation condition for the cache of the custom result set may generally comprise: configuring a failure condition for the cache of the self-defined result set; setting a trigger for the database running state related to the failure condition, wherein the trigger is used for carrying out failure processing on the self-defined result set when triggering. In this embodiment, the trigger is a special monitoring tool that automatically executes when a specific operation occurs on the database table. The trigger can be used for realizing the operations of data integrity check, business rule implementation, data cascade update and the like. When the database running state changes, the trigger can judge whether the changed running state meets the failure condition, and under the condition of meeting the failure condition, the operation of failure processing is automatically triggered.
In some alternative embodiments, the failure condition may generally include a database table change; the step of monitoring the operational state of the database and determining whether the operational state satisfies the failure condition may generally further comprise: and monitoring the database table through the trigger, and judging that the running state meets the failure condition when the database table changes. In this embodiment, the failure condition may be set to be that the database table is changed, for example, the database table is deleted or the structure of the database table is changed, so that the user-defined result set corresponding to the database table cannot be used continuously, and at this time, it is determined that the database table meets the failure condition, so that the user-defined result set related to the database table is failed.
In other alternative embodiments, the failure condition may generally include a change in data within the database table; the step of monitoring the operational state of the database and determining whether the operational state satisfies the failure condition may generally further comprise: and monitoring the data in the database table through the trigger, and judging that the running state meets the failure condition when the data in the database table changes. In this embodiment, the failure condition may be set to change the data in the database table. For example, when the data of the database table changes, if the data in the cache is generated based on the data of the table, the cached custom result set will also change accordingly. This is because the cached custom result set is dependent on the data in the database table, and therefore, when the data in the database table changes, the running state is determined to satisfy the failure condition, and then the custom result set related to the data in the database table is subjected to failure processing.
In yet other alternative embodiments, the failure condition may generally include a database environment parameter; the step of monitoring the operational state of the database and determining whether the operational state satisfies the failure condition may generally further comprise: and monitoring the database environment parameters through the trigger, and judging that the running state meets the failure condition when the database environment parameters change. In this embodiment, the database environment parameters are various parameters for configuring and optimizing the database system operating environment, such as network parameters, security parameters, and memory parameters of the database. These parameters can affect the performance, stability and security of the database and can affect the caching of the custom result set when the parameters change. For example, a change in a memory parameter may result in a shortage of memory required for caching the result set, thereby affecting the performance of the existing custom result set cache. Therefore, when the environmental parameters of the database change, a result set cache which is possibly affected by the environmental parameters needs to be determined, and then the result set cache is subjected to invalidation treatment.
In some alternative embodiments, the failure condition may generally include a change in the execution plan; the step of monitoring the operational state of the database and determining whether the operational state satisfies the failure condition may generally further comprise: acquiring a database operation statement; analyzing the database operation statement to obtain a first execution plan; acquiring a target user-defined result set corresponding to the database operation statement and a second execution plan corresponding to the target user-defined result set; judging whether the contents of the first execution plan and the second execution plan are consistent; if not, judging that the running state meets the failure condition. In this embodiment, since most of the custom result sets correspond to one database operation statement, and the custom result set may be one node in the execution plan of the database operation statement, if the execution plan of the database operation statement is changed, the data in the corresponding custom result set may not conform to the changed execution plan, and if the custom result set is used continuously, the result may deviate, so that the first execution plan corresponding to the database operation statement and the second execution plan corresponding to the custom result set need to be compared, and if the two execution plans are different, failure processing needs to be performed on the custom result set, thereby ensuring accuracy of the execution result.
The step of obtaining the target custom result set corresponding to the database operation statement and the corresponding second execution plan thereof may generally include: searching a target self-defined result set corresponding to the database operation statement in a preset data table, and acquiring an execution plan corresponding to the target self-defined result set as a second execution plan.
Fig. 2 is a flow chart of a result set caching method of a database according to another embodiment of the present invention. In this embodiment, the process may generally include:
in this embodiment, since most of the custom result sets correspond to one database operation statement, and the custom result set may be a node in the execution plan of the database operation statement, if the execution plan of the database operation statement is changed, the data in the corresponding custom result set may not conform to the changed execution plan, and if the custom result set is used, the result may deviate, so the following steps are executed.
Step S201, a database operation sentence is acquired. In this embodiment, the database operation statement refers to a statement for controlling and modifying the database, an alternative example is SQL (Structured Query Language), and the SQL statement has multiple functions such as data manipulation and data definition, and the language has an interactivity feature, so that great convenience can be provided for users, and the database management system should make full use of the SQL language to improve the working quality and efficiency of the computer application system. The SQL language can be independently applied to the terminal, can also be used as a sub-language to provide effective assistance for other programming, and can optimize program functions together with other programming languages, so that more and more comprehensive information is provided for users.
Step S202, a target user-defined result set corresponding to the database operation statement and a second execution plan corresponding to the target user-defined result set are obtained. In this embodiment, the user-defined result set refers to that, in the process of using the database, the user generally performs secondary processing on the result set due to the requirement of actual service, and especially for complex data processing requirements, other technologies or tools may be further required to perform deeper secondary processing and analysis on the result set, such as data mining, machine learning, and the like. In the process, if such secondary processing operation is often needed in the execution process, the result set after secondary processing can be directly set as the self-defined result set, so that complex secondary processing operation is removed, and the execution speed of the database is further improved. The specific content of the custom result set can be determined by a person skilled in the art according to the actual situation.
This step may generally include: searching a target self-defined result set corresponding to the database operation statement in a preset data table, and acquiring an execution plan corresponding to the target self-defined result set as a second execution plan. In this embodiment, for each self-defined result set cache, the running state data corresponding to the current state of the self-defined result set is recorded in a preset data table, for example, information such as database operation sentences and corresponding execution plans related to the self-defined result set is recorded, so that when the running state is monitored to be changed subsequently, the corresponding self-defined result set can be found out in time according to the changed running state, and failure processing is performed.
Step S203, determining whether the contents of the first execution plan and the second execution plan are consistent. In this step, an alternative comparison is for example: the first execution plan and the second execution plan are exported as text, and differences in the two execution plans are then compared by a specific text comparison tool to determine whether the execution logic of the two execution plans agree.
Step S204, if the determination in step S203 is no, performing the invalidation process on the custom result set related to the operation state satisfying the invalidation condition. In this step, if step S203 determines that no, it indicates that the database operation statement generates a new execution plan after the database optimization, and at this time, it is necessary to perform invalidation processing on the custom result set buffer corresponding to the database operation statement in the database memory, and then execute to generate a corresponding result set again according to the first execution plan.
By the method, the database can realize automatic invalidation of the self-defined result set while supporting self-defined result set caching, so that the use experience of the database is improved.
The present implementation also provides a machine-readable storage medium and a computer device. Fig. 3 is a schematic diagram of a machine-readable storage medium 301 according to one embodiment of the invention, and fig. 4 is a schematic diagram of a computer device 403 according to one embodiment of the invention.
The machine-readable storage medium 301 has stored thereon a machine-executable program 302, which when executed by a processor, implements the result set caching method of the database of any of the embodiments described above.
The computer device 403 may include a memory 401, a processor 402, and a machine executable program 302 stored on the memory 401 and running on the processor 402, and the processor 402 implements the result set caching method of the database of any of the embodiments described above when executing the machine executable program 302.
It should be noted that the logic and/or steps represented in the flow diagrams or otherwise described herein, e.g., performing a failure process, may be embodied in any machine-readable storage medium for use by or in connection with an instruction execution system, apparatus, or device, such as a computer-based system, processor-containing system, or other system that can fetch the instructions from the instruction execution system, apparatus, or device and execute the instructions.
For the purposes of this description of embodiments, a machine-readable storage medium 301 can be any means that can contain, store, communicate, propagate, or transport the program for use by or in connection with the instruction execution system, apparatus, or device. More specific examples (a non-exhaustive list) of the machine-readable storage medium 301 include the following: an electrical connection (electronic device) having one or more wires, a portable computer diskette (magnetic device), a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber device, and a portable compact disc read-only memory (CDROM). Additionally, the machine-readable storage medium 301 may even be paper or other suitable medium upon which the program is printed, as the program may be electronically captured, via, for instance, optical scanning of the paper or other medium, then compiled, interpreted, or otherwise processed in a suitable manner if necessary, and then stored in a computer memory.
It is to be understood that portions of the present invention may be implemented in hardware, software, firmware, or a combination thereof. In the above-described embodiments, the various steps or methods may be implemented in software or firmware stored in a memory and executed by a suitable instruction execution system.
The computer device 403 may be, for example, a server, a desktop computer, a notebook computer, a tablet computer, or a smartphone. In some examples, computer device 403 may be a cloud computing node. Computer device 403 may be described in the general context of computer system-executable instructions, such as program modules, being executed by a computer system. Generally, program modules may include routines, programs, objects, components, logic, data structures, etc. that perform particular tasks or implement particular abstract data types. Computer device 403 may be implemented in a distributed cloud computing environment in which remote processing devices that are linked through a communications network perform tasks. In a distributed cloud computing environment, program modules may be located in both local and remote computing system storage media including memory storage devices.
Computer device 403 may include a processor 402 adapted to execute stored instructions, a memory 401 providing temporary storage space for the operation of the instructions during operation. Processor 402 may be a single-core processor, a multi-core processor, a computing cluster, or any number of other configurations. Memory 401 may include Random Access Memory (RAM), read only memory, flash memory, or any other suitable storage system.
The processor 402 may be connected via a system interconnect (e.g., PCI-Express, etc.) to an I/O interface (input/output interface) adapted to connect the computer device 403 to one or more I/O devices (input/output devices). The I/O devices may include, for example, a keyboard and a pointing device, which may include a touch pad or touch screen, among others. The I/O device may be a built-in component of the computer device 403 or may be a device externally connected to the computing device.
The processor 402 may also be linked through a system interconnect to a display interface adapted to connect the computer device 403 to a display device. The display device may include a display screen as a built-in component of the computer device 403. The display device may also include a computer monitor, television, projector, or the like, which is externally connected to the computer device 403. Further, a network interface controller (network interface controller, NIC) may be adapted to connect the computer device 403 to a network through a system interconnect. In some embodiments, the NIC may use any suitable interface or protocol (such as an internet small computer system interface, etc.) to transfer data. The network may be a cellular network, a radio network, a Wide Area Network (WAN), a Local Area Network (LAN), or the internet, among others. The remote device may be connected to the computing device through a network.
The flowcharts provided by this embodiment are not intended to indicate that the operations of the method are to be performed in any particular order, or that all of the operations of the method are included in all of each case. Furthermore, the method may include additional operations. Additional variations may be made to the above-described methods within the scope of the technical ideas provided by the methods of the present embodiments.
By now it should be appreciated by those skilled in the art that while a number of exemplary embodiments of the invention have been shown and described herein in detail, many other variations or modifications of the invention consistent with the principles of the invention may be directly ascertained or inferred from the present disclosure without departing from the spirit and scope of the invention. Accordingly, the scope of the present invention should be understood and deemed to cover all such other variations or modifications.
Claims (10)
1. A result set caching method for a database, comprising:
acquiring a self-defined result set;
caching the self-defined result set to the database, and configuring a failure condition for the cache of the self-defined result set;
monitoring the running state of the database and judging whether the running state meets the failure condition or not;
if yes, performing failure processing on the self-defined result set related to the running state meeting the failure condition.
2. The method for caching a result set in a database as claimed in claim 1, wherein,
the step of caching the custom result set in the database and configuring a failure condition for the cache of the custom result includes:
caching the self-defined result set into a memory of the database;
and configuring failure conditions for the self-defined result set, and recording the running state corresponding to the self-defined result set into a preset data table.
3. The method for caching a result set in a database as claimed in claim 2, wherein,
the step of configuring the invalidation condition for the cache of the self-defined result set comprises the following steps:
configuring a failure condition for the cache of the self-defined result set;
setting a trigger for the database running state related to the failure condition, wherein the trigger is used for carrying out failure processing on the self-defined result set when triggering.
4. The method for caching a result set in a database according to claim 3, wherein,
the failure condition comprises a database table change;
the step of monitoring the operation state of the database and judging whether the operation state meets the failure condition further comprises the following steps: and monitoring the database table through the trigger, and judging that the running state meets the failure condition when the database table changes.
5. The method for caching a result set in a database according to claim 3, wherein,
the failure condition comprises the change of data in a database table;
the step of monitoring the operation state of the database and judging whether the operation state meets the failure condition further comprises the following steps: and monitoring the data in the database table through the trigger, and judging that the running state meets the failure condition when the data in the database table changes.
6. The method for caching a result set in a database according to claim 3, wherein,
the failure condition comprises a database environment parameter;
the step of monitoring the operation state of the database and judging whether the operation state meets the failure condition further comprises the following steps: and monitoring the database environment parameters through the trigger, and judging that the running state meets the failure condition when the database environment parameters change.
7. The method for caching a result set in a database according to claim 3, wherein,
the failure condition includes a change in execution plan;
the step of monitoring the operation state of the database and judging whether the operation state meets the failure condition further comprises the following steps: acquiring a database operation statement; analyzing the database operation statement to obtain a first execution plan; acquiring a target custom result set corresponding to the database operation statement and a second execution plan corresponding to the target custom result set; judging whether the contents of the first execution plan and the second execution plan are consistent; if not, judging that the running state meets the failure condition.
8. The method for caching results set in a database as claimed in claim 7, wherein,
the step of obtaining the target custom result set corresponding to the database operation statement and the corresponding second execution plan comprises the following steps:
searching a target custom result set corresponding to the database operation statement in the preset data table, and acquiring an execution plan corresponding to the target custom result set as the second execution plan.
9. A machine-readable storage medium having stored thereon a machine-executable program which when executed by a processor implements a result set caching method of a database according to any of claims 1 to 8.
10. A computer device comprising a memory, a processor and a machine executable program stored on the memory and running on the processor, and the processor implementing a result set caching method of a database according to any one of claims 1 to 8 when executing the machine executable program.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202311754609.3A CN117743399A (en) | 2023-12-19 | 2023-12-19 | Result set caching method, medium and computer equipment of database |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202311754609.3A CN117743399A (en) | 2023-12-19 | 2023-12-19 | Result set caching method, medium and computer equipment of database |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN117743399A true CN117743399A (en) | 2024-03-22 |
Family
ID=90250385
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202311754609.3A Pending CN117743399A (en) | 2023-12-19 | 2023-12-19 | Result set caching method, medium and computer equipment of database |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN117743399A (en) |
-
2023
- 2023-12-19 CN CN202311754609.3A patent/CN117743399A/en active Pending
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN100576172C (en) | A kind of method of determining that function point changes that changes by code analysis | |
| US11676114B2 (en) | Automated control of distributed computing devices | |
| CN110688305A (en) | Test environment synchronization method, device, medium and electronic equipment | |
| CN113760306A (en) | Method and device for installing software, electronic equipment and storage medium | |
| CN111966382A (en) | Online deployment method and device of machine learning model and related equipment | |
| CN117389843B (en) | Intelligent operation and maintenance system, method, electronic equipment and storage medium | |
| CN112905225A (en) | Method and device for creating continuous integration tool construction task | |
| CN108959508B (en) | SQL data generation method and device | |
| CN117076491A (en) | Data processing method, storage medium and equipment | |
| CN111258618A (en) | File configuration method and device, computer equipment and storage medium | |
| CN117743399A (en) | Result set caching method, medium and computer equipment of database | |
| CN110716949A (en) | Method, device, medium and electronic equipment for automatically optimizing structured query statement | |
| CN112559233B (en) | Method, device, equipment and computer readable medium for identifying fault type | |
| CN110806967A (en) | Unit testing method and device | |
| CN111711713B (en) | Data access method, computer device and storage medium | |
| CN112559001B (en) | Method and device for updating application | |
| CN110727457A (en) | Component management method, device, storage medium and electronic equipment | |
| CN111026466A (en) | File processing method and device, computer readable storage medium and electronic equipment | |
| CN118093667A (en) | Method, medium and computer equipment for inquiring statistical quantity of distributed database | |
| CN112965747B (en) | Method, apparatus, device and computer readable medium for mining code loopholes | |
| CN117633040A (en) | Processing method, medium and computer equipment for local temporary table of database | |
| CN117762999A (en) | Processing method, medium and computer equipment for database operation statement | |
| CN110727739B (en) | Data storage method and device | |
| CN118035210A (en) | Data dictionary management method, storage medium, device and product of database | |
| CN116595010A (en) | Database index optimization method, storage medium and device |
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 | ||
| CB02 | Change of applicant information |
Country or region after: China Address after: 100102 201, 2 / F, 101, No. 5 building, No. 7 Rongda Road, Chaoyang District, Beijing Applicant after: China Electronics Technology Group Jincang (Beijing) Technology Co.,Ltd. Address before: 100102 201, 2 / F, 101, No. 5 building, No. 7 Rongda Road, Chaoyang District, Beijing Applicant before: BEIJING KINGBASE INFORMATION TECHNOLOGIES Inc. Country or region before: China |
|
| CB02 | Change of applicant information |