Integrative configuration for bot behavior and database behavior

Patent metadata

Field	Value
Publication number	US-12204530-B2
Application number	US-202418431816-A
Country	US
Kind code	B2
Filing date	Feb 2, 2024
Priority date	Aug 18, 2021
Publication date	Jan 21, 2025
Grant date	Jan 21, 2025

Abstract

Routines are used to connect bot queries entered via a bot interface and database queries executed on a database. Each routine is associated with routine configurations, including (a) query attributes associated with bot queries that trigger the routine, (2) a database query executed or to be executed for the routine, and/or (3) display settings for displaying information returned from the database query in a bot response. Each routine is configured to generate an output structured data object (SDO) indicating information returned from the database query and the display settings applicable to the information. The output SDOs from the various routines are transmitted to the bot application via a single API endpoint. The routine configurations are entered by a design user through one or more design user interfaces rendered by an integrative configuration application module.

First claim

What is claimed is:

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:
generating a first input structured data object comprising a first set of one or more attributes associated with a first bot query obtained from a first end user through a bot interface;
transmitting the first input structured data object to a particular endpoint of an application programming interface (API) associated with a database system,
receiving, from the particular endpoint of the API, a first output structured data object comprising a first set of information determined by:
determining that the first set of one or more attributes map to a first set of one or more routines, of a plurality of routines,
responsive to determining that the first set of one or more attributes map to the first set of one or more routines: executing the first set of one or more routines to determine the first set of information;

generating, based at least in part on the first output structured data object, a first bot response comprising the first set of information;
presenting the first bot response for display on the bot interface.

2. The one or more non-transitory computer-readable media of claim 1 , wherein mapping the first set of one or more attributes to the first set of one or more routines is performed by the database system, and wherein executing the first set of one or more routines to determine the first set of information is performed by the database system.

3. The one or more non-transitory computer-readable media of claim 1 , wherein the operations further comprise:
generating a second input structured data object comprising a second set of one or more attributes associated with a second bot query obtained from a second end user through the bot interface;
transmitting the second input structured data object to the particular endpoint of the API;
receiving, from the particular endpoint of the API, a second output structured data object comprising a second set of information determined by:
determining that the second set of one or more attributes map to a second set of one or more routines, of the plurality of routines,
responsive to determining that the second set of one or more attributes map to the second set of one or more routines: executing the second set of one or more routines to determine the second set of information;

generating, based at least in part on the second output structured data object, a second bot response comprising the second set of information;
presenting the second bot response for display on the bot interface.

4. The one or more non-transitory computer-readable media of claim 3 ,
wherein the first bot response is presented for display on the bot interface in accordance with a first display setting determined based at least in part on the first input structured data object,
wherein the second bot response is presented for display on the bot interface in accordance with a second display setting determined based at least in part on the second input structured data object,
wherein the first display setting differs from the second display setting.

5. The one or more non-transitory computer-readable media of claim 3 ,
wherein generating the first bot response comprises: applying a first display setting to the first set of information, wherein the first set of one or more routines indicates the first display setting, and
wherein generating the second bot response comprises: applying a second display setting to the second set of information, wherein the second set of one or more routines indicates the second display setting,
wherein the first set of one or more routines differs from the second set of one or more routines.

6. The one or more non-transitory computer-readable media of claim 1 , wherein executing the first set of one or more routines to determine the first set of information comprises:
identifying a first database query that is mapped to the first set of one or more routines,
executing the first database query on a database, and
determining the first set of information based at least in part on a query result obtained in response to executing the first database query on the database.

7. The one or more non-transitory computer-readable media of claim 1 , wherein generating the first bot response comprises: applying a first display setting to the first set of information, wherein the first set of one or more routines indicates the first display setting,
wherein the first bot response is presented for display on the bot interface in accordance with the first display setting.

8. The one or more non-transitory computer-readable media of claim 1 , wherein the first output structured data object is generated based at least in part on a configuration indicated by the first set of one or more routines.

9. A method, comprising:
generating a first input structured data object comprising a first set of one or more attributes associated with a first bot query obtained from a first end user through a bot interface;
transmitting the first input structured data object to a particular endpoint of an application programming interface (API) associated with a database system,
receiving, from the particular endpoint of the API, a first output structured data object comprising a first set of information determined by:
determining that the first set of one or more attributes map to a first set of one or more routines, of a plurality of routines,
responsive to determining that the first set of one or more attributes map to the first set of one or more routines: executing the first set of one or more routines to determine the first set of information;

generating, based at least in part on the first output structured data object, a first bot response comprising the first set of information;
presenting the first bot response for display on the bot interface;
wherein the method is performed by at least one device including a hardware processor.

10. The method of claim 9 , wherein mapping the first set of one or more attributes to the first set of one or more routines is performed by the database system, and wherein executing the first set of one or more routines to determine the first set of information is performed by the database system.

11. The method of claim 9 , further comprising:
generating a second input structured data object comprising a second set of one or more attributes associated with a second bot query obtained from a second end user through the bot interface;
transmitting the second input structured data object to the particular endpoint of the API;
receiving, from the particular endpoint of the API, a second output structured data object comprising a second set of information determined by:
determining that the second set of one or more attributes map to a second set of one or more routines, of the plurality of routines,
responsive to determining that the second set of one or more attributes map to the second set of one or more routines: executing the second set of one or more routines to determine the second set of information;

generating, based at least in part on the second output structured data object, a second bot response comprising the second set of information;
presenting the second bot response for display on the bot interface.

12. The method of claim 11 ,
wherein the first bot response is presented for display on the bot interface in accordance with a first display setting determined based at least in part on the first input structured data object,
wherein the second bot response is

Assignees

• Oracle Int Corp

Inventors

• Kumar Tarun
• Naik Bhagat Pravas Sudhakar
• Noriega Soto Manuel Humberto
• Viswanathan Nair Krishna Kumar
• Venkatasubramanian Vishwanagendran
• Nurani Raman Sankaranarayanan
• Hernández Fernández Del Castillo Lourdes
• Takano Gustavo

Classifications

• G06F9/54

  Interprogram communication · CPC title

• G06F16/2448 Primary

  for particular applications; for extensibility, e.g. user defined types · CPC title

• G06F9/541 Primary

  via adapters, e.g. between incompatible applications · CPC title