Streaming change logs from streaming database tables
US12423293B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Oct 26, 2023 |
| Grant date | Sep 23, 2025 |
| Priority date | — |
| Expiry date | Oct 26, 2043 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/24573
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
As with database tables in general, a streaming table and its columns are defined within by a database. DML commands are issued against a streaming table that specify to insert rows and values into their defined columns. Change records in a change log (e.g., redo log) are generated to record the changes specified by DML commands. The change log may be used to stream data captured by the change log. However, unlike with database tables in general, the rows of a streaming table are not persistently stored in the database at commit time. Alternatively, rows are stored persistently but without values for columns defined as streaming columns. Columns defined as streaming columns may be set to values specified by DML commands but are not stored in the database; streaming column values are captured in change logs, however.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.