IP Library Granted Patent US 11,438,412
Granted Patent B2
US 11,438,412 · App. 14/990,055 · Granted Sep 6, 2022

Technologies for conversion of mainframe files for big data ingestion

Inventors: James Franklin Hewitt (Cincinnati, OH); Senthil Andavar Karmegam (Mason, OH)
Assignee: Worldpay, LLC
H04L67/1097G06F16/258H04L63/0428H04L67/565G06Q2220/00
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 11,438,412
App. No.
14/990,055
Granted
Sep 6, 2022
Kind
B2
Abstract

Technologies for conversion and transmission of data files from a mainframe computing system for big data ingestion. Secure electronic payment transactional data is extracted in a mainframe format, such as Extended Binary Coded Decimal Interchange Code (EBCDIC). The electronic payment transactional data is converted to American Standard Code for Information Interchange (ASCII) code prior to transmission to a big data analytics computing system. The converted data is encrypting and transmitted for ingestion into a big data analytics computing system.

Claims (47)

1. A method for migrating data files from an acquirer computing system including a mainframe computing system to a computer cluster, the method comprising:

receiving, at a point of sale (POS) device, indication of a payment vehicle interacting with the POS device to initiate a payment vehicle transaction, the payment vehicle associated with an account holder, and the POS device associated with a merchant;

receiving, by the POS device, payment vehicle data from the payment vehicle, the payment vehicle data including identifying information of the account holder;

sending, by the POS device to the acquirer computing system, an authorization request, the authorization request including the payment vehicle data and identifying information of the payment vehicle transaction;

sending, by the acquirer computing system, the authorization request to a payment network;

sending, by the payment network, an authorization response to the acquirer computing system based on the authorization request;

sending, by the acquirer computing system, an authorization result to the POS device based on the authorization response;

completing, by the POS device, the payment vehicle transaction based on the authorization result;

receiving, from the POS device, electronic payment transactional data, the electronic payment transactional data comprising: i) a first data format composed of Extended Binary Coded Decimal Interchange Code (EBCDIC), and ii) transaction parameters associated with the completed payment vehicle transaction, wherein the transaction parameters include the payment vehicle data and loyalty account information of the account holder;

storing, by the acquirer computing system, the electronic payment transactional data in a database of a first logical partition of the mainframe computing system, the mainframe computing system being a component of the acquirer computing system;

generating, by the mainframe computing system, an input file based on the electronic payment transactional data stored in the database of the mainframe computing system;

landing, by the mainframe computing system, the input file in a second logical partition of the mainframe computing system, the second logical partition being a subset of a hardware resource of the mainframe computing system virtualized as a separate computer from the first logical partition;

generating, by a mainframe utility of the second logical partition of the mainframe computing system and based on the landing of the input file in the second logical partition, an output file in the second logical partition, wherein generating the output file comprises converting, by the mainframe utility of the second logical partition of the mainframe computing system prior to transmitting the output file to a computer cluster, the first data format of the input file to a second data format composed of American Standard Code for Information Interchange (ASCII) code as the output file in the second logical partition of the mainframe computing system;

encrypting, by the mainframe utility of the second logical partition of the mainframe computing system, the output file in the second logical partition of the mainframe computing system;

transmitting, by a file transfer utility of the mainframe computing system and based on the encrypting, the output file from the second logical partition of the mainframe computing system to an ingestion component of the computer cluster; and

processing, by the computer cluster, the output file received from the second logical partition of the mainframe computing system in ASCII code, wherein the processing includes using distributed processing across a plurality of data nodes of the computer cluster to perform one or more analytic operations, the one or more analytic operations based at least in part on the electronic payment transactional data.

2. The method of claim 1 , further comprising:

compressing, by the mainframe computing system, the output file prior to transmitting the output file to the ingestion component of the computer cluster.

3. The method of claim 2 , wherein the output file is compressed based on a determination of a size of the output file exceeding a size threshold.

4. The method of claim 1 , wherein the mainframe utility comprises operations performed by DFSORT on the mainframe computing system.

5. The method of claim 1 , wherein the computer cluster comprises a Hadoop cluster separate from the mainframe computing system.

6. The method of claim 1 , wherein the input file comprises settlement data for each of a plurality of payment vehicle transactions.

7. The method of claim 1 , wherein the transmitting the output file from the mainframe computing system to the ingestion component of the computer cluster comprises a point-to-point data exchange.

8. A system comprising a point of sale (POS) device, an acquirer computing system including a mainframe computing system, a payment network, and a computer cluster, the system configured to:

receive, by the POS device, an indication of a payment vehicle interacting with the POS device to initiate a payment vehicle transaction, the payment vehicle associated with an account holder;

receive, by the POS device, payment vehicle data from the payment vehicle, the payment vehicle data including identifying information of the account holder;

send, by the POS device to the acquirer computing system, an authorization request, the authorization request including the payment vehicle data and identifying information of the payment vehicle transaction;

send, by the acquirer computing system, the authorization request to the payment network;

based on the authorization request, send, by the payment network, an authorization response to the acquirer computing system;

based on the authorization response, send, by the acquirer computing system, an authorization result to the POS device;

based on the authorization result, complete, by the POS device, the payment vehicle transaction;

receive, by the acquirer computing system from the POS device, electronic payment transactional data, the electronic payment transactional data comprising: i) a first data format composed of Extended Binary Coded Decimal Interchange Code (EBCDIC), and ii) transaction parameters associated with the completed payment vehicle transaction, wherein the transaction parameters include the payment vehicle data and loyalty account information of the account holder;

store, by the acquirer computing system, the electronic payment transactional data in a database of a first logical partition of the mainframe computing system;

generate, by the mainframe computing system, an input file based on the electronic payment transactional data stored in the database of the mainframe computing system;

land, by the mainframe computing system, the input file in a second logical partition of the mainframe computing system, the second logical partition being a subset of a hardware resource of the mainframe computing system virtualized as a separate computer from the first logical partition;

based on the landing of the input file in the logical partition, generate, by a mainframe utility of the second logical partition of the mainframe computing system, an output file in the second logical partition, wherein the generating of the output file comprises converting, by the mainframe utility of the second logical partition of the mainframe computing system prior to transmitting the output file to a computer cluster, the first data format of the input file to a second data format composed of American Standard Code for Information Interchange (ASCII) code as the output file in the second logical partition of the mainframe computing system;

encrypt, by the mainframe utility of the second logical partition of the mainframe computing system, the output file in the second logical partition of the mainframe computing system;

based on the encrypting, transmit, by a file transfer utility of the mainframe computing system, the output file from the second logical partition of the mainframe computing system to a big data ingestion component of the computer cluster; and

process, by the computer cluster, the output file received from the second logical partition of the mainframe computing system in ASCII code, wherein the processing includes using distributed processing across a plurality of data nodes of the computer cluster to perform one or more analytic operations, the one or more analytic operations based at least in part on the electronic payment transactional data.

9. The system of claim 8 , wherein the system is further configured to:

compress, by the mainframe computing system, the output file prior to transmitting the output file to the big data ingestion component of the computer cluster.

10. The system of claim 9 , wherein the compression of the output file is based on a determination of a size of the output file exceeding a size threshold.

11. The system of claim 8 , wherein the mainframe utility comprises operations performed by DFSORT on the mainframe computing system.

12. The system of claim 8 , wherein the input file comprises settlement data for each of a plurality of payment vehicle transactions.

13. The system of claim 8 , wherein the transmitting of the output file from the mainframe computing system to the big data ingestion component of the computer cluster comprises a point-to-point data exchange.

14. The system of claim 8 , wherein the computer cluster comprises a Hadoop cluster.

15. The system of claim 14 , wherein the acquirer computing system comprises the Hadoop cluster.

Assignments (6)
RELEASE OF SECURITY INTERESTS RECORDED AT REEL/FRAMES 066626/0655, 066625/0426, 066625/0347, AND 066625/0276 Recorded Jan 12, 2026
From: WILMINGTON TRUST, NATIONAL ASSOCIATION, AS NOTES COLLATERAL AGENT
To: WORLDPAY, LLC; WORLDPAY ISO AND ECOMMERCE, LLC; PAYMETRIC, LLC; WORLDPAY US, LLC
Reel/Frame 074314/0622 →
RELEASE OF SECURITY INTEREST IN INTELLECTUAL PROPERTY RECORDED AT R/F 066624/0719 Recorded Jan 12, 2026
From: JPMORGAN CHASE BANK, N.A., AS COLLATERAL AGENT
To: WORLDPAY, LLC
Reel/Frame 074315/0412 →
SECURITY INTEREST Recorded Feb 19, 2024
From: WORLDPAY, LLC
To: JPMORGAN CHASE BANK, N.A., AS COLLATERAL AGENT
Reel/Frame 066624/0719 →
SECURITY INTEREST Recorded Feb 19, 2024
From: WORLDPAY, LLC
To: WILMINGTON TRUST, NATIONAL ASSOCIATION, AS NOTES COLLATERAL AGENT
Reel/Frame 066626/0655 →
CHANGE OF NAME Recorded Aug 6, 2018
From: VANTIV, LLC
To: WORLDPAY, LLC
Reel/Frame 046723/0234 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Jan 7, 2016
From: HEWITT, JAMES FRANKLIN; KARMEGAM, SENTHIL ANDAVAR
To: VANTIV, LLC
Reel/Frame 037430/0190 →
Continuity (1)
Related Publication 20170200153A1 · Jul 13, 2017