Patent ID: 7398264

Claim:
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.