Invention Grant
- Patent Title: System and method for subunit operations in a database
- Patent Title (中): 数据库中子单元操作的系统和方法
-
Application No.: US12833388Application Date: 2010-07-09
-
Publication No.: US08209699B2Publication Date: 2012-06-26
- Inventor: Gregory Paul Ferguson , Jeffrey Maurice Heisz , Richard Ta-Min , Yi Wang , Branko Daljevic
- Applicant: Gregory Paul Ferguson , Jeffrey Maurice Heisz , Richard Ta-Min , Yi Wang , Branko Daljevic
- Applicant Address: US OH Dayton
- Assignee: Teradata US, Inc.
- Current Assignee: Teradata US, Inc.
- Current Assignee Address: US OH Dayton
- Agent James Stover
- Main IPC: G06F9/46
- IPC: G06F9/46 ; G06F7/00

Abstract:
A method for processing a transaction request at a database load balancer is disclosed. The method comprises receiving the transaction request, where the transaction request is comprised of one or more operations to be performed upon a database; analyzing the transaction request to determine the one or more operations; analyzing the transaction to determine one or more database units associated with the operations; analyzing the transaction requests and the one or more database units to determine one or more database subunits associated with the database units that the transaction request will perform one or more operations upon; associating one or more database locks with each of the one or more operations; analyzing one or more of the database locks to determine one or more sequence numbers associated with each of the one or more operations; and transmitting one or more unique identifiers for each of the database subunits, the one or more operations with the associated database locks and the sequence numbers to one or more database servers accessible to the database load balancer. Systems, apparatus and computer programming associated with or implementing the method are also disclosed.
Public/Granted literature
- US20110029498A1 System and Method for Subunit Operations in a Database Public/Granted day:2011-02-03
Information query