# US 2023/0069265 A1 · Integrative configuration for bot behavior and database behavior

> Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt

- Number: US 2023/0069265 A1
- Document ID: US20230069265A1
- Status: Published application
- Kind: A1
- Application number: 17/405,415
- Filed: 2021-08-18
- Published: 2023-03-02
- Earliest claimed: 2021-08-18
- Assignees: Oracle International Corporation
- Applicants: Oracle International Corporation
- Inventors: Tarun Kumar; Pravas Sudhakar Naik Bhagat; Manuel Humberto Noriega Soto; Krishna Kumar Viswanathan Nair; Vishwanagendran Venkatasubramanian; Sankaranarayanan Nurani Raman; Lourdes Hernández Fernández Del Castillo; Gustavo Takano
- Web page: https://patentgrep.com/patent/US20230069265A1

## CPC

- G06F 9/541: {via adapters, e.g. between incompatible applications}
- G06F 16/2448: {for particular applications; for extensibility, e.g. user defined types}
- G06F 9/54: Interprogram communication
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## 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.

## Claims

### Claim 1

One or more non-transitory computer readable media storing instructions which, when executed by one or more hardware processors, cause:
receiving, via one or more user interfaces rendered by an integrative configuration application module, user input specifying first routine configurations associated with a first routine of a plurality of routines, wherein receiving the user input specifying the first routine configurations comprises:
receiving user input indicating a first set of one or more query attributes associated with a bot query that triggers the first routine, wherein the bot query is obtained from an end user through a bot interface rendered by a bot application;
receiving user input indicating a first database query on a first database that is executed or to be executed in association with the bot query;
receiving user input indicating display settings for displaying at least a subset of information returned from the first database query in a bot response on the bot interface responsive to the bot query;
generating or updating the first routine based on the first routine configurations, wherein the first routine is configured to return a first structured data object indicating at least the subset of the information returned from the first database query;
wherein each of the plurality of routines is associated with respective database queries on the first database;
wherein each of the plurality of routines is configured to transmit respective structured data objects indicating information returned from the respective database queries on the first database to the bot application via a particular endpoint of an application programming interface (API) implemented between the bot application and the first database.

### Claim 2 (depends on 1)

The media of claim 1, wherein:
the information returned from the first database query comprises a set of labels and a corresponding set of values;
the display settings comprise one or more of:
whether to display, in the bot response, a first label of the set of labels;
whether to display, in the bot response, a first value corresponding to the first label;
a first position, within the bot response, for displaying at least one of the first label and the first value;
a first format for displaying, in the bot response, at least one of the first label and the first value.

### Claim 3 (depends on 2)

The media of claim 2, wherein the first structured data object further indicates the display settings for displaying the set of labels and the corresponding set of values in the bot response.

### Claim 4 (depends on 1)

The media of claim 1, wherein:
the information returned from the first database query comprises a set of labels and a corresponding set of values;
the display settings comprise a first conditional display setting that is applicable to a first value of the set of values if a first condition is satisfied, and that is not applicable to the first value if the first condition is not satisfied.

### Claim 5 (depends on 4)

The media of claim 4, wherein the first structured data object indicates a different display setting, without indicating the first conditional display setting, for the first value if the first condition is not satisfied.

### Claim 6 (depends on 4)

The media of claim 4, wherein the first structured data object indicates the first conditional display setting for the first value, without identifying the first condition.

### Claim 7 (depends on 1)

The media of claim 1, wherein:
the information returned from the first database query comprises a set of labels and a corresponding set of values;
the display settings indicate that a first label of the set of labels is iterative, and at least one of a particular layout and a particular format associated with the first label;
the first structured data object iteratively indicates the at least one of the particular layout and the particular format in association with each sub-value in a value corresponding to the first label.

### Claim 8 (depends on 1)

The media of claim 1, further storing instructions comprising:
responsive to receiving the user input indicating the first database query:
determining a set of labels associated with the information returned from the first database query;
concurrently displaying, on a particular user interface of the one or more user interfaces:
a first interface element configured to receive a first display setting, of the display settings, associated with a first label of the set of labels; and
a second interface element configured to receive a second display setting, of the display settings, associated with a second label of the set of labels.

### Claim 9 (depends on 1)

The media of claim 1, further storing instructions comprising:
concurrently displaying, on a particular user interface of the one or more user interfaces:
a first interface element configured to receive the user input indicating the first set of one or more query attributes associated with the bot query that triggers the first routine;
a second interface element configured to receive the user input indicating the first database query of the first database that is executed or to be executed in association with the bot query;
a third interface element configured to receive the user input indicating the display settings for displaying at least the subset of information returned from the first database query in the bot response.

### Claim 10 (depends on 1)

The media of claim 1, further storing instructions comprising:
displaying, on a first user interface of the one or more user interfaces, a navigation button configured to navigate from the first user interface to a second user interface of the one or more user interfaces;
displaying, on the first user interface, a first interface element configured to receive the user input indicating the first set of one or more query attributes associated with the bot query that triggers the first routine;
responsive at least to receiving a user selection of the navigation button: displaying, on the second user interface, a second interface element configured to receive the user input indicating the first database query of the first database that is executed or to be executed in association with the bot query.

### Claim 11 (depends on 1)

The media of claim 1, further storing instructions comprising:
displaying, on a first user interface of the one or more user interfaces, a navigation button configured to navigate from the first user interface to a second user interface of the one or more user interfaces;
displaying, on the first user interface, a first interface element configured to receive the user input indicating the first database query of the first database that is executed or to be executed in association with the bot query;
responsive at least to receiving a user selection of the navigation button: displaying, on the second user interface, a second interface element configured to receive the user input indicating the display settings for displaying at least the subset of information returned from the first database query in the bot response.

### Claim 12 (depends on 1)

The media of claim 1, further storing instructions comprising:
concurrently displaying, on a particular user interface of the one or more user interfaces, a first tab button corresponding to a first user interface of the one or more user interfaces, and a second tab button corresponding to a second user interface of the one or more user interfaces;
responsive at least to receiving a user selection of the first tab button: displaying, on the first user interface, a first interface element configured to receive the user input indicating the first set of one or more query attributes associated with the bot query that triggers the first routine;
responsive at least to receiving a user selection of the second tab button: displaying, on the second user interface, a second interface element configured to receive the user input indicating the first database query of the first database that is executed or to be executed in association with the bot query.

### Claim 13 (depends on 1)

The media of claim 1, further storing instructions comprising:
concurrently displaying, on a particular user interface of the one or more user interfaces, a first tab button corresponding to a first user interface of the one or more user interfaces, and a second tab button corresponding to a second user interface of the one or more user interfaces;
responsive at least to receiving a user selection of the first tab button: displaying, on the first interface element configured to receive the user input indicating the first database query of the first database that is executed or to be executed in association with the bot query;
responsive at least to receiving a user selection of the second tab button: displaying, on the second user interface, a second interface element configured to receive the user input indicating the display settings for displaying at least the subset of information returned from the first database query in the bot response.

### Claim 14 (depends on 1)

The media of claim 1, further storing instructions comprising:
responsive to receiving user input indicating a parent routine for the first routine: displaying, on the user interfaces, the parent routine configurations for the parent routine as second routine configurations for the first routine.

### Claim 15 (depends on 14)

The media of claim 14, further storing instructions comprising:
receiving user input modifying the second routine configurations to become the first routine configurations for the first routine.

### Claim 16 (depends on 1)

The media of claim 1, wherein the bot application is configured to parse the first structured data object to generate the bot response in accordance with the display settings.

### Claim 17 (depends on 1)

The media of claim 1, wherein the user input indicating the first database query of the first database comprises user input selecting a first database view from a plurality of database views.

### Claim 18 (depends on 1)

The media of claim 1, wherein the first set of query attributes are indicated by an input structured data object received by the database via the particular endpoint responsive to the bot query.

### Claim 19 (depends on 1)

The media of claim 1, wherein the integrative configuration application module is implemented by the database.

### Claim 20

One or more non-transitory computer readable media storing instructions which, when executed by one or more hardware processors, cause:
receiving, from a particular endpoint of an application programming interface (API) implemented between a first database and a bot interface, a first input structured data object comprising a first set of one or more attributes associated with a first bot query obtained from an end user through the bot interface;
wherein respective input structured data objects comprising respective sets of one or more attributes associated with a plurality of bot queries obtained through the bot interface are received from the particular endpoint of the API;
based on the first set of attributes associated with the first bot query, selecting a first routine, from a plurality of routines, to be executed for the first bot query;
determining first routine configurations associated with the first routine, wherein the first routine configurations comprise:
identification of a first database query of the first database executed or to be executed in association with the first bot query;
identification of display settings for displaying at least a subset of information returned from the first database query in a first bot response on the bot interface responsive to the first bot query;
generating a first output structured data object indicating at least (a) the subset of the information returned from the first database query and (b) the display settings for displaying the subset of the information returned from the first database query in the first bot response;
transmitting the first output structured data object to the particular endpoint of the API;
wherein respective output structured data objects indicating respective information returned from respective database queries associated with the plurality of routines to be included in respective bot responses are transmitted to the bot interface via the particular endpoint of the API.

### Claim 21 (depends on 20)

The media of claim 20, wherein:
the information returned from the first database query comprises a set of labels and a corresponding set of values;
the display settings comprise one or more of:
whether to display, in the bot response, a first label of the set of labels;
whether to display, in the bot response, a first value corresponding to the first label;
a first position, within the bot response, for displaying at least one of the first label and the first value;
a first format for displaying, in the bot response, at least one of the first label and the first value.

### Claim 22 (depends on 20)

The media of claim 20, wherein the first routine configurations are obtained from one or more design users through one or more user interfaces rendered by a same integrative configuration application module.

### Claim 23 (depends on 22)

The media of claim 22, wherein the integrative configuration application module is implemented by the first database on which the first database query is executed.
