Sap Se

Robert Boschgmbh

Holger Wuest

Peter Bartel

Dirk Endesfelder

Lothar Muessler

Markus Riepp

Florian Bessler

Markus Kahn

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.

Table schema providing improved database system performance

Growing community of inventors

Linkenheim-Hochstetten, Germany

Holger Wuest