Providing multiple concurrent transactions on a single database schema using a single concurrent transaction database infrastructure

• US 9,384,257 B2
• Filed: 06/24/2013
• Issued: 07/05/2016
• Est. Priority Date: 06/24/2013
• Status: Expired due to Fees

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Bar, Oren, Stotland, Vadim, Maoz, Itay
• Primary Examiner(s): LE, HUNG D
• Application Number:
  US13/925,126
• Publication Number:
  US 20140379674A1
• Time in Patent Office: 1,107 Days
• Field of Search: None
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2343 Locking methods, e.g. distributed locking or locking implementation details
• CPC Class Codes: G06F 16/284 Relational databases

Abstract

Executing multiple concurrent transactions on the single database schema using a single concurrent transaction database infrastructure, wherein the single database schema is a single concurrent transactional relational database.

Claims

1. A method for efficient use of a relational database by a processor device in a computing environment, the method comprising:

executing a plurality of concurrent transactions on the single database schema using a single concurrent transaction database infrastructure, wherein the single database schema is a single concurrent transactional relational database;

combing a plurality of databases to expose the single database schema for providing a plurality of concurrent transactions on the single database schema using the single concurrent transactional relational database, wherein character traits and behaviors of a transactional relational database executing multiple concurrent transactions are maintained;

calculating a plurality of parameters for controlling a tradeoff between at least each of concurrency, throughput, and latency;

initializing a semaphore for controlling the plurality of concurrent transactions; and

executing a plurality of concurrent transactions on the single database schema in parallel on the single database schema using the single concurrent transaction database infrastructure.

2. The method of claim 1, further including storing a subset of a plurality of entries according to primary key values for occupying data in each of the plurality of databases, wherein each of the plurality of databases have an identical single database schema.

3. The method of claim 2, further including performing one of:

performing workload for a plurality of single entry operations,

calculating a database index when a single entry operation is executed and acquiring a lock of the database index, wherein upon acquiring the lock of the database index;

executing the single entry operation on a designed one of a designated one of a plurality of databases.

4. The method of claim 1, further including attaching an N number of the plurality of databases for executing a singular concurrent transaction across a plurality of entries, wherein alternative transactions and alternative queries are locked for the duration of the singular concurrent transaction.

5. The method of claim 4, further including cloning a single database operation for the plurality of entries for performing identical operations on each one of the N number of the plurality of databases in a single unified transaction, wherein each lock of each of the N number of the plurality of databases are locked in an increasing order to prevent deadlocks with other operations.

6. A system for efficient use of a relational database in a computing environment, the system comprising:

a plurality of databases, wherein the plurality of databases are relational databases; and

at least one processor device in association with the plurality of databases and operable in the computing environment, wherein processor device;

executes a plurality of concurrent transactions on a single database schema using the single concurrent transaction database infrastructure, wherein the single database schema is a single concurrent transactional relational database,

combines a plurality of databases to expose the single database schema for providing a plurality of concurrent transactions on the single database schema using the single concurrent transactional relational database, wherein character traits and behaviors of a transactional relational database executing multiple concurrent transactions are maintained,

calculates a plurality of parameters for controlling a tradeoff between at least each of concurrency, throughput, and latency,

initializes a semaphore for controlling the plurality of concurrent transactions, and

executes a plurality of concurrent transactions on the single database schema in parallel on the single database schema using the single concurrent transaction database infrastructure.

7. The system of claim 6, wherein the at least one processor device stores a subset of a plurality of entries according to primary key values for occupying data in each of the plurality of databases, wherein each of the plurality of databases have an identical single database schema.

8. The system of claim 7, wherein the at least one processor device performs one of:

performing workload for a plurality of single entry operations,

calculating a database index when a single entry operation is executed and acquiring a lock of the database index, wherein upon acquiring the lock of the database index;

executing the single entry operation on a designed one of a designated one of a plurality of databases.

9. The system of claim 6, wherein the at least one processor device attaches an N number of the plurality of databases for executing a singular concurrent transaction across a plurality of entries, wherein alternative transactions and alternative queries are locked for the duration of the singular concurrent transaction.

10. The system of claim 9, wherein the at least one processor device clones a single database operation for the plurality of entries for performing identical operations on each one of the N number of the plurality of databases in a single unified transaction, wherein each lock of each of the N number of the plurality of databases are locked in an increasing order to prevent deadlocks with other operations.

11. A computer program product for efficient use of relational databases in a computing environment by at least one processor device, the computer program product comprising a non-transitory computer-readable storage medium having computer-readable program code portions stored therein, the computer-readable program code portions comprising:

a first executable portion that executes a plurality of concurrent transactions on the single database schema using a single concurrent transaction database infrastructure, wherein the single database schema is a single concurrent transactional relational database;

a second executable portion that combines a plurality of databases to expose the single database schema for providing a plurality of concurrent transactions on the single database schema using the single concurrent transactional relational database, wherein character traits and behaviors of a transactional relational database executing multiple concurrent transactions are maintained;

a third executable portion that calculates a plurality of parameters for controlling a tradeoff between at least each of concurrency, throughput, and latency;

a fourth executable portion that initializes a semaphore for controlling the plurality of concurrent transactions; and

a fifth executable portion that executes a plurality of concurrent transactions on the single database schema in parallel on the single database schema using the single concurrent transaction database infrastructure.

12. The computer program product of claim 11, further including a sixth executable portion that stores a subset of a plurality of entries according to primary key values for occupying data in each of the plurality of databases, wherein each of the plurality of databases have an identical single database schema.

13. The computer program product of claim 12, further including a seventh executable portion that performs one of:

performing workload for a plurality of single entry operations,

calculating a database index when a single entry operation is executed and acquiring a lock of the database index, wherein upon acquiring the lock of the database index;

executing the single entry operation on a designed one of a designated one of a plurality of databases.

14. The computer program product of claim 11, further including a sixth executable portion that attaches an N number of the plurality of databases for executing a singular concurrent transaction across a plurality of entries, wherein alternative transactions and alternative queries are locked for the duration of the singular concurrent transaction.

15. The computer program product of claim 14, further including a seventh executable portion that:

clones a single database operation for the plurality of entries for performing identical operations on each one of the N number of the plurality of databases in a single unified transaction, wherein each lock of each of the N number of the plurality of databases are locked in an increasing order to prevent deadlocks with other operations.