Sesame Software Assigned 4 Patents in 2020 for Data Replication and SaaS Disaster Recovery Techniques

Sesame Software, Inc. announced four USPTO patents awarded in 2020, further cementing its lead in instant data warehouse and SaaS disaster recovery applications.

Click to enlarge

• 10,838,983 Method of integrating remote databases by automated client scoping of update requests prior to download via a communications network
  Abstract: “A system and method enable the selection of a time range, or other record selection criteria, of database records for upload from a local database source and for transfer to a remote database. A specifically bounded time period is selected to limit the number of data records selected for upload in a particular action to those records that are individually associated with date time stamp values falling within the specified time period. This limitation of records selected for inclusion in an upload process to data records having associations with date time stamps falling within a limited time range, or other criteria, reduces a likelihood of overload in transferring data and thereby reduces the incidence of time-outs in the communication of a local database, any intermediary server or software action, and the remote database in an updating of the recipient database to reflect a current state of the local database. A plurality of asynchronous threads may be employed to contemporaneously upload records associated with date time stamps having values within a requested time range whereby data records may be uploaded in parallel.“

• 10,812,567 Multi-threaded download with asynchronous writing
  Abstract: “A system and method are presented for the facilitation of threaded download of software record identifiers and software records. Software record identifiers and software records are stored in separate one-dimensional stacks, which stacks feed a plurality of download threads in a first-in, first-out method. Software records and/or software record identifiers may optionally be written in parallel, or in an asynchronous manner. The total number of threads allowed to a user may optionally be limited to a pre-set number. The speed and efficiency of downloading records is increased through use of all of the cores of multi-cored computing systems to substantively concurrently download several threads. The method further allows a failed download thread to restart from the point at which it failed, rather than beginning again from the origin of the thread, thus ensuring that no software records are duplicated, and that no software records are skipped within a download thread.“

• 10,540,237 System and method for procedure for point-in-time recovery of cloud or database data and records in whole or in part
  Abstract: “A user interface, system and method are provided for the recovery and restoration of software records or elements thereof to earlier record or data iterations or versions in order to overcome or repair consequences of database corruption or data deletion. A source database and/or a current archive database further enable recording of records of the source database to an historical data archive, from which records or elements thereof may be recovered. A restore command is detectable by the system as directly input via a user interface and/or as sent via an electronics communications modality or network. The databases and archives may have access to multiple iterations/versions of a record including the original record version as stored in an historical archive or elsewhere in a network. The records may optionally be updated in a batch method, in real time, and/or as the software records are created.“

• 10,838,827 System and method for time parameter based database restoration
  Abstract: “A system and method are provided for the recovery and restoration of software records of a database server to record iterations previous to the current state of the selected records. This action may be taken in order to overcome the consequences of database corruption. An event-time maybe designated which is applied to select some or all of the earlier but most recent versions of each selected record. The system and method presented include a local target database for the purpose of recording software records to an archive, and may include a remote source database, from which records may be transmitted to the local target database. A restore command may be detected by the database server as sent from the remote source server, as received in an electronic message, as received via an electronics communications network, or as directly input. The local target database may have access to multiple iterations or versions of a software record including the original record version as stored in an archive, and may, upon instruction or command, revert to a previous iteration of a software record stored in the archive if corruption of later iterations is suspected. Alternatively or additionally, the local target database may not be restored with earlier versions of records but the remote source database may be restored with the selected record versions. The software records may optionally be updated in a batch method, or may alternatively be updated in real time, as the software records are created.“

The first two patents solidify performance and reliability gains since the company’s Relational Junction Data Warehouse Builder first came to market as a bi-directional data warehouse replicator for Salesforce.com users. Since then, the firm has added support for a wide variety of data sources, including cloud databases and SaaS applications. The current product is between ten to one hundred times faster than the original version, depending on source and target systems and available bandwidth.

The second two patents describe Relational Junction’s enhanced data recovery capabilities, which will be expanding from Salesforce.com to include many other cloud applications and databases. The data recovery features include a user interface that can search for records by any field or by time range, enabling partial or full recovery of records and their dependent records.

The company’s patent portfolio now includes thirteen awarded patents, ensuring Relational Junction’s uniqueness in the marketplace for instant data warehouses and data recovery of SaaS and on-premise applications and databases.