Relational operations between database tables and application tables
US10606838B2 · kind B2 · utility
Assignee
Inventor
Key dates
| Filing date | Nov 7, 2016 |
| Grant date | Mar 31, 2020 |
| Priority date | — |
| Expiry date | Mar 5, 2038 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/284
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
Disclosed aspects perform a join operation between a database table and second in-memory data of an application may be provided. The operation is expressed as an join query between first data residing in the relational database and second data residing in a memory space of an application. Aspects can include serializing rows of the second data into a character large binary object, generating a composite statement by decoding, using a table function, rows of the character large binary object into columns of associated database data-types. The rows are substrings of the character large binary object. Aspects may include sending the character large binary object and the composite statement to a relational database, executing it, and receiving a result.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.