Back to results
US 10,120,921 B2Granted
Parallel transfer of SQL data to software framework
AssigneeMastercard International Incorporated
InventorJoshua A. Allbright
Life of this patent
Estimating the term…
Abstract
A system, method, and computer-readable storage medium configured to facilitate the parallel transfer of Structured Query Language (SQL) data to a software framework.
Claims18
A method of transferring data from at least one relational database to a software framework comprising:
- determining, with a processor, a maximum number of parallel database threads for the at least one relational database;
- based on a predetermined percentage of the maximum number of parallel database threads, load balancing the maximum number of parallel database threads with the processor, resulting in a load-balanced number of parallel database threads;
- determining, with the processor, a number of hash buckets to be used based on a predetermined number of queries per job and a predetermined number of threads per query;
- formulating a formulated query to the at least one relational database with the processor based on a query of the desired information, the formulated query including the load-balanced number of parallel database threads and the number of hash buckets, the formulated query assigning a respective row of the at least one relational database into a hash bucket;
- receiving a query file from the at least one relational database based on the formulated query, the query file being stored on a non-transitory computer-readable storage medium;
- and
- importing the query file into the software framework, the software framework being stored on the non-transitory computer-readable storage medium.
4 more elements
A computing device to transfer data from at least one relational database to a software framework comprising:
- means for determining a maximum number of parallel database threads for the at least one relational database;
- means for load balancing the maximum number of parallel database threads based on a predetermined percentage of the maximum number of parallel database threads, resulting in a load-balanced number of parallel database threads;
- means for determining a number of hash buckets to be used based on a predetermined number of queries per job and a predetermined number of threads per query;
- means for formulating a formulated query to the at least one relational database based on a query of the desired information, the formulated query including the load-balanced number of parallel database threads and the number of hash buckets, the formulated query assigning a respective row of the at least one relational database into a hash bucket;
- means for receiving a query file from the at least one relational database based on the formulated query, the query file being stored on a non-transitory computer-readable storage medium;
- and
- means for importing the query file into the software framework, the software framework being stored on the non-transitory computer-readable storage medium.
4 more elements
A device to transfer data from at least one relational database to a software framework, said device comprising:
- a processor programmed to:
- determine a maximum number of parallel database threads for the at least one relational database,
- load balance the maximum number of parallel database threads with said processor based on a predetermined percentage of the maximum number of parallel database threads, resulting in a load balanced number of parallel database threads,
- determine a number of hash buckets to be used based on a predetermined number of queries per job and a predetermined number of threads per query,
- formulate a formulated query to the at least one relational database based on a query of the desired information, the formulated query including the load balanced number of parallel database threads and the number of hash buckets, the formulated query assigning a respective row of the at least one relational database into a hash bucket,
- receive a query file from the at least one relational database based on the formulated query, and
- import the query file into a software framework;
- and
- a non-transitory computer-readable storage medium coupled to said processor and configured to store the query file and the software framework.
6 more elements
Dependencies are inferred from the claim text.