Patent · US Active

Table schema providing improved database system performance

US12271365B2 · kind B2 · utility

0Cited by

6References

20Claims

0Family size

Assignee

SAP SE · DE

Inventors

Holger Wuest · Linkenheim-Hochstetten, DE
Markus Kahn · Walldorf, DE
Lothar Muessler · Wiesloch, DE
Dirk Endesfelder · Angelbachtal, DE
Markus Riepp · Reilingen, DE

Key dates

Filing date	Feb 21, 2023
Grant date	Apr 8, 2025
Priority date	—
Expiry date	Jun 30, 2043

Classification

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

Abstract

Techniques and solutions are provided for a table schema that facilitates data denormalization, and which can allow for improved database system performance. Rather than accessing multiple tables, database operations can access a single table, which can reduce the number and complexity of database operations. The table schema includes an attribute subset indicator field. Different values of the attribute subset indicator field can be associated with different contexts, such as different tables or views, which in turn can represent different entity types. A given value of the attribute subset indicator field allows data to be accessed at a coarse granularity, while more-fine grained results can be obtained by providing a value for one or more attribute fields of the table. Different subsets of attributes are retrievable for a given value of the attribute subset indicator field.

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