US 12,093,757 B2
System and method for rest-based interface for use with data analytics environments
Sambit Nanda, San Ramon, CA (US); and Alan Lee, Minneapolis, MN (US)
Assigned to ORACLE INTERNATIONAL CORPORATION, Redwood Shores, CA (US)
Filed by Oracle International Corporation, Redwood Shores, CA (US)
Filed on Mar. 25, 2022, as Appl. No. 17/704,845.
Claims priority of provisional application 63/242,820, filed on Sep. 10, 2021.
Prior Publication US 2023/0080955 A1, Mar. 16, 2023
Int. Cl. G06F 9/54 (2006.01)
CPC G06F 9/547 (2013.01) [G06F 9/541 (2013.01)] 15 Claims
OG exemplary drawing
 
1. A system for providing a REST-based interface and connector for use with a data analytics environment, comprising:
a computer having a processor, memory, and data analytics environment operating thereon;
wherein the data analytics environment exposes a connector that can be is configured via a user interface, wherein a user creates and/or configures one or more connections, to support access, via a configurable data object, to data provided by a variety of databases or data sources, including receiving as input a configuration comprising:
a base uniform resource locator (URL); and
one or more endpoints mapped to an endpoint response URL;
wherein the system establishes a configured connection to the one or more endpoints which are used to access and manipulate data provided by the databases or data sources based on the received configuration including:
connecting to a database or data source associated with the configured connection, and sampling and creating nested flattened objects mapped to parent tables and child tables;
generating for use with the data object, an object-to-table mapping operating between the data object and table rows and columns of data provided by the database or data source; and
providing access via the data object to the table rows and columns of data provided by the database or data source, for use with an analytics workload of the data analytics environment.