System and method for accessing information in a replicated database

Abstract

A method for accessing information in a replicated database may include receiving a request for information in a database. The request may be associated with a table in the database. The table may include a plurality of identifiers each identifying a portion of the information in the table. The method may also include executing a logical structure associated with the table to produce a logical view of the table. The logical view may contain at least a portion of the information from the table, without containing the identifiers. The method may further include identifying the requested information in the logical view, and communicating the identified requested information in the logical view.

1 . A method, comprising:
 storing information in a first database, the information being logically represented as a first table comprising a set of rows and columns;   generating, for each row in the first table, a row identifier that uniquely identifies the row;   receiving a modification to a first row in the first table;   automatically modifying information in a second table of a second database based on the modification to the first row in the first table, wherein the modifying includes:
 identifying, based on the row identifier, a second row in the second table that corresponds to the first row in the first table, and 
 modifying the second row in the second table based on the modification to the first row in the first table; 
   receiving a request for information in the first database, the request corresponding to a query, to the first table, for information in the first row; and   providing the requested information, the providing including providing information in the first row of the first table without providing the row identifier.   
     
     
         2 . The method of  claim 1 , wherein the query for the information in the first row includes a query for all information stored in the first row. 
     
     
         3 . The method of  claim 2 , wherein the query for the information in the first row is received from an application that is not designed to process the row identifier. 
     
     
         4 . The method of  claim 1 , wherein the row identifier is hidden from a user, from whom the modification is received. 
     
     
         5 . The method of  claim 1 , wherein automatically modifying the information in the second database occurs without a request to modify the information in the second database. 
     
     
         6 . The method of  claim 1 , wherein generating, for a particular row in the first table, a particular row identifier includes:
 automatically generating the particular row identifier when the particular row is added to the first table.   
     
     
         7 . The method of  claim 1 , wherein providing the requested information includes:
 generating a logical structure that represents at least a portion of the first table, the at least the portion of the first table including at least the information associated with the first row,   wherein the logical structure does not include the row identifier associated with the first row; and   using the information associated with the first row, in the logical structure, to provide the requested information.   
     
     
         8 . A system, comprising:
 a plurality of memory devices, storing:
 first information regarding a first database, the first information being logically represented as a first table comprising a first set of rows and columns, 
 second information regarding a second database, the second information being logically represented as a second table comprising a second set of rows and columns, and 
 a set of processor-executable instructions; and 
   one or more processors to execute the set of processor-executable instructions, wherein executing the set of processor-executable instructions causes the one or more processors to:
 generate, for each row in the first table, a row identifier that uniquely identifies the row; 
 receive a modification to a first row in the first table; 
 identify, based on the row identifier, a second row in the second table that corresponds to the first row in the first table, 
 modify the second row in the second table based on the modification to the first row in the first table; 
 receive a request for information in the first database, the request corresponding to a query, to the first table, for information in the first row; and 
 provide, based on the request, information in the first row of the first table without providing the row identifier associated with the first row. 
   
     
     
         9 . The system of  claim 8 , wherein the query for the information in the first row includes a query for all information stored in the first row. 
     
     
         10 . The system of  claim 9 , wherein the query for the information in the first row is received from an application that is not designed to process the row identifier. 
     
     
         11 . The system of  claim 8 , wherein the row identifier is hidden from a user, from whom the modification is received. 
     
     
         12 . The system of  claim 8 , wherein automatically modifying the information in the second database occurs without a request to modify the information in the second database. 
     
     
         13 . The system of  claim 8 , wherein, for a particular row in the first table, a particular row identifier is automatically generated when the particular row is added to the first table. 
     
     
         14 . The system of  claim 8 , wherein executing the processor-executable instructions, to provide the requested information, causes the one or more processors to:
 generate a logical structure that represents at least a portion of the first table, the at least the portion of the first table including at least the information associated with the first row,   wherein the logical structure does not include the row identifier associated with the first row; and   use the information associated with the first row, in the logical structure, to provide the requested information.   
     
     
         15 . A non-transitory computer-readable medium, storing a plurality of instructions, which, when executed by a processor, cause the processor to:
 generate, for each row in a first table that comprises a set of rows and columns, a row identifier that uniquely identifies the row;   receive a modification to a first row in the first table;   identify, based on the row identifier, a second row in a second table, the second row corresponding to the first row in the first table,   modify the second row in the second table based on the modification to the first row in the first table;   receive a request for information in the first database, the request corresponding to a query, to the first table, for information in the first row; and   provide, based on the request, information in the first row of the first table without providing the row identifier associated with the first row.   
     
     
         16 . The non-transitory computer-readable medium of  claim 15 , wherein the query for the information in the first row includes a query for all information stored in the first row. 
     
     
         17 . The non-transitory computer-readable medium of  claim 16 , wherein the query for the information in the first row is received from an application that is not designed to process the row identifier. 
     
     
         18 . The non-transitory computer-readable medium of  claim 15 , wherein the row identifier is hidden from a user, from whom the modification is received. 
     
     
         19 . The non-transitory computer-readable medium of  claim 15 , wherein automatically modifying the information in the second database occurs without a request to modify the information in the second database. 
     
     
         20 . The non-transitory computer-readable medium of  claim 15 , wherein the processor-executable instructions, to provide the requested information, include instructions to:
 generate a logical structure that represents at least a portion of the first table, the at least the portion of the first table including at least the information associated with the first row,   wherein the logical structure does not include the row identifier associated with the first row; and   use the information associated with the first row, in the logical structure, to provide the requested information.