US Patent 7676418 Credit portfolio benchmarking system and method

A portfolio benchmarking system comprises a repository of trade data, a repository of consumer data, a build computer, and a benchmarking query application. The repository of trade data comprises a plurality of data items regarding trade lines. The repository of consumer data comprises a plurality of data items regarding consumers, wherein at least some information in the consumer data is not in the trade data and at least some information in the trade data is not in the consumer data. The build computer periodically generates at least one data file comprising a plurality of data items, each data item combining information from the trade data and the consumer data, such that searches can be performed on the combined data without joining trade data and consumer data at query run time. The benchmarking query application executes queries on the data file generated by the build computer.