Key pattern management in multi-tenancy database systems

US11561956B2 · kind B2 · utility

Assignee

• SAP SE · DE

Inventors

• Ulrich Auer · Hockenheim, DE
• Immo-Gert Birn · Philippsburg, DE
• Ralf-Juergen Hauck · Heidelberg, DE
• Uwe Schlarb · Östringen, DE
• Christian Stork · Hamm, DE
• Welf Walter · Ettingen, DE
• Torsten Ziegler · Dielheim, DE
• Volker Driesen · Heidelberg, DE

Key dates

• Filing date: Apr 28, 2020
• Grant date: Jan 24, 2023
• Expiry date: Feb 28, 2041

Classification

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

Abstract

The present disclosure involves systems, software, and computer implemented methods for key pattern management. One example method includes receiving a query for a logical database table from an application. A determination is made as to whether the query is a write query. In response to determining that the query is a write query, a determination is made as to whether the query complies with a key pattern configuration that describes keys of records included in a physical database table that is part of a logical table implementation. The physical table includes records of the logical database table that are allowed to be written by the application. The write query is redirected to the physical database table in response to determining that the query complies with the key pattern definition. The query is rejected in response to determining that the query does not comply with the key pattern configuration.