CN104376054B - A kind of processing method and processing device of persisted instances object - Google Patents
A kind of processing method and processing device of persisted instances object Download PDFInfo
- Publication number
- CN104376054B CN104376054B CN201410613369.XA CN201410613369A CN104376054B CN 104376054 B CN104376054 B CN 104376054B CN 201410613369 A CN201410613369 A CN 201410613369A CN 104376054 B CN104376054 B CN 104376054B
- Authority
- CN
- China
- Prior art keywords
- unit
- persisted instances
- instances object
- persisted
- database
- 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/24—Querying
- G06F16/245—Query processing
- G06F16/2453—Query optimisation
- G06F16/24534—Query rewriting; Transformation
- G06F16/24549—Run-time optimisation
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F9/00—Arrangements for program control, e.g. control units
- G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
- G06F9/46—Multiprogramming arrangements
- G06F9/466—Transaction processing
Abstract
The embodiment of the invention discloses a kind of processing method of persisted instances object, methods described includes：Persisted instances object is obtained, the persisted instances object is placed in thread；Mark the persistence state of the persisted instances object；When flow engine needs to operate the persisted instances object, the persisted instances object is extracted from thread and is operated, is reentered into after end of operation in thread, and the persistence state is changed according to the operation content；At the end of flow engine is to the persisted instances Object Operations, SQL statement is generated according to the current persistence state of the persisted instances object；The SQL statement is submitted to database.The embodiment of the present invention additionally provides a kind of processing unit of persisted instances object.Present invention decreases the access pressure of database, the process performance of database is improved, while also improves the treatment effeciency of persisted instances object.
Description
Technical field
The present invention relates to computer realm, more particularly to a kind of processing method and processing device of persisted instances object.
Background technology
With the fast development of IT application in enterprises, BPM (Business Process Management, letter
Claiming BPM) effect in Process of Information is more and more prominent.Flow engine is a kind of identification model of computerization, and being can
The finite state machine of business process is completely or partially performed automatically, and its effect is according to a series of process rules, document, information
Or task is transmitted and performed between different executors.
Three kinds of instance objects be present inside flow engine：Flow instance, node instance and work item example, flow engine root
Multiple modification is made to the state of these three objects according to state transition diagram and related contention mechanism, finally flow state is reached one
Individual relatively steady state.
Prior art first turns on db transaction when changing instance objects and obtains persisted instances object, so-called " to hold
Longization " is for " non-persistentization ", and for the data in caching, its attribute is non-persistence；And for database
Data, its attribute is then persistence, that is to say, that if not active delete, the data of persistence are to disappear automatically
Lose, rather than the data of persistence can be automatically deleted over time.
After persisted instances object is obtained, flow engine needs to change persisted instances object described in database
During state, flow engine SQL statement and submits to database according to corresponding to generating the content of modification.When flow engine is to described
Persisted instances Object Operations finish, then submit db transaction, to perform these SQL statements, in database persistently
Change the modification of the state of instance objects.
Wherein, affairs (Transaction) are the base units of con current control, and affairs define a working cell model
Enclose, sequence of operations can be carried out to resource in this working cell, otherwise these operations are carried out, otherwise do not perform.Thing
Business should have four characteristics：Atomicity, uniformity, isolation, continuation, this four characteristics are commonly referred to as the ACID of affairs special
Property.SQL refers to SQL, i.e., a kind of data base querying and programming language, for access data and inquiry,
Renewal and administrative relationships Database Systems.
In the prior art, SQL statement corresponding to will being generated during each flow engine modification instance objects simultaneously submits to number
According to storehouse, because SQL statement is large number of, causes Database Systems pressure heavy, seriously reduce the performance of database, cause to flow
Journey engine operation efficiency is low.
The content of the invention
In order to solve the above-mentioned technical problem of prior art, the embodiment of the present invention provides a kind of place of persisted instances object
Method and device is managed, the access pressure of database is reduced, improves the process performance of database, while also improve persistence
The treatment effeciency of instance objects.
The embodiments of the invention provide a kind of processing method of persisted instances object, methods described includes：
Persisted instances object is obtained, the persisted instances object is placed in thread；
Mark the persistence state of the persisted instances object；
When flow engine needs to operate the persisted instances object, it is real that the persistence is extracted from thread
Example object is operated, and is reentered into after end of operation in thread, and changes the persistence state according to the operation content；
At the end of flow engine is to the persisted instances Object Operations, current according to the persisted instances object
Persistence state generates SQL statement；
The SQL statement is submitted to database.
Preferably, when the persisted instances object of acquisition is not stored in database, then it is real to mark the persistence
The persistence state of example object is " INSERT "；
When the operation that flow engine is carried out to the persisted instances object is updates, then the persistence state change
For " INSERT "；
When the operation that flow engine is carried out to the persisted instances object is deletes, then the persisted instances are deleted
Object and the persistence state.
Preferably, when the persisted instances object of acquisition is stored in data, then the persisted instances pair are marked
The persistence state of elephant is " SELECT "；
When the operation that flow engine is carried out to the persisted instances object is updates, then the persistence state change
For " UPDATE "；
When the operation that flow engine is carried out to the persisted instances object is deletes, then the persistence state change
For " DELETE ".
Preferably, before the SQL statement step to database submission, methods described also includes：
Turn-on data storehouse affairs；
After the SQL statement step to database submission, methods described also includes：
Submit db transaction.
Preferably, before the SQL statement to database submission, methods described also includes：
The SQL statement is ranked up according to the order of database priority from high to low corresponding to the SQL statement.
The embodiment of the present invention additionally provides a kind of processing unit of persisted instances object, and described device includes：Obtain single
Member, mark unit, processing unit, generation unit and sentence submit unit；
Wherein, the acquiring unit is connected with the mark unit, and the mark unit is connected with the processing unit, institute
State processing unit to be connected with the generation unit, the generation unit submits unit to be connected with the sentence；
The acquiring unit, for obtaining persisted instances object, the persisted instances object is placed in thread；
The mark unit, for marking the persistence state of the persisted instances object；
The processing unit, for when flow engine need the persisted instances object is operated when, from thread
The middle extraction persisted instances object is operated, and is reentered into after end of operation in thread, and according to the operation content
Change the persistence state；
The generation unit, at the end of when flow engine to the persisted instances Object Operations, held according to described
The current persistence state generation SQL statement of longization instance objects；
The sentence submits unit, for submitting the SQL statement to database.
Preferably, described device also includes：Affairs opening unit and affairs submit unit；
Wherein, the generation unit is connected with the affairs opening unit, and the affairs opening unit carries with the sentence
Presentate member connection, the sentence submit unit to submit unit to be connected with the affairs；
The affairs opening unit, for turn-on data storehouse affairs；
The affairs submit unit, for submitting db transaction.
Preferably, described device also includes：Sequencing unit, be connected to the generation unit and the sentence submit unit it
Between, for being ranked up according to the order of database priority from high to low corresponding to the SQL statement to the SQL statement.
Compared with prior art, the present invention has advantages below：
The processing method and processing device of persisted instances object provided by the invention only changes persisted instances in thread
Object and persistence state, the ginseng of database is not needed when flow engine operates to the persisted instances object
With after flow engine terminates to the persisted instances Object Operations, SQL is generated according to its current persisted instances object
Sentence, therefore, each persisted instances object at most generate a SQL statement.In terms of existing technologies, due to this implementation
The processing method of the persisted instances object of offer has simplified SQL statement, so reducing the access pressure of database, improves
The process performance of database, while also improve the treatment effeciency of persisted instances object.
Brief description of the drawings
, below will be to embodiment or existing in order to illustrate more clearly of the embodiment of the present application or technical scheme of the prior art
There is the required accompanying drawing used in technology description to be briefly described, it should be apparent that, drawings in the following description are only this
Some embodiments described in application, for those of ordinary skill in the art, on the premise of not paying creative work,
Other accompanying drawings can also be obtained according to these accompanying drawings.
Fig. 1 is a kind of flow chart of the processing method embodiment one of persisted instances object provided by the invention；
Fig. 2 is a kind of flow chart of the processing method embodiment two of persisted instances object provided by the invention；
Fig. 3 is a kind of structured flowchart of the processing unit embodiment one of persisted instances object provided by the invention；
Fig. 4 is a kind of structured flowchart of the processing unit embodiment two of persisted instances object provided by the invention.
Embodiment
In order that those skilled in the art more fully understand the present invention program, below in conjunction with the embodiment of the present invention
Accompanying drawing, the technical scheme in the embodiment of the present invention is clearly and completely described, it is clear that described embodiment is only this
Invention part of the embodiment, rather than whole embodiments.Based on the embodiment in the present invention, those of ordinary skill in the art exist
The every other embodiment obtained under the premise of creative work is not made, belongs to the scope of protection of the invention.
Embodiment of the method one：
Referring to Fig. 1, the figure is a kind of flow chart of processing method embodiment one of persisted instances object provided by the invention.
The processing method for the persisted instances object that the present embodiment provides comprises the following steps：
S101:Persisted instances object is obtained, and the persisted instances object is placed in thread.
The characteristics of having caching period short due to thread, it will be removed after one time service logic is finished, will not be long-term
Occupy internal memory, will not also produce the problem of internal memory overflows, therefore, persisted instances object, which is placed in thread, can improve persistently
Change the treatment effeciency of instance objects.
S102:Mark the persistence state of the persisted instances object.
According to whether there is in advance in database, the persisted instances object includes two kinds：Persistence caused by new
Instance objects, i.e., do not exist in advance in database, and be present in the persisted instances object in database in advance.
For new caused persisted instances object, it is placed directly in thread, and the persistence state is labeled as
" INSERT ", its implication are " insertion "；For the persisted instances object being already present in advance in database, from database
Inquired about, be then put into thread, and be " SELECT " by its persistence status indication, its implication is " selection ".
S103:When flow engine needs to operate the persisted instances object, held from thread described in extraction
Longization instance objects are operated, and are reentered into after end of operation in thread, and described persistently according to operation content change
Change state.
For persisted instances object caused by new, when operation of the flow engine to it is renewal, flow engine is from line
Extract the persisted instances object in journey to be updated, after the completion of renewal operation, by the persisted instances object weight after renewal
Newly it is put into thread, and the persistence state is changed to " INSERT ", or it can be appreciated that keeps " INSERT "
State is constant；When flow engine to it is described it is new caused by the operation of persisted instances object be to delete when, flow engine is from thread
The middle extraction persisted instances, are deleted, therefore be that need not generate SQL in step S104 together with its persistence state
Sentence.
For the persisted instances object being present in advance in database, when operation of the flow engine to it is renewal,
Flow engine extracts the persisted instances object from thread and is updated, will be lasting after renewal after the completion of renewal operation
Change instance objects to be reentered into thread, and the persistence object is changed to " UPDATE "；When flow engine is to described new
The operation of caused persisted instances object is that flow engine extracts the persisted instances object from thread and carried out when deleting
Delete, and its persistence state is changed to " DELETE ".
S104:At the end of flow engine is to the persisted instances Object Operations, according to the persisted instances object
Current persistence state generation SQL statement.
S105:The SQL statement is submitted to database.
In the prior art, flow engine operates to persisted instances object every time, all can accordingly generate a SQL language
Sentence, and submitted to database, and due to the atomicity of affairs, or all operations in affairs are carried out, or not
Perform, therefore for same persisted instances object, the SQL statement ultimately produced is only effectively.Due in practical application
Middle flow engine generally requires largely to operate same persistence object, so the behaviour of this flow engine of prior art
Make method and very big access pressure is caused to database, reduce the process performance of database, while also reduce persistence reality
The treatment effeciency of example object.
The processing method for the persisted instances object that the present embodiment provides only changes persisted instances object in thread
And persistence state, the participation of database is not needed when flow engine operates to the persisted instances object, when
After flow engine terminates to the persisted instances Object Operations, SQL statement is generated according to its current persisted instances object,
Therefore, each persisted instances object at most generates a SQL statement.In terms of existing technologies, because this implementation provides
The processing method of persisted instances object simplified SQL statement, so reducing the access pressure of database, improve data
The process performance in storehouse, while also improve the treatment effeciency of persisted instances object.
For example, when the persisted instances object that flow engine obtains is that the persistence that is previously stored in database is real
During example object, it is assumed that flow engine is operated three times to it, and this is operated respectively three times：Renewal, renewal and deletion.It is existing
Three SQL statements can be produced in technology, database can also correspond to and carry out change operation three times, wherein, result meeting is changed for the first time
Covered by second of change result, and changing result for the second time can be deleted in third time operates, therefore, should although deleting
Persisted instances object is only final result, and preceding change operation twice still needs to be performed.
And the scheme provided according to the present embodiment, realize that the persistence being stored in database is real when flow engine is got
After example object, the persistence state " SELECT " of the persisted instances object is marked.When flow engine is real to the persistence
When example object is carried out for the first time and second updates, its persistence state is changed to " UPDATE ", and only in more new thread
Persisted instances object.When flow engine carries out deletion action to the persisted instances object, the change of its persistence state
For " DELETE ", and SQL statement is generated according to the persistence state.For database, the SQL statement is being received
Afterwards, directly corresponding persisted instances object is deleted, without being updated operation, plays the effect for simplifying SQL statement
Fruit.
Embodiment of the method two：
Referring to Fig. 2, the figure is a kind of flow chart of processing method embodiment two of persisted instances object provided by the invention.
The processing method for the persisted instances object that the present embodiment provides comprises the following steps：
S201：Persisted instances object is obtained, the persisted instances object is placed in thread.
S202：Mark the persistence state of the persisted instances object.
S203：When flow engine needs to operate the persisted instances object, held from thread described in extraction
Longization instance objects are operated, and are reentered into after end of operation in thread, and described persistently according to operation content change
Change state.
S204：At the end of flow engine is to the persisted instances Object Operations, according to the persisted instances object
Current persistence state generation SQL statement.
S205：The SQL statement is carried out according to the order of database priority from high to low corresponding to the SQL statement
Sequence.
In actual applications, flow engine can be operated a lot, such as flow is initiated, node is initiated, flow retracts, stream
Journey hang-up etc., and each operate and may be directed to multiple database tables, under complications, due to each operational access number
It is different according to the order of storehouse table, it is possible to submit SQL statement when produce database deadlocks, concurrency is bigger, produces deadlock
Probability it is bigger.
For example, it is assumed that have two database Table As and B, while there are two thread first, second to carry out SQL to this two tables
Sentence submits operation, but order is different.A-wire journey first performs submission (having locked A tables) to A tables, and second thread is first held to B tables
Go submission (having locked B tables), find B tables by second thread locked when continuing to submit B tables after A-wire journey has submitted A tables
, A-wire journey can only wait locking of the second thread release to B tables just to continue executing with；Similarly second thread continues to carry A tables
During friendship, A tables are found by first thread locked, and second thread can only wait the release of A-wire journey just to continue executing with the lock of A tables, so
Result in the first and second two threads and be waiting for the lock resource that other side's release has occupied, finally can not all perform downwards, so as to make
Into deadlock.
In the present embodiment, to each thread according to database priority corresponding to the SQL statement from high to low
Order is ranked up to the SQL statement, ensures that all threads all submit database table in a fixed order, thus can be with
Effectively avoid the unordered database deadlocks problem brought.
By taking above-mentioned example as an example, in this example, it is assumed that A-wire journey has tri- SQL statements of a, b, c, wherein a, b corresponding A
Table, c correspond to B tables；Second thread has tetra- SQL statements of d, e, f, g, wherein, d, e correspond to B tables, f, g corresponding A table.Assuming that A tables are preferential
Level be higher than B tables, then A-wire journey and second thread are the SQL statement for first carrying out A tables to the execution sequence of A tables and B tables, rear execution
The SQL statement of B tables.If A-wire journey first carries out A tables than second thread, then second thread waits for, until A-wire journey by A tables and
All SQL statements of B tables are carried out success, and second thread just can order execution A tables and B tables.
Certainly, can also be ranked up for the SQL statement in same table according to priority, such as A-wire journey pin logarithm
Priority according to the SQL statement a and b of storehouse Table A is respectively 80 and 100, then b sentences are just first carried out, it is rear to perform a sentences.Referring to
Following table, table 1 are not ranked SQL statement, and table 2 is the SQL statement after sequence.
The not ranked SQL statement of table 1
SQL statement after the sequence of table 2
S206：Turn-on data storehouse affairs.
Persisted instances object is obtained in turn-on data storehouse affairs in the prior art, is carried after the submission of all SQL statements
Db transaction is handed over, therefore, the handling process of whole persisted instances object is required for taking databases.For height simultaneously
Hair, the BPM systems of high traffic, database resource is narrow resources, can serious shadow if taking databases for a long time
Ring the access performance of database.In addition, it is generally the case that application server can preserve a database connection pool, due to data
Storehouse connection pool number is limited, and prolonged db transaction, which can influence database connection, to be discharged in time, and occupancy largely connects
Connect, connection may be exhausted when serious, cause other threads to be waited for, influence the speed accessed.
In order to solve in the prior art because the handling process of whole persisted instances object is required for taking in database
The technical problem of database access performance is influenceed caused by depositing, the present embodiment is just opened before SQL statement is submitted to database
Database is opened, therefore, the db transaction time is only the time for submitting SQL statement, therefore the when span of affairs is greatly reduced
Degree, effectively improves database resource access efficiency.
S207：The SQL statement is submitted to database.
S208：Submit db transaction.
In summary, the processing method for the persisted instances object that the present embodiment provides overcomes database in the prior art
The problem of deadlock, and the time span of affairs is shortened, effectively improve database resource access efficiency.
A kind of processing method of the persisted instances object provided based on above example, the embodiment of the present invention are additionally provided
A kind of processing unit of persisted instances object, describe its operation principle in detail below in conjunction with the accompanying drawings.
Device embodiment one：
Referring to Fig. 3, the figure is a kind of structural frames of processing unit embodiment one of persisted instances object provided by the invention
Figure.
The processing unit for the persisted instances object that the present embodiment provides includes：
Acquiring unit 301, mark unit 302, processing unit 303, generation unit 304 and sentence submit unit 305；
Wherein, the acquiring unit 301 is connected with the mark unit 302, and the mark unit 302 and the processing are single
Member 303 is connected, and the processing unit 303 is connected with the generation unit 304, and the generation unit 304 is submitted with the sentence
Unit 305 connects；
The acquiring unit 301, for obtaining persisted instances object, the persisted instances object is placed on thread
In；
The mark unit 302, for marking the persistence state of the persisted instances object；
The processing unit 303, for when flow engine need the persisted instances object is operated when, from line
The persisted instances object is extracted in journey to be operated, and is reentered into after end of operation in thread, and according in the operation
Hold and change the persistence state；
The generation unit 304, at the end of when flow engine to the persisted instances Object Operations, according to described
The current persistence state generation SQL statement of persisted instances object；
The sentence submits unit 305, for submitting the SQL statement to database.
The processing unit for the persisted instances object that the present embodiment provides only changes persisted instances object in thread
And persistence state, the participation of database is not needed when flow engine operates to the persisted instances object, when
After flow engine terminates to the persisted instances Object Operations, SQL statement is generated according to its current persisted instances object,
Therefore, each persisted instances object at most generates a SQL statement.In terms of existing technologies, because this implementation provides
The processing method of persisted instances object simplified SQL statement, so reducing the access pressure of database, improve data
The process performance in storehouse, while also improve the treatment effeciency of persisted instances object.
Device embodiment two：
Referring to Fig. 4, the figure is a kind of structural frames of processing unit embodiment two of persisted instances object provided by the invention
Figure.
On the basis of said apparatus embodiment one, a kind of processing of persisted instances object provided in an embodiment of the present invention
Device also includes：
Sequencing unit 306, it is connected between the generation unit 304 and sentence submission unit 305, for according to institute
The order of database priority from high to low corresponding to SQL statement is stated to be ranked up the SQL statement.
In the present embodiment, to each thread according to database priority corresponding to the SQL statement from high to low
Order is ranked up to the SQL statement, ensures all threads all operating database tables in a fixed order, thus can be with
Effectively avoid the unordered database deadlocks problem brought.
In order to solve in the prior art because the handling process of whole persisted instances object is required for taking in database
The technical problem of database access performance is influenceed caused by depositing, in the present embodiment, described device also includes：
Affairs opening unit 307 and affairs submit unit 308；
Wherein, the sequencing unit 306 is connected with the affairs opening unit 307, the affairs opening unit 307 and institute
Predicate sentence submits unit 305 to connect, and the sentence submits unit 305 to submit unit 308 to be connected with the affairs；
The affairs opening unit 307, for turn-on data storehouse affairs；
The affairs submit unit 308, for submitting db transaction.
The present embodiment ability turn-on data storehouse before SQL statement is submitted to database, therefore, the db transaction time is only
The time of SQL statement is submitted, therefore the time span of affairs is greatly reduced, effectively improves database resource access efficiency.
Each embodiment in this specification is described by the way of progressive, identical similar portion between each embodiment
Divide mutually referring to what each embodiment stressed is the difference with other embodiment.It is real especially for device
For applying example, because it is substantially similar to embodiment of the method, so describing fairly simple, related part is referring to embodiment of the method
Part explanation.Device embodiment described above is only schematical, wherein described be used as separating component explanation
Unit and module can be or may not be physically separate.Furthermore it is also possible to it is selected according to the actual needs
In some or all of unit and module realize the purpose of this embodiment scheme.Those of ordinary skill in the art are not paying
In the case of creative work, you can to understand and implement.
Described above is only the embodiment of the present invention, it is noted that for the ordinary skill people of the art
For member, under the premise without departing from the principles of the invention, some improvements and modifications can also be made, these improvements and modifications also should
It is considered as protection scope of the present invention.
Claims (6)
1. a kind of processing method of persisted instances object, it is characterised in that methods described includes：
Persisted instances object is obtained, the persisted instances object is placed in thread；
Mark the persistence state of the persisted instances object；
When flow engine needs to operate the persisted instances object, the persisted instances pair are extracted from thread
As being operated, it is reentered into after end of operation in thread, and the persistence state is changed according to the operation content；
At the end of flow engine is to the persisted instances Object Operations, according to current lasting of the persisted instances object
Change state generates SQL statement；
The SQL statement is ranked up according to the order of database priority from high to low corresponding to the SQL statement；
The SQL statement is submitted to database.
2. the processing method of persisted instances object according to claim 1, it is characterised in that when acquisition it is described persistently
Change instance objects to be not stored in database, then the persistence state for marking the persisted instances object is " INSERT "；
When the operation that flow engine is carried out to the persisted instances object is updates, then the persistence state is changed to
“INSERT”；
When the operation that flow engine is carried out to the persisted instances object is deletes, then the persisted instances object is deleted
With the persistence state.
3. the processing method of persisted instances object according to claim 1, it is characterised in that when acquisition it is described persistently
Change instance objects to be stored in data, then the persistence state for marking the persisted instances object is " SELECT "；
When the operation that flow engine is carried out to the persisted instances object is updates, then the persistence state is changed to
“UPDATE”；
When the operation that flow engine is carried out to the persisted instances object is deletes, then the persistence state is changed to
“DELETE”。
4. the processing method of persisted instances object according to claim 1, it is characterised in that carried described to database
Before handing over the SQL statement step, methods described also includes：
Turn-on data storehouse affairs；
After the SQL statement step to database submission, methods described also includes：
Submit db transaction.
5. a kind of processing unit of persisted instances object, it is characterised in that described device includes：Acquiring unit, mark unit,
Processing unit, generation unit and sentence submit unit；
Wherein, the acquiring unit is connected with the mark unit, and the mark unit is connected with the processing unit, the place
Reason unit is connected with the generation unit, and the generation unit submits unit to be connected with the sentence；
The acquiring unit, for obtaining persisted instances object, the persisted instances object is placed in thread；
The mark unit, for marking the persistence state of the persisted instances object；
The processing unit, for when flow engine needs to operate the persisted instances object, being carried from thread
Take the persisted instances object to be operated, be reentered into after end of operation in thread, and changed according to the operation content
The persistence state；
The generation unit, at the end of when flow engine to the persisted instances Object Operations, according to the persistence
The current persistence state generation SQL statement of instance objects；
The sentence submits unit, for submitting the SQL statement to database；
Described device also includes：Sequencing unit, be connected between the generation unit and the sentence submit unit, for according to
The order of database priority from high to low is ranked up to the SQL statement corresponding to the SQL statement.
6. the processing unit of persisted instances object according to claim 5, it is characterised in that described device also includes：
Affairs opening unit and affairs submit unit；
Wherein, the generation unit is connected with the affairs opening unit, and the affairs opening unit is submitted single with the sentence
Member connection, the sentence submit unit to submit unit to be connected with the affairs；
The affairs opening unit, for turn-on data storehouse affairs；
The affairs submit unit, for submitting db transaction.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410613369.XA CN104376054B (en) | 2014-11-04 | 2014-11-04 | A kind of processing method and processing device of persisted instances object |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410613369.XA CN104376054B (en) | 2014-11-04 | 2014-11-04 | A kind of processing method and processing device of persisted instances object |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN104376054A CN104376054A (en) | 2015-02-25 |
| CN104376054B true CN104376054B (en) | 2017-12-29 |
Family
ID=52554961
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410613369.XA Active CN104376054B (en) | 2014-11-04 | 2014-11-04 | A kind of processing method and processing device of persisted instances object |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104376054B (en) |
Families Citing this family (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105912384A (en) * | 2016-04-01 | 2016-08-31 | 广东凯通软件开发有限公司 | Transaction processing method and device for workflow engine |
| CN110717074B (en) * | 2019-09-26 | 2023-04-07 | 上海依图网络科技有限公司 | Object persistence methods, apparatus, media and systems |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101777154A (en) * | 2010-02-01 | 2010-07-14 | 浪潮集团山东通用软件有限公司 | Persistence method of workflow data in workflow management system |
| CN102043625A (en) * | 2010-12-22 | 2011-05-04 | 中国农业银行股份有限公司 | Workflow operation method and system |
| CN102521712A (en) * | 2011-12-27 | 2012-06-27 | 东软集团股份有限公司 | Process instance data processing method and device |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US8073882B2 (en) * | 2007-07-11 | 2011-12-06 | Mats Stefan Persson | Method, system and computer-readable media for managing software object handles in a dual threaded environment |
-
2014
- 2014-11-04 CN CN201410613369.XA patent/CN104376054B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101777154A (en) * | 2010-02-01 | 2010-07-14 | 浪潮集团山东通用软件有限公司 | Persistence method of workflow data in workflow management system |
| CN102043625A (en) * | 2010-12-22 | 2011-05-04 | 中国农业银行股份有限公司 | Workflow operation method and system |
| CN102521712A (en) * | 2011-12-27 | 2012-06-27 | 东软集团股份有限公司 | Process instance data processing method and device |
Also Published As
| Publication number | Publication date |
|---|---|
| CN104376054A (en) | 2015-02-25 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109299102B (en) | HBase secondary index system and method based on Elastcissearch | |
| CN103678556B (en) | The method and processing equipment of columnar database processing | |
| US10191932B2 (en) | Dependency-aware transaction batching for data replication | |
| CN107463632A (en) | A kind of distributed NewSQL Database Systems and data query method | |
| US20140279986A1 (en) | System and Method for Performing a Transaction in a Massively Parallel Processing Database | |
| CN109144994A (en) | Index updating method, system and relevant apparatus | |
| CN105824957A (en) | Query engine system and query method of distributive memory column-oriented database | |
| CN102651007A (en) | Method and device for managing database indexes | |
| CN104239417A (en) | Dynamic adjustment method and dynamic adjustment device after data fragmentation in distributed database | |
| CN106919678A (en) | A kind of database inquiry optimization system and method | |
| CN104423982B (en) | The processing method and processing equipment of request | |
| CN104750720A (en) | Method for achieving high-performance data processing under multithread concurrent access environment | |
| US9734176B2 (en) | Index merge ordering | |
| KR101400214B1 (en) | Appratus for providing a hybrid c interface | |
| CN104504008B (en) | A kind of Data Migration algorithm based on nested SQL to HBase | |
| US11409722B2 (en) | Database live reindex | |
| CN104504001A (en) | Massive distributed relational database-oriented cursor creation method | |
| CN104111958A (en) | Data query method and device | |
| CN106528898A (en) | Method and device for converting data of non-relational database into relational database | |
| WO2019161645A1 (en) | Shell-based data table extraction method, terminal, device, and storage medium | |
| WO2019228015A1 (en) | Index creating method and apparatus based on nosql database of mobile terminal | |
| CN103019691A (en) | Transformation method for extract, transform and load (ETL) operation relation graph and implementation system thereof | |
| CN104683472A (en) | Data transmission method capable of supporting large data volume | |
| WO2020206952A1 (en) | Graph database data import method and apparatus | |
| CN108431766A (en) | Method and system for object-oriented/functional language to be mapped to database language |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |