Simplifying Movement of Data to Different Desired Storage Portions Depending on the State of the Corresponding Transaction

• US 20060161589A1
• Filed: 01/17/2005
• Published: 07/20/2006
• Est. Priority Date: 01/17/2005
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Krishnamoorthy, Karthick
• Granted Patent: US 7,398,264 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2379 Updates performed during online database operations; commit processing
• CPC Class Codes: Y10S 707/99931 Database or file accessing
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching

Abstract

A user may merely need to specify various states of transactions and actions to be performed upon reaching a state for the corresponding transaction, and a front end block may automatically perform an action when the corresponding state is reached. Each action may indicate any necessary movement of data to a new storage portion. As a result, a programmer can be shielded from various details (e.g., which database to store the data in, data format conversions) in (developing the code for) processing the transactions.

Claims

1. A software implemented method to simplify a programmer'"'"'s task of moving data to different storage portions depending on the state of the corresponding transaction, said method comprising:

storing data related to a first transaction in a first storage portion;

receiving a configuration data indicating one or more actions to be performed associated with each of a plurality of states of transactions;

receiving a transaction data indicating a new state of said first transaction;

determining a first set of actions to be performed associated with said new state according to said configuration data; and

executing said first set of actions in response to said receiving,

wherein said first set of actions specify moving data related to said first transaction from said first storage portion to a second storage portion,

wherein said programmer developing code to process said first transaction is relieved of the task of having to specify movement of data related to said first transaction from said first storage portion to said second storage portion.

2. The method of claim 1, wherein said first portion and second portion respectively comprise a first table and a second table in a database.

3. The method of claim 1, wherein said first portion and second portion respectively comprise a first database and a second database, whereby said programmer can develop code with a view of a single database even though data related to said first transaction is stored in different databases in different states.

4. The method of claim 3, wherein said configuration data comprises a table containing columns specifying a present state, a database in which the data related to the transaction is to be stored, and a rule, wherein said rule indicates any additional actions which are to be performed corresponding to said present state.

5. The method of claim 4, wherein said first database stores a portion of said first transaction according to a first format and said second database stores said portion according to a second format, said method further comprising converting said portion from said first format to said second automatically such that said programmer is relieved of conversion task.

6. The method of claim 5, wherein said second format comprises extended Meta Language (XML).

7. The method of claim 5, wherein said first transaction is related to order processing.

9. The computer readable medium of claim 1, wherein said first portion and second portion respectively comprise a first table and a second table in a database.

10. The computer readable medium of claim 1, wherein said first portion and second portion respectively comprise a first database and a second database, whereby said programmer can develop code with a view of a single database even though data related to said first transaction is stored in different databases in different states.

11. The computer readable medium of claim 10, wherein said configuration data comprises a table containing columns specifying a present state, a database in which the data related to the transaction is to be stored, and a rule, wherein said rule indicates any additional actions which are to be performed corresponding to said present state.

12. The computer readable medium of claim 11, wherein said first database stores a portion of said first transaction according to a first format and said second database stores said portion according to a second format, further comprising converting said portion from said first format to said second automatically such that said programmer is relieved of conversion task.

13. The computer readable medium of claim 12, wherein said second format comprises extended Meta Language (XML).

14. The computer readable medium of claim 12, wherein said first transaction is related to order processing.

8. A computer readable medium carrying one or more sequences of instructions causing a digital processing system to simplify a programmer'"'"'s task of moving data to different storage portions depending on the state of the corresponding transaction, wherein execution of said one or more sequences of instructions by one or more processors contained in said digital processing system causes said one or more processors to perform the actions of:

storing data related to a first transaction in a first storage portion;

receiving a configuration data indicating one or more actions to be performed associated with each of a plurality of states of transactions;

receiving a transaction data indicating a new state of said first transaction;

determining a first set of actions to be performed associated with said new state according to said configuration data; and

executing said first set of actions in response to said receiving,

wherein said first set of actions specify moving data related to said first transaction from said first storage portion to a second storage portion,

wherein said programmer developing code to process said first transaction is relieved of the task of having to specify movement of data related to said first transaction from said first storage portion to said second storage portion.