Addition and processing of continuous SQL queries in a streaming relational database management system
US8812487B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Mar 5, 2009 |
| Grant date | Aug 19, 2014 |
| Priority date | — |
| Expiry date | Jan 5, 2030 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/2471
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
Systems, methods, and media are disclosed herein that can be embodied in a traditional Relational Database Management System (RDBMS) in order to transform it into a Streaming Relational Database Management System (SRDBMS). An SRDBMS may provide functionality such as to manage and populate streams, tables, and archived stream histories and support the evaluation of continuous queries on streams and tables. Both continuous and snapshot queries support the full spectrum of the industry standard, widely used, Structured Query Language. The present technology can support a high number of concurrent continuous queries using a scalable and efficient shared query evaluation scheme, support on-the-fly addition of continuous queries into a mechanism that implements the shared evaluation scheme, reuse RDBMS modules such as relational operators and expression evaluators, and visualize results of continuous queries in real time.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.