Restartable scalable database system updates with user defined rules

• US 7,249,140 B1
• Filed: 05/31/2002
• Issued: 07/24/2007
• Est. Priority Date: 05/31/2002
• Status: Active Grant

• Current Assignee: Teradata US, Inc. (Teradata Corporation)
• Original Assignee: NCR Corporation
• Inventors: Korenevsky, Greg, Yung, Alex, Feinholz, Steven
• Primary Examiner(s): Gaffin; Jeffrey
• Assistant Examiner(s): MAHMOUDI, HASSAN
• Application Number:
  US10/160,754
• Time in Patent Office: 1,880 Days
• Field of Search: 706/45, 706/60, 707/2, 719/313
• US Class Current: 707/602
• CPC Class Codes: G06F 16/20 of structured data, e.g. relational data
• CPC Class Codes: Y10S 707/99932 Access augmentation or optimizing
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface

Abstract

A method, computer program, and computer system for updating a database system using a parallel application are disclosed. The parallel application includes a plurality of parallel operators. The method includes receiving records. A unique identifier is assigned to each record. A user defined rule condition is evaluated for each record. An action identifier is assigned to a subset of the records, based on the evaluation of the user defined rule condition. The records are transmitted to the database system with the unique identifiers and, for each of the subset of records, action identifiers.

Claims

1. A method for updating a database system using a parallel application, the parallel application including a plurality of parallel operators, the method comprising:

receiving records;

attaching a unique identifier to each record;

receiving one or more user defined rules;

generating an action and a user defined rule condition for each of the user defined rules;

assigning an action identifier to each action/user defined rule condition pair;

evaluating a first user defined rule condition for each record;

attaching first action identifier to a first subset of the records, based on the evaluation of the first user defined rule condition;

evaluating a second user defined rule condition for each record;

attaching a second action identifier to a second subset of the records, based on the evaluation of the second user defined rule condition;

transmitting the records to the database system with the unique identifiers and, for each of the first subset of the records, the first action identifiers;

transmitting the second action identifier to the database system with each of the second subset of the records; and

transmitting the one or more actions to the database system.

2. The method of claim 1 where the records are received from one or more sources and attaching a unique identifier to each record comprises:

assigning a unique source number to each source of records; and

for each source, combining the unique source number with a sequential number for records from that source.

3. The method of claim 1 where transmitting the records comprises:

transmitting, for each record, a unique update identifier based on the record, its unique identifier, and its action identifiers.

4. The method of claim 1 further comprising:

deriving columns for the received records and wherein transmitting the records to the database system comprises transmitting the derived columns.

5. The method of claim 1 where the first user defined rule condition is satisfied for each of the records.

6. The method of claim 1 where the unique identifiers are attached to the records in at least two parallel processes.

7. The method of claim 1 where the first and the second user defined rule conditions are evaluated for each record in at least two parallel processes.

8. The method of claim 1 where the records are transmitted to the database system in at least two parallel processes.

9. The method of claim 1 further comprising applying an action corresponding to the first action identifier to the first subset of records.

10. The method of claim 1 where the first action identifier corresponds to an UPDATE statement.

11. A computer program, stored on a tangible storage medium, for use in updating a database system using a parallel application, the parallel application including a plurality of parallel operators, the computer program comprising executable instructions that cause a computer to:

receive records;

attach a unique identifier to each record;

receive one or more user defined rules;

generate an action and a user defined rule condition for each of the user defined rules;

assign an action identifier to each action/user defined rule condition pair;

evaluate a first user defined rule condition for each record;

attach first action identifier to a first subset of the records, based on the evaluation of the first user defined rule condition;

evaluate a second user defined rule condition for each record;

attach a second action identifier to a second subset of the records, based on the evaluation of the second user defined rule condition;

transmit the records to the database system with the unique identifiers and, for each of the first subset of the records, the first action identifiers;

transmit the second action identifier to the database system with each of the second subset of records; and

transmit the one or more actions to the database system.

12. The computer program of claim 11 where records are received from one or more sources and the computer attaches a unique identifier to each record by:

assigning a unique source number to each source of records; and

for each source, combining the unique source number with a sequential number for records from that source.

13. The computer program of claim 11 where the computer transmits records by transmitting, for each record, a unique update identifier based on the record, its unique identifier, and its action identifiers.

14. The computer program of claim 11 further comprising executable instructions that cause the computer to:

derive columns for the received records and wherein the computer transmits records to the database system by transmitting the derived columns.

15. The computer program of claim 11 where the first user defined rule condition is satisfied for each of the records.

16. The computer program of claim 11 where the unique identifiers are attached to the records in at least two parallel processes.

17. The computer program of claim 11 where the first and the second user defined rule conditions are evaluated for each record in at least two parallel processes.

18. The computer program of claim 11 where the records are transmitted to the database system in at least two parallel processes.

19. The computer program of claim 11 further comprising executable instructions that cause the computer to apply an action corresponding to the first action identifier to the first subset of records.

20. The computer program of claim 11 where the first action identifier corresponds to an UPDATE statement.

21. A computer system for use in updating a database system using a parallel application, the parallel application including a plurality of parallel operators, the computer system comprising:

a rule compiler adapted to receive one or more user defined rules, generate an action and a user defined rule condition for each of the user defined rules, and assign an action identifier to each action/user defined rule condition pair;

one or more nodes;

a plurality of CPUs, each of the one or more nodes providing access to one or more CPUs;

a plurality of operators, each of the one or more CPUs providing access to one or more operators;

one of the operators comprising a source record identifier generator adapted to receive records and attach a unique identifier to each record;

one of the operators comprising a rule evaluator operator adapted to receive records, including attached unique identifiers, from the source record identifier generator, evaluate a first and a second user defined rule condition for each record, and attach a first action identifier to a first subset of the records based on the evaluation of the first user defined rule condition and attach a second action identifier to a second subset of the records based on the evaluation of the second user defined rule condition;

one of the operators comprising an update operator adapted to receive records, including attached unique identifiers and attached action identifiers, from the rule evaluator operator; and

a database system server adapted to receive records, including attached unique identifiers and attached action identifiers, actions, and an update identifier from the update operator.

22. The computer system of claim 21 where one of the operators comprises a derived column projector operator coupled to provide derived column values to the rule evaluator and the update operator.