×

Unified architecture for hybrid database storage using fragments

  • US 10,740,036 B2
  • Filed: 06/23/2017
  • Issued: 08/11/2020
  • Est. Priority Date: 03/12/2013
  • Status: Active Grant
First Claim
Patent Images

1. A computer program product comprising a non-transitory machine-readable medium storing instructions that, when executed by at least one programmable processor, cause the at least one programmable processor to perform operations comprising:

  • storing, in a plurality of fragments retained in on-disk storage, a plurality of data records that comprise a data set, each fragment of the plurality of fragments comprising a local row index, wherein the local row index comprises a search structure to identify each fragment based on RowID intervals, wherein the local row index is mapped to RowID values in a global RowID column for the data set;

    compressing a first fragment of the plurality of fragments, wherein compressing comprises using a compression that is optimized for the first fragment;

    reading data records in the first fragment into a main system memory from the on-disk storage;

    creating a temporary, in-memory data structure including data records from the first fragment and a committed row from a change associated with the data set in the first fragment;

    compressing the temporary, in-memory data structure in the main system memory; and

    storing data from the compressed temporary, in-memory data structure to a revised fragment in the on-disk storage.

View all claims
  • 2 Assignments
Timeline View
Assignment View
    ×
    ×