Key pattern management in multi-tenancy database systems

US10740318B2 · 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: Oct 26, 2017
• Grant date: Aug 11, 2020
• Expiry date: May 17, 2038

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.