System and method for accessing information in a replicated database
A method for accessing information in a replicated database includes receiving a request for information in a database. The request is associated with a table in the database. The table includes a plurality of identifiers each identifying a portion of the information in the table. The method also includes executing a logical structure associated with the table to produce a logical view of the table. The logical view contains at least a portion of the information from the table without containing the identifiers. The method further includes identifying the requested information in the logical view, and communicating the identified requested information in the logical view.
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.