Simplifying movement of data to different desired storage portions depending on the state of the corresponding transaction

• US 7,398,264 B2
• Filed: 01/17/2005
• Issued: 07/08/2008
• 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
• Primary Examiner(s): Wong; Don
• Assistant Examiner(s): Dang; Thanh-Ha
• Application Number:
  US10/905,696
• Publication Number:
  US 20060161589A1
• Time in Patent Office: 1,268 Days
• Field of Search: 707/10, 707/1, 707/100, 707/3
• 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 method to simplify a programmer'"'"'s task of maintaining data in a plurality of databases depending on the state of the corresponding transaction, wherein each database is designed to facilitate structured queries and storage, said method comprising:

storing data related to a first transaction in a first database;

receiving a configuration data indicating one or more actions associated with each of a plurality of states of said first transaction, wherein said plurality of states includes a new state and wherein a set of actions associated with said new state indicates a move action of said data related to said first transaction to a second database, wherein said first database and said second database are contained in said plurality of databases;

receiving a database query indicating said new state of said first transaction;

determining said move action corresponding to said new state in said database query by examining said configuration data;

forming a first query directed to said first database and a second query directed to said second database based on said determining; and

executing said first query and said second query to move said data from said first database to said second database in response to said determining of said move action,

wherein said determining, said forming and said executing are performed in response to said receiving of said database query.

2. The method of claim 1, wherein said database query does not indicate a database to which said database query is directed to, and said forming forms said first query and said second query respectively directed to said first database and said second database based on said configuration data, whereby said database query need not specify either database such that 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.

3. The method of claim 2, wherein said configuration data comprises a table containing columns specifying a state, a database for storing the data related to the transaction and a rule, wherein said rule contains said first query,

wherein said forming forms said first query from said rule column in a first row of said table, wherein said state column of said first row matches said new state.

4. The method of claim 3, 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 format automatically such that said programmer is relieved of conversion task.

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

6. The method of claim 4, wherein said first transaction is related to order processing, wherein said new state equals one of an order start process state and an order payment state.

7. The method of claim 4, wherein said forming forms said second query by incorporating the value in said database column in said first row into said database query, wherein said database query is a structured query compatible with Structured Query Language (SQL).

8. The method of claim 1, wherein each of said first query and said second query comprises a corresponding structured query compatible with Structured Query Language (SQL).

9. A computer readable storage medium carrying one or more sequences of instructions causing a digital processing system to simplify a programmer'"'"'s task of maintaining data in a plurality of databases, wherein each database is designed to facilitate structured queries and storage, wherein execution of said one or more sequences of instructions by one or more processors contained in said digital processing system causes said digital processing system to perform the actions of:

storing data related to a first transaction in a first database, said first transaction having one of a plurality of states, and wherein said data is stored in said first database when said first transaction is in a first state;

receiving a configuration data indicating one or more actions associated with each of said plurality of states of said first transaction, wherein said plurality of states includes a new state and wherein a set of actions associated with said new state indicates a store action of new data related to said first transaction in a second database, wherein said first database and said second database are contained in said plurality of databases;

receiving a database query indicating said new state of said first transaction and a corresponding new data;

determining said store action corresponding to said new state in said database query by examining said configuration data;

forming a first query directed to said second database based on said determining; and

executing said first query to store said new data in said second database,

wherein said determining, said forming and said executing are performed in response to said receiving of said database query.

10. The computer readable storage medium of claim 9,

wherein said database query does not indicate a database to which said database query is directed to, and said forming forms said first query directed to said second database based on said configuration data,

whereby said database query need not specify either database such that 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 storage medium of claim 10, wherein said configuration data comprises a table containing columns specifying a state, a database for storing the data related to the transaction and a rule, wherein said rule contains a second query designed to remove said data from said first database,

wherein said forming forms said second query from said rule column in a first row of said table, wherein said state column of said first row matches said new state,

wherein said executing executes said second query to remove said data from said first database, thereby causing movement of data related to said first transaction from said first database to said second database.

12. The computer readable storage 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 format automatically such that said programmer is relieved of conversion task.

13. The computer readable storage medium of claim 11, wherein said forming forms said first query by incorporating the value in said database column in said first row into said database query, wherein said database query is a structured query compatible with Structured Query Language (SQL).

14. The computer readable storage medium of claim 9, wherein each of said first query and said second query comprises a corresponding structured query compatible with Structured Query Language (SQL).

15. An apparatus to simplify a programmer'"'"'s task of maintaining data in a plurality of databases depending on the state of the corresponding transaction, wherein each database is designed to facilitate structured queries and storage, said apparatus comprising:

means for storing data related to a first transaction in a first database, said first transaction having one of a plurality of states, and wherein said data is stored in said first database when said first transaction is in a first state;

means for receiving a configuration data indicating one or more actions associated with each of said plurality of states of said first transaction, wherein said plurality of states includes a new state and wherein a set of actions associated with said new state indicates a store action of new data related to said first transaction in a second database, wherein said first database and said second database are contained in said plurality of databases;

means for receiving a database query indicating said new state of said first transaction and a corresponding new data;

means for determining said store action corresponding to said new state in said database query by examining said configuration data;

means for forming a first query directed to said second database based on said determining; and

means for executing said first query to store said data in said second database,

wherein said determining, said forming and said executing are performed in response to said receiving of said database query.

16. The apparatus of claim 15, wherein said configuration data comprises a table containing columns specifying a state, a database for storing the data related to the transaction and a rule, wherein said rule contains a second query designed to remove said data from said first database,

wherein said means for forming forms said second query from said rule column in a first row of said table, wherein said state column of said first row matches said new state, and forms said first query by incorporating the value in said database column in said first row into said database query,

wherein said means for executing executes said second query to remove said data from said first database, thereby causing movement of data related to said first transaction from said first database to said second database.

17. A computer implemented method to simplify maintenance of data in a plurality of databases depending on the state of the corresponding transaction, wherein each database is designed to facilitate storage in the form of tables and queries using a structured query language (SQL), said method comprising:

storing data related to a first transaction in a first database, said first transaction having one of a plurality of states, and wherein said data is stored in said first database when said first transaction is in a first state;

receiving a configuration data specifying a corresponding target database to store said data related to the transaction for each of said plurality of states;

receiving a database query indicating a new state of said first transaction and a corresponding new data, said database query not indicating a database to which said database query is directed;

determining a first target database corresponding to said new state by examining said configuration data, wherein said first database and said first target database are contained in said plurality of databases;

forming a first query directed to said first target database, wherein said first query is generated by incorporating said first target database in said database query;

executing said first query to store said new data related to said first transaction in said first target database,

wherein said database query and said first query are according to said SQL,

wherein said determining, said forming and said executing are performed in response to said receiving of said database query.

18. The method of claim 17, wherein said configuration data specifies a first rule corresponding to said new state indicating a removal action of said data related to said first transaction from said first database,

wherein said forming forms a second query designed to remove said data from said first database based on said removal action in said first rule in said configuration data,

wherein said executing executes said second query to remove said data from said first database, thereby causing movement of data related to said first transaction from said first database to said first target database.

19. The method of claim 17, wherein said configuration data specifies a first store action of data related to said first transaction in said first database for a second state of said transaction, wherein said second state is different from said first state,

wherein said configuration data also specifies a second rule corresponding to said second state, said second rule indicating a second store action of a portion of data related to said first transaction in a second table, wherein said second table is different from a table in which said data is stored when said first transaction is in said first state,

said method further comprising receiving a second database query indicating said second state of said first transaction, said second database query further indicating a second data for said first transaction, said second database query not indicating a database to which said second database query is directed;

wherein said forming generates a third query and a fourth query based respectively on said first store action and said second store action, wherein said third query is generated by incorporating said first database in said second database query, wherein said fourth query is generated based on said second rule and is designed to store portion of said second data in said second table;

wherein said executing executes said third query and said fourth query, wherein execution of said third query stores said second data in said first database and execution of said fourth query stores portion of said second data in said second table.

20. The method of claim 17, wherein said first database is designed to store said data related to said first transaction according to a first format and said first target database is designed to store said new data according to a second format,

wherein said configuration data indicates a store action of data in said first target database in said second format,

said method further comprising converting said new data to said second format automatically in response to said store action in said configuration data such that said programmer is relieved of conversion task.