High availability database system using live/load database copies

• US 20020004799A1
• Filed: 02/12/2001
• Published: 01/10/2002
• Est. Priority Date: 02/11/2000
• Status: Abandoned Application

• Current Assignee: Acta Technology, Inc. (SAP SE)
• Original Assignee: Acta Technology, Inc. (SAP SE)
• Inventors: Burda, Leon, Gorelik, Alexander
• Application Number:
  US09/782,178
• Publication Number:
  US 20020004799A1
• Time in Patent Office: Days
• US Class Current: 707/201
• CPC Class Codes: G06F 16/2365 Ensuring data consistency and integrity
• CPC Class Codes: G06F 16/284 Relational databases

Abstract

In a computing system, wherein applications access databases to obtain data and the databases are updated from time to time and the applications require consistent data from the databases even while an update is occurring, a first database; a second database, wherein the first database and second database a substantive copies of each other outside of an update period; a database indicator that indicates one of the first and second databases as a live database and the other one of the first and second databases as a load database; a query router for routing queries from application to the live database; and a router switcher for switching the database indicator such that the live database becomes the load database and the load database becomes the live database.

Claims

1. A computing system, wherein applications access databases to obtain data and the databases are updated from time to time and the applications require consistent data from the databases even while an update is occurring, the computing system comprising:

a first database;

a second database, wherein the first database and second database a substantive copies of each other outside of an update period;

a database indicator that indicates one of the first and second databases as a live database and the other one of the first and second databases as a load database;

a query router for routing queries from application to the live database; and

a router switcher for switching the database indicator such that the live database becomes the load database and the load database becomes the live database.

2. The computing system of claim 1, wherein the queries from an application to the live database are in the form of SQL queries.

3. The computing system of claim 1, further comprising an update router for routing updates from an updater to the load database.

4. The computing system of claim 3, wherein the updates from an updater to the load database are in the form of SQL statements.

5. The computing system of claim 1, further comprising an update cache that stores updates from the updater including logic to initiate update of the live database with the stored updates when the live database becomes the load database.

6. A method for providing consistent information from a database

management system comprising a plurality of databases, comprising:

receiving a request for a first information item by said database management system;

processing said request by a first database of said database management system, when said request is for a read operation;

processing said request by a second database of said database management system, when said request is for a write operation; and

following a database update period, switching the roles of the first database and the second database such that the database that processed reads then processes writes and the database that processed writes then processes reads.