Data Replication for Cloud Based In-Memory Databases

• US 20140250070A1
• Filed: 03/04/2013
• Published: 09/04/2014
• Est. Priority Date: 03/04/2013
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: Jens Odenheimer
• Inventors: Boehm, Markus, ODENHEIMER, Jens
• Granted Patent: US 11,023,487 B2
• Time in Patent Office: Days
• US Class Current: 707/634
• 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

Abstract

Disclosed herein are system, method, and computer program product embodiments for data replication for cloud based in-memory databases. An embodiment operates by requesting, by a first computing device, configuration of an on-demand cloud-based in-memory database, assessing, at the first computing device, database system components, and transmitting database system component information from the first computing device to a second computing device over a network. The first computing device receives from the second computing device an evaluation of the database system components and a recommended replication strategy responsive to a replication rule set. The database system components at the first computing device are then configured to use the recommended replication strategy.

Claims

1. A method comprising:

requesting, by a first computing device, configuration of an on-demand cloud-based in-memory database;

assessing, at the first computing device, database system components;

transmitting database system component information from the first computing device to a second computing device over a network;

receiving at the first computing device from the second computing device, an evaluation of the database system components and a recommended replication strategy responsive to a replication rule set; and

configuring the database system components at the first computing device to use the recommended replication strategy.

2. The method of claim 1, the configuring further comprising:

configuring the database system components at the first computing device to use a recommended cloud based replication technology provided by the second computing device.

3. The method of claim 1, the configuring further comprising:

configuring the database system components at the first computing device to use a recommended on premise replication technology provided by the first computing device.

4. The method of claim 1, the configuring further comprising:

configuring the database system components at the first computing device to use an optimized replication strategy comprising one of a first recommended cloud based replication technology provided by the second computing device and a second recommended on premise replication technology provided by the first computing device.

5. The method of claim 4, further comprising:

determining whether the database system components are compatible with a plurality of replication technologies responsive to the replication rule set.

6. The method of claim 1, wherein the database system component information comprises a database suite component, a component version, a component database vendor, a computer hostname, and a computer network address.

7. The method of claim 1, wherein the replication rule set comprises restrictions based on a number of database components, enterprise resource planning, customer relationship management, supplier relationship management, a source database type, a data compression type, and database protocols.

8. A system, comprising:

a memory; and

at least one processor coupled to the memory and configured to;

request, by a first computing device, configuration of an on-demand cloud-based in-memory database;

assess, at the first computing device, database system components;

transmit database system component information from the first computing device to a second computing device over a network;

receive at the first computing device from the second computing device an evaluation of the database system components and a recommended replication strategy responsive to a replication rule set; and

configure the database system components at the first computing device to use the recommended replication strategy.

9. The system of claim 8, the at least one processor further configured to:

configure the database system components at the first computing device to use a recommended cloud based replication technology provided by the second computing device.

10. The system of claim 8, the at least one processor further configured to:

configure the database system components at the first computing device to use a recommended on premise replication technology provided by the first computing device.

11. The system of claim 8, the at least one processor further configured to:

configure the database system components at the first computing device to use an optimized replication strategy comprising one of a first recommended cloud based replication technology provided by the second computing device and a second recommended on premise replication technology provided by the first computing device.

12. The system of claim 11, the at least one processor further configured to:

determine whether the database system components are compatible with a plurality of replication technologies responsive to the replication rule set.

13. The system of claim 8, wherein the database system component information comprises a database suite component, a component version, a component database vendor, a computer hostname, and a computer network address.

14. The system of claim 8, wherein the replication rule set comprises restrictions based on a number of database components, enterprise resource planning, customer relationship management, supplier relationship management, a source database type, a data compression type, and database protocols.

15. A tangible computer-readable device having instructions stored thereon that, when executed by at least one computing device, causes the at least one computing device to perform operations comprising:

requesting, by a first computing device, configuration of an on-demand cloud-based in-memory database;

assessing, at the first computing device, database system components;

transmitting database system component information from the first computing device to a second computing device over a network;

receiving at the first computing device from the second computing device an evaluation of the database system components and a recommended replication strategy responsive to a replication rule set; and

configuring the database system components at the first computing device to use the recommended replication strategy.

16. The computer-readable device of claim 15, the configuring further comprising:

configuring the database system components at the first computing device to use a recommended cloud based replication technology provided by the second computing device.

17. The computer-readable device of claim 15, the configuring further comprising:

configuring the database system components at the first computing device to use a recommended on premise replication technology provided by the first computing device.

18. The computer-readable device of claim 15, the configuring further comprising:

configuring the database system components at the first computing device to use an optimized replication strategy comprising one of a first recommended cloud based replication technology provided by the second computing device and a second recommended on premise replication technology provided by the first computing device.

19. The computer-readable device of claim 18, the operations further comprising:

determining whether the database system components are compatible with a plurality of replication technologies responsive to the replication rule set.

20. The computer-readable device of claim 15, wherein the database system component information comprises a database suite component, a component version, a component database vendor, a computer hostname and a computer network address and wherein the replication rule set comprises restrictions based on a number of database components, enterprise resource planning, customer relationship management, supplier relationship management, a source database type, a data compression type, and database protocols.

21. A method, comprising:

receiving, by a second computing device, a request for configuration of an on-demand cloud-based in-memory database;

receiving, by the second computing device, database system component information regarding database system components at a first computing device;

evaluating, by the second computing device, the database system component information;

determining, by the second computing device, a recommended replication strategy responsive to a replication rule set; and

configuring, by the second computing device, database system components at the first computing device and the on-demand cloud-based in-memory database based on the recommended replication strategy.