Multi-tenancy for structured query language (SQL) and non structured query language (NoSQL) databases
US10664487B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Aug 24, 2018 |
| Grant date | May 26, 2020 |
| Priority date | — |
| Expiry date | Aug 24, 2038 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/256
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
Techniques and structures for providing a multitenant environment having both a relational database and a non-relational database. A database query is received with at least one server computing device providing a multitenant environment having a relational database system and a non-relational database system, the database query in a format corresponding to the relational database system. The query is parsed with the at least one server computing device to find one or more components of the query directed to data stored in the non-relational database system. One or more components of the query directed to data stored in the non-relational database system are converted to one or more scans of the non-relational database system. Results from the query of the relational database system and results from the one or more scans of the non-relational database system are collected. The results from the query and the results of the one or more scans to a combined result are combined. The combined results are provided to a client entity.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.