US 12,254,006 B2
Integrative configuration for bot behavior and database behavior
Tarun Kumar, Bangalore (IN); Pravas Sudhakar Naik Bhagat, Bangalore (IN); Manuel Humberto Noriega Soto, Mexico City (MX); Krishna Kumar Viswanathan Nair, Ezhamkulam (IN); Vishwanagendran Venkatasubramanian, Bangalore (IN); Sankaranarayanan Nurani Raman, Bangalore (IN); Lourdes Hernández Fernández Del Castillo, Mexico City (MX); and Gustavo Takano, Juriquilla (MX)
Assigned to Oracle International Corporation, Redwood Shores, CA (US)
Filed by Oracle International Corporation, Redwood Shores, CA (US)
Filed on Feb. 2, 2024, as Appl. No. 18/431,812.
Application 18/431,812 is a continuation of application No. 17/405,415, filed on Aug. 18, 2021, granted, now 11,928,109.
Prior Publication US 2024/0176779 A1, May 30, 2024
This patent is subject to a terminal disclaimer.
Int. Cl. G06F 16/242 (2019.01); G06F 9/54 (2006.01)
CPC G06F 16/2448 (2019.01) [G06F 9/54 (2013.01)] 20 Claims
OG exemplary drawing
 
1. One or more non-transitory computer-readable media comprising computer-executable instructions that, when executed by one or more processors, cause performance of operations, comprising:
displaying a chatbot configuration interface for mapping query attributes to at least one of a plurality of routines;
receiving a first set of one or more user inputs via the chatbot configuration interface, wherein the first set of one or more user inputs maps a first routine, of the plurality of routines, to at least a first query attribute;
storing a first mapping between the first routine and the first query attribute;
configuring, based on the first mapping, a database system to:
receive, from an endpoint of an application programming interface (API), input structured data objects comprising query request associated with the first query attribute,
access the first mapping based on the query requests being associated with the first query attribute,
select the first routine from the plurality of routines based on the first routine being mapped to the first query attribute by the first mapping, and
execute the first routine, wherein the first routine comprises:
execute a first query upon a first database,
receive information in response to the first query,
generate an output structured data object comprising the information returned from the first query, and
transmit the output structure data object to the endpoint of the API;
wherein the database system receives a first query request associated with the first query attribute, and
wherein, based on the first query request being associated with the first query attribute and the first routine being mapped to the first query attribute, the database system selects the first routine from the plurality of routines and executes the first routine.