Visa International Service Association

Abhijith Ramesh Kashyap

Sukalyan Chakraborty

Prithwiraj Mitra

Mahesh Subhash Joshi

Urjit Anand Khadilkar

Nelson Inas Dsouza

Nitin Singhal

Basudeb Ghosh

Mahesh Govind Joshi

Nikhil Jayant Ghate

Sathis Kumar Appukutty

Rohith Reddy Sannapareddy

A system and method may retrieve transaction data for a plurality of electronic payment system transactions. The transaction data may describe a plurality of electronic payment transactions between a payment network system and a plurality of merchants. The transaction data may include a transaction location and a merchant store number. The system and method may parse the transaction data to identify the transaction location and the merchant store number and analyze the retrieved and parsed transaction data to identify one or more centroids for at least a portion of the retrieved and parsed transaction data. The one or more centroids may correspond to a merchant location for each transaction of the retrieved and parsed transaction data. The system and method may then clean the retrieved and parsed transaction data having a transaction location outside a threshold distance from the one or more centroids to include accurate merchant store number data.

System and method for determining merchant store number

Provided is a method for managing source identifiers of clustered records, which may include receiving a plurality of records, each having identification data associated with a source thereof. The records may be sorted into a first plurality of clusters. A first source identifier may be generated for each cluster. Update data associated with an update to the records may be received. At least some of the records may be sorted into a second plurality of clusters. A first cluster of the second plurality of clusters may have first identification data different from at least one cluster of the first plurality of clusters, and a second cluster of the second plurality of clusters may have identification data that substantially matches the at least one cluster. Whether to assign the first source identifier to the first or second cluster may be determined. A system and computer program product are also disclosed.

Method, system, and computer program product for managing source identifiers of clustered records

Embodiments include apparatuses, methods, and systems for managing a data warehouse associated with an electronic payment transaction processing network. A first set of stores are active and a second set of stores are inactive in an offer program related to merchandise of a merchant. A first set of transaction records for a first set of transactions from the first set of stores and a second set of transaction records for a second set of transactions from the second set of stores are obtained. A first set of operations on the data warehouse for the first set of transaction records and a second set of operations on the data warehouse for the second set of transaction records may be performed. The second set of operations, different from the first set of operations, includes an update operation on the data warehouse. Other embodiments may also be described and claimed.

Management of data warehouse for electronic payment transaction processing networks

Growing community of inventors

San Carlos, CA, United States of America

Abhijith Ramesh Kashyap