This application is related to co-pending application Ser. No. 09/729,515 entitled “Method and System for Enhanced Concurrency in a Computing Environment,” by Clifford L. Hersh and Herbert W. Sullivan, filed on Dec. 4, 2000 still pending, co-pending application Ser. No. 09/884,280 U.S. Pat. No. 7,039,865, entitled “System and Method for Determining the Commutativity of Computational Operations,” by Clifford L. Hersh, filed on Jun. 19, 2001 and specifically incorporated herein by reference, co-pending application Ser. No. 09/884,243 U.S. Pat. No. 6,760,726 entitled “System and Method for Managing Concurrent Operations on Linked Lists,” by Clifford L. Hersh, filed on Jun. 19, 2001, and co-pending application Ser. No. 09/976,931, STILL PENDING, entitled “System and Method for Deferred Rebalancing of a Tree Data Structure” filed on even date herewith.
Not Applicable
1. Field of the Invention
The invention relates generally to the field of computer algorithms and more particularly to a multiphase system and method of performing operations upon data structures.
2. Background Information
Data structures, such as linked lists, trees, sets, and graphs are well known in the computing arts and are used to store information in a logical and efficient manner for access and operation by computing processes. Computing processes operable upon such data structures include operations for inserting, deleting, and updating data structure elements. Such computing processes include concurrent operations such as operations upon a data structure element and operations upon a row including the data structure element.
Systems and methods of the prior art avoid conflicts between concurrent operations by locking the affected data structure or a portion thereof affected by concurrent operations. In this manner the integrity of the data structure being operated upon as well as the integrity of the information stored therein is ensured. Such locking further ensures that concurrent operations operating upon a same element of the data structure or upon the information stored in the same element are performed in the correct sequence to thereby eliminate corruption of the information or error conditions.
Thus for example, concurrent operations such as updating entries in a database are conventionally stored in an ordered list of pending operations. For each pending operation on the list, upon execution of the operation, an affected row in the database is locked until the operation is completed. The affected row is locked in order that other pending operations do not intercede and produce inconsistent results. For example, if the ordered list includes two updates to a cell in the database row, the affected row is locked while a first update operation executes and commits thus preventing a second update operation from concurrently executing. In this manner, the integrity of the database is maintained.
The execution of such operations using locks is expensive. Locking of the data structure can result in significant performance degradation of data structure operations because one operation may have to wait for another operation to complete. Additionally, while the data structure is locked, processes are precluded from reading information from the data structure.
What is needed are systems and methods for performing operations upon data structures which reduce and/or eliminate the need to lock the data structure or the portion thereof being operated upon during the execution of concurrent operations. Such systems and methods preferably reduce the time during which data structures operated upon are locked.
A method for executing operations upon a linked data structure having at least one element includes performing a first set of operation tasks in a first phase in which the linked data structure is not locked. The first set of operation tasks is operable to effect a first set of state transitions characterized by navigation of at least an existing link of the linked data structure.
The method further includes developing a second set of operation tasks, the second set of operation tasks operable to effect a second set of element state transitions characterized by at least a pointer to the linked data structure. The second set of element state transitions is distinct from the first set of element state transitions and a portion of the linked data structure being operated upon by the operation is locked during the execution of the second set of operation tasks. The second set of operation tasks is performed in a second phase and instructions for carrying out the second set of operation tasks are executed atomically.
The system and method of the invention find particular implementation in the rebalancing of tree data structures. It has been found that the rebalancing of a tree data structure can be advantageously deferred. More particularly, the method of the invention finds particular use in such deferred rebalancing including executing a first set of rebalancing operation tasks in the first phase and a second set of rebalancing operation tasks in the second phase.
It has been discovered that the execution of operations upon a data structure can be divided into two phases in such manner that the overall efficiency of a computing system is improved. In an update phase, update phase state transitions of operations as further described herein are executed concurrently thus eliminating the need to lock the affected data structure. During the update phase, the data structure can still be traversed using existing links thereby enabling read operations to execute.
In a commit phase, commit phase state transitions of the operations are executed in an ordered manner. During the commit phase, affected elements of the data structure are locked and the commit phase state transitions are executed atomically. Such transitions include the breaking of existing links thereby precluding the execution of operations requiring navigation of the data structure, such as read operations.
The system and method of the invention provide for overall improvement in the efficiency of the computing system by reducing the time during which the data structure is locked. Furthermore, the system and method of the invention provide for improved efficiency in the case where the computing system is heavily loaded and for improved responsiveness in the case where the computing system is not heavily loaded.
In accordance with one embodiment of the invention and with reference to
In a step 120 the process 100 checks if any operations have been received in step 110. If any operations have been received, then in a step 130 the update phase state transitions of the received operations are either executed or postponed in the update phase as further described herein. Operations postponed are returned to the task queue. In a step 140 the commit phase state transitions of the received operations which have not been postponed are executed in the commit phase. If no operations have been received as determined in step 120, the process 100 returns to step 110 and waits to receive operations. Upon completion of the commit phase in step 140, the check performed in step 120 is repeated.
During the execution of the update phase of step 130 and the commit phase of step 140, additional operations may be received and queued by step 110 for later execution in steps 130 and 140. Thus the number of operations executed in steps 130 and 140 is dependent upon the number of operations queued in step 110. Process 100 thus executes operations in such manner that if a small number of operations are queued in step 110, a small number of operations are executed in steps 130 and 140 and if a large number of operations are queued in step 110, a large number of operations are executed in steps 130 and 140.
It has been found that the process 100 operates to improve the efficiency of the computing system. In the case where relatively few operations are received in step 110, then the process 100 achieves improved responsiveness. If on the other hand, a relatively large amount of operations are received in step 110, then the process 100 achieves improved efficiency by reducing the number of times the process 100 switches between the update phase of step 130 and the commit phase of step 140.
The invention may be practiced in a computing system 200 such as illustrated in
Data structure 240 is preferably a linked structure and includes a plurality of elements 245, such as nodes or list elements as is well known in the art. Elements 245 further include fields 247 such as data fields and links which enable the linked structure. While data structure 240 has been described in terms of nodes and list elements, those skilled in the art will recognize that data structure 240 may include any data organization that uses links or the like to associate and establish relationships between data structure elements 245.
According to one embodiment of the invention, operations upon the data structure 240 include state transitions between defined states as listed in Table 1. An element 245 of data structure 240 affected by the execution of a given operation includes a corresponding state field preferably stored in field 247.
Thus, for example, an insertion operation includes state transitions between a pre-associated state, in which an element 245 to be inserted into data structure 240 is created, to a pending insert state, in which the element 245 to be inserted is linked to the data structure 240 at an insertion point while an existing link at the insertion point is maintained, to a valid state, in which the existing link at the insertion point is removed.
In similar fashion, a deletion operation includes state transitions between a valid state in which an element 245 to be deleted from data structure 240 remains linked to other elements 245 at a deletion point, to a pending delete state in which a link is created between the elements 245 in data structure 240 linked to the element 245 to be deleted, to a deleted state, in which the element 245 to be deleted is no longer linked to the data structure 240.
Additional states include an invalid state and a hidden state. An example of element 245 being in an invalid state is when the element 245 has been deleted from the data structure but the deleted element still physically exists. Additional clean up processes physically delete the deleted element 245. Preferably, such clean up processes execute in the commit phase of step 140 (
An element 245 is in the hidden state following a rollback request in which the element 245 to be inserted is hidden from all operations. As further described herein, an element 245 in the hidden state may undergo a state transition from the hidden state to the invalid state as well as a state transition from the hidden state to the pending insert state.
As explained herein, state transitions are executed in either the update phase of step 130 or the commit phase of step 140 (
The update data 250 (
The state transition from the pre-associated state to the pending insert state similarly involves navigation to the point of insertion in the data structure 240. The state transition from the pending insert state to the hidden state also involves navigation to the insertion point.
During the update phase of step 130 (
In the present invention each table row 320 includes a pending update field (PU) 330 that holds a pointer to update data 250 if update data 250 associated with that row 320 exists. If a specific PU field 330 holds a NULL pointer created when a specific row 320 is developed, then update data 250 associated with the specific row 320 does not exist and no updates are pending on a particular element 245 of data structure 240 associated with the specific row 320. If PU 330 holds a non-NULL pointer then the pointer points to update data 250 associated with the particular element 245.
Update data 250 is developed during the update phase of step 130 (
When added to update data 250, top item 340 includes a flag (not shown) indicating that conflicts have not been checked. Upon encountering such a flag, computer code 220 searches update data 250 for possible conflicts including operations executing upon the same element 245. If no conflicts are found then the flag is modified to indicate that no conflicts exist. If a conflict is found then a rollback of the operation is scheduled for the next commit phase as further described herein, and in particular with reference to
During the commit phase of step 140 (
The instructions from update data 250 include a pointer to the data elements 245 within data structure 240 operated on during the update phase of step 130. These pointers eliminate the need for computer code 220 to navigate through data structure 240 during the commit phase of step 140. The FILO structure of update data 250 forces operations to be performed in an order that assures no conflicts.
An element insertion operation includes, as stated previously, the state transitions from pre-associated to pending insert to valid.
In a step 520 the update phase of step 130 starts. In a step 530 new element 410 to be inserted by the insertion operation is created by computer code 220 if new element 410 does not already exist and a field 247 of the new element 410 is modified to indicate that new element 410 is in the pre-associated state.
In a step 540 field 247 within new element 410 is modified to indicate that new element 410 has transitioned from the pre-associated state to the pending insert state.
In a step 550 computer code 220 navigates through data structure 240 to first element 420 which will become a parent of new element 410 if the insertion operation executes successfully. Step 550 further includes the execution of tasks associated with the insertion of new element 410 such as creating links 450 and 460 and a pointer to the insertion point for use during the commit phase of step 140 (
In a decision step 560, computer code 220 determines if there are existing update data 250 associated with the row 320 in which link 450 to new element 410 is being inserted. If no such update data 250 yet exists, then, in a step 570, memory for update data 250 is allocated and pointed to by PU 330 as described herein and illustrated in
In a step 580 instructions for transitioning the state of first element 420 from the pending insert state to the valid state during the commit phase of step 140 (
Returning to decision step 560, if update data 250 associated with the row in which link 450 to new element 410 to be inserted already exists, then computer code 220 executes a step 582 identical to step 580. After writing data to update data 250 computer code 220 traverses update data 250 in a step 584, testing for operations that would conflict with the insertion of new element 410. Methods of identifying conflicting operations include those described in co-pending application entitled “System and Method for Determining the Commutativity of Computational Operations.”
In a decision step 586 computer code 220 considers if conflicting operations were found in step 584. If a conflicting operation is identified then the insertion operation is not executable and the insertion is blocked from completion in a step 588. The blocking step 588 optionally includes postponing the execution of the operation by returning the insertion operation to task queue 260. Returning the operation to task queue 260 causes the operation to be retried during the next update phase of step 130 (
If on the other hand it is determined in step 586 that the insertion operation can execute without conflicts, then in a step 592 the flag written in step 582 is modified to indicate that conflict tests have been checked. Similarly, the flag written in step 580 is modified to indicate that conflict tests have been checked. Note that although no conflict tests were performed following step 580, the flag written in step 580 is thus far the first data 250 associated with a particular row 320 and, hence, there can be no conflicts.
In a step 594 computer code 220 creates new links 450 and 460 pointing from first element 420 to new element 410 and from new element 410 to element 430 respectively. Links 450 and 460 are only visible to the process performing the insertion of new element 410. In a step 596 computer code 220 proceeds to the next operation that was received in step 510.
Once all update phase state transition of operations received in step 510 are handled, then the update phase of step 130 (
Commit phase state transitions of additional operations received in step 510 are executed by reading and executing, in order, any remaining items of update data 250 associated with the first row 320. Upon execution of all items in such update data 250, the commit phase of step 140 determined in decision step 660 if all pointers 315 in RID 310 have been processed. Step 660 is executed directly after step 630 if the PU 330 examined in step 630 includes a NULL pointer. If all pointers 315 in RID 310 have been processed the method proceeds to step 120 (
While the update and commit phases of steps 130 and 140 (
The system and method of the invention find particular implementation in the rebalancing of tree data structures. Conventional systems either rebalance a tree data structure with every insertion or deletion of a node that causes the tree to become unbalanced, or allow the tree data structure to become unbalanced.
As is well known in the art, searches or traversals of an unbalanced tree are more costly than such operations on a balanced tree. This inefficiency has motivated the prior art to rebalance whenever the tree becomes unbalanced, however slightly.
It has been found that the rebalancing of a tree data structure can be advantageously deferred. More particularly, the method described with reference to
With reference to
It has been found that such deferred rebalancing minimally affects the average search of tree data structure 700. For example the maximum number of steps in a binary search of a binary tree data structure having n nodes is log2 n. Thus for a tree data structure 700 having 64K nodes, the maximum number of steps is 16. It has been found that bounding the length of the unbalanced portion of tree data structure 700 to two times the maximum number of steps in the binary search does not adversely affect the performance of the system in terms of the average number of steps taken to find a particular node of tree data structure 700.
As shown in
In an alternative embodiment, the threshold level compared with the insertion level in step 830 is calculated by adding a constant, such as eight, to the depth of the tree data structure 700 determined after rebalancing step 840. This approach allows tree data structure 700 to grow a constant number levels deeper than the minimum number of levels required to hold the elements nodes within tree data structure 700.
After the rebalancing, tree data structure 700 may be organized as tree data structure 900 shown in
Several embodiments are specifically illustrated and/or described herein. However, it will be appreciated that modifications and variations are covered by the above teachings and within the scope of the appended claims without departing from the spirit and intended scope thereof.
Number | Name | Date | Kind |
---|---|---|---|
4847754 | Obermarck et al. | Jul 1989 | A |
5222238 | Zobre et al. | Jun 1993 | A |
5781910 | Gostanian et al. | Jul 1998 | A |
6868414 | Khanna et al. | Mar 2005 | B2 |
Number | Date | Country |
---|---|---|
466339 | Jan 1992 | EP |