Sesame Software Awarded Two New Patents for Data Warehouse Automation

Sesame Software, Patents, Data Warehouse Automation
Sesame Software Awarded Two New Patents for Data Warehouse Automation

Sesame Software, the innovative leader in Enterprise Data Management, announced two new patents awarded for its Relational Junction data warehouse automation and SaaS data recovery technology. This brings Sesame’s proprietary technology portfolio to nine awarded patents and six pending patents.

How blockchain could potentially transform global healthcare in the wake of COVID-19

“These patents are essential to Sesame’s leadership in building instant data warehouses and being able to recover SaaS data without a time-consuming project. Relational Junction does everything for you – there is no project. Simply put, there is no other solution that can match the time to deliver a working warehouse, the level of automation, the speed of loading, and the number of endpoints supported,” says Rick Banister, CEO, and Founder of Sesame Software.

Data Warehouse Loading Performance Improvements
The United States Patent 10,003,634 further improves the art of multi-threaded loading of a relational database from a source application by storing the record identifiers that meet a specified query range or filter, multi-threading readers on the content, saving the records in memory, and writing the records from memory into a database.

The scalability and performance of this technique allow massive amounts of data to be loaded quickly and with full retractability in the event of a failure. Customers with hundreds of millions of records benefit from extremely fast throughput, with many threads handling federated loading of a single object in the Cloud to the warehouse. The techniques described in the patent have improved the throughput of Relational Junction by 100 times since the original design in 2004.

SaaS Data Recovery
The United States Patent 10,540,237 provides a user interface and internal methods to recover complex relational data to a cloud or on-premise business application. The techniques allow a global recovery, subsetting the data by object name, time range, and record filters, restoring child records automatically, and recovering past versions of records, all in a user-friendly web interface.

Mobility Tech taking center stage for B2B Companies

Competing products use either a daily flat-file backup or a database backup with a single version of each record. Relational Junction uses primary and secondary backup tables, with the secondary table holding all prior versions. There is never a need for full backups after the initial load, and every version of every record is maintained without having to retain full daily backups for years. A new Recovery Interface is now included in the product for select SaaS applications, such as Salesforce.

Previous articleMicroBilt Creates Solution for SMB Lenders to Automate & Verify PPP Application Data
Next articleDigital Realty Powers on Third Data Centre in Singapore