Invention Grant
- Patent Title: Multi-tenancy for structured query language (SQL) and non structured query language (NoSQL) databases
-
Application No.: US14542348Application Date: 2014-11-14
-
Publication No.: US10061823B2Publication Date: 2018-08-28
- Inventor: Jonathan Mark Bruce , Eli Levine , Simon Toens , James Taylor
- Applicant: salesforce.com, inc.
- Applicant Address: US CA San Francisco
- Assignee: salesforce.com, inc.
- Current Assignee: salesforce.com, inc.
- Current Assignee Address: US CA San Francisco
- Agency: Jaffery, Watson, Mendonsa & Hamilton, LLC
- Main IPC: G06F17/30
- IPC: G06F17/30

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.
Public/Granted literature
- US20150142783A1 MULTI-TENANCY FOR STRUCTURED QUERY LANGUAGE (SQL) AND NON STRUCTURED QUERY LANGUAGE (NOSQL) DATABASES Public/Granted day:2015-05-21
Information query