US 11,947,526 B2
System, method, and apparatus for generating analytics with structured query files
Kevin Isao Mori, San Francisco, CA (US); and Lace Cheung, San Francisco, CA (US)
Assigned to Visa International Service Association, San Francisco, CA (US)
Filed by Visa International Service Association, San Francisco, CA (US)
Filed on Apr. 5, 2022, as Appl. No. 17/713,328.
Application 17/713,328 is a continuation of application No. 16/408,564, filed on May 10, 2019, granted, now 11,321,310.
Claims priority of provisional application 62/670,021, filed on May 11, 2018.
Prior Publication US 2022/0229836 A1, Jul. 21, 2022
This patent is subject to a terminal disclaimer.
Int. Cl. G06F 16/242 (2019.01); G06F 16/16 (2019.01); G06F 16/2453 (2019.01); G06F 16/25 (2019.01); H04L 67/06 (2022.01)
CPC G06F 16/2423 (2019.01) [G06F 16/168 (2019.01); G06F 16/24535 (2019.01); G06F 16/252 (2019.01); H04L 67/06 (2013.01)] 20 Claims
OG exemplary drawing
 
1. A computer-implemented method comprising:
recording, in a transaction database of a transaction processing system, transaction data for a plurality of payment transactions processed in an electronic payment processing network between a plurality of merchants and a plurality of consumers, each payment transaction associated with an account identifier, a merchant system, and an issuer system;
receiving, with at least one processor from at least one of an issuer system and a merchant system in the electronic payment processing network, a request for a plurality of analytics for a segment of the plurality of consumers;
generating, with at least one processor, a request file based on the request for the plurality of analytics, the request file comprising:
a request definition object comprising at least one data structure including a plurality of metadata fields;
a query object representing a plurality of separate queries corresponding to the plurality of analytics; and
a segment object identifying at least one segment file external to the request file, the at least one segment file comprising a list of external user identifiers;
transmitting the request file to a query system;
transmitting the at least one external segment file to the query system separate from the request file; and
receiving, from the query system, a response file structured based on the request definition object and comprising a set of transaction data from the transaction database.