Invention Application
- Patent Title: QUERY PROCESSING FOR DISK BASED HYBRID TRANSACTIONAL ANALYTICAL PROCESSING SYSTEM
-
Application No.: US17332575Application Date: 2021-05-27
-
Publication No.: US20220382758A1Publication Date: 2022-12-01
- Inventor: Ivan Schreter
- Applicant: SAP SE
- Applicant Address: DE Walldorf
- Assignee: SAP SE
- Current Assignee: SAP SE
- Current Assignee Address: DE Walldorf
- Main IPC: G06F16/2455
- IPC: G06F16/2455 ; G06F16/242 ; G06F16/2457 ; G06F16/22 ; G06F16/248 ; G06F12/123

Abstract:
A method for processing a query may include receiving a query associated with one or more predicate columns and one or more aggregate columns. To respond to the query, one or more partial data pages including the one or more predicate columns but not the one or more aggregate columns may be loaded from disk to memory. For each partial data page, a first value occupying the one or more predicate columns may be evaluated to identify one or more rows satisfying a predicate associated with the query. A portion of a data page containing the aggregate columns may be loaded from disk into memory. A result of the query corresponding to a second value occupying the aggregate columns may be generated based on the portion of the data page loaded in the memory. Related systems and articles of manufacture are also provided.
Public/Granted literature
- US12072885B2 Query processing for disk based hybrid transactional analytical processing system Public/Granted day:2024-08-27
Information query