Data separation and write redirection in multi-tenancy database systems

US10621167B2 · 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: Apr 14, 2020
• Expiry date: Jul 3, 2038

Classification

• Technology area (CPC G): Physics
• CPC primary: G06F8/65
• WIPO field: Computer technology
• WIPO sector: Electrical engineering

Abstract

The present disclosure involves systems, software, and computer implemented methods for data separation and write redirection in multi-tenancy database systems. One example method includes providing access to at least one application to a database system. A query is received from an application. A determination is made that the query is associated with a union view that provides unified access to a first read-only table in a shared database container and a first writable table in a tenant database container. A determination is made as to whether the query is a read query or a write query. In response to determining that the query is a read query, the query is processed using the union view. In response to determining that the query is a write query, the query is modified to use the first writable table and the query is processed using the writable table.