System and method for accessing information in a replicated database

• US 8,682,847 B2
• Filed: 08/25/2005
• Issued: 03/25/2014
• Est. Priority Date: 10/19/2001
• Status: Expired due to Fees

• Current Assignee: Verizon Patent and Licensing Incorporated (Verizon Communications Inc.)
• Original Assignee: Verizon Patent and Licensing Incorporated (Verizon Communications Inc.)
• Inventors: Zoltan, William B., Venderbeck, Sunny C.
• Primary Examiner(s): CHANNAVAJJALA, SRIRAMA T
• Application Number:
  US11/211,320
• Publication Number:
  US 20060004733A1
• Time in Patent Office: 3,134 Days
• Field of Search: 707 1- 4, 707/10, 707/100, 707/102, 707/103.R, 707200-202, 707/609, 707615-616, 707/634, 707/638, 707/757, 707/758, 707/765, 707/766, 707/802, 707/803, 707/810
• US Class Current: 707/615
• CPC Class Codes: G06F 16/00 Information retrieval; Database structures therefor; File system structures therefor
• CPC Class Codes: G06F 16/27 Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
• CPC Class Codes: G06F 16/951 Indexing; Web crawling techniques
• CPC Class Codes: G06F 16/9538 Presentation of query results
• CPC Class Codes: G06F 17/00 Digital computing or data processing equipment or methods, specially adapted for specific functions information retrieval, database structures or file system structures therefor G06F16/00
• CPC Class Codes: Y10S 707/99931 Database or file accessing
• CPC Class Codes: Y10S 707/99953 Recoverability

Abstract

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.

Claims

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.