Low latency query processing over a series of redo records
US10423600B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Sep 16, 2016 |
| Grant date | Sep 24, 2019 |
| Priority date | — |
| Expiry date | Aug 25, 2037 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/27
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
Systems for high-performance, low-latency database log mining applications. A method commences upon receiving a log mining query. The query specifies desired results that correspond to a prior logical state of the database system. A first type of processing entity is invoked to process contents of the redo stream by loading metadata into a data dictionary, and a second type of processing entity is invoked to construct metadata from the redo stream, wherein the constructed metadata pertains only database objects referenced in the query. During the time that the first type of processing entity is processing contents of the redo stream by loading metadata into a data dictionary, a process of a second type serves incoming queries using a subset of entries in the redo stream. When the data dictionary is completed, a switchover point is reached and thenceforth, incoming queries are served using the first type of processing entity.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.