CN101178724A - Temporary table management method - Google Patents
Temporary table management method Download PDFInfo
- Publication number
- CN101178724A CN101178724A CNA2007101681787A CN200710168178A CN101178724A CN 101178724 A CN101178724 A CN 101178724A CN A2007101681787 A CNA2007101681787 A CN A2007101681787A CN 200710168178 A CN200710168178 A CN 200710168178A CN 101178724 A CN101178724 A CN 101178724A
- Authority
- CN
- China
- Prior art keywords
- temporary table
- reusable
- reusable temporary
- application program
- name
- 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.)
- Granted
Links
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides a temporary table managing method which comprises that: steps used for creating reused temporary tables, steps used for using the reusable temporary tables and steps used for deleting and/or releasing reusable temporary tables. The reusable temporary tables provided by the invention keep the effective state all along whether applying procedure has unbroken database connection as long as the applying procedure does not request to delete the whole reusable temporary tables. The invention also realizes the management to the table names of the reusable temporary tables, prevents the collision of the table names and the problem that the applying procedure can not normally run. The invention can prevent the data tables from being frequently created / deleted during the applying procedure, improve the using capacity of the database and reduce the generating rate of the database locking by using a common table to simulate the temporary table and by restricting the name of the table to realize reuse of the reusable temporary table.
Description
Technical field
The present invention relates to electric digital data processing field, particularly temporary table management method.
Background technology
In application program, tend to produce a large amount of intermediate data, these data need be kept in the database, use for subsequent processes process or other program, in case when these intermediate data no longer need, should from database, delete, to discharge shared resource.The tables of data of preserving intermediate data is called temporary table.Application program generally uses the temporary table administrative mechanism of database to manage temporary table, then should show to delete from database when the data in the temporary table no longer are used, and perhaps the closing database connection allows database delete temporary table automatically.
Present database product all has oneself manages the mechanism of temporary table, be divided into local temporary table and overall temporary table as temporary table in SQL SERVER, to connect session relevant with each for local temporary table, only in the connection session of this temporary table of establishment as seen, when session is closed, understand deleted; Overall situation temporary table can be connected session access by all, but database can be deleted this overall situation temporary table when this temporary table is not connected the session use by any one.
Some functions of application program use temporary table that individual characteristics are arranged: the intermediate data that will preserve is similar at every turn, so each temporary table structure of creating is also identical, on program, the list structure of at every turn creating temporary table all is identical, and just table name might be different.Deleting temporary table or allow database delete temporary table automatically by the PROGRAMMED REQUESTS database has individual shortcoming: deletion and establishment table/temporary table need expend certain resource, and system's table that in this course can lock database, reduce database performance, particularly under the situation of frequent establishment/deletion temporary table, cause system deadlock probably.
Summary of the invention
The object of the invention is to propose a kind of reusable temporary table that can be used repeatedly by whole application.
The invention provides temporary table management method, comprising: the step of creating reusable temporary table; Use the step of reusable temporary table; Delete and/or discharge the step of reusable temporary table.
The step of the reusable temporary table of above-mentioned establishment comprises: application program is created the predicative sentence to systems communicate, and the step of reusable temporary table is created in request; The step of reusable temporary table is created according to creating the predicative sentence by system.
The step of the reusable temporary table of above-mentioned deletion comprises: application program is to systems communicate delete list statement, and the step of reusable temporary table is specified in the request deletion; System is according to the step of the reusable temporary table of delete list statement deletion appointment.
Preferably, above-mentioned temporary table management method also comprises: when application initialization, and the step of the reusable temporary table that the system-kill application program is created.
Preferably, above-mentioned temporary table management method also comprises: utilize table name to discern reusable temporary table.
Above-mentioned table name comprises prefix, external program sign and random identification, and prefix, external program sign and random identification triplicity make table name different.The prefix of the reusable temporary table that same application program generates is identical; The external program sign is to generate according to application program place machine address, hardware and/or system information; Random identification is to be obtained by external program sign, reusable temporary table creation-time and/or random number combinatorial operation.
The step of the reusable temporary table of above-mentioned establishment comprises: system generates the step of table name according to the request of application program; System replaces the table name of creating in the predicative sentence with table name, generates the step of new establishment predicative sentence; System carries out new establishment predicative sentence, creates the step of reusable temporary table.
Preferably, said system is pre-created at least one reusable temporary table, and manages at least one reusable temporary table with the temporary table pond.
The reusable temporary table step of above-mentioned establishment comprises: application program is created the step of the statement of reusable temporary table to systems communicate; After system receives and creates statement, the step of in the temporary table pond, searching corresponding reusable temporary table; Find corresponding reusable temporary table, then return the step of the table name of reusable temporary table; Or do not find corresponding reusable temporary table, then system generates unduplicated table name, creates new reusable temporary table and by the management of temporary table pond, returns the step of new reusable temporary table table name with table name.
The step of the reusable temporary table of above-mentioned release comprises: application program indicates the table name of the reusable temporary table that will discharge, and discharges the step of reusable temporary table to system request; System finds out the reusable temporary table of appointment, the step that the data of specifying in the reusable temporary table are emptied; Reusable temporary table is specified in the management of temporary table pond, makes reusable temporary table can supply the step of using with program.
Provided by the inventionly can be called reusable temporary table by the reusable temporary table of whole application.No matter whether application program has the database that does not disconnect to connect, and then they just can be in effective status always as long as application program does not ask to delete this overall situation temporary table.Application program can determine whether these overall temporary tables can be deleted, and the system that also can transfer to decides.Will produce intermediate data inevitably in the large database application program, reusable temporary table promptly can be preserved these intermediate data and delete these data when working as making, and has realized sharing in whole application program these intermediate data again.
The present invention has also realized the management to reusable temporary table table name simultaneously, in conventional system, if hundreds of even several ten thousand temporary tables are arranged in the application program, the title of how to specify these tables will be a very big problem, because quantity is many, and encoded by different developers, just cause the table name conflict probably, application program can not normally be carried out.Reusable temporary table naming rule provided by the invention and reusable temporary table administrative mechanism have solved this problem well.
The present invention passes through common table simulation temporary table, and retrains the repeated use that realizes reusable temporary table by table name, can avoid establishment/deleted data table frequent in application program, improves the usability of database, reduces the occurrence probability of database deadlock.
Description of drawings
Fig. 1 is the schematic flow sheet of first embodiment of the invention;
Fig. 2 is the schematic flow sheet of second embodiment of the invention;
Fig. 3 is the detailed process synoptic diagram that third embodiment of the invention is created reusable temporary table;
Fig. 4 is the detailed process synoptic diagram that third embodiment of the invention discharges reusable temporary table.
The realization of the object of the invention, functional characteristics and advantage will be in conjunction with the embodiments, are described further with reference to accompanying drawing.
Embodiment
With reference to Fig. 1, the schematic flow sheet of first embodiment of the invention is shown.
The present invention proposes reusable temporary table, and the software systems of using present embodiment to realize abbreviate system as.Present embodiment uses the general data storehouse to show to simulate temporary table, the application program of external software system (hereinafter to be referred as application program) can be used as this reusable temporary table in a common table and use, this reusable temporary table has the characteristic of temporary table again simultaneously: when the data in the table no longer need with deleted, to discharge database space.The life cycle of reusable temporary table comprises three parts: create, use and delete, when creating reusable temporary table, the table name of temporary table is by system management; Use after creating and just can use this reusable temporary table, this moment, all databases connected, and comprised that other application's data storehouse connects the data that can visit in this table; If application program is determined reusable temporary table and can be used again, then can Request System delete this reusable temporary table, also can delete this reusable temporary table automatically by system.
The system of present embodiment provides an interface of creating reusable temporary table, the supply routine call.Application program is not directly submitted request to database when creating and discharging reusable temporary table, and should be undertaken by the interface that present embodiment provides.
The flow process of present embodiment comprises:
Step S11 creates reusable temporary table;
Step S12 uses reusable temporary table;
Step S13 deletes reusable temporary table.
Step S11 wherein, create reusable temporary table and comprise:
Step S111, application program is to SQL statement of creating reusable temporary table of systems communicate, and reusable temporary table is created in request;
Step S112, reusable temporary table is created according to this SQL statement by system.
Wherein step S12 uses reusable temporary table, and application program should be used as temporary table by reusable temporary table, deposits or read ephemeral data in.
Step S13 wherein, delete reusable temporary table and comprise:
Step S131, application program is to the SQL statement of a reusable temporary table of deletion of systems communicate, and reusable temporary table is specified in the request deletion;
Step S132, system specifies reusable temporary table according to this SQL statement deletion application program.
It is as follows to lift a concrete example:
Step S111, application program is to SQL statement of systems communicate " CREATE TABLE TEST (idvarchar (20) not null, f1 varchar (20)) ", and it is the reusable temporary table of " TEST " that table name is created in request;
Step S112, reusable temporary table is created according to this SQL statement by system, and this reusable temporary table topology example is as shown in table 1:
| Field name | Field type | The field default value |
| id | varchar(20) | not null |
| f1 | varchar(20) |
Table 1
Step S12, application program should be used as temporary table by reusable temporary table, deposits or read ephemeral data in.
Step S131, application program is to systems communicate SQL statement " DROP TABLE TEST ", and the request delete list is called the reusable temporary table of " TEST ";
Step S132, system finds out the reusable temporary table of table name for " TEST " according to this SQL statement, with its deletion.
Among first embodiment, can not be used again, then can ask this reusable temporary table of deletion if application program is determined certain reusable temporary table.For further improving the management of reusable temporary table, based on a last embodiment, the present invention proposes second embodiment, and system will delete useless reusable temporary table automatically, and specific practice is the reusable temporary table of creating before once closing in the deletion certainly from database when application initialization.
Application program must be passed through initialization procedure from being closed to opening.This moment, system can delete all reusable temporary tables of creating in the last use of this application program from database.
For what guarantee system-kill is reusable temporary table but not other general data storehouses table, and present embodiment proposes to utilize table name to discern reusable temporary table.System generates reusable temporary table according to certain naming rule, and naming rule guarantees that not only each table name is unique in database, has also indicated reusable temporary table simultaneously and by which application program has been created.
Based on existing database technology, each database product (as db2, sqlseryer, oracle etc.) all can be in system's table the table name of all tables of data in the register system, system discerns reusable temporary table by inquiring about this system's table, find out the table name of all reusable temporary tables of current application program establishment, then these reusable temporary tables are deleted from database.
Empty after the reusable temporary table, the shared database resource of reusable temporary table that the application program last time creates in database is released.
The reusable temporary table naming rule that present embodiment proposes is " prefix+external program sign+random identification ".Wherein prefix is certain fixing character string (as ZT_), and the table name of the reusable temporary table that same application program generates all uses identical prefix; Wherein the external program sign is the character string according to the IP address generation of application program place machine; And random identification is after generating character string by " external program sign+creation-time+random number ", the character string that computing forms through MD5.
Above-mentioned reusable temporary table naming rule is as follows with the algorithm example that JAVA realizes:
/**
* obtain the table name of reusable temporary table
*/
public String getTableName(){
String local＝InetAddress.getLocal Host( ).toString( )；
String SID＝Long.toSting(local.hashCode( )，35).toUpperCase( ).
replaceAll(″-″，″Z″)；
SecureRandom mySecureRand＝new SecureRandom( )；
long time＝System.current TimeMillis( )；
long rand＝mySecureRand.nextLong( )；
String ValueBeforeMD5＝S_ID+″:″+Long.toString(time)+″:″+
Long.toString(rand))；
MessageDigest md5＝MessageDigest.getInstance(″MD5″)；
md5.update(ValueBeforeMD5.getBytes())；
byte array[]＝md5.digest( )；
long high＝(long)((array[0]&0xffL)^((array[1]&0xffL)＜＜8)
^((array[2]&0xffL)＜＜16)^((array[3]&0xffL)＜＜24)
^((array[4]&0xffL)＜＜32)^((array[5]&0xffL)＜＜40)
^((array[6]&0xffL)＜＜48)^((array[7]&0xffL)＜＜56))；
long low＝(long)((array[8]&0xffL)^((array[9]&0xffL)＜＜8)
^((array[10]&0xffL)＜＜16)^((array[11]&0xffL)＜＜24)
^((array[12]&0xffL)＜＜32)^((array[13]&0xffL)＜＜40)
^((array[14]&0xffL)＜＜48)^((array[15]&0xffL)＜＜56))；
String UID＝Long.toString(high，35).toUpperCase( ).replaceAll(″-″，″Z″)+
Long.toString(low，35).toUpperCase( ).replaceAll(″-″，″Z″)；
return ″ZT_″+SID+GUID；
}
In the above-mentioned algorithm, " ZT_ " is the prefix of determining according to application program; SID is the external program sign, and GUID is a random identification.
The table name length that the value of high and low can be as required in the above-mentioned algorithm and changing for example will be limited in 30 character strings, then the value of low can for: low=(long) ((array[8]; 0xffL) ^ ((array[9] ﹠amp; 0xffL)＜＜8) ^ ((array[10] ﹠amp; 0xffL)＜＜16)).
The naming rule that present embodiment provides significantly reduces application program and sends the frequency of creating and deleting reusable temporary table statement to database, reduce the chance (because these two operations all need the locking system table) of lock database system table, thereby promoted the database usability.
The reusable temporary table naming rule of present embodiment can also generate table name according to other hardware or the system information of application program place environment.
The flow process of present embodiment comprises as described in Figure 2:
Step S21, the reusable temporary table that this application program of system-kill is created;
Step S22, application program is created reusable temporary table to system request;
Step S23, reusable temporary table is created according to this request by system;
Step S24, application program is used reusable temporary table;
Step S25, whether the application program decision deletes certain reusable temporary table;
Step S26 is if certain reusable temporary table of application program decision deletion then carries out step S27; Otherwise process ends;
Step S27, application program is deleted certain reusable temporary table to system request;
Step S28, system finds out the reusable temporary table of application program appointment according to this request, with its deletion, process ends.
Above-mentioned steps S21, the reusable temporary table specific practice that this application program of system-kill is created is the prefix that system determines according to application program, finds out all prefixes prefix identical reusable temporary table definite with this application program in system's table, with its deletion.
Above-mentioned steps S23, system create reusable temporary table according to this request and specifically comprise:
Step S231, system claims according to the request generation table name of application program;
Step S232, system replaces table name in the original establishment predicative sentence with new table name, generates new establishment predicative sentence;
Step S233, system carry out new establishment predicative sentence in database, create reusable temporary table.
Other steps of present embodiment flow process and first embodiment are similar, so do not give unnecessary details.
The present invention proposes the 3rd embodiment on the foregoing description basis, the proposition system is pre-created some reusable temporary table supplies and uses with program.
Present embodiment proposition system is pre-created some reusable temporary tables, for managing these reusable temporary tables, can safeguard a temporary table pond, preserve the information of the reusable temporary table of having created in the temporary table pond, comprise table name, list structure feature, user mode etc., as shown in table 2:
| Table name | The table name of reusable temporary table |
| The list structure feature | The one or more features such as field name, field type and field default value that comprise reusable temporary table. |
| User mode | Indicate this reusable temporary table and whether be in and be used state, have and use and two kinds of values of idle condition. |
Table 2
Above-mentioned list structure feature can obtain from the SQL statement of the reusable temporary table of request establishment, in SQL statement " CREATE TABLE TEST (id varchar (20) not null; f1 varchar (20)) ", id varchar (20) not null and f1 varchar (20) are exactly the list structure feature of this reusable temporary table.
The present embodiment flow process comprises:
Step S31 creates reusable temporary table;
Step S32 uses reusable temporary table;
Step S33 discharges reusable temporary table.
Step S31 wherein, the detailed process of creating reusable temporary table comprises as shown in Figure 3:
Step S310 when application program need be used reusable temporary table, sends a SQL statement of creating reusable temporary table to system;
After step S311, system receive and create statement, be not in database, to create reusable temporary table immediately, but in the temporary table pond, search corresponding reusable temporary table according to the list structure feature that from this establishment statement, obtains;
Step S312, judge whether to find idle reusable temporary table is arranged accordingly, this deterministic process can travel through in the previous step process according to creating a plurality of reusable temporary table information that statement is obtained, judge the user mode of the reusable temporary table that meets the list structure feature, if having user mode is idle and reusable temporary table information that meet the list structure feature, then showing has idle reusable temporary table, carries out step S317; Otherwise carry out step S313;
Step S313, system generate the table name of reusable temporary table, and create a new reusable temporary table according to the list structure of statement in database;
Step S314, system is encapsulated into the table name that step S313 generates in the reusable temporary table information, is saved in the temporary table pond;
Step S315 is provided with in the temporary table pond, and the user mode of new reusable temporary table is " using ";
Step S316 returns the table name of the new reusable temporary table that step S313 generates;
Step S317 if there is idle reusable temporary table in the temporary table pond, then selects one at random in the reusable temporary table of these free time;
Step S318 is provided with in the temporary table pond, and the user mode of the reusable temporary table of choosing is " using ";
Step S319 returns the table name of the reusable temporary table that step S318 chooses.
When above-mentioned steps S313, system create a new reusable temporary table in database, can adopt the naming rule among second embodiment, also can adopt other naming rules new reusable temporary table name.Above-mentioned steps S317 obtains from the temporary table pond in the information process of a reusable temporary table, can also add the detecting step to reusable temporary table validity, and detects the step that the result acts accordingly according to validity.Wherein validity is meant mainly whether the reusable temporary table of request exists in database, because database is an external system, and may be by other system or wherein table of deletion artificially, so before request, can judge whether reusable temporary table exists; And corresponding actions is meant that working as the reusable temporary table of discovery does not exist, and then creates reusable temporary table again.
Above-mentioned steps S32, use reusable temporary table, reusable temporary table is created the back and just can be used repeatedly, the use of reusable temporary table is the same with common table, support all characteristics, the reusable temporary table that when only using reusable temporary table is table name correspondence that step S31 is returned is operated, rather than the table that the table name correspondence in the reusable temporary table statement is created in the application programs request is operated.
Step S33 discharges reusable temporary table, after application uses reusable temporary table, must discharge this reusable temporary table, so that discharge database resource and this reusable temporary table can be reused.
As shown in Figure 4, the process that discharges reusable temporary table comprises:
Step S331 after application program uses reusable temporary table, discharges this reusable temporary table to system request, rather than directly sends the request of delete list to database.Application program indicates the table name of the reusable temporary table that will discharge in request;
Step S332, system find the reusable temporary table of appointment, will specify the data in the reusable temporary table to empty.System sends truncate table order rather than drop table order to database, to empty the data of specifying in the reusable temporary table;
The user mode that step S333, system are provided with reusable temporary table in the temporary table pond is " idle condition ", shows that this reusable temporary table has been released, and can be used again.
Use present embodiment, as need be in the very big tables of data of data volume garbled data, and during Pagination Display, can the major key that meet the data of screening be put in the reusable temporary table earlier, from this reusable temporary table, obtain a part of major key then at every turn, in former database, inquire about corresponding data by these major keys.Can significantly improve performance under the huge situation of this way data volume in original table.
Can also be used in combination common overall temporary table and local temporary table when using present embodiment, but common overall temporary table is by the database product management, and the system of present embodiment only manages reusable temporary table.
The above only is the preferred embodiments of the present invention; be not so limit claim of the present invention; every equivalent structure or equivalent flow process conversion that utilizes instructions of the present invention and accompanying drawing content to be done; or directly or indirectly be used in other relevant technical fields, all in like manner be included in the scope of patent protection of the present invention.
Claims (10)
1. temporary table management method comprises:
Create the step of reusable temporary table;
Use the step of reusable temporary table;
Delete and/or discharge the step of reusable temporary table.
2. temporary table management method according to claim 1 is characterized in that, the step of the reusable temporary table of described establishment comprises:
Application program is created the predicative sentence to systems communicate, and the step of reusable temporary table is created in request;
The step of reusable temporary table is created by system according to described establishment predicative sentence.
3. temporary table management method according to claim 1 is characterized in that, the step of the reusable temporary table of described deletion comprises:
Application program is to systems communicate delete list statement, and the step of reusable temporary table is specified in the request deletion;
System specifies the step of reusable temporary table according to described delete list statement deletion.
4. temporary table management method according to claim 1 is characterized in that, also comprises:
When application initialization, the step of the reusable temporary table that the described application program of system-kill is created.
5. temporary table management method according to claim 1 is characterized in that:
Described system utilizes table name to discern reusable temporary table.
6. temporary table management method according to claim 5 is characterized in that:
Described table name comprises prefix, external program sign and random identification, and the prefix of the reusable temporary table that same application program generates is identical; Described external program sign is to generate according to application program place machine address, hardware and/or system information; Described random identification is to be obtained by external program sign, reusable temporary table creation-time and/or random number combinatorial operation.
7. temporary table management method according to claim 5 is characterized in that, the step of the reusable temporary table of described establishment comprises:
System generates the step of table name according to the request of application program;
System replaces the table name of creating in the predicative sentence with table name, generates the step of new establishment predicative sentence;
System carries out new establishment predicative sentence, creates the step of reusable temporary table.
8. according to the described temporary table management method of arbitrary claim in the claim 1 to 7, it is characterized in that:
System is pre-created at least one reusable temporary table, and manages described at least one reusable temporary table with the temporary table pond.
9. temporary table management method according to claim 8 is characterized in that, creates reusable temporary table step and comprises:
Application program is created the step of the statement of reusable temporary table to systems communicate;
After system receives and creates statement, the step of in the temporary table pond, searching corresponding reusable temporary table;
Find corresponding reusable temporary table, then return the step of the table name of described reusable temporary table; Or do not find corresponding reusable temporary table, then system generates table name, creates new reusable temporary table and by the management of described temporary table pond, returns the step of described reusable temporary table table name newly with described table name.
10. temporary table management method according to claim 8 is characterized in that, the step of the reusable temporary table of described release comprises:
Application program indicates the table name of the reusable temporary table that will discharge, and discharges the step of described reusable temporary table to system request;
System finds out the reusable temporary table of appointment, the step that the data of specifying in the reusable temporary table are emptied;
The reusable temporary table of described appointment is managed in described temporary table pond, makes described reusable temporary table can supply the step of using with program.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2007101681787A CN101178724B (en) | 2007-11-28 | 2007-11-28 | Temporary table management method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2007101681787A CN101178724B (en) | 2007-11-28 | 2007-11-28 | Temporary table management method |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN101178724A true CN101178724A (en) | 2008-05-14 |
| CN101178724B CN101178724B (en) | 2011-05-04 |
Family
ID=39404979
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2007101681787A Active CN101178724B (en) | 2007-11-28 | 2007-11-28 | Temporary table management method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN101178724B (en) |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101860449A (en) * | 2009-04-09 | 2010-10-13 | 华为技术有限公司 | Data query method, device and system |
| CN101894142A (en) * | 2010-06-28 | 2010-11-24 | 中兴通讯股份有限公司 | Method and device for preventing database in intelligent network system from deadly embrace |
| CN101739447B (en) * | 2009-11-16 | 2012-11-28 | 金蝶软件（中国）有限公司 | Method and device for managing temporary tables |
| US10534790B2 (en) | 2016-10-20 | 2020-01-14 | International Business Machines Corporation | Dynamic and predictive global temporary tables |
| CN112181990A (en) * | 2020-10-15 | 2021-01-05 | 金蝶云科技有限公司 | Method and device for reusing temporary table |
| CN112199203A (en) * | 2020-11-16 | 2021-01-08 | 奥士康科技股份有限公司 | Method and system for solving deadlock caused by multi-table operation |
-
2007
- 2007-11-28 CN CN2007101681787A patent/CN101178724B/en active Active
Cited By (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101860449A (en) * | 2009-04-09 | 2010-10-13 | 华为技术有限公司 | Data query method, device and system |
| CN101860449B (en) * | 2009-04-09 | 2014-02-19 | 华为技术有限公司 | Data query method, device and system |
| CN101739447B (en) * | 2009-11-16 | 2012-11-28 | 金蝶软件（中国）有限公司 | Method and device for managing temporary tables |
| CN101894142A (en) * | 2010-06-28 | 2010-11-24 | 中兴通讯股份有限公司 | Method and device for preventing database in intelligent network system from deadly embrace |
| CN101894142B (en) * | 2010-06-28 | 2013-11-06 | 中兴通讯股份有限公司 | Method and device for preventing database in intelligent network system from deadly embrace |
| US10534790B2 (en) | 2016-10-20 | 2020-01-14 | International Business Machines Corporation | Dynamic and predictive global temporary tables |
| CN112181990A (en) * | 2020-10-15 | 2021-01-05 | 金蝶云科技有限公司 | Method and device for reusing temporary table |
| CN112199203A (en) * | 2020-11-16 | 2021-01-08 | 奥士康科技股份有限公司 | Method and system for solving deadlock caused by multi-table operation |
Also Published As
| Publication number | Publication date |
|---|---|
| CN101178724B (en) | 2011-05-04 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US6684438B2 (en) | Method of using cache to determine the visibility to a remote database client of a plurality of database transactions | |
| US7730097B2 (en) | Smart database | |
| US6178425B1 (en) | Method of determining the visibility to a remote database client of a plurality of database transactions using simplified visibility rules | |
| US6216135B1 (en) | Method of determining visibility to a remote database client of a plurality of database transactions having variable visibility strengths | |
| JP5833406B2 (en) | Data management architecture related to generic data items using references | |
| US8140495B2 (en) | Asynchronous database index maintenance | |
| CN102681836B (en) | The system and method being extended for a large amount of concurrent users | |
| CN101178724B (en) | Temporary table management method | |
| US20070198566A1 (en) | Method and apparatus for efficient storage of hierarchical signal names | |
| US20070027849A1 (en) | Integrating query-related operators in a programming language | |
| US20070094301A1 (en) | Application programming interface for centralized storage of principal data | |
| US20090234880A1 (en) | Remote storage and management of binary object data | |
| CN104067216A (en) | System and method for implementing a scalable data storage service | |
| US7865912B2 (en) | Method and system for managing tables that are used by network processors to control traffic through a network | |
| CN107038222A (en) | Database caches implementation method and its system | |
| KR20160130256A (en) | Managing data profiling operations related to data type | |
| Taniar et al. | A taxonomy of indexing schemes for parallel database systems | |
| US8554889B2 (en) | Method, system and apparatus for managing computer identity | |
| US5299122A (en) | Table manipulations for enterprise specific search terms | |
| US20130297755A1 (en) | Network element configuration management | |
| US20040260699A1 (en) | Access management and execution | |
| CN111400279B (en) | Data operation method, device and computer readable storage medium | |
| JPH07210435A (en) | Database managing device | |
| KR101063577B1 (en) | Schema and stored procedure real-time management system and method of large database | |
| JP4825504B2 (en) | Data registration / retrieval system and data registration / retrieval method |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant |