{"id":23658,"date":"2020-07-03T15:26:54","date_gmt":"2020-07-03T14:26:54","guid":{"rendered":"https:\/\/developer.kore.ai\/v9-1\/?p=23658"},"modified":"2021-08-14T09:36:13","modified_gmt":"2021-08-14T08:36:13","slug":"data-as-a-service","status":"publish","type":"post","link":"https:\/\/developer.kore.ai\/v9-1\/docs\/bots\/advanced-topics\/data-as-a-service\/","title":{"rendered":"Data Table"},"content":{"rendered":"<section class=\"l-section wpb_row height_auto\"><div class=\"l-section-h i-cf\"><div class=\"g-cols vc_row type_default valign_top\"><div class=\"vc_col-sm-12 wpb_column vc_column_container\"><div class=\"vc_column-inner\"><div class=\"wpb_wrapper\">\r\n\t<div class=\"wpb_text_column \">\r\n\t\t<div class=\"wpb_wrapper\">\r\n\t\t\t<p>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.<\/p>\n<p><strong>Data Tables<\/strong> allow you to persist custom data and retrieve it whenever needed. These can be used as data points collection for \u2018feedback\u2019 or \u2018survey\u2019 tasks, collecting user inputs that can be retrieved at a later point, etc.<\/p>\n\r\n\t\t<\/div>\r\n\t<\/div>\r\n<div class=\"w-separator size_medium with_line width_default thick_1 style_solid color_border align_center\"><div class=\"w-separator-h\"><\/div><\/div>\r\n\t<div class=\"wpb_text_column \">\r\n\t\t<div class=\"wpb_wrapper\">\r\n\t\t\t<h1><span class=\"ez-toc-section\" id=\"Highlights\">Highlights<\/span><\/h1>\n<ul>\n<li>Create <strong>custom Data Tables<\/strong> for any business needs<\/li>\n<li>Joining two or more tables to create <strong>custom Data Views<\/strong>.<\/li>\n<li>Support for <strong>secure fields<\/strong>, <strong>indexing<\/strong>, and <strong>references<\/strong>.<\/li>\n<li><strong>APIs<\/strong> to read, write, update, and delete data.<\/li>\n<li>Ability to <strong>scope<\/strong> tables and views to specific bots. process apps and apps.<\/li>\n<\/ul>\n\r\n\t\t<\/div>\r\n\t<\/div>\r\n<div class=\"w-separator size_medium with_line width_default thick_1 style_solid color_border align_center\"><div class=\"w-separator-h\"><\/div><\/div>\r\n\t<div class=\"wpb_text_column \">\r\n\t\t<div class=\"wpb_wrapper\">\r\n\t\t\t<h1><span class=\"ez-toc-section\" id=\"Overview\">Overview<\/span><\/h1>\n<p>Data Table offering on Kore.ai Bots platform is split into two parts:<\/p>\n<ul>\n<li><strong>Data Definition<\/strong> which includes:\n<ul>\n<li>Defining <strong>Data Tables<\/strong>\u00a0and <strong>Views<\/strong>.<\/li>\n<li><strong>Granting access<\/strong> to the bots, and processes for manipulating data from these Tables and Views.<\/li>\n<li><strong>Defining Apps<\/strong> for securely exporting and importing definitions and for querying the data from views or data tables.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\r\n\t\t<\/div>\r\n\t<\/div>\r\n\r\n\t<div class=\"wpb_text_column \">\r\n\t\t<div class=\"wpb_wrapper\">\r\n\t\t\t<p><a ref=\"magnificPopup\" href=\"https:\/\/kore-wordpress.s3.us-east-2.amazonaws.com\/developer.kore.ai\/v9-1\/wp-content\/uploads\/sites\/22\/20210624124513\/data_dd.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-28008\" src=\"https:\/\/kore-wordpress.s3.us-east-2.amazonaws.com\/developer.kore.ai\/v9-1\/wp-content\/uploads\/sites\/22\/20210624124513\/data_dd.png\" alt=\"\" width=\"1652\" height=\"558\" srcset=\"https:\/\/kore-wordpress.s3.us-east-2.amazonaws.com\/developer.kore.ai\/v9-1\/wp-content\/uploads\/sites\/22\/20210624124513\/data_dd.png 1652w, https:\/\/kore-wordpress.s3.us-east-2.amazonaws.com\/developer.kore.ai\/v9-1\/wp-content\/uploads\/sites\/22\/20210624124513\/data_dd-300x101.png 300w, https:\/\/kore-wordpress.s3.us-east-2.amazonaws.com\/developer.kore.ai\/v9-1\/wp-content\/uploads\/sites\/22\/20210624124513\/data_dd-1024x346.png 1024w\" sizes=\"auto, (max-width: 1652px) 100vw, 1652px\" \/><\/a><\/p>\n\r\n\t\t<\/div>\r\n\t<\/div>\r\n\r\n\t<div class=\"wpb_text_column \">\r\n\t\t<div class=\"wpb_wrapper\">\r\n\t\t\t<ul>\n<li><strong>Data Manipulation<\/strong> allows performing CRUD operations on data from any of the data tables by making <strong>API calls<\/strong>.<\/li>\n<\/ul>\n\r\n\t\t<\/div>\r\n\t<\/div>\r\n\r\n\t<div class=\"wpb_text_column \">\r\n\t\t<div class=\"wpb_wrapper\">\r\n\t\t\t<p>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, <a href=\"#Glossary\">listed below<\/a>, to refresh your concepts.<\/p>\n\r\n\t\t<\/div>\r\n\t<\/div>\r\n<div class=\"w-separator size_medium with_line width_default thick_1 style_solid color_border align_center\"><div class=\"w-separator-h\"><\/div><\/div><div class=\"g-cols wpb_row  type_default valign_top vc_inner \"><div class=\"vc_col-sm-12 wpb_column vc_column_container\"><div class=\"vc_column-inner\"><div class=\"wpb_wrapper\">\r\n\t<div class=\"wpb_text_column \">\r\n\t\t<div class=\"wpb_wrapper\">\r\n\t\t\t<h1><span class=\"ez-toc-section\" id=\"Data_Definition\">Data Definition<\/span><\/h1>\n<p>For Data Definition, you need to access the <strong>Data tab<\/strong> of the Bot Builder Landing Page.<\/p>\n<p>From here you can:<\/p>\n<ul>\n<li>Create Data Tables, <a href=\"\/docs\/bots\/advanced-topics\/data-table\/\" target=\"_blank\" rel=\"noopener noreferrer\">refer here for more<\/a>;<\/li>\n<li>Define Table Views, <a href=\"\/docs\/bots\/advanced-topics\/table-views\/\" target=\"_blank\" rel=\"noopener noreferrer\">refer here for more<\/a>;\u00a0and<\/li>\n<li>Create Apps for access, <a href=\"\/docs\/bots\/advanced-topics\/app-definition\/\">refer here for more<\/a>.<\/li>\n<\/ul>\n\r\n\t\t<\/div>\r\n\t<\/div>\r\n\r\n\t<div class=\"wpb_text_column \">\r\n\t\t<div class=\"wpb_wrapper\">\r\n\t\t\t<p><a ref=\"magnificPopup\" href=\"https:\/\/kore-wordpress.s3.us-east-2.amazonaws.com\/developer.kore.ai\/v9-1\/wp-content\/uploads\/sites\/22\/20210624124728\/data.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-28012\" src=\"https:\/\/kore-wordpress.s3.us-east-2.amazonaws.com\/developer.kore.ai\/v9-1\/wp-content\/uploads\/sites\/22\/20210624124728\/data.png\" alt=\"\" width=\"1363\" height=\"371\" srcset=\"https:\/\/kore-wordpress.s3.us-east-2.amazonaws.com\/developer.kore.ai\/v9-1\/wp-content\/uploads\/sites\/22\/20210624124728\/data.png 1363w, https:\/\/kore-wordpress.s3.us-east-2.amazonaws.com\/developer.kore.ai\/v9-1\/wp-content\/uploads\/sites\/22\/20210624124728\/data-300x82.png 300w, https:\/\/kore-wordpress.s3.us-east-2.amazonaws.com\/developer.kore.ai\/v9-1\/wp-content\/uploads\/sites\/22\/20210624124728\/data-1024x279.png 1024w\" sizes=\"auto, (max-width: 1363px) 100vw, 1363px\" \/><\/a><\/p>\n\r\n\t\t<\/div>\r\n\t<\/div>\r\n<\/div><\/div><\/div><\/div>\r\n\t<div class=\"wpb_text_column \">\r\n\t\t<div class=\"wpb_wrapper\">\r\n\t\t\t<h1><span class=\"ez-toc-section\" id=\"Data_Manipulation\">Data Manipulation<\/span><\/h1>\n<p>APIs can be used to access the data in the data tables and data views are as follows:<\/p>\n<ul>\n<li>Data Insert API &#8211; <a href=\"\/docs\/bots\/api-guide\/data-insert-api\/\" target=\"_blank\" rel=\"noopener noreferrer\">See here for more<\/a><\/li>\n<li>Data Update API &#8211; <a href=\"\/docs\/bots\/api-guide\/data-update-api\/\" target=\"_blank\" rel=\"noopener noreferrer\">See here for more<\/a><\/li>\n<li>Data Delete API &#8211; <a href=\"\/docs\/bots\/api-guide\/data-delete-api\/\" target=\"_blank\" rel=\"noopener noreferrer\">See here for more<\/a><\/li>\n<li>Query Data from Table &#8211; <a href=\"\/docs\/bots\/api-guide\/query-data-table-api\/\" target=\"_blank\" rel=\"noopener noreferrer\">See here for more<\/a><\/li>\n<li>Query Data from View &#8211; <a href=\"\/docs\/bots\/api-guide\/query-data-view-api\/\" target=\"_blank\" rel=\"noopener noreferrer\">See here for more<\/a><\/li>\n<\/ul>\n\r\n\t\t<\/div>\r\n\t<\/div>\r\n<div class=\"w-separator size_medium with_line width_default thick_1 style_solid color_border align_center\"><div class=\"w-separator-h\"><\/div><\/div>\r\n\t<div class=\"wpb_text_column \">\r\n\t\t<div class=\"wpb_wrapper\">\r\n\t\t\t<h1><span class=\"ez-toc-section\" id=\"Glossary\">Glossary<\/span><\/h1>\n<p>Following are the terms and their definitions as used by the platform<\/p>\n<table>\n<tbody>\n<tr>\n<th>Term<\/th>\n<th>Definition<\/th>\n<\/tr>\n<tr>\n<td>Data Definition<\/td>\n<td>Data Definition deals with defining how the data gets stored in terms of tables, columns, views, etc.<\/td>\n<\/tr>\n<tr>\n<td>Data Manipulation<\/td>\n<td>Data Manipulation refers to the basic CRUD operations that can be performed against the date ie. retrieve, update, and delete the data.<\/td>\n<\/tr>\n<tr>\n<td>Data Table<\/td>\n<td>\u00a0Data storage wherein the data can be accessed in a tabular form, with rows and\/or columns named.<\/td>\n<\/tr>\n<tr>\n<td>Columns<\/td>\n<td>The column name refers to the individual field value that is stored in the table.<\/td>\n<\/tr>\n<tr>\n<td>Reference Table and Column<\/td>\n<td>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.<\/td>\n<\/tr>\n<tr>\n<td>Index<\/td>\n<td>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.<\/td>\n<\/tr>\n<tr>\n<td>Table View<\/td>\n<td>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.<\/td>\n<\/tr>\n<tr>\n<td>Filter Criteria<\/td>\n<td>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.<\/td>\n<\/tr>\n<tr>\n<td>Group By<\/td>\n<td>When defining views, this property can be used to arrange identical data into groups from the resultant data set.<\/td>\n<\/tr>\n<tr>\n<td>Sort By<\/td>\n<td>When defining views, this property can be used to arrange the rows in the resultant data set based on the specified columns.<\/td>\n<\/tr>\n<tr>\n<td>Join<\/td>\n<td>When defining views, join can be used to fetch data from two or more tables and joined to appear as single set of data.<\/td>\n<\/tr>\n<tr>\n<td>Inner Join<\/td>\n<td>This is a simple join in which the result is based on matched data from the two tables as per the equality condition.<\/td>\n<\/tr>\n<tr>\n<td>Right Outer Join<\/td>\n<td>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&#8217;s columns.<\/td>\n<\/tr>\n<tr>\n<td>Left Outer Join<\/td>\n<td>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&#8217;s columns.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\r\n\t\t<\/div>\r\n\t<\/div>\r\n<div class=\"w-separator size_medium with_line width_default thick_1 style_solid color_border align_center\"><div class=\"w-separator-h\"><\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/section>\n","protected":false},"excerpt":{"rendered":"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...","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[15],"tags":[],"class_list":["post-23658","post","type-post","status-publish","format-standard","hentry","category-advanced-topics"],"_links":{"self":[{"href":"https:\/\/developer.kore.ai\/v9-1\/wp-json\/wp\/v2\/posts\/23658","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/developer.kore.ai\/v9-1\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/developer.kore.ai\/v9-1\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/developer.kore.ai\/v9-1\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/developer.kore.ai\/v9-1\/wp-json\/wp\/v2\/comments?post=23658"}],"version-history":[{"count":11,"href":"https:\/\/developer.kore.ai\/v9-1\/wp-json\/wp\/v2\/posts\/23658\/revisions"}],"predecessor-version":[{"id":30978,"href":"https:\/\/developer.kore.ai\/v9-1\/wp-json\/wp\/v2\/posts\/23658\/revisions\/30978"}],"wp:attachment":[{"href":"https:\/\/developer.kore.ai\/v9-1\/wp-json\/wp\/v2\/media?parent=23658"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/developer.kore.ai\/v9-1\/wp-json\/wp\/v2\/categories?post=23658"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/developer.kore.ai\/v9-1\/wp-json\/wp\/v2\/tags?post=23658"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}