Data Table4 min read

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 Kore.ai Bots 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.

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:

Create Data Tables, refer here for more;
Define Table Views, refer here for more; and
Create Apps for access, refer here for more.

Data Manipulation

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

Data Insert API – See here for more
Data Update API – See here for more
Data Delete API – See here for more
Query Data from Table – See here for more
Query Data from View – See here for more

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.

On this Page