United States Patent 8,122,040 yields a major competitive advantage for Sesame Software’s Relational Junction data warehouse offering, which includes dozens of source applications and databases and all popular databases for the warehouse.

This patent describes a scalability technique that breaks down the replication process into smaller data sets by ranges of time stamps in the source data. This allows Relational Junction replication products to copy unlimited data sets by breaking them into discreet ranges and checkpointing the results for restartability. The time ranges are variable length, depending on how much data is queried in the previous time range, and adjusted to prevent attempting to download too much in any one interval. This prevents timeouts from the SaaS data source and also makes the process restartable at the point of failure rather than having to repeatedly truncate and reload a database table when failures occur.

Some of Sesame Software’s customers have terabytes of data in the cloud, and we are able to load it to the on-premise or cloud data warehouse despite numerous timeouts and restarts during the initial load.