Table data persistence

US9639544B1 · kind B1 · utility

Assignee

• PIVOTAL SOFTWARE, INC. · US

Inventors

• Daniel Allen Smith · Portland, US
• Anthony M. Baker · Sherwood, US
• Sumedh Wale · Jamkhed, IN
• Hemant Bhanawat · Jamkhed, IN
• Jagannathan Ramnarayanan · Portland, US
• Swapnil Prakash Bawaskar · Hillsboro, US
• Ashvin Agrawal · Bengaluru, IN
• Neeraj Kumar · Agra, IN

Key dates

• Filing date: Oct 28, 2014
• Grant date: May 2, 2017
• Expiry date: Aug 16, 2035

Classification

• Technology area (CPC H): Electricity
• CPC primary: H04L67/1097
• WIPO field: Computer technology
• WIPO sector: Electrical engineering

Abstract

Methods, systems, and apparatus, including computer programs encoded on computer storage media, for a distributed parallel processing database system that persists table data in memory to a distributed file system. A distributed parallel processing database system persists table data in memory to a distributed file system. A parameter of creating a database table specifies that data records in the database table and history of changes to the data records can be stored in memory as well as in the distributed file system. When the database table is populated or otherwise modified, data records and the history in memory are evicted to the distributed file system as log files and removed from memory. The log files can be designated as write-only, where the data records, once written, cannot be read by structured query language (SQL) queries, or as read-write, where the data records, once written, can be read by SQL queries.