# Database

## Data management (database)

* Positioning: “Space Database” supports the questioning of data types. After the user uploads/binds a database, the robot is able to query, count and analyze the uploaded data;
* Each robot can only bind **one** database at present;
* Multiple data files can be uploaded in the database (no limit on the number for the time being);

### 1.1 Database Configuration

#### 1.1.1 Create a database

* Entry:

Click “Space Resource Library” - “Space Database” on the left bottom menu after user login.

<figure><img src="https://1886561579-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXbXiJN0Eq6xgdmU34Ktv%2Fuploads%2F0QsUZgaqjuEav8OZskMN%2Fimage.png?alt=media&#x26;token=93f75fd8-03a2-4979-9adf-36dd3d248bb0" alt=""><figcaption></figcaption></figure>

* Operation: “+Create Database” on the upper right side.

<figure><img src="https://1886561579-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXbXiJN0Eq6xgdmU34Ktv%2Fuploads%2FiUHh6R1YC4F9x0Cpw6Q9%2Fimage.png?alt=media&#x26;token=497d51bc-b5ab-4a47-94b0-f7146edd3061" alt=""><figcaption></figcaption></figure>

<figure><img src="https://1886561579-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXbXiJN0Eq6xgdmU34Ktv%2Fuploads%2FCBTvEuEWIw5lS6Vhe2Qn%2Fimage.png?alt=media&#x26;token=175a519a-87a2-4b9f-8c65-1674c43a09cb" alt=""><figcaption></figcaption></figure>

<figure><img src="https://1886561579-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXbXiJN0Eq6xgdmU34Ktv%2Fuploads%2FTsWKdiParBDqXNlMkSOT%2Fimage.png?alt=media&#x26;token=ed468287-3d87-4bf0-8ad3-c0c980418177" alt=""><figcaption></figcaption></figure>

* Supported Forms:&#x20;

Currently support “Local Upload” and “Online Connection” two database creation method.

<figure><img src="https://1886561579-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXbXiJN0Eq6xgdmU34Ktv%2Fuploads%2F8q6jfqGNtWqbdHtuovyZ%2Fimage.png?alt=media&#x26;token=ae0c871e-b543-41f0-9696-da439bc81136" alt=""><figcaption></figcaption></figure>

#### **1.1.1.1** Local upload for new database

Upload local excel, csv format data table to create a database, after successfully created, can be visualized in the “space database”.

* Database name: Users fill in the database purpose according to their actual personal needs;
* Database description: Additional details. Enable the robot to interpret the database more accurately, improve the response rate and retrieval accuracy. For example: the database is used to include customer lists, sales orders, inventory count.

<figure><img src="https://1886561579-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXbXiJN0Eq6xgdmU34Ktv%2Fuploads%2FVvmVFrcVKL7n7nFMj7JY%2Fimage.png?alt=media&#x26;token=a865f254-1194-43d0-a5e3-74c2ba145b66" alt=""><figcaption></figcaption></figure>

* Data Table Upload Entrance:&#x20;

“Upload Table” on the upper right side / “Go to upload” in the middle of the interface.

<figure><img src="https://1886561579-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXbXiJN0Eq6xgdmU34Ktv%2Fuploads%2FZQ1LmuFjimDt9ydZVkis%2Fimage.png?alt=media&#x26;token=f4a8afe7-9548-4720-a167-8a920331125e" alt=""><figcaption></figcaption></figure>

Upload Requirements:

* Support format: excel/csv.;
* Only support uploading 1 file at a time, multiple files need to be uploaded in several times;
* Each file only supports the first sheet worksheet;
* The size of a single file does not exceed 20 M; not more than 100,000 rows, 20 columns.

<figure><img src="https://1886561579-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXbXiJN0Eq6xgdmU34Ktv%2Fuploads%2FyKHMGZOxaEgVtfXgBifb%2Fimage.png?alt=media&#x26;token=c31cc7c4-fbc8-40c6-9a3d-9a119c691a50" alt=""><figcaption></figcaption></figure>

Data table parsing:

* Data Table Name: users name the data table according to their individual needs;
* Data Table Description: additional data table details; E.g. This table shows product information data and contains four fields, namely: product name, price, category and stock.
* Field Configuration: show the fields and information parsed from the uploaded file;
* Field Description : describes the field usage. Helps to optimize data analysis results.
* Allow Null: When Allow Null is on, the whole data will be written when the field is empty; otherwise, the whole data will not be written.&#x20;

<figure><img src="https://1886561579-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXbXiJN0Eq6xgdmU34Ktv%2Fuploads%2F8zhn2HeLE8TrrBGP5xAd%2Fimage.png?alt=media&#x26;token=3496e033-262d-49fc-bcb0-d8cf9202af25" alt=""><figcaption></figcaption></figure>

Data table batch import/data export: you can perform data batch upload/data export operation after the data table is uploaded successfully.

* Batch Import:&#x20;

The column fields and data types of the batch imported data need to be consistent with the current data table configuration, otherwise it cannot be uploaded.

* Export Data:

Uploaded data files can be exported in xlsx format in the web side - download list.

<figure><img src="https://1886561579-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXbXiJN0Eq6xgdmU34Ktv%2Fuploads%2FRHDnYz1dRz424EmebzKj%2Fimage.png?alt=media&#x26;token=c478b64c-4dfb-4f6b-ad07-faa13bcaee5a" alt=""><figcaption></figcaption></figure>

<figure><img src="https://1886561579-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXbXiJN0Eq6xgdmU34Ktv%2Fuploads%2F10knA8ID0HN3aT9vYbdO%2Fimage.png?alt=media&#x26;token=57b96d2f-a2ae-492e-b40c-903ac8530032" alt=""><figcaption></figcaption></figure>

Data table detail view: Click on the <mark style="background-color:blue;">blue table header name</mark> to view the data details.

<figure><img src="https://1886561579-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXbXiJN0Eq6xgdmU34Ktv%2Fuploads%2FFJaSUcghpB7Z7PfBLxaS%2Fimage.png?alt=media&#x26;token=57fa9f87-ee69-48c5-9eba-2cbc8b55b743" alt=""><figcaption></figcaption></figure>

<figure><img src="https://1886561579-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXbXiJN0Eq6xgdmU34Ktv%2Fuploads%2FqOnsB3Sda7mkDsMzH7rC%2Fimage.png?alt=media&#x26;token=a0f82018-2b31-429d-8306-e1dac54db724" alt=""><figcaption></figcaption></figure>

Data Table Single Data Edit: Supports the modification and deletion of a single piece of data within a data table.

* Modification: Change the details of a single piece of data.

<figure><img src="https://1886561579-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXbXiJN0Eq6xgdmU34Ktv%2Fuploads%2FM7FfLVuuSpU6NdJYN7ap%2Fimage.png?alt=media&#x26;token=782e0fcc-718c-4397-96e9-e0bb1f33033d" alt=""><figcaption></figcaption></figure>

<figure><img src="https://1886561579-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXbXiJN0Eq6xgdmU34Ktv%2Fuploads%2FecBM0oeYaqTIbZrivDd8%2Fimage.png?alt=media&#x26;token=5b9fd8ac-f9d7-43a6-be4d-35b6fcb03888" alt=""><figcaption></figcaption></figure>

* Delete

Delete a single piece of data (set up a secondary pop-up window to effectively prevent false touches).

<figure><img src="https://1886561579-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXbXiJN0Eq6xgdmU34Ktv%2Fuploads%2FcYVewsdnh5mkixINiOwx%2Fimage.png?alt=media&#x26;token=96c912ae-5ced-4ea7-93c3-e449fc982a61" alt=""><figcaption></figcaption></figure>

<figure><img src="https://1886561579-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXbXiJN0Eq6xgdmU34Ktv%2Fuploads%2FXJhmFwGKnm7FawaRIwWP%2Fimage.png?alt=media&#x26;token=3c37c26f-c91b-4fbc-ab74-a57f004afd66" alt=""><figcaption></figcaption></figure>

#### 1.1.1.2 Online connection for new database

* Database name: users can name the database according to their personal needs;
* Database description: fill in the database purpose, which helps to improve data management efficiency and quality, enhance robot autonomy, and optimize decision support;
* Database type: currently supports MySQL, PostgreSQL, SQL Server, Oracle.

<figure><img src="https://1886561579-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXbXiJN0Eq6xgdmU34Ktv%2Fuploads%2FCojsoWNx9VFbNSQEUx1Z%2Fimage.png?alt=media&#x26;token=23064daa-e227-4938-9f14-73f1a79497dd" alt=""><figcaption></figcaption></figure>

#### 1.1.2 Database editing

* Entry:

&#x20;Click “Space Resource Library” —  “Space Databases” — Right footer of the database to be edited— "Edit"

<figure><img src="https://1886561579-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXbXiJN0Eq6xgdmU34Ktv%2Fuploads%2F9yWsb7RyOFPBg4ENisZG%2Fimage.png?alt=media&#x26;token=809bddaf-a54f-46cf-b03e-0bfc274bd523" alt=""><figcaption></figcaption></figure>

* Editable contents：Database Name,Database Description

<figure><img src="https://1886561579-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXbXiJN0Eq6xgdmU34Ktv%2Fuploads%2F7NVyrccq6meHM2x8YNPH%2Fimage.png?alt=media&#x26;token=e3ada93d-0d65-4e6c-a824-b0c1426dc5fe" alt=""><figcaption></figcaption></figure>

#### 1.1.3 Database deletion

* Entry:&#x20;

Click “Space Resource Library” —  “Space Databases” — Right footer of the database to be edited— "Delete"

<figure><img src="https://1886561579-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXbXiJN0Eq6xgdmU34Ktv%2Fuploads%2Fux8i8EAs6TemnyTy3NSv%2Fimage.png?alt=media&#x26;token=d3390fbd-9702-48b1-9cad-41877accc974" alt=""><figcaption></figcaption></figure>

* Path:

Click on "Delete" → a confirmation pop-up window for secondary deletion appears (to prevent accidental touching) → the user manually enters the words ‘Confirm Deletion’ to complete the deletion → a ‘Deleted Successfully’ prompt appears → the deletion is completed.

<figure><img src="https://1886561579-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXbXiJN0Eq6xgdmU34Ktv%2Fuploads%2Fp6kzSPnSiO5JRLH8VTnJ%2Fimage.png?alt=media&#x26;token=7e24c9f2-022f-4ba3-bfa5-50f773fb2d86" alt=""><figcaption></figcaption></figure>

<figure><img src="https://1886561579-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXbXiJN0Eq6xgdmU34Ktv%2Fuploads%2FKb1FvAtRg0lVFHkOcbeu%2Fimage.png?alt=media&#x26;token=b7a7142b-8845-4b70-975c-141daa82c46e" alt=""><figcaption></figcaption></figure>

### 1.2 Binding database

After the database is created, you can bind the database to a specific robot. Currently, one robot only supports binding **one** database.

* Entry: Click “Database” on the right side of the robot configuration page to bind;
* Effect: After binding a database, ask a question to the robot, and the robot will retrieve the database automatically.

<figure><img src="https://1886561579-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXbXiJN0Eq6xgdmU34Ktv%2Fuploads%2FNZq67Iik10kf5Zp5VJHc%2Fimage.png?alt=media&#x26;token=8b1d91ce-50f9-452e-bbf3-b620b25f64e0" alt=""><figcaption></figcaption></figure>

<figure><img src="https://1886561579-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXbXiJN0Eq6xgdmU34Ktv%2Fuploads%2Fbn9x9njZcFNWai420xPO%2Fimage.png?alt=media&#x26;token=78ca51b1-ea0b-4328-a40b-1ceccaa2d55e" alt=""><figcaption></figcaption></figure>

<figure><img src="https://1886561579-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXbXiJN0Eq6xgdmU34Ktv%2Fuploads%2FXJoTCEqRuQ3AkvmTN4ma%2Fimage.png?alt=media&#x26;token=5f57d96e-2df6-40fe-ac64-d730b5d274c6" alt=""><figcaption></figcaption></figure>

### 1.3 Database settings

#### 1.3.1 Entry

* On the spatial database page, click on any database card to enter the data list page of that database. On the data list page, click on \[DB Config] in the left-hand menu to access **Database Settings** .

<figure><img src="https://1886561579-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXbXiJN0Eq6xgdmU34Ktv%2Fuploads%2Fp2GhG9xvsNMmD7gnvzhx%2Fimage.png?alt=media&#x26;token=87dad646-3fa5-4fa7-8ca0-b24edf59879a" alt=""><figcaption></figcaption></figure>

<figure><img src="https://1886561579-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXbXiJN0Eq6xgdmU34Ktv%2Fuploads%2F5NuGbTMdXOCmUSMiijxP%2Fimage.png?alt=media&#x26;token=0401e741-efe4-4e9a-b632-2fab40e03114" alt=""><figcaption></figcaption></figure>

#### 1.3.2 Data Table Retrieval

<figure><img src="https://1886561579-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXbXiJN0Eq6xgdmU34Ktv%2Fuploads%2FlJZuED96KrmfzVEyxDTY%2Fimage.png?alt=media&#x26;token=46a333b3-5012-48f6-a728-e84c1e132a0e" alt=""><figcaption></figcaption></figure>

#### 1.3.2.1 Initial Retrieval

Preliminary search and screening the data in the database, so that the Agent quickly locates the data records that meet the basic conditions. It provides the basis for further data processing, analysis and query. As an important antecedent step, Initial retrieval can effectively improve query efficiency when dealing with large-scale data.

#### 1.3.2.1.1 Ratio

1. Clarification：

Setting the percentage of Initial  Retrieval.

The left side shows the percentage of semantic retrieval and the right side shows the percentage of keyword retrieval;

* semantic retrieval&#x20;

(1) Meaning:

&#x20;A search based on semantic understanding. Not only focuses on the input keywords, but also tries to understand the semantic meaning behind them and their relationship with the context, in order to return results that are more in line with the intent;

(2) Applicable Scenarios:&#x20;

Suitable for scenarios that require understanding of intent and return more accurate results.

* keyword retrieval

(1)Meaning:

A search based on text matching. By looking for direct occurrences of the keywords entered in the database to return relevant results. Means ‘literal matching’.

(2)Applicable Scenarios:&#x20;

Suitable for the need to quickly find the contents of specific words, high speed requirements and semantic understanding of the scene is not complex.

2. Scope：

* Semantic retrieval percentage + keyword retrieval percentage = 100%, any percentage can be 0;
* Default value: semantic search percentage = 30%, keyword search percentage = 70%.

#### 1.3.2.1.2 Quantity

1. Clarification：

A setting is made for the total number of initial retrievals (number of semantic retrievals + number of keyword retrievals). Means set on how many data tables will be taken for further reordering for the initial retrieval.

2. Scope：10-50 (integer), default value 20.

#### 1.3.2.2 Re-ranking

#### 1.3.2.2.1 Re-ranking Model

1. Clarification:

Settings for the model used for re-ranking, currently three models are supported in the dropdown box.

<figure><img src="https://1886561579-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXbXiJN0Eq6xgdmU34Ktv%2Fuploads%2FYVHeTTFx3o4A81kAbZVC%2Fimage.png?alt=media&#x26;token=bbde3101-3eaf-4187-8781-ae264b9d70e1" alt=""><figcaption></figcaption></figure>

2. Scope

The \[bge-reranker-large] model is supported by default.

#### 1.3.2.2.2 Relevance Threshold

1. Clarification

Configure a threshold for data table retrieval relevance above which the database Q\&A process is triggered.

2. Scope

0-1, default value is 0.3.

#### 1.3.2.2.3 Maximum number of retrieved data tables

1. Clarification

* The maximum number of data tables taken from the database at a time that satisfy the threshold, i.e., the upper limit on the number of data tables given to the big model to process
* Indicates the maximum number of datasheets at a time that an intelligent body can take and answer

2. Scope

1-10, default value is 3.

#### 1.3.3 Q\&A example retrieval

<figure><img src="https://1886561579-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXbXiJN0Eq6xgdmU34Ktv%2Fuploads%2FGJIarYDPbpqutTPy8qDr%2Fimage.png?alt=media&#x26;token=cc8f025e-a06e-45c5-a6be-24be878aef28" alt=""><figcaption></figcaption></figure>

#### 1.3.1.1 Initial Retrieval

#### 1.3.1.1.1 Ratio

1. Clarification：

Setting the percentage of Initial  Retrieval.

The left side shows the percentage of semantic retrieval and the right side shows the percentage of keyword retrieval;

* semantic retrieval&#x20;

(1) Meaning:

&#x20;A search based on semantic understanding. Not only focuses on the input keywords, but also tries to understand the semantic meaning behind them and their relationship with the context, in order to return results that are more in line with the intent;

(2) Applicable Scenarios:&#x20;

Suitable for scenarios that require understanding of intent and return more accurate results.

* keyword retrieval

(1)Meaning:

A search based on text matching. By looking for direct occurrences of the keywords entered in the database to return relevant results. Means ‘literal matching’.

(2)Applicable Scenarios:&#x20;

Suitable for the need to quickly find the contents of specific words, high speed requirements and semantic understanding of the scene is not complex.

2. Scope：

* Semantic retrieval percentage + keyword retrieval percentage = 100%, any percentage can be 0;
* Default value: semantic search percentage = 30%, keyword search percentage = 70%.

#### 1.3.1.1.2 Quantity

1. Clarification：

A setting is made for the total number of initial retrievals (number of semantic retrievals + number of keyword retrievals). Means set on how many data tables will be taken for further reordering for the initial retrieval.

2. Scope：10-50 (integer), default value 20.

#### 1.3.3.2 Re-ranking

#### 1.3.3.2.1 Re-ranking Model

1. Clarification:

Settings for the model used for re-ranking, currently three models are supported in the dropdown box.

<figure><img src="https://1886561579-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXbXiJN0Eq6xgdmU34Ktv%2Fuploads%2FYVHeTTFx3o4A81kAbZVC%2Fimage.png?alt=media&#x26;token=bbde3101-3eaf-4187-8781-ae264b9d70e1" alt=""><figcaption></figcaption></figure>

2. Scope

The \[bge-reranker-large] model is supported by default.

#### 1.3.3.2.2 Relevance Threshold

1. Clarification

Configure a threshold for data table retrieval relevance above which the database Q\&A process is triggered.

2. Scope

0-1, default value is 0.5.

#### 1.3.3.2.3 Maximum number of retrieved Q\&A pairs

1. Clarification

* The maximum number of Q\&A pairs taken from the Q\&A training pool each time that satisfy the threshold, i.e., the upper limit on the number of Q\&A pairs that are given to the big model for processing;
* Indicates how many question-answer pairs are taken by the intelligences at a time and answered based on them.

2. Scope

1-10, default value is 3.

#### 1.4 Q\&A Training

* Positioning

The database's Q\&A training supports the writing of SQL code for specified questions, a feature that transforms raw data into actionable and customisable business insights, providing users with a more flexible and efficient way of interacting with data to meet complex queries and advanced analytical needs. This feature improves the adaptability and scalability of intelligences to meet the precise data analysis needs of different users for different industries, which can help enterprises achieve more efficient data-driven decision-making.

* Entry

Space database page, click on any database card to enter the data list page of the database, data list page click on the left list \[Q\&A training] to enter the Q\&A training page;

<figure><img src="https://1886561579-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXbXiJN0Eq6xgdmU34Ktv%2Fuploads%2FIKQ9hQ5I5NuIkW7vvOBp%2Fimage.png?alt=media&#x26;token=e0564bd0-277d-4bc9-9331-039d711029a4" alt=""><figcaption></figcaption></figure>

<figure><img src="https://1886561579-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXbXiJN0Eq6xgdmU34Ktv%2Fuploads%2FCu5fwbNDh1c1hS47GKX9%2Fimage.png?alt=media&#x26;token=4f558bdd-c18a-4755-9c91-977013af54fe" alt=""><figcaption></figcaption></figure>

#### 1.4.1 **Single Q\&A Training**

#### **1.4.1.1** Add Single Q\&A Training

* Entry:

1. When there's no Q\&A training data, you can add a new Single Q\&A Training by \[Click add] in the middle of the page or \[+Add] in the upper right corner of the page;
2. When  Q\&A training data is not empty, you can add a new Single Q\&A Training by  \[+Add] in the upper right corner of the page;

<figure><img src="https://1886561579-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXbXiJN0Eq6xgdmU34Ktv%2Fuploads%2F9Jo9WDwwWKBZzfe6LFl7%2Fimage.png?alt=media&#x26;token=3ff84abe-55e9-438a-b465-4d90384f1105" alt=""><figcaption></figcaption></figure>

* Question:User-entered text question, e.g. Data query instruction: ‘<mark style="color:blue;">Precise query for customers with declining sales in Q4 2023</mark>’. Up to 2,000 characters;
* Answer: The user's ideal, SQL query-like statement (SELECT) for the question;
* Status: On by default. Turn on button, the Q\&A training takes effect for the Agent dialogue when successfully added; Turn off button does not enable this training for the Agent.

<figure><img src="https://1886561579-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXbXiJN0Eq6xgdmU34Ktv%2Fuploads%2FZfWKt7UVDpKxO6QrAvxn%2Fimage.png?alt=media&#x26;token=1e9b40bc-973d-41b0-8398-76dad1dcbf3a" alt=""><figcaption></figcaption></figure>

#### **1.4.1.2** Edit Single Q\&A Training

* Entry:\[Q\&A Training] - Actions - \[Edit]

<figure><img src="https://1886561579-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXbXiJN0Eq6xgdmU34Ktv%2Fuploads%2F7YzWa8E5zVsaaifQ4idY%2Fimage.png?alt=media&#x26;token=093225b0-fcf2-468d-84d8-ae8acf783175" alt=""><figcaption></figcaption></figure>

* Supports secondary editing of training questions, answers, and status.

<figure><img src="https://1886561579-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXbXiJN0Eq6xgdmU34Ktv%2Fuploads%2F4wNRJ0z7pehybub1Fj6r%2Fimage.png?alt=media&#x26;token=b462b883-1f08-4a9c-b5a5-8a9abec92abf" alt=""><figcaption></figcaption></figure>

#### **1.4.1.3 Delete** Single Q\&A Training

* Entry:\[Q\&A Training] - Actions - \[Delete]

<figure><img src="https://1886561579-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXbXiJN0Eq6xgdmU34Ktv%2Fuploads%2FkSScQ9mJSLnxGuFkP7Hu%2Fimage.png?alt=media&#x26;token=e30dc8b7-c82c-41e1-bc52-e05333eb154c" alt=""><figcaption></figcaption></figure>

* Secondary Confirmation: After the user clicks \[Delete], a confirmation of deletion pop-up window will appear, click \[Confirm] to complete the deletion to prevent accidental touches.

<figure><img src="https://1886561579-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXbXiJN0Eq6xgdmU34Ktv%2Fuploads%2FLYqjuLoamzhWDf1gdMWD%2Fimage.png?alt=media&#x26;token=aa2f86bf-a545-40cb-829b-3c2ea0ca0ce8" alt=""><figcaption></figcaption></figure>

<figure><img src="https://1886561579-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXbXiJN0Eq6xgdmU34Ktv%2Fuploads%2F7yWkwpjHexoBRAX9tDc3%2Fimage.png?alt=media&#x26;token=bca03400-1da9-4b49-b92d-e87b145fc6d5" alt=""><figcaption></figcaption></figure>

#### 1.4.2 Batch QA training

#### 1.4.2.1 Batch import of Q\&A training

* Entry:

\[QA training] - \[import]

<figure><img src="https://1886561579-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXbXiJN0Eq6xgdmU34Ktv%2Fuploads%2FP6nzvXf8qnm4xSjVx0lD%2Fimage.png?alt=media&#x26;token=204504c1-b22d-48be-8671-7245aac16843" alt=""><figcaption></figcaption></figure>

* Training data import requirements:

1. The size of a single file ≤ 20M;
2. Each file only supports the first sheet. 3;
3. It is recommended to remove the weight before uploading.

<figure><img src="https://1886561579-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXbXiJN0Eq6xgdmU34Ktv%2Fuploads%2FiFqchRdzQMSDUxNUeTkZ%2Fimage.png?alt=media&#x26;token=47cdd20f-dcad-4179-9703-59bc1011e952" alt=""><figcaption></figcaption></figure>

#### 1.4.2.2 Batch export of Q\&A training

* Entry:

\[QA training] - \[Export]

<figure><img src="https://1886561579-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXbXiJN0Eq6xgdmU34Ktv%2Fuploads%2F0g4UyGKgGQj0qLHIVk3D%2Fimage.png?alt=media&#x26;token=3ba32709-67ee-41a0-a277-8e33dfb9c65e" alt=""><figcaption></figcaption></figure>

* Export format:&#x20;

the title contains three parts: question, answer, and status.

<figure><img src="https://1886561579-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXbXiJN0Eq6xgdmU34Ktv%2Fuploads%2FVZedKlg2NX1quq3HvAbG%2Fimage.png?alt=media&#x26;token=f793be76-f1ad-4d88-9cfb-c6870672f5c3" alt=""><figcaption></figcaption></figure>

* Limitination: Supports exporting up to 10w Q\&A pairs.

### 1.5 Q\&A effect display Robot Data Q\&A currently supports:

* Visualization results display: charts (bar charts, line charts, pie charts), tables, SQL;
* Single table/multi-table Q\&A display.

#### 1.5.1 Visualization

* Currently three forms of visualization are supported: charts, tables and code (SQL).

#### 1.5.1.1 Chart format

* Charts can be copied and downloaded in the upper right corner;
* Note: Chart display may not appear every time, the big model will filter the data suitable for generating charts for visualization;
* The bottom of the dialog box generates a text summary;
* Chart form: currently supports three forms: bar chart, line chart and pie chart, the initial default graph is bar chart.

1. Bar Chart: centered display of metric content.

<figure><img src="https://1886561579-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXbXiJN0Eq6xgdmU34Ktv%2Fuploads%2Fb6tdjVw6Nh4lx2ECM1O3%2Fimage.png?alt=media&#x26;token=5906f713-923d-4255-a403-c8e4b49c68a5" alt=""><figcaption></figcaption></figure>

2. Line Chart:&#x20;

The content of the measure is displayed in the center, and when there are multiple lines in a chart at the same time, the colors of the lines will be clearly differentiated.

<figure><img src="https://1886561579-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXbXiJN0Eq6xgdmU34Ktv%2Fuploads%2FrTLgEjdXwdcCDE5AgxTs%2Fimage.png?alt=media&#x26;token=7df5a869-1094-490f-8070-452ac5b73481" alt=""><figcaption></figcaption></figure>

3. Pie chart: the graph will be displayed in the center.

<figure><img src="https://1886561579-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXbXiJN0Eq6xgdmU34Ktv%2Fuploads%2FHHtkvKACImdlKVZ034i4%2Fimage.png?alt=media&#x26;token=2c43ecc0-6b57-4b1d-adf9-21f1020e36a6" alt=""><figcaption></figcaption></figure>

#### 1.5.1.2 Table

* A table header is displayed in the first row and a summary is generated at the bottom of the dialog box.

<figure><img src="https://1886561579-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXbXiJN0Eq6xgdmU34Ktv%2Fuploads%2FvFQmpodvwo5MTMiZmmrA%2Fimage.png?alt=media&#x26;token=fa331d31-9e7d-4b61-807c-af91833d5ae8" alt=""><figcaption></figcaption></figure>

#### 1.5.1.3 SQL forms

* SQL statements output in the form of code blocks are supported to run;

<figure><img src="https://1886561579-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXbXiJN0Eq6xgdmU34Ktv%2Fuploads%2FEKaULop2DcxninKeDStO%2Fimage.png?alt=media&#x26;token=687826b4-6245-4740-bf6d-41f4d77b7ead" alt=""><figcaption></figcaption></figure>

#### 1.5.2 Single/multi-table forms&#x20;

#### 1.5.2.1 Single-table Q\&A

* The robot looks up information in one table to answer user's question.

<figure><img src="https://1886561579-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXbXiJN0Eq6xgdmU34Ktv%2Fuploads%2FskhIjPXmxnkQIHgwA9OB%2Fimage.png?alt=media&#x26;token=6ced5bee-00a6-48e7-9b5c-ecc9fcedf84a" alt=""><figcaption></figcaption></figure>

#### 1.5.2.2 Multi-table Q\&A

* The robot looks up information in multiple data tables and handles correlations between multiple tables in order to answer the user's questions.

<figure><img src="https://1886561579-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXbXiJN0Eq6xgdmU34Ktv%2Fuploads%2FF7eCs7WikLJFNKfGEalo%2Fimage.png?alt=media&#x26;token=b0a5a17d-2d6b-45b2-a589-fe7986bbc53d" alt=""><figcaption></figcaption></figure>
