IP Library Granted Patent US 8,135,765
Granted Patent B2
US 8,135,765 · App. 12/136,247 · Granted Mar 13, 2012

System and method for a genetic integration of a database into a high availability cluster

Assignee: Software AG
View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 8,135,765
App. No.
12/136,247
Granted
Mar 13, 2012
Kind
B2
Abstract

An interface unit adapted for connecting at least one database to at least one of a plurality of high availability cluster servers (HA cluster servers), wherein each database is adapted to execute a set of database-specific commands and wherein each HA cluster server is adapted to output a set of HA cluster server-specific commands. The interface unit may comprise a first interface layer adapted for receiving each of the set of HA cluster server-specific commands outputted by the HA cluster servers; and a second interface layer adapted for sending each of the set of database-specific commands to the respective databases. The interface unit may be further adapted to map each of the HA cluster server-specific commands to at least one of the database-specific commands.

Claims (26)

1. A non-transitory computer accessible memory medium comprising program instructions adapted for connecting at least one database to at least one of a plurality of high availability cluster servers (HA cluster servers), wherein each database is adapted to execute a set of database-specific commands and wherein each HA cluster server is adapted to output a set of HA cluster server-specific commands, wherein the program instructions are executable to implement:

a. a first interface layer adapted for receiving each of the set of HA cluster server-specific commands outputted by the HA cluster servers; and

b. a second interface layer adapted to communicate with the first interface layer and which is adapted for sending each of the set of database-specific commands to the respective databases, wherein the second interface layer is different from the first interface layer;

c. wherein the program instructions are further executable to map each of the HA cluster server-specific commands to at least one of the database-specific commands.

2. The non-transitory computer accessible memory medium of claim 1 , wherein the program instructions are further executable to respond to one of the HA cluster server-specific commands even when the at least one database does not respond to the at least one database-specific command in a predetermined amount of time.

3. The non-transitory computer accessible memory medium of claim 1 , wherein the program instructions are further executable to implement a set of HA cluster server-independent commands, wherein the interface unit is adapted for mapping each of the set of HA cluster server-specific commands onto the set of HA cluster server-independent commands.

4. The non-transitory computer accessible memory medium of claim 3 , wherein the set of HA cluster server-independent commands comprises at least one of the group of commands comprising: setting the database active, shutting down the database in an ordered manner, monitoring the health of the database and/or shutting down the database independent of whether the database is currently active or inactive.

5. The non-transitory computer accessible memory medium of claim 1 , wherein the program instructions are further executable to implement a set of database-independent commands, wherein the interface unit is adapted for mapping the set of database-independent commands onto each of the set of database-specific commands.

6. The non-transitory computer accessible memory medium of claim 5 , wherein the set of database-independent commands comprises at least one of the group of commands comprising: starting the database, stopping the database with rollback of transactions, monitoring the health of the database, updating a timestamp in a defined location of the database, aborting the database, terminating the database and/or cleaning up the operating system resources used by the database.

7. The non-transitory computer accessible memory medium of claim 1 ,

wherein the program instructions are further executable to implement a set of HA cluster server-independent commands, wherein the interface unit is adapted for mapping each of the set of HA cluster server-specific commands onto the set of HA cluster server-independent commands;

wherein the program instructions are further executable to implement a set of database-independent commands, wherein the interface unit is adapted for mapping the set of database-independent commands onto each of the set of database-specific commands; and

wherein the program instructions are further executable to map the set of HA cluster server-independent commands onto the set of database-independent commands, wherein a HA cluster server-independent command calls at least one database-independent command.

8. The non-transitory computer accessible memory medium of claim 1 , wherein the first interface layer is further adapted for implementing a shared library provided by at least one of the plurality of HA cluster servers.

9. The non-transitory computer accessible memory medium of claim 1 , wherein the first interface layer is further adapted for using a scripting language provided by at least one of the plurality of HA cluster servers.

10. A method for connecting at least one database to at least one of a plurality of high availability cluster servers (HA cluster servers), wherein each database is adapted to execute a set of database-specific commands, and wherein each HA cluster server is adapted to output a set of HA cluster server-specific commands, the method comprising:

a. receiving each of the set of HA cluster server-specific commands outputted by the HA cluster servers at a first interface layer; and

b. sending each of the set of database-specific commands to the respective databases from a second interface layer, wherein the second layer is different from the first interface layer and adapted to communicate with the first interface layer;

c. wherein each of the HA cluster server-specific commands is mapped to at least one of the database-specific commands.

11. The method of claim 10 , further comprising responding to one of the HA cluster server-specific commands even when the at least one database does not respond to the at least one database-specific command in a predetermined amount of time.

12. The method of claim 10 , further comprising mapping each of the set of HA cluster server-specific commands onto a set of HA cluster server-independent commands.

13. The method of claim 10 , further comprising mapping a set of database-independent commands onto each of the set of database-specific commands.

14. The method of claim 10 , further comprising:

mapping each of the set of HA cluster server-specific commands onto a set of HA cluster server-independent commands;

mapping a set of database-independent commands onto each of the set of database-specific commands; and

mapping the set of HA cluster server-independent commands onto the set of database-independent commands, wherein a HA cluster server-independent command calls at least one database-independent command.

Assignments (2)
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Sep 25, 2024
From: SOFTWARE AG
To: INTERNATIONAL BUSINESS MACHINES CORPORATION
Reel/Frame 069048/0240 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Jul 31, 2008
From: SCHULER, KLAUS; GREINER, MARKUS
To: SOFTWARE AG
Reel/Frame 021320/0342 →
Priority Claims (1)
EP 08010216 · Jun 4, 2008 · regional
Continuity (1)
Related Publication 20090307246A1 · Dec 10, 2009