CN116010438B - Method and system for calculating database operation delay - Google Patents
Method and system for calculating database operation delay Download PDFInfo
- Publication number
- CN116010438B CN116010438B CN202211660760.6A CN202211660760A CN116010438B CN 116010438 B CN116010438 B CN 116010438B CN 202211660760 A CN202211660760 A CN 202211660760A CN 116010438 B CN116010438 B CN 116010438B
- Authority
- CN
- China
- Prior art keywords
- database
- database operation
- analysis processing
- result
- operation object
- 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
Links
- 238000000034 method Methods 0.000 title claims abstract description 50
- 239000012634 fragment Substances 0.000 claims abstract description 55
- 230000008569 process Effects 0.000 claims abstract description 25
- 238000004458 analytical method Methods 0.000 claims description 103
- 238000004364 calculation method Methods 0.000 claims description 23
- 230000002194 synthesizing effect Effects 0.000 claims description 7
- 239000002699 waste material Substances 0.000 description 5
- 230000009467 reduction Effects 0.000 description 4
- 238000012098 association analyses Methods 0.000 description 3
- 230000003111 delayed effect Effects 0.000 description 2
- 230000009191 jumping Effects 0.000 description 2
- 238000010276 construction Methods 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 238000007667 floating Methods 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004044 response Effects 0.000 description 1
- 230000001960 triggered effect Effects 0.000 description 1
- 238000011144 upstream manufacturing Methods 0.000 description 1
Classifications
-
- 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
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The application discloses a method and a system for calculating database operation delay, wherein the method comprises the following steps: defining an object attribute structure of the database operation object according to the elements contained in the database operation object; receiving and analyzing a user database operation request, and generating a database operation object according to the object attribute structure; analyzing the database operation object to generate an SQL statement of the user database operation request; executing the SQL sentence and returning an execution result; in S103, multiple parsing processes are performed on the database operation object, multiple SQL statement fragments are generated, and the multiple SQL statement fragments are synthesized into a complete SQL statement, so that delay computation processing of database operation is implemented, intermediate tables generated in the database operation processing process are reduced, and utilization rate of database resources and database operation processing performance are improved.
Description
Technical Field
The present application relates to the field of database technologies, and in particular, to a method and a system for calculating a database operation delay.
Background
Database operations refer to a series of operations performed on data on a database in response to an application request, including reading data, writing data, updating or modifying data, deleting data, and the like. Databases are the most common component of application in implementing related database operations, the data types of which include integer, character, date, floating point, etc. The database operations such as reading data, writing data, updating or modifying data, deleting data and the like can be realized in the database through construction and execution of SQL sentences.
In practical applications, database operations executed by the database are often complex, deep and associated more, resulting in that related database operations cannot be realized only by simple SQL sentences. In this case, the database needs to perform association analysis on the dependency relationship between database operations.
Taking a database table as an example, in the prior art, when dependency relationships between database operations are subjected to association analysis, a nested relationship exists between the dependency relationships, each dependency relationship corresponds to one database operation, and each database operation generates a complete SQL sentence and generates an intermediate table. In order to return a database operation result to an application request, when a corresponding database operation is processed, a series of database operation operations are often required to generate a plurality of SQL sentences and generate a plurality of intermediate tables, and the database operations cause a large amount of database resources to be occupied, including storage space, computing resources, cache space, networks and the like, so that the waste of the database resources is caused, and the overall performance of the database operation processing is further reduced. Therefore, in the prior art, the database operation is subjected to association analysis, each database operation is subjected to real-time calculation, and a complete SQL sentence and a corresponding intermediate table are generated, so that the complex database operation processing requirement cannot be met.
Based on this, a new method and system are necessary to be introduced, which can meet the complex database operation processing requirements, so as to solve the technical problems of the prior art that each database operation needs real-time operation and generates an intermediate table, resulting in the waste of database resources and the reduction of processing performance, thereby realizing the delayed calculation processing of the database operation, reducing the generation of the intermediate table in the database operation processing process, improving the utilization rate of database resources and the database operation processing efficiency, and the overall processing performance of the database.
Disclosure of Invention
Aiming at the technical problems, the application provides a method and a system for delaying calculation of database operation, which are used for defining an object attribute structure of a database operation object, converting each database operation in complex database operation by the object attribute structure to generate a corresponding SQL sentence fragment, synthesizing all SQL sentence fragments into a complete SQL sentence, finally executing the complete SQL sentence and obtaining an execution result, realizing the delayed calculation processing of the database operation, reducing the generation of intermediate tables in the database operation processing process, solving the technical problems of real-time operation and intermediate table generation in each database operation in the prior art, causing database resource waste, processing performance reduction and the like, further improving the database resource utilization rate and the database operation processing efficiency during database operation processing, and improving the overall processing performance of a database.
The application provides a method for calculating database operation delay, which comprises the following steps:
s101, defining an object attribute structure of a database operation object according to elements contained in the database operation object;
s102, receiving and analyzing a user database operation request, and generating a database operation object according to the object attribute structure;
s103, analyzing the database operation object to generate an SQL statement of the user database operation request;
s104, executing the SQL statement and returning an execution result;
the parsing process performed on the database operation object in S103 is performed multiple times, and multiple SQL statement fragments are generated, and the multiple SQL statement fragments are synthesized into a complete SQL statement.
As described above, the object attribute structure includes: database operation object name, database table identification, object dependency, database operation, SQL statement field.
As described above, the step of performing the parsing process on the database operation object a plurality of times in S103 includes:
initializing analysis processing of the database operation object to obtain an analysis processing initial result and an initialization SQL sentence fragment;
the analysis processing initial result comprises the assignment of the database operation object name, the database table name, the object dependency relationship and the database operation, and the database table identification is marked as False;
the initializing SQL statement fragment comprises database operation for analyzing and processing initial results and 2 fields of database table names of current analyzing and processing results, and the specific structure is as follows:
the database operation from of the Select parsing initial result { database table name of the current parsing result }.
As described above, the step of performing the multiple parsing process on the database operation object in S103 is a recursive parsing process, and the recursive parsing process includes the steps of:
analyzing the database operation object in a recursion mode to obtain a current analysis processing result and a recursion SQL sentence fragment of the current analysis processing result;
judging whether to continue the recursion analysis processing according to the database table identification in the current analysis processing result;
when the database table in the current analysis processing result is marked as False, continuing the recursion analysis processing, and obtaining a subsequent analysis processing result and a recursion SQL sentence fragment of the subsequent analysis processing result; and stopping the recursive analysis processing when the database table in the current analysis processing result is marked as True, and synthesizing the initialized SQL sentence fragments and all the recursive SQL sentence fragments into a complete SQL sentence.
As described above, the recursive SQL statement fragment includes 2 fields of database operation of the current parsing result and database table name of the subsequent parsing result, and the specific structure is:
the database operation from of the current analysis processing result of Select { database table name of the subsequent analysis processing result }.
As described above, the determining whether to continue the recursive parsing process according to the database table identifier in the current parsing result further includes;
the database table identification is obtained according to the comparison of the database table name and the table names in the database;
when the database table names are the same as the table names in the database, the database table is identified as True; when the database table name and the table name in the database are not the same, the database table is identified as False.
Correspondingly, the application also provides a system for implementing the method for calculating the database operation delay, which comprises a database object definition unit, a request analysis unit, an object analysis unit and an execution unit;
wherein,
the database object definition unit is used for defining an object attribute structure of the database operation object according to the elements contained in the database operation object;
the request analysis unit is used for receiving and analyzing a user database operation request and generating a database operation object according to the object attribute structure;
the object analysis unit is used for analyzing the database operation object and generating an SQL statement of the user database operation request;
the execution unit is used for executing the SQL statement and returning an execution result.
By applying the technical scheme, the application realizes the object attribute structure of the database operation object by definition, and the object attribute structure converts each database operation in the complex database operation to generate a corresponding SQL sentence fragment, all SQL sentence fragments are synthesized into a complete SQL sentence, and finally the complete SQL sentence is executed and an execution result is obtained, thereby completing the delay calculation processing of the database operation, reducing the generation of intermediate tables in the database operation processing process, solving the technical problems of database resource waste, processing performance reduction and the like caused by real-time operation and generation of intermediate tables in each database operation in the prior art, further improving the database resource utilization rate and the database operation processing efficiency in the database operation processing, and improving the overall processing performance of the database.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present application, the drawings that are needed in the description of the embodiments will be briefly described below, it being obvious that the drawings in the following description are only some embodiments of the present application, and that other drawings may be obtained according to these drawings without inventive effort for a person skilled in the art.
FIG. 1 is a schematic flow chart of a database operation delay calculation method according to an embodiment of the application;
FIG. 2 is a schematic flow chart of a recursive parsing process of a database operation delay calculation method according to an embodiment of the present application;
FIG. 3 is a schematic diagram of a database operation delay computing system according to an embodiment of the present application.
Detailed Description
The following description of the embodiments of the present application will be made clearly and completely with reference to the accompanying drawings, in which it is apparent that the embodiments described are only some embodiments of the present application, but not all embodiments. All other embodiments, which can be made by those skilled in the art based on the embodiments of the application without making any inventive effort, are intended to be within the scope of the application.
The application provides a method for calculating database operation delay, as shown in fig. 1, which comprises the following steps:
s101, defining an object attribute structure of the database operation object according to the elements contained in the database operation object.
In this embodiment, the object attribute structure includes: database operation object name, database table identification, object dependency, database operation, SQL statement field.
The object attribute structure is shown in table 1.
TABLE1
For ease of understanding and use, in some embodiments of the present application, the object attribute structure is abstracted into fields denoted by english acronyms, for example, as shown in table 2, the database operation object name is denoted as dbo _name, the database table name is denoted as table_name, the database table identifier is denoted as computer, the object dependency is denoted as dependencies, the database operation is denoted as operator, and the SQL statement field is denoted as sql_fragment.
TABLE 2
S102, receiving and analyzing a user database operation request, and generating a database operation object according to the object attribute structure.
S103, analyzing the database operation object to generate the SQL statement of the user database operation request.
In S103, parsing is performed on the database operation object for multiple times, and multiple SQL statement fragments are generated, and the multiple SQL statement fragments are synthesized into a complete SQL statement.
Optionally, the step of performing the parsing process on the database operation object in S103 includes: initializing analysis processing of the database operation object to obtain an analysis processing initial result and an initialization SQL sentence fragment.
The analysis processing initial result comprises the steps of assigning values to the database operation object names, the database table names, the object dependency relationships and the database operation, and marking the database table identification as False; the initialization SQL statement fragment is stored in an SQL statement field in the analysis processing initial result.
The initializing SQL statement fragment comprises database operation for analyzing and processing initial results and 2 fields of database table names of current analyzing and processing results, and the specific structure is as follows:
the database operation from of the Select parsing initial result { database table name of the current parsing result }.
In order to ensure that each database operation in the database operation processing procedure can be processed, in this embodiment, the step of performing the multiple parsing processing on the database operation object in S103 is a recursive parsing processing, where the recursive parsing processing includes the steps of:
performing recursion analysis processing on the database operation object to obtain a current analysis processing result and a recursion SQL sentence fragment of the current analysis processing result; and the recursive SQL sentence fragment corresponding to the current analysis processing result is stored in an SQL sentence field in the current analysis processing result.
Judging whether to continue the recursion analysis processing according to the database table identification in the current analysis processing result;
when the database table in the current analysis processing result is marked as False, continuing the recursion analysis processing, and obtaining a subsequent analysis processing result and a corresponding recursion SQL sentence fragment; the recursive SQL sentence fragments corresponding to the subsequent analysis processing results are stored in SQL sentence fields in the subsequent analysis processing results;
and stopping the recursive analysis processing when the database table in the current analysis processing result is marked as True, and synthesizing the initialized SQL sentence fragments and all the recursive SQL sentence fragments into a complete SQL sentence.
The recursive SQL statement fragment comprises 2 fields of database operation of the current analysis processing result and database table names of the subsequent analysis processing result, and the specific structure is as follows:
the database operation from of the current analysis processing result of Select { database table name of the subsequent analysis processing result }.
S104, executing the SQL statement and returning an execution result.
In order to uniformly manage the database table identifiers, in some embodiments of the present application, the SQL statement is executed, and the database table identifier corresponding to the initial result of the parsing process is marked as True while the execution result is returned; and naming and creating a new database table by the name of the database table in the initial result of the analysis processing, and storing the new database table in a database.
Alternatively, in some embodiments of the present application, the user may trigger the actual database operation calculation by calling the computer () method, execute the SQL statement, create an entity table whose database table name is the database table name in the initial result of the parsing process, and return the execution result, while marking the database table identifier of the entity table as True.
When the operation calculation of the database is triggered, the corresponding SQL statement is required to be provided for the database, and specific trigger conditions are set according to the sequence of the triggering:
condition 1, such as meeting the topological relation of the graph;
condition 2, the degree of entry of an object whose computed is True is considered to be 0;
condition 3, contains only objects whose topological relationship is upstream.
And (3) simultaneously meeting the conditions 1, 2 and 3, triggering database operation calculation, executing the SQL sentence, creating an entity table with a database table name in the initial analysis processing result, returning an execution result, and marking the database table identifier of the entity table as True.
As shown in fig. 2, the step of performing the multiple parsing process on the database operation object in S103 is a recursive parsing process, where the recursive parsing process includes:
s201, performing recursion analysis processing on the database operation object to obtain a current analysis processing result and a recursion SQL sentence fragment of the current analysis processing result.
S202, judging whether to continue the recursion analysis processing according to the database table identification in the current analysis processing result.
In order to accurately obtain the value of the database table identifier in the current parsing result, in some embodiments of the present application, the determining whether to proceed with the recursive parsing according to the database table identifier in the current parsing result includes:
the database table identification is obtained according to the comparison of the database table name and the table names in the database; when the database table names are the same as the table names in the database, the database table is identified as True; when the database table name and the table name in the database are not the same, the database table is identified as False.
Optionally, in some embodiments of the present application, the determining whether to continue the recursive analysis according to the database table identifier in the current analysis result further includes determining whether to continue the recursive analysis according to a calculation identifier, where the steps include:
adding a calculation identifier for a database table, and assigning a value of the calculation identifier of the database to 1 when the database table is created; when the database table is deleted, assigning a value of 0 to a calculation identifier of the database;
judging whether to continue the recursion analysis processing according to the calculation identification of the database; when the value of the calculation identifier of the database is greater than or equal to 1, the database table identifier is True; when the value of the calculated identity of the database is equal to 0, the database table is identified as False.
The calculation identifier of the database table is used for indicating whether the database table is calculated, namely whether the database table actually exists in a database, and when the value of the calculation identifier of the database is more than or equal to 1, the calculation identifier of the database table indicates that the database table is calculated, namely the database table actually exists; when the value of the calculation identifier of the database is equal to 0, the database table is not calculated, namely the database table does not exist in reality, and is a virtual database table.
It should be noted that, a person skilled in the art may set other types of identifiers for the database table according to the actual application scenario, so as to indicate whether the database table actually exists, which does not affect the protection scope of the present application.
And S203, when the database table in the current analysis processing result is marked as False, continuing the recursion analysis processing, obtaining a subsequent analysis processing result and a recursion SQL sentence fragment of the subsequent analysis processing result, and jumping to the step S205.
In this embodiment, the recursive SQL statement fragment includes 2 fields of a database operation of a current analysis processing result and a database table name of a subsequent analysis processing result, and the specific structure is:
the database operation from of the current analysis processing result of Select { database table name of the subsequent analysis processing result }.
S204, when the database table in the current analysis processing result is identified as True, stopping the recursion analysis processing, and jumping to step S205.
S205, synthesizing the initialization SQL sentence fragments and all the recursion SQL sentence fragments into a complete SQL sentence.
In order to facilitate a better understanding of the method for calculating a database operation delay provided by the present application, a further description will be given of the method for calculating a database operation delay provided by the present application with reference to examples.
For example, when the received user database operation request is the first 5 columns of the query database table, the user database operation request is parsed, and a database operation object dbo _01 is generated according to the object attribute structure; wherein the name of the database operation object is dbo _01.
And initializing the analysis processing of the database operation object dbo _01 to obtain an analysis processing initial result and an initialization SQL statement fragment.
The initial analysis result includes 2 database tables with the names of a table and b table respectively related to the database operation object dbo _01, the database table of the a table is identified as False, the database operation of the database operation object dbo _01 is b=a.head (5), and the object dependency relationship is the relationship between the a table and the b table; the initialization SQL statement fragment is as follows:
select { Table a } limit5.
And according to the database table identifier of the table a in the initial analysis result, performing analysis processing on the database operation object dbo _01 to obtain the current analysis processing result and a recursion SQL sentence fragment of the current analysis processing result.
The current analysis processing result comprises a database operation object dbo _02 with a database operation object name dbo _02, and a database table with a database table name a table, wherein the database table of the a table is identified, and the database operation object dbo _02 is used for database operation and object dependency relationship.
Judging whether to continue the recursion analysis processing according to the database table identifier of the table a in the current analysis processing result;
and stopping the recursive analysis processing when the database table of the table a is identified as True, so as to obtain the follow-up analysis processing result and the recursive SQL statement fragment of the follow-up analysis processing result which are both null values.
Synthesizing the initialized SQL statement fragment and the recursion SQL statement fragment into a complete SQL statement, wherein the specific structure of the SQL statement is as follows:
create table{b.table_name}as with
table1 as (select { Table a } limit 5)
select*from{b.table_name}。
When the database table of the table a is marked as False, continuing the recursive analysis processing to obtain the subsequent analysis processing result and a recursive SQL sentence fragment of the subsequent analysis processing result, and obtaining that the database operation in the database operation object dbo _02 is a=c.head (5), wherein the object dependency relationship is the relationship between the table c and the table a; the recursive SQL statement fragment of the current analysis processing result is as follows:
select from { table c }.
The subsequent analysis processing result comprises a database operation object dbo _03 with a database operation object name dbo _03, and a database table with a database table name c table, wherein the database table of the c table is marked as True, and both the database operation and the object dependency relationship in the database operation object dbo _02 are null values; the recursive SQL sentence fragment of the subsequent analysis processing result is also a null value.
Synthesizing the initialized SQL statement fragment and the recursion SQL statement fragment into a complete SQL statement, wherein the specific structure of the SQL statement is as follows:
create table{b.table_name}as with
table1 as (select { Table a } limit 5)
{ Table a } as (select from { Table c })
select*from{b.table_name}。
Calling a computer () method, submitting the SQL statement to the computer () method, triggering actual database operation calculation, executing the SQL statement, creating an entity table with a database table name of b, returning an execution result, and marking the database table identifier of the entity table as True.
By applying the technical scheme, the object attribute structure of the database operation object is defined according to the elements contained in the database operation object; receiving and analyzing a user database operation request, and generating a database operation object according to the object attribute structure; analyzing the database operation object to generate an SQL statement of the user database operation request; executing the SQL sentence and returning an execution result; the method and the device realize that by defining the object attribute structure of the database operation object, the object attribute structure converts each database operation in the complex database operation to generate a corresponding SQL sentence fragment, all SQL sentence fragments are synthesized into a complete SQL sentence, and finally the complete SQL sentence is executed and an execution result is obtained, thereby completing the delay calculation processing of the database operation, reducing the generation of intermediate tables in the database operation processing process, solving the technical problems of the prior art that each database operation needs real-time operation and generates intermediate tables, resulting in the waste of database resources, the reduction of processing performance and the like, further improving the database resource utilization rate and the database operation processing efficiency in the database operation processing, and improving the overall processing performance of the database.
Corresponding to a method for calculating the database operation delay in the embodiment of the application, the application also discloses a system for calculating the database operation delay, which comprises a database object definition unit, a request analysis unit, an object analysis unit and an execution unit as shown in fig. 3.
Wherein,
the database object definition unit is used for defining an object attribute structure of the database operation object according to the elements contained in the database operation object;
the request analysis unit is used for receiving and analyzing a user database operation request and generating a database operation object according to the object attribute structure;
the object analysis unit is used for analyzing the database operation object and generating an SQL statement of the user database operation request;
the execution unit is used for executing the SQL statement and returning an execution result.
In this specification, each embodiment is described in a related manner, and identical and similar parts of each embodiment are all referred to each other, and each embodiment mainly describes differences from other embodiments.
The foregoing description is only of the preferred embodiments of the present application and is not intended to limit the scope of the present application. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present application are included in the protection scope of the present application.
Claims (4)
1. A method of database operation delay computation, the method comprising:
s101, defining an object attribute structure of a database operation object according to elements contained in the database operation object;
s102, receiving and analyzing a user database operation request, and generating a database operation object according to the object attribute structure;
s103, analyzing the database operation object to generate an SQL statement of the user database operation request;
s104, executing the SQL statement and returning an execution result;
the method is characterized in that the analysis processing executed on the database operation object in S103 is repeated, a plurality of SQL sentence fragments are generated through the repeated analysis processing, and the SQL sentence fragments are synthesized into a complete SQL sentence;
wherein,
the object attribute structure includes the following fields: the method comprises the steps of beta database operation object name, database table identification, object dependency relationship, database operation and SQL statement;
the step of performing the parsing process on the database operation object a plurality of times in S103 is a recursive parsing process, where the recursive parsing process includes:
analyzing the database operation object in a recursion mode to obtain a current analysis processing result and a recursion SQL sentence fragment of the current analysis processing result;
judging whether to continue the recursion analysis processing according to the database table identification in the current analysis processing result;
when the database table in the current analysis processing result is marked as False, continuing the recursion analysis processing, and obtaining a subsequent analysis processing result and a recursion SQL sentence fragment of the subsequent analysis processing result; stopping the recursive analysis processing when the database table in the current analysis processing result is marked as True, and synthesizing the initialized SQL sentence fragments and all the recursive SQL sentence fragments together into a complete SQL sentence;
the step of judging whether to continue the recursive parsing process according to the database table identifier in the current parsing result further includes:
the database table identification is obtained according to the comparison of the database table name and the table names in the database;
when the database table names are the same as the table names in the database, the database table is identified as True; when the database table name and the table name in the database are not the same, the database table is identified as False.
2. The method according to claim 1, wherein the step of performing the parsing process on the database operation object a plurality of times in S103 includes:
initializing the analysis processing of the database operation object to obtain an initial result of the analysis processing and an initialized SQL sentence fragment;
wherein the initial result of the parsing process includes assigning values to the database operation object name, the database table name, the object dependency relationship, and the database operation, and marking the database table identifier as False;
the initializing SQL statement fragment comprises database operation for analyzing and processing initial results and 2 fields of database table names of current analyzing and processing results, and the specific structure is as follows:
the database operation from of the Select parsing initial result { database table name of the current parsing result }.
3. The method of claim 1, wherein the recursive SQL statement fragment comprises 2 fields of a database operation of a current parsing result and a database table name of a subsequent parsing result, and the specific structure is:
the database operation from of the current analysis processing result of Select { database table name of the subsequent analysis processing result }.
4. A system for implementing a method of database operation delay calculation of claim 1, the system comprising a database object definition unit, a request resolution unit, an object resolution unit, and an execution unit;
wherein,
the database object definition unit is used for defining an object attribute structure of the database operation object according to the elements contained in the database operation object;
the request analysis unit is used for receiving and analyzing a user database operation request and generating a database operation object according to the object attribute structure;
the object analysis unit is used for analyzing the database operation object and generating an SQL statement of the user database operation request;
the execution unit is used for executing the SQL statement and returning an execution result.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202211660760.6A CN116010438B (en) | 2022-12-22 | 2022-12-22 | Method and system for calculating database operation delay |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202211660760.6A CN116010438B (en) | 2022-12-22 | 2022-12-22 | Method and system for calculating database operation delay |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN116010438A CN116010438A (en) | 2023-04-25 |
| CN116010438B true CN116010438B (en) | 2023-11-28 |
Family
ID=86030998
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202211660760.6A Active CN116010438B (en) | 2022-12-22 | 2022-12-22 | Method and system for calculating database operation delay |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN116010438B (en) |
Citations (14)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2016037244A1 (en) * | 2014-09-12 | 2016-03-17 | Mammothdb Eood | Method and system for distributed execution of sql queries |
| CN105550241A (en) * | 2015-12-07 | 2016-05-04 | 珠海多玩信息技术有限公司 | Multidimensional database query method and apparatus |
| CN111813796A (en) * | 2020-06-15 | 2020-10-23 | 北京邮电大学 | Data column level blood margin processing system and method based on Hive data warehouse |
| CN111949684A (en) * | 2020-08-06 | 2020-11-17 | 上海达梦数据库有限公司 | SQL statement execution method, device, equipment and storage medium |
| CN112416908A (en) * | 2020-12-04 | 2021-02-26 | 重庆忽米网络科技有限公司 | Method and system for analyzing prefix sublibrary storage data based on Handle identification |
| CN113051285A (en) * | 2021-03-25 | 2021-06-29 | 未鲲(上海)科技服务有限公司 | SQL statement conversion method, system, equipment and storage medium |
| CN113157723A (en) * | 2021-04-06 | 2021-07-23 | 福州大学 | SQL access method for Hyperridge Fabric |
| CN113792067A (en) * | 2021-11-16 | 2021-12-14 | 全景智联(武汉)科技有限公司 | System and method for automatically generating SQL (structured query language) based on recursive algorithm |
| CN114416776A (en) * | 2021-12-28 | 2022-04-29 | 航天信息股份有限公司 | Data self-defined query statistical method |
| CN114490703A (en) * | 2020-11-11 | 2022-05-13 | 中国移动通信有限公司研究院 | Data analysis method and device and computer readable storage medium |
| CN114817298A (en) * | 2022-05-12 | 2022-07-29 | 平安科技（深圳）有限公司 | Method, device and equipment for extracting field-level data blood margin and storage medium |
| CN114896271A (en) * | 2022-06-09 | 2022-08-12 | 城云科技（中国）有限公司 | Method, device and application for efficiently maintaining node full path |
| CN114968917A (en) * | 2022-06-02 | 2022-08-30 | 中国银行股份有限公司 | Method and device for rapidly importing file data |
| CN115237940A (en) * | 2022-07-20 | 2022-10-25 | 北京恒华伟业科技股份有限公司 | Data query method, device and equipment |
Family Cites Families (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7761900B2 (en) * | 2006-08-02 | 2010-07-20 | Clarendon Foundation, Inc. | Distribution of content and advertisement |
| US10909139B2 (en) * | 2018-06-13 | 2021-02-02 | Microsoft Technology Licensing, Llc | SQL query formatting by examples |
-
2022
- 2022-12-22 CN CN202211660760.6A patent/CN116010438B/en active Active
Patent Citations (14)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2016037244A1 (en) * | 2014-09-12 | 2016-03-17 | Mammothdb Eood | Method and system for distributed execution of sql queries |
| CN105550241A (en) * | 2015-12-07 | 2016-05-04 | 珠海多玩信息技术有限公司 | Multidimensional database query method and apparatus |
| CN111813796A (en) * | 2020-06-15 | 2020-10-23 | 北京邮电大学 | Data column level blood margin processing system and method based on Hive data warehouse |
| CN111949684A (en) * | 2020-08-06 | 2020-11-17 | 上海达梦数据库有限公司 | SQL statement execution method, device, equipment and storage medium |
| CN114490703A (en) * | 2020-11-11 | 2022-05-13 | 中国移动通信有限公司研究院 | Data analysis method and device and computer readable storage medium |
| CN112416908A (en) * | 2020-12-04 | 2021-02-26 | 重庆忽米网络科技有限公司 | Method and system for analyzing prefix sublibrary storage data based on Handle identification |
| CN113051285A (en) * | 2021-03-25 | 2021-06-29 | 未鲲(上海)科技服务有限公司 | SQL statement conversion method, system, equipment and storage medium |
| CN113157723A (en) * | 2021-04-06 | 2021-07-23 | 福州大学 | SQL access method for Hyperridge Fabric |
| CN113792067A (en) * | 2021-11-16 | 2021-12-14 | 全景智联(武汉)科技有限公司 | System and method for automatically generating SQL (structured query language) based on recursive algorithm |
| CN114416776A (en) * | 2021-12-28 | 2022-04-29 | 航天信息股份有限公司 | Data self-defined query statistical method |
| CN114817298A (en) * | 2022-05-12 | 2022-07-29 | 平安科技（深圳）有限公司 | Method, device and equipment for extracting field-level data blood margin and storage medium |
| CN114968917A (en) * | 2022-06-02 | 2022-08-30 | 中国银行股份有限公司 | Method and device for rapidly importing file data |
| CN114896271A (en) * | 2022-06-09 | 2022-08-12 | 城云科技（中国）有限公司 | Method, device and application for efficiently maintaining node full path |
| CN115237940A (en) * | 2022-07-20 | 2022-10-25 | 北京恒华伟业科技股份有限公司 | Data query method, device and equipment |
Also Published As
| Publication number | Publication date |
|---|---|
| CN116010438A (en) | 2023-04-25 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US8181155B2 (en) | Unified expression and location framework | |
| KR102361153B1 (en) | Managing data profiling operations related to data type | |
| CN107038222B (en) | Database cache implementation method and system | |
| US20090204593A1 (en) | System and method for parallel retrieval of data from a distributed database | |
| JP2000222212A (en) | Real class determination of object in execution | |
| CN109710220B (en) | Relational database query method, relational database query device, relational database query equipment and storage medium | |
| US10896180B2 (en) | Statement parsing method for database statement | |
| CN109597618B (en) | Program development method, program development device, computer device, and storage medium | |
| JP7254925B2 (en) | Transliteration of data records for improved data matching | |
| CN112883030A (en) | Data collection method and device, computer equipment and storage medium | |
| CN108536728A (en) | A kind of data query method and apparatus | |
| CN115809063B (en) | Storage process compiling method, system, electronic equipment and storage medium | |
| CN116383238A (en) | Data virtualization system, method, device, equipment and medium based on graph structure | |
| CN112579595A (en) | Data processing method and device, electronic equipment and readable storage medium | |
| CN113901083A (en) | Heterogeneous data source operation resource analysis positioning method and equipment based on multiple analyzers | |
| CN112506950A (en) | Data aggregation processing method, computing node, computing cluster and storage medium | |
| KR102172138B1 (en) | Distributed Computing Framework and Distributed Computing Method | |
| CN109240998B (en) | Configurable file parsing method | |
| US10303791B2 (en) | Efficient join on dynamically compressed inner for improved fit into cache hierarchy | |
| CN110019342B (en) | Partition table access method, device and equipment and computer readable storage medium | |
| CN116010438B (en) | Method and system for calculating database operation delay | |
| CN117215540A (en) | Code generation method, device and system of remote procedure call framework | |
| CN110888876A (en) | Method and device for generating database script, storage medium and computer equipment | |
| WO2024130887A1 (en) | Method and system for delay computing of database operation | |
| CN116010461A (en) | Data blood relationship analysis method and device, storage medium and electronic equipment |
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 |