METHOD AND SYSTEM FOR THE UPDATE OF REMOTE DATA USING PERSISTENT KEYS

摘要

A method and system for the creation, enhancement and update of data on a customer database (210) using data from a central database (224) and persistent keys (610) that are linked to each data structured disclosed (510). The persistent keys (610) allow matching of equivalent data structures (510) between the remote (312) and central (224) databases so that enhancement data from the central database (224) can be overlaid onto the customer database (210). The persistent keys (510) also make the update of data on the customer database (210) more efficient, since key matching (664) allows the transfer of only the data that is needed to update the customer database (210). Data may be transferred from the central database (224) to the customer database (210) either in batch mode or in a near real-time mode through a direct table join. The linking feature of the persistent keys (610) further allows the linkage of the customer database (210) and the central database (224) to create a multidimensional database.