US 2005/0240601 A1 · System and method for transactional data collection and processing

Abstract

A system and method for loading and processing of transaction data is provided. The system and method can obtain transaction data for commercial cards from many feeds with different data formats. A generic file parser is easily modified to account for different data feed formats. Further processing of the transaction data includes sorting the data into multiple temporary tables, which are then resorted in other sorting and processing operations to properly prepare the data for loading into tables in a database. These tables in the database greatly improve the information available to many different parties who need to access the transaction data in the database. The system and method provides the ability to quickly format large amounts of data and insert it into a database with minimal time.

Claims17

Dependent claims

A system for processing incoming data and inserting said incoming data into a database, comprising:

an incoming data receiving component, to connect to a source of data and receive incoming data;
a parsing component communicating with said incoming data receiving component, to receive and parse said incoming data as a function of a plurality of fields;
a loader component, in communication with said parsing component, to receive parsed data from said parsing component, and to sort said parsed data into a plurality of temporary tables as a function of said plurality of fields;
a data sorting component, in communication with said plurality of temporary tables and with said database, to access sorted data in said plurality of temporary tables, and to re-sort said sorted data into a plurality of tables in said database.

1 more element

Dependencies are inferred from the claim text.

System and method for transactional data collection and processing

Life of this patent

System and method for transactional data collection and processing

Life of this patent

Abstract

Claims17