Projecting effect of in-flight streamed data on a relational database
US10127283B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Oct 31, 2016 |
| Grant date | Nov 13, 2018 |
| Priority date | — |
| Expiry date | Oct 31, 2036 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F2201/865
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
Profiling data characterizing a data streaming application is used to project changes to a relational database resulting from current in-flight streamed data. Preferably, the streaming application produces tuples which are entered into the relational database. Trace data is collected during previous execution of the streaming application to construct operator graph profile data showing likely paths of tuples through multiple processing elements of the streaming application. Responsive to a query, agent(s) residing within the computer system(s) supporting the streaming application query in-flight tuples in one or more buffers of the streaming application. The responses to the agent queries are analyzed using the operator graph profile data to project tuples which will be output to the database. Projected changes to the database may alternatively be used for other purposes, e.g., creating database metadata structures; reorganizing data inserts; regulating query governors; and/or updating database statistics.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.