Patent · US Active

Multi-tenancy for structured query language (SQL) and non structured query language (NOSQL) databases

US11392599B2 · kind B2 · utility

0Cited by
72References
15Claims
0Family size

Assignee

Inventors

Key dates

Filing dateMay 26, 2020
Grant dateJul 19, 2022
Priority date
Expiry dateMay 26, 2040

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.