System and method for data warehouse workload transformation
US12164538B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Jul 6, 2022 |
| Grant date | Dec 10, 2024 |
| Priority date | — |
| Expiry date | Jul 6, 2042 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/24542
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A system for data warehouse workload transformation is disclosed. A data extraction module receives job metadata from one or more extract transform load applications, extracts domain logic information from the job metadata. A canonical model generation module creates one or more relational models from the domain logic information, generates a canonical model for the job metadata by merging the one or more relational models. A model optimization module creates a query execution plan using an optimization technique, passes the canonical model through one or more optimization layers, and optimizes the query execution plan to execute common logic at a single point of time for removing one or more redundant operations. A code generation module generates an output code corresponding to the predefined target environment from an optimized canonical model, upon mapping of the one or more entities, for the workload transformation.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.