[미국특허]
System and method for accessing information in a replicated database
원문보기
IPC분류정보
국가/구분
United States(US) Patent
등록
국제특허분류(IPC7판)
G06F-017/00
G06F-017/30
출원번호
US-0211320
(2005-08-25)
등록번호
US-8682847
(2014-03-25)
발명자
/ 주소
Zoltan, William B.
Venderbeck, Sunny C.
출원인 / 주소
Verizon Patent and Licensing Inc.
인용정보
피인용 횟수 :
1인용 특허 :
47
초록▼
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 in
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 pa
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; andmodifying 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; andat 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; andmodify 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.
Bartfai Robert F. ; Divirgilio John ; Doxtader John W. ; LeVangia Peter J. ; Merritt Laura J. ; Rash Nicholas P. ; Reilly Kevin J., Apparatus for synchronizing operator initiated commands with a failover process in a distributed processing system.
Arendt James W. ; Chao Ching-Yun ; Kistler Michael David ; Lawlor Frank Daniel ; Mancisidor Rodolfo Augusto ; Ramanathan Jayashree ; Strong Hovey Raymond, Enqueuing a configuration change in a network cluster and restore a prior configuration in a back up storage in reverse sequence ordered.
Colyer Adrian Mark,GBX, High-availability WWW computer server system with pull-based load balancing using a messaging and queuing unit in front of back-end servers.
Pi-Yu Chung ; Om P. Damani ; Yennun Huang ; Chandra M. Kintala ; Yi-Min Wang, Hosting a network service on a cluster of servers using a single-address image.
Adelman Kenneth Allen ; Kashtan David Lyon ; Palter William L. ; Piper ; II Derrell D., Method and apparatus for a TCP/IP load balancing and failover process in an internet protocol (IP) network clustering system.
Adelman Kenneth Allen ; Kashtan David Lyon ; Palter William L. ; Piper ; II Derrell D., Method and apparatus for an internet protocol (IP) network clustering system.
Joffe Rodney Lance ; Dykes Barry A. ; Brittain Jason Alan ; Oppleman Victor Joseph ; Pettingell Brian Everett ; Lippard James Joseph ; Vandeventer Ian Burke ; Watson Brett Dean ; Hotz Steven Michael , Method and apparatus for balancing the process load on network servers according to network and serve based policies.
Murphy Declan J. ; Talluri Madhusudhan ; Matena Vladimir ; Khalidi Yousef A. ; Bernabeu-Auban Jose M.,ESX ; Tucker Andrew G., Method and apparatus for transparent server failover for highly available objects.
Lamberton, Marc; Levy-Abegnoli, Eric; Montagnon, Eric; Thubert, Pascal, Method and system for dispatching client sessions within a cluster of servers connected to the world wide web.
Gorczyca Robert ; Rashid Aamir Arshad ; Rodgers Kevin Forress ; Warnsman Stuart ; Weaver Thomas Van, Method and system for dynamically reconfiguring a cluster of computer systems.
Raitto John ; Ziauddin Mohamed ; Finnerty James, Rewriting a query in terms of a summary based on aggregate computability and canonical format, and when a dimension tabl.
Adriaan W. Veldhuisen, System and method for managing data privacy in a database management system including a dependently connected privacy data mart.
Klein Johannes ; Van der Linden Robbert C. ; Rathee Raj K., System and method for performing database operations and for skipping over tuples locked in an incompatible mode.
Attanasio Clement Richard ; Goldszmidt German Sergio ; Hunt Guerney Douglas Holloway ; Smith Stephen Edwin, System and method for providing dynamically alterable computer clusters for message routing.
※ AI-Helper는 부적절한 답변을 할 수 있습니다.