CN104866595B - Relational database script is added the method and device of transaction controlling - Google Patents
Relational database script is added the method and device of transaction controlling Download PDFInfo
- Publication number
- CN104866595B CN104866595B CN201510289793.8A CN201510289793A CN104866595B CN 104866595 B CN104866595 B CN 104866595B CN 201510289793 A CN201510289793 A CN 201510289793A CN 104866595 B CN104866595 B CN 104866595B
- Authority
- CN
- China
- Prior art keywords
- added
- transaction
- script
- granularity
- transaction controlling
- 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
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/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
-
- 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/21—Design, administration or maintenance of databases
- G06F16/217—Database tuning
Abstract
The invention discloses the method and devices that transaction controlling is added in a kind of pair of relational database script.This method comprises: configuration transaction granularity；Transaction controlling sentence will be added before or after the row for the integral multiple that the line number of script is affairs granularity.The present invention can carry out dynamic configuration to affairs granularity, the dynamic for realizing addition transaction controlling can match, it improves the efficiency that transaction controlling is added and whole work efficiency can be improved, with increasing for maintenance system, the manual work of a large amount of repeatability can be reduced, working efficiency is greatly improved, the mistake of manual operations and generation in the prior art is avoided.
Description
Technical field
The present embodiments relate to database management technologies more particularly to a kind of pair of relational database script, and affairs control is added
The method and device of system.
Background technique
Often batch is inserted into script in the daily operation management of database, and the script of batch insertion is usually by developer
Offer, insertion script are substantially up to ten thousand even hundreds of thousands above data, once insertion and no any submission sentence,
In program exception transaction rollback operating system is had an impact be it is self-evident, therefore, it is necessary to be added in perform script
Transaction controlling sentence COMMIT.
In the prior art, transaction controlling sentence is added is by O&M DBA (Database administrator, database
Administrator) or developer be manually added.This method efficiency that transaction controlling is manually added is lower, in data volume
Workload is huge when big, due to mistake, a large amount of system dirty datas can be also generated, to increase the workload of O&M DBA.
Summary of the invention
In view of this, the embodiment of the present invention provides the method and dress that transaction controlling is added in a kind of pair of relational database script
It sets, to improve the efficiency that transaction controlling is added.
In a first aspect, the embodiment of the invention provides the method that transaction controlling is added in a kind of pair of relational database script, institute
The method of stating includes:
Configuration transaction granularity；
Transaction controlling sentence will be added before or after the row for the integral multiple that the line number of script is affairs granularity.
Further, before configuration transaction granularity, further includes:
According to whether having existed transaction controlling sentence, judge whether to need that transaction controlling is added, if so, triggering configuration
The operation of affairs granularity.
Further, transaction controlling language will be added before or after the row for the integral multiple that the line number of script is affairs granularity
Sentence, comprising:
The temporary line number of the script read is subjected to remainder calculating to affairs granularity；
Transaction controlling sentence is added before or after calculated result is 0 row.
Further, further includes:
Configuration data table information and the database version information for exporting script；
Transaction controlling sentence will be added before or after the row for the integral multiple that the line number of script is affairs granularity, comprising:
The line number of query statement is subjected to remainder calculating to affairs granularity；
Transaction controlling sentence is added behind query statement in the row that calculated result is 0；
The transaction controlling sentence and the query statement are closed using dynamic, structured query language row conversion column algorithm
It and is a column；
According to the database version information of the data table information and export script, the inquiry of transaction controlling sentence will be added
Program exports as database script.
Further, the range of the affairs granularity is 200-500.
Second aspect, the embodiment of the invention also provides the device that transaction controlling is added in a kind of pair of relational database script,
Described device includes:
Affairs granularity configuration module is used for configuration transaction granularity；
Module is added in transaction controlling, for will add before or after the row for the integral multiple that the line number of script is affairs granularity
Enter transaction controlling sentence.
Further, further includes:
Judgment module, for before configuration transaction granularity, according to whether having existed transaction controlling sentence, judgement to be
It is no to need that transaction controlling is added, if so, the operation of triggering configuration transaction granularity.
Further, the transaction controlling addition module includes:
First remainder computing unit, by carrying out based on remainder the temporary line number of the script read to affairs granularity
It calculates；
First transaction controlling adding unit, for transaction controlling sentence to be added before or after calculated result is 0 row.
Further, further includes:
Tables of data and database version configuration module are believed for configuration data table information and the database version for exporting script
Breath；
Module is added in the transaction controlling
Second remainder computing unit, for the line number of query statement to be carried out remainder calculating to affairs granularity；
Second transaction controlling adding unit, for affairs control to be added behind query statement in the row that calculated result is 0
Sentence processed；
Merging module, for converting column algorithm for the transaction controlling sentence and institute using dynamic, structured query language row
It states query statement and merges into a column；
Script export module will be added for the database version information according to the data table information and export script
The polling routine of transaction controlling sentence exports as database script.
Further, the range of the affairs granularity is 200-500.
The method and device provided in an embodiment of the present invention for relational database script being added transaction controlling, by configuring thing
It is engaged in granularity, transaction controlling sentence will be added before or after the row for the integral multiple that the line number of script is affairs granularity, it can be with
Dynamic configuration is carried out to affairs granularity, the dynamic for realizing addition transaction controlling can match, and improve the effect that transaction controlling is added
Rate and whole work efficiency can be improved, with increasing for maintenance system, it is possible to reduce the manual works of a large amount of repeatability, greatly
It is big to improve working efficiency, avoid the mistake of manual operations and generation in the prior art.
Detailed description of the invention
Fig. 1 is the process for the method that transaction controlling is added in a kind of pair of relational database script that the embodiment of the present invention one provides
Figure；
Fig. 2 is the process for the method that transaction controlling is added in a kind of pair of relational database script provided by Embodiment 2 of the present invention
Figure；
Fig. 3 is the process for the method that transaction controlling is added in a kind of pair of relational database script that the embodiment of the present invention three provides
Figure；
Fig. 4 is the process for the method that transaction controlling is added in a kind of pair of relational database script that the embodiment of the present invention four provides
Figure；
Fig. 5 is the signal for the device that transaction controlling is added in a kind of pair of relational database script that the embodiment of the present invention five provides
Figure.
Specific embodiment
The present invention is described in further detail with reference to the accompanying drawings and examples.It is understood that this place is retouched
The specific embodiment stated is used only for explaining the present invention rather than limiting the invention.It also should be noted that in order to just
In description, only some but not all contents related to the present invention are shown in the drawings.
Embodiment one
Fig. 1 is the process for the method that transaction controlling is added in a kind of pair of relational database script that the embodiment of the present invention one provides
Figure, the present embodiment are applicable to transaction controlling is added from script derived from relational database or leads in relational database
Transaction controlling is added when script out, this method can be executed by computer, be specifically comprised the following steps:
Step 110, configuration transaction granularity.
Wherein, affairs granularity refers to the minimum unit to relational database script insertion transaction controlling, i.e., to relationship number
A transaction controlling sentence COMMIT is inserted into every the script of the line number of affairs granularity according in the script of library.
Wherein, the affairs granularity ranges preferably from 200-500.The range of affairs granularity, i.e. row interval 200-
500 are obtained by repeatedly testing, and can satisfy various types of business needs.
Computer provides setting window for user configuration affairs granularity size, and user can need dynamic to match according to business
Affairs granularity is set, and is inputted in computer by the setting window, computer receives the configuration transaction of user's input
After the value of granularity, affairs granularity is configured according to the value of the affairs granularity of user's input.It is this to affairs granularity
Dynamic can facilitate routine work needs of user with mode, and can be to relational database script addition transaction controlling
The size of dynamic adjustment affairs granularity is needed according to business in the process, it can the affairs granularity of dynamic control at any time adapts to
The requirement that various different classes of databases submit affairs.
Step 120, transaction controlling language will be added before or after the row for the integral multiple that the line number of script is affairs granularity
Sentence.
The line number that script can be located to the transaction controlling sentence that relational database script is added is the whole of affairs granularity
Before the row of several times, it can also be located at after row of the line number of script for the integral multiple of affairs granularity.
Wherein, the line number of script is from the interim row for derived from relational database in script being the scripting lines read
Number, from relational database export script when be query statement line number.From derived from relational database in script
Add transaction controlling when, only need to the temporary line number of the scripting lines read be affairs granularity integral multiple row before or it
Transaction controlling sentence is added afterwards；When exporting script from relational database when addition transaction controlling, in the line number of query statement
After transaction controlling sentence is added before or after the row of the integral multiple of affairs granularity, then execute the program of export script.
The present embodiment to from database export script scripting language there is no limit, that is, be suitable in Windows
Perl, Shell, Python script are based on platform based on VBA script and on Linux, Unix platform, and can be cross-platform
Realize dynamic addition transaction controlling.
The present embodiment by configuration transaction granularity, by before the row for the integral multiple that the line number of script is affairs granularity or
Transaction controlling sentence is added later, the dynamic for realizing addition transaction controlling can match, and improve the efficiency of addition transaction controlling simultaneously
And whole work efficiency can be improved, with increasing for maintenance system, it is possible to reduce the manual work of a large amount of repeatability mentions significantly
High working efficiency avoids the mistake of manual operations and generation in the prior art.
Embodiment two
Fig. 2 is the process for the method that transaction controlling is added in a kind of pair of relational database script provided by Embodiment 2 of the present invention
Figure, specifically comprises the following steps:
Step 210, according to whether having existed transaction controlling sentence, judge whether to need that transaction controlling is added, if so,
Trigger the operation of configuration transaction granularity.
When having existed transaction controlling sentence in database script, it is judged as and does not need that transaction controlling is added；Certainly, when
Have existed transaction controlling sentence in database script but the row interval of the transaction controlling sentence in script is larger (such as in the ranks
It is divided into 1000, but being in the ranks divided into 200) of needing of business, when the business of being unsatisfactory for needs, also it is judged as and needs to be added affairs control
System；When transaction controlling sentence is not present in database script, it is judged as and needs that transaction controlling is added, when needs to be added affairs control
When processed, the operation of configuration transaction granularity is triggered.
Step 220, configuration transaction granularity.
Step 230, transaction controlling language will be added before or after the row for the integral multiple that the line number of script is affairs granularity
Sentence.
The present embodiment passes through according to whether have existed transaction controlling sentence, judges whether to need that transaction controlling is added, when
When needing that transaction controlling is added, configuration transaction granularity, by the line number of script be affairs granularity integral multiple row before or
Transaction controlling sentence is added later, the dynamic for realizing addition transaction controlling can match, the efficiency that transaction controlling is added is improved, with
Embodiment one is compared, and the present embodiment is obtained by judgement need not add transaction controlling language when having existed transaction controlling sentence
Sentence, the repetition for avoiding transaction controlling are added.
Embodiment three
Fig. 3 is the process for the method that transaction controlling is added in a kind of pair of relational database script that the embodiment of the present invention three provides
Step 120 has further been split into step 320 and step 330 compared with embodiment one by figure, the present embodiment, and the present embodiment is suitable
For specifically comprising the following steps: to transaction controlling is added in derived script from relational database
Step 310, configuration transaction granularity.
Step 320, the temporary line number of the script read is subjected to remainder calculating to affairs granularity.
To when transaction controlling is added in derived script from database, foot can be read since the first row of script
This, and during reading a line script, the temporary line number of the script read is subjected to remainder meter to affairs granularity
It calculates.Wherein, when temporary line number refers to reading script, the line number of the script read, since derived script is text file
Line number is not present, so being denoted as temporary line number here in format.
Step 330, transaction controlling sentence is added before or after calculated result is 0 row.
During reading script, a certain temporary line number for traveling far and wide this read carries out remainder meter to affairs granularity
It calculates, a breakpoint can be then arranged in calculated result 0 before the row, so that transaction controlling sentence is added, it can also be at this
Transaction controlling sentence is added in setting breakpoint after row.
The present embodiment carries out affairs granularity by configuration transaction granularity, and by the temporary line number of the script read
Remainder calculates, and transaction controlling sentence is added before or after calculated result is 0 row, realizes to from relational database
In derived script the dynamic of transaction controlling is added can match, improve the efficiency that transaction controlling is added.
Example IV
Fig. 4 is the process for the method that transaction controlling is added in a kind of pair of relational database script that the embodiment of the present invention four provides
Figure, the present embodiment specifically comprise the following steps: suitable for transaction controlling is added to when exporting script from relational database
Step 410, configuration transaction granularity.
Step 420, the database version information of configuration data table information and export script.
When exporting script from relational database, other than wanting configuration transaction granularity, configuration data table information is also wanted
And the database version information of export script.Wherein, data table information is the information for needing to export the tables of data of script, for example,
Need the quantity and type of derived tables of data.
Step 430, the line number of query statement is subjected to remainder calculating to affairs granularity.
When exporting script from database to some tables of data, the information of tables of data is realized by query statement, is being looked into
Each query statement line number of the row is had before asking sentence, the line number of query statement is subjected to remainder meter to affairs granularity
It calculates.
Step 440, transaction controlling sentence is added behind query statement in the row that calculated result is 0.
Transaction controlling sentence is directly first added behind query statement in the row that calculated result is 0, transaction controlling is added
The effect shown on the screen after sentence is with a table of three column, i.e. gauge outfit is respectively line number, query statement and affairs
Control statement, therefore, entire table have three column, i.e., line number column, inquiry column and transaction controlling column, as shown in table 1, table 1 be with
The effect shown on the screen after transaction controlling sentence is added for affairs granularity 200.In table 1, it is for blank in inquiry column
Because which type of query statement does not limit here is, it is in other rows for being 200 and 400 in addition to line number in transaction controlling column
Blank is because not needing that transaction controlling is added in other rows.
The effect shown on the screen after transaction controlling sentence is added in table 1
| Line number | Query statement | Transaction controlling sentence |
| 1 | ||
| … | ||
| 200 | COMMIT | |
| … | ||
| 400 | COMMIT |
Step 450, the transaction controlling sentence is looked into described using dynamic, structured query language row conversion column algorithm
It askes sentence and merges into a column.
Column algorithm is converted by institute using dynamic, structured query language (Structured Query Language, SQL) row
Column where stating transaction controlling sentence merge into a column with the column where the query statement, after merging, the affairs control of addition
Sentence processed can be located at the row before the query statement in the row where merging the preceding transaction controlling sentence, can also be located at and merge
The row after the query statement in row where the preceding transaction controlling sentence.
Step 460, according to the database version information of the data table information and export script, transaction controlling language will be added
The polling routine of sentence exports as database script.
According to the database version information of the data table information and export script, the inquiry of transaction controlling sentence will be added
The program of tables of data represented by the data table information exports as database script.
The present embodiment is by configuration transaction granularity and configuration data table information and database version information, by query statement
Line number to affairs granularity carry out remainder calculating, calculated result be 0 row below be added transaction controlling sentence, use dynamic
SQL row turns column algorithm and the transaction controlling sentence and the query statement is merged into a column, according to the data table information and
The polling routine that transaction controlling sentence is added is exported as database script, realized by the database version information for exporting script
Transaction controlling is added when exporting script from relational database, and can dynamically control the size of affairs granularity, is suitable for each
The relational database of kind mainstream, such as Oracle, SQL Server, Mysql, improve the efficiency that transaction controlling is added.
Embodiment five
Fig. 5 is the signal for the device that transaction controlling is added in a kind of pair of relational database script that the embodiment of the present invention five provides
Figure, as shown in figure 5, the device provided in this embodiment for relational database script being added transaction controlling includes: affairs granularity
Module 520 is added in configuration module 510 and transaction controlling.
Wherein, affairs granularity configuration module 510 is used for configuration transaction granularity；
Transaction controlling be added module 520 for will the line number of script be affairs granularity integral multiple row before or after
Transaction controlling sentence is added.
Preferably, further includes:
Judgment module, for before configuration transaction granularity, according to whether having existed transaction controlling sentence, judgement to be
It is no to need that transaction controlling is added, if so, the operation of triggering configuration transaction granularity.
Preferably, the transaction controlling addition module includes:
First remainder computing unit, by carrying out based on remainder the temporary line number of the script read to affairs granularity
It calculates；
First transaction controlling adding unit, for transaction controlling sentence to be added before or after calculated result is 0 row.
Preferably, further includes:
Tables of data and database version configuration module are believed for configuration data table information and the database version for exporting script
Breath；
Module is added in the transaction controlling
Second remainder computing unit, for the line number of query statement to be carried out remainder calculating to affairs granularity；
Second transaction controlling adding unit, for affairs control to be added behind query statement in the row that calculated result is 0
Sentence processed；
Merging module, for converting column algorithm for the transaction controlling sentence and institute using dynamic, structured query language row
It states query statement and merges into a column；
Script export module will be added for the database version information according to the data table information and export script
The polling routine of transaction controlling sentence exports as database script.
Preferably, the range of the affairs granularity is 200-500.
Method provided by any embodiment of the invention can be performed in the said goods, has the corresponding functional module of execution method
And beneficial effect.
Note that the above is only a better embodiment of the present invention and the applied technical principle.It will be appreciated by those skilled in the art that
The invention is not limited to the specific embodiments described herein, be able to carry out for a person skilled in the art it is various it is apparent variation,
It readjusts and substitutes without departing from protection scope of the present invention.Therefore, although being carried out by above embodiments to the present invention
It is described in further detail, but the present invention is not limited to the above embodiments only, without departing from the inventive concept, also
It may include more other equivalent embodiments, and the scope of the invention is determined by the scope of the appended claims.
Claims (8)
1. the method that transaction controlling is added in a kind of pair of relational database script, which is characterized in that the described method includes:
By the affairs granularity that window reception user configuration is arranged；
Configuration data table information and the database version information for exporting script；
The line number of query statement is subjected to remainder calculating to affairs granularity；
Calculated result be 0 row in query statement below addition transaction controlling sentence, the transaction controlling sentence with it is described
Query statement and line number form the table with three column；
The transaction controlling sentence is merged into the query statement using dynamic, structured query language row conversion column algorithm
One column；
According to the database version information of the data table information and export script, the polling routine of transaction controlling sentence will be added
Export as database script.
2. the method according to claim 1, wherein before configuration transaction granularity, further includes:
According to whether having existed transaction controlling sentence, judge whether to need that transaction controlling is added, if so, triggering configuration transaction
The operation of granularity.
3. method according to claim 1 or 2, which is characterized in that the range of the affairs granularity is 200-500.
4. the device that transaction controlling is added in a kind of pair of relational database script, which is characterized in that described device includes:
Affairs granularity configuration module, for the affairs granularity by setting window reception user configuration；
Tables of data and database version configuration module, for configuration data table information and the database version information of export script；
Module is added in transaction controlling, for thing will be added before or after the row for the integral multiple that the line number of script is affairs granularity
Business control statement；
Module is added in the transaction controlling
Second remainder computing unit, for the line number of query statement to be carried out remainder calculating to affairs granularity；
Second transaction controlling adding unit, for transaction controlling language to be added behind query statement in the row that calculated result is 0
Sentence, the transaction controlling sentence and the query statement and line number form the table with three column；
Merging module, for being looked into the transaction controlling sentence with described using dynamic, structured query language row conversion column algorithm
It askes sentence and merges into a column；
Affairs will be added for the database version information according to the data table information and export script in script export module
The polling routine of control statement exports as database script.
5. device according to claim 4, which is characterized in that further include:
Judgment module, for according to whether having existed transaction controlling sentence, judging whether to need before configuration transaction granularity
Transaction controlling is added, if so, the operation of triggering configuration transaction granularity.
6. device according to claim 4 or 5, which is characterized in that the range of the affairs granularity is 200-500.
7. a kind of computer, which is characterized in that the computer includes:
One or more processors；
Storage device, for storing one or more programs,
When one or more of programs are executed by one or more of processors, so that one or more of processors are real
Now such as the method as claimed in any one of claims 1-3 that transaction controlling is added to relational database script.
8. a kind of computer readable storage medium, is stored thereon with computer program, which is characterized in that described program is by processor
It is realized when execution such as the method as claimed in any one of claims 1-3 that transaction controlling is added to relational database script.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510289793.8A CN104866595B (en) | 2015-05-29 | 2015-05-29 | Relational database script is added the method and device of transaction controlling |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510289793.8A CN104866595B (en) | 2015-05-29 | 2015-05-29 | Relational database script is added the method and device of transaction controlling |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN104866595A CN104866595A (en) | 2015-08-26 |
| CN104866595B true CN104866595B (en) | 2019-05-03 |
Family
ID=53912421
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201510289793.8A Active CN104866595B (en) | 2015-05-29 | 2015-05-29 | Relational database script is added the method and device of transaction controlling |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104866595B (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108536745B (en) * | 2018-02-24 | 2021-03-16 | 平安科技（深圳）有限公司 | Shell-based data table extraction method, terminal, equipment and storage medium |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1815469A (en) * | 2005-02-01 | 2006-08-09 | 华为技术有限公司 | Database connection resource management method |
| CN103309625A (en) * | 2013-05-29 | 2013-09-18 | 华为技术有限公司 | Method and system based on self-adaptive storage heat transferring |
| CN104021043A (en) * | 2014-06-23 | 2014-09-03 | 中国银行股份有限公司 | Interruption reentry method and system of batch applications |
| CN104317960A (en) * | 2014-11-14 | 2015-01-28 | 中国建设银行股份有限公司 | Method and device for processing batch job |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20070282803A1 (en) * | 2006-06-02 | 2007-12-06 | International Business Machines Corporation | Methods and systems for inventory policy generation using structured query language |
-
2015
- 2015-05-29 CN CN201510289793.8A patent/CN104866595B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1815469A (en) * | 2005-02-01 | 2006-08-09 | 华为技术有限公司 | Database connection resource management method |
| CN103309625A (en) * | 2013-05-29 | 2013-09-18 | 华为技术有限公司 | Method and system based on self-adaptive storage heat transferring |
| CN104021043A (en) * | 2014-06-23 | 2014-09-03 | 中国银行股份有限公司 | Interruption reentry method and system of batch applications |
| CN104317960A (en) * | 2014-11-14 | 2015-01-28 | 中国建设银行股份有限公司 | Method and device for processing batch job |
Also Published As
| Publication number | Publication date |
|---|---|
| CN104866595A (en) | 2015-08-26 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN105608086B (en) | Transaction processing method and device for distributed database system | |
| CN106796585B (en) | Conditional validation rules | |
| US9753986B2 (en) | Multi-dimensional feature merging for supporting evidence in a question and answering system | |
| US10824602B2 (en) | System for determining the impact to databases, tables and views by batch processing | |
| CN104657346A (en) | Question matching system and question matching system in intelligent interaction system | |
| CN107798030B (en) | Splitting method and device of data table | |
| US8839198B2 (en) | Automated analysis of composite applications | |
| CN111026779A (en) | Data processing method, device and storage medium based on Flink SQL | |
| US11501178B2 (en) | Data processing method, medical term processing system and medical diagnostic system | |
| US9785430B2 (en) | Methods, systems and computer-readable media for detecting a partial commit | |
| US10497067B2 (en) | System for perfoming an extraction process on input data containing XBRL files using a combination of extraction criteria | |
| US10664477B2 (en) | Cardinality estimation in databases | |
| US11269880B2 (en) | Retroreflective clustered join graph generation for relational database queries | |
| US10579500B2 (en) | Debugging for SQL statement | |
| CN108694108B (en) | iOS crash data classification and statistics method and device | |
| US20190213188A1 (en) | Distributed computing framework and distributed computing method | |
| US9031930B2 (en) | Data browser for group-by data access | |
| CN109783498B (en) | Data processing method and device, electronic equipment and storage medium | |
| CN108255852B (en) | SQL execution method and device | |
| CN104866595B (en) | Relational database script is added the method and device of transaction controlling | |
| CN116502273B (en) | Dynamic data desensitization method, device and equipment based on data blood edges | |
| Bakri et al. | The formal specification for the inventory system using Z language | |
| Poess et al. | A pdgf implementation for tpc-h | |
| CN107273293B (en) | Big data system performance test method and device and electronic equipment | |
| CN110515967B (en) | Spark calculation framework-based data analysis method and electronic equipment |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| EXSB | Decision made by sipo to initiate substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |