Processing correlated calculated fields in correlated subqueries
US12235839B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Nov 9, 2022 |
| Grant date | Feb 25, 2025 |
| Priority date | — |
| Expiry date | Feb 24, 2043 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/244
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
The present disclosure involves systems, software, and computer implemented methods for processing correlated calculated fields in correlated subqueries. One example method includes receiving a request to process a database query that includes at least one subquery and processing each subquery. A determination is made as to whether each subquery includes a correlated calculated field that is a calculated field that is not included in a first datasource queried by the subquery but is included in a second datasource queried by an outer query that includes the subquery. If the subquery does not include a correlated calculated field, the subquery is processed without modification. If the subquery includes a correlated calculated field, metadata is retrieved for the outer query of the subquery that queries the second datasource and includes the correlated calculated field. The subquery is rewritten using the metadata and the rewritten subquery is processed.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.