System and method for accessing information in a replicated database

• US 20060004733A1
• Filed: 08/25/2005
• Published: 01/05/2006
• Est. Priority Date: 10/19/2001
• Status: Active Grant

• Current Assignee: Verizon Patent and Licensing Incorporated (Verizon Communications Inc.)
• Original Assignee: Verizon Patent and Licensing Incorporated (Verizon Communications Inc.)
• Inventors: Vanderbeck, Sunny C., Zoltan, William B.
• Granted Patent: US 8,682,847 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• 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 for accessing information in a replicated databae, comprising:

receiving a request for information in a database;

associating the request with a table in the database, the table comprising a plurality of identifiers each identifying a portion of the information in the table;

associating a logical structure to the table;

executing the logical structure to produce a logical view of the table, the logical view containing at least a portion of the information from the table without containing the identifiers; and

identifying the requested information in the logical view.