Patent Number 8,745,029
Referenced Patent # 8,375,010
Method for Generating Indexes for Downloading Data
United States Patent 8,745,029 provides a method for generating indexes for downloading data. This is essential to performance of the database triggers referenced in patent 8,375,010, “Data replication of related records to SaaS Data Sources”, and also boosts performance of reports and other operations that join tables.
Relational Junction provides an on-premise replicated database for SaaS data sources. The metadata provided by a mature SaaS API such as Salesforce.com enables the product to interrogate the relationship structure, and create a database schema with performance indexes on the relationship fields. The automation of this index creation is what sets Relational Junction apart from other vendor offerings in providing a fully indexed warehouse.
A method for bi-directional data replication between a Web Service application and a relational database are provided. In an electronic communications network, a computer implemented method is provided for generating indexes of relationship fields by accessing the metadata of a remote web service. A plurality of records may be downloaded from the remote web service to a computer. The plurality of records may include metadata related to the identity of data fields involved in parent-child record relationships. An index may be built at least partially on the data fields involved in parent-child relationships.
United States Patent 8,745,029 describes a method for generating indexes for downloading data, enabling more reliable and scalable record transfer workflows. The invention supports efficient tracking of record identifiers during large downloads, improving both performance and fault tolerance. When large datasets are transferred, traditional approaches can struggle with restartability and ensuring completeness across retries. This patented method improves download management by organizing identifiers and enabling more controlled retrieval of records. In enterprise environments, this supports more reliable ETL processes, cloud data replication, and migration workflows where large-scale downloads must be accurate and repeatable.
This patent matters because enterprise data movement requires accurate tracking of record identifiers to prevent missed or duplicated records. By generating indexes for downloading data, the invention improves reliability, supports restartable transfers, and enables scalable downloads for large datasets across remote systems and databases.
Method for Download Indexes
Awarded June 3, 2014