System and method for management system data aggregation and transformation using client-specific criteria
US12222933B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Jan 15, 2021 |
| Grant date | Feb 11, 2025 |
| Priority date | — |
| Expiry date | May 25, 2041 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06N20/00
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A method may include receiving, at a first time, an instruction to execute a stored procedure at a database system, retrieving a schema of a structure of a database used by a management system of a client entity, determining an identity of a management system and a type of data to retrieve for the client entity. The method may also include, responsive to determining the identity and the type of data to retrieve, determining a criteria to use in a dynamic query based on the identity and the type of data to retrieve. The method may also include, responsive to determining the criteria, generating, in the stored procedure, the dynamic query comprising the criteria, and executing the stored procedure to retrieve raw data from the database used by the management system and transform the raw data to transformed data using the dynamic query.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.