Skip to content

Data Table

Kore.ai takes care of your data needs, without having to depend on external services for it. Data offering lets you define Data Tables, Table Views, and manipulate them from your Virtual Assistant and Process Apps.

Data Tables allow you to persist custom data and retrieve it whenever needed. These can be used as data points collection for ‘feedback’ or ‘survey’ tasks, collecting user inputs that can be retrieved at a later point, etc.

Highlights

  • Create custom Data Tables for any business needs
  • Joining two or more tables to create custom Data Views.
  • Support for secure fields, indexing, and references.
  • APIs to read, write, update, and delete data.
  • Ability to scope tables and views to specific bots. process apps and apps.

Overview

Data Table offering on XO Platform is split into two parts:

  • Data Definition which includes:

    • Defining Data Tables and Views.
    • Granting access to the bots, and processes for manipulating data from these Tables and Views.
    • Defining Apps for securely exporting and importing definitions and for querying the data from views or data tables.

    Define data

  • Data Manipulation allows performing CRUD operations on data from any of the data tables by making API calls.

In the document, we will be elaborating on each of these aspects. A brief knowledge of RDBMS is essential for working with this feature. You can refer to the glossary, listed below, to refresh your concepts.

Data Definition

For Data Definition, you need to access the Data tab of the Bot Builder Landing Page.

From here you can:

Data Definition

Data Manipulation

APIs can be used to access the data in the data tables and data views are as follows:

Glossary

Following are the terms and their definitions as used by the platform

TERM DEFINITION
Data Definition Data Definition deals with defining how the data gets stored in terms of tables, columns, views, etc.
Data Manipulation Data Manipulation refers to the basic CRUD operations that can be performed against the date ie. retrieve, update, and delete the data.
Data Table Data storage wherein the data can be accessed in a tabular form, with rows and/or columns named.
Columns The column name refers to the individual field value that is stored in the table.
Reference Table and Column This represents the domain for the columns that reference it, ie the values of the referenced column should be contained in the reference table column.
Index An index is a pointer to data in a table and is used to speed up data retrieval. Assing a column that you think best identifies a row in the table.
Table View A virtual table which can be used to access a subset of information from a single table or combine data from two or more table, using joins.
Filter Criteria When defining views, this property can be used to define the resultant data set, ie. the rows to be included in the view based on the values in specified columns.
Group By When defining views, this property can be used to arrange identical data into groups from the resultant data set.
Sort By When defining views, this property can be used to arrange the rows in the resultant data set based on the specified columns.
Join When defining views, join can be used to fetch data from two or more tables and joined to appear as single set of data.
Inner Join This is a simple join in which the result is based on matched data from the two tables as per the equality condition.
Right Outer Join The right outer join returns a result set with the matched data from the two tables and then the remaining rows of the right table and null from the corresponding left table’s columns.
Left Outer Join The left outer join returns a result set with the matched data from the two tables and then the remaining rows of the left table and null from the corresponding right table’s columns.