US 11,841,881 B2
Querying for custom data objects
Naveen Singh Jaunk, Lafayette, CA (US); Sahil Bhutani, Alameda, CA (US); Palaniappa Manivasagam Ramanathan, Bangalore (IN); Adithya Nittor Vishwanath, Bangalore (IN); and Raveendrnathan Loganathan, Sammamish, WA (US)
Assigned to Salesforce, Inc., San Diego, CA (US)
Filed by salesforce.com, inc., San Francisco, CA (US)
Filed on Jan. 29, 2021, as Appl. No. 17/163,032.
Claims priority of application No. 202041046518 (IN), filed on Oct. 26, 2020.
Prior Publication US 2022/0129435 A1, Apr. 28, 2022
Int. Cl. G06F 16/2455 (2019.01); G06F 16/22 (2019.01); G06F 16/242 (2019.01); G06F 16/25 (2019.01); G06F 16/28 (2019.01); G06F 16/2453 (2019.01); G06F 16/248 (2019.01)
CPC G06F 16/288 (2019.01) [G06F 16/2282 (2019.01); G06F 16/248 (2019.01); G06F 16/2423 (2019.01); G06F 16/24549 (2019.01); G06F 16/24553 (2019.01); G06F 16/254 (2019.01)] 20 Claims
OG exemplary drawing
 
1. A method for data processing, comprising:
receiving, at a relational database system, an indication of a definition of a data object type and an indication of a data stream process for ingesting data associated with the data object type;
receiving, from a client at the relational database system, a query that is supported by the relational database system, the relational database system being configured to store a plurality of data objects such that each data object is associated with a respective data table of a plurality of data tables of the relational database system and a respective value of a key prefix, the key prefix resulting in an upper limit of data objects supportable by the relational database system;
determining that the query that is supported by the relational database system is indicative of the data object type that is associated with data stored in a data system separate from the relational database system, wherein the separate data system is a non-relational database system;
identifying, based at least in part on determining that the query is indicative of the data object type associated with the data stored in the separate data system, a schema of the data object type using a schema record maintained by the relational database system and the separate data system, wherein the schema indicates mapping information maintained in the relational database system and indicates information that is configured to differentiate between data objects stored in the separate data system and sharing a same value of the key prefix;
transmitting, to the separate data system based at least in part on identifying the schema, a request associated with a data object, wherein the request is configured based at least in part on the identified schema;
receiving, from the separate data system in response to the request, the requested data that is ingested based at least in part on the separate data system being the non-relational database system and using the data stream process; and
returning, to the client, a query response that indicates the data retrieved from the separate data system.