Aggregate query-caching in databases architectures with a differential buffer and a main store

US9740741B2 · kind B2 · utility

Assignee

• Hasso-Plattner Institut fuer Softwaresystemtechnik GmbH · DE

Inventors

• Hasso Plattner · Schriesheim, DE
• Stephan Mueller · Potsdam, DE
• Jens Krueger · Heidenheim, DE
• Juergen Mueller · Berlin, DE
• Christian Schwarz · Vuarrengel, CH

Key dates

• Filing date: Feb 10, 2014
• Grant date: Aug 22, 2017
• Expiry date: Oct 6, 2034

Classification

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

Abstract

The invention relates to a computer system for both online transaction processing and online analytical processing, comprising: a processor coupled to a database, the database comprising the database comprising: a main store (116) for storing records, a differential buffer (114) for receiving and buffering added or deleted or modified records, the differential buffer being coupled to the main store, a schema comprising records stored in the main store and records stored in the differential buffer, and a cache store (112) for caching a result of a query against the schema; and a cache controller (106) executable by the processor and communicatively coupled to the database, the cache controller being configured for: storing the result of the query in the cache store; receiving an analytical request; and determining, in response to the received request, an up-to-date result of the query by (216): accessing the cache store to obtain the cached result; determining the records of the schema that have been added or deleted or modified since the step of storing the cached result in the cache store on the basis of the records stored in the differential buffer; and incrementally deriving the…