Granted Patent B2

US 8,682,847 · App. 11/211,320 · Granted Mar 25, 2014

Abstract

Claims (40)

1. 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.

2. The method of claim 1 , wherein the logical view comprises all columns from the first table in the first database, except a column containing the row identifiers.

3. The method of claim 1 , wherein each row identifier, of the plurality of row identifiers, uniquely identifies a row in the first database.

4. The method of claim 1 , further comprising renaming the first table from an original name; and

wherein the logical structure names the logical view after the original name of the first table.

5. The method of claim 4 , wherein the request comprises a query to the first database.

6. The method of claim 5 , wherein the query contains the original name of the first table.

7. The method of claim 5 , wherein identifying the requested information in the logical view comprises executing the query using the logical view.

8. The method of claim 1 , wherein the row identifiers are hidden from a user associated with the computing device, from which the request is received.

9. A system, comprising:

a memory device comprising processor-executable instructions; and

at least one processor to execute the processor-executable instructions, wherein executing the processor-executable instructions causes the at least one processor to:

receive a request from a computing device for information in a first database;

associate 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;

associate a logical structure to the first table;

execute 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;

identify the requested information in the logical view;

communicate the identified requested information to the computing device;

receive a modification to a first row in the first table in the first database;

store information regarding the modification, the information including the row identifier associated with the first row;

locate a second row, in a second table in the second database, using the row identifier associated with the first row; and

modify 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.

10. The system of claim 9 , wherein the logical view comprises all columns from the first table in the first database, except a column containing the row identifiers.

11. The system of claim 9 , wherein each row identifier, of the plurality of row identifiers, uniquely identifies a row in the first database.

12. The system of claim 9 , wherein executing the processor-executable instructions further causes the at least one processor to rename the first table from an original name; and

wherein the logical structure names the logical view after the original name of the first table.

13. The system of claim 12 , wherein the request comprises a query to the first database.

14. The system of claim 13 , wherein the query contains the original name of the first table.

15. The system of claim 13 , wherein identifying the requested information in the logical view comprises executing the query using the logical view.

16. The system of claim 9 , wherein the row identifiers are hidden from a user associated with the computing device, from which the request is received.

Assignments (6)