Sesame Software™ Awarded Cloud Services Data Replication Patent

SAN DIEGO, April 2, 2012 /PRNewswire/ -- Today, Sesame Software, Inc. announced that the company has been awarded United States Patent 8,122,040.   The patent award yields a major competitive advantage for Sesame Software's Relational Junction™ replication and data warehouse offering which includes products for Salesforce®, NETSUITE® and QuickBooks®.  Among the vendors offering replication and integration tools, only Relational Junction can effectively replicate massive amounts of data for integration and analysis with other corporate data and for data backup to meet regulatory compliance which is mandated in a variety of industries. 

According to Sesame CEO, Rick Banister, "Sesame Software's patented technique of segmenting data by variable date ranges means, for example, our Relational Junction for Salesforce product is the only data replication product that can effectively handle millions of records."

The Challenge of Large Volume Data Replication

Historically, the technique for retrieving and loading massive amounts of data from a cloud services application into a relational database is to perform one single pass.  This technique is fundamentally flawed because web services typically have more restrictive performance and reliability characteristics compared to relational databases due to Internet latency and bandwidth capacity. Therefore, to reliably replicate large amounts of data, it is 1) important that the initial loading of the data is reliable, 2) critical that the load can be restarted at the point of failure and 3) the data loading does not over burden the source system.

As data volumes grow exponentially across all businesses, the single pass data loading technique either takes so long that network and system stability jeopardize the likelihood of a successful load or the load is timed out by the data source application. 

Salesforce.com is a typical cloud application from which many companies want to replicate their data for both backup and integration with other corporate data for business analysis.  Using the old data replication technique of a single pass load, attempts to load millions of records can fail. 

The Solution – Sesame Software Patent

Sesame Software has patented a reliable and scalable method for bi-directional data replication between a Web Service or cloud application and a relational database. Techniques of Enterprise Application Integration (EAI) and Extract Transform Load (ETL) technology are employed.

Sesame's replication technique involves a series of queries by time range. The time range is automatically optimized to an interval that both minimizes the number of queries and allows restart at the failure point in the event of network or system failure.  A sophisticated heuristic automatically lengthens or shortens the query interval depending upon the results of the previous query.  This new data loading process circumvents the failure points of, and eliminates the manual intervention required for, older replication and integration products.  This is the heart of Sesame Software's patent.

Organizations with millions of records residing in cloud applications require the ability to reliably replicate their data to a local data warehouse for a variety of business critical processes including: integration with other application data, data backup, reporting, regulatory compliance.  Absent a reliable and scalable data loading and replication product, the process is prone to unrecoverable crashes and the initial loading of large data sets will fail. 

Sesame Software is a privately held company specializing in the development and worldwide distribution of scalable, developer-friendly software solutions for data replication, integration and protection – the Relational Junction™ Suite.  The Sesame team comprises business and technical professionals experienced in software development, distribution and data integration For more information, please visit www.sesamesoftware.com.

Contact: Andrea Skov

[email protected]

SOURCE Sesame Software, Inc.