 |
|
|
|
|
|
 Title: |
US5966706:
Local logging in a distributed database management computer system
|
| Country: |
US United States of America
|
| |
| Inventor: |
Biliris, Alexandros; Chatham, NJ
Jagadish, Hosagrahar Visvesvaraya; Berkeley Heights, NJ
Panagos, Euthimios; New Providence, NJ
Rastogi, Rajeev R.; New Providence, NJ
|
| Assignee: |
AT&T Corp, New York, NY
Lucent Technologies Inc., Murray Hill, NJ
other patents from AT&T CORP. (706518) (approx. 16,328)
News, Profiles, Stocks and More about this company
|
| Published / Filed: |
1999-10-12
/ 1997-02-19
|
| Application Number: |
US1997000803042
|
| IPC Code: |
Advanced:
G06F 11/14;
Core:
more...
IPC-7:
G06F 17/30;
|
| ECLA Code: |
G06F11/14A4C;
|
| U.S. Class: |
Current:
001/001;
707/999.01;
714/E11.13;
Original:
707/010;
707/001;
707/008;
707/100;
707/102;
707/002;
|
| Field of Search: |
707/003,10,101,4,2,100,102,103,200
|
| Priority Number: |
| 1997-02-19 |
US1997000803042 |
|
| Abstract: |
A distributed database management computer system includes a plurality of nodes and a plurality of database pages. When a first node in the computer system updates a first database page, the first node generates a log record. The first node determines whether it manages the first database page. If the first node determines that it manages the first database page, the first node writes the log record to a log storage local to the first node. However, if the first node determines that it does not manage the first database page, the first node then determines whether it includes a local log storage. If the first node includes a local log storage, the first node writes the log record to the local log storage, even if the first node does not manage the first database page. If the first node does not include a local log storage, the first node sends the log record to a second node managing the first database page.
|
| Primary / Asst. Examiners: |
Amsbury, Wayne; Alam, Shahid
|
| INPADOC Legal Status: |
Show legal status actions
Family Legal Status Report
|
| Designated Country: |
CA EP JP MX
|
| Family: |
Show 2 known family members
|
First Claim:
Show all 8 claims |
What is claimed is:
1. A method of operating a first node in a distributed database management computer system having a first set of database pages managed by the first node and a second set of database pages managed by a second node, wherein said first node can update pages in the first and second set, comprising the steps of:
- (a) updating a database page at the first node;
- (b) generating a first log record at the first node;
- (c) determining whether the first database page is managed by the first node;
- (d) if at step (c) it is determined that the first database page is managed by the first node, writing the first log record to a log storage local to the first node; and
- (e) if at step (c) it is determined that the first database page is not managed by the first node:
- (e-1) determining whether the first node includes a local log storage;
- (e-2) if at step (e-1) it is determined that the first node includes a local log storage, writing the first log record to the local log storage; and
- (e-3) if at step (e-1) it is determined that the first node does not include a local log storage, sending the first log record to a node that manages the first database page.
|
| Background / Summary: |
Show background / summary
|
| Drawing Descriptions: |
Show drawing descriptions
|
| Description: |
Show description
|
| Forward References: |
Show 56 U.S. patent(s) that reference this one
|
