Patent · US Active

Calculated dictionary column readers

US12380078B1 · kind B1 · utility

0Cited by

0References

20Claims

0Family size

Assignee

SAP SE · DE

Inventors

Nico Bohnsack · Ingersleben, DE
Andreas Amler · Heidelberg, DE
Paul Willems · Heidelberg, DE
Manuel Mayr · Walldorf, DE

Key dates

Filing date	Jun 3, 2024
Grant date	Aug 5, 2025
Priority date	—
Expiry date	Jun 3, 2044

Classification

Technology area (CPC G)Physics
CPC primaryG06F16/2456
WIPO fieldComputer technology
WIPO sectorElectrical engineering

Abstract

Arrangements for a reading scheme for column-oriented databases are provided. A virtual column may be generated by applying a structured query language operation on distinct values in a column of data in a table. Based on applying the structured query language operation, the virtual column may be populated with corresponding precalculated values. The virtual column may be compressed with dictionary-based compression. The compressing may include generating a column of value identifiers, each of the value identifiers representing a distinct value in the column of data. A database query against the compressed virtual column may be received. A result of the database query may be returned by retrieving one or more of the precalculated values from the compressed virtual column.

Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.