Patent ID: 8682847

Claim:
A method performed by at least one processor, the method comprising: receiving a request from a computing device for information in a first database; associating the request with a first table in the first database, the first table including a plurality of rows, each row being associated with a particular row identifier, of a plurality of row identifiers, the plurality of identifiers facilitating an automated replication of changes to information in the first table to a second different database; associating a logical structure to the first table; executing the logical structure to produce a logical view of the first table, the logical view including one or more rows from the first table, without containing the row identifiers associated with the one or more rows; identifying the requested information in the logical view; communicating the identified requested information to the computing device; receiving a modification to a first row in the first table in the first database; storing information regarding the modification, the information including the row identifier associated with the first row; locating a second row, in a second table in the second database, using the row identifier associated with the first row; and modifying the second row in the second table in the second database based on the received modification to the first row in the first table in the first database.