| Line 1: | Line 1: | ||
= Genesys Info Mart Overview = | = Genesys Info Mart Overview = | ||
| + | Genesys Info Mart data resides in the [[InfoMartDBSchema|Genesys Info Mart database schema]]. A separate [[TenantUserDBSchema|Tenant User database schema]] can be added for each tenant as required. This page describes how data is organized and how it can be accessed through views. | ||
| − | + | {{NoteFormat|The term ''voice interactions'' refers to traditional telephony calls while the term ''multimedia interactions'' refers to interactions that are processed through Genesys eServices/Multimedia solution, including 3rd Party Media interactions.}} | |
| − | + | ||
| + | ==Star Schemas== | ||
| + | Genesys Info Mart uses multidimensional modeling to create a constellation of star schemas. These star schemas create a database for storing contact center data that can be retrieved by using SQL queries. Star schemas support queries that speed the retrieval of the stored data. | ||
| + | |||
| + | ===Fact and Dimension Tables=== | ||
| + | The types of tables that make up the Genesys Info Mart star schemas are fact tables and dimension tables. Fact tables are the large tables in the middle of a star schema. They represent business measures, such as how long customers wait in a queue, how long and how often agents put customers on hold, or how long agents talk to customers. Fact tables are surrounded by a set of slowly-changing dimension tables. Fact tables represent a many-to-many relationship between dimensions; that is, there are many facts in a single fact table, and these facts are related to many dimensions in various dimension tables. Fact tables reference dimensions by using surrogate key columns. Dimension tables describe the attributes that are common to many facts in the associated fact tables. For example, dimensions that are related to interactions might include the date and time at which each interaction started, the required skills for the various service types that are requested by customers, and the value of various customers to the business. | ||
| + | |||
| + | ===Views=== | ||
| + | Genesys Info Mart supplies read-only views for both single-tenant and multi-tenant deployments. [[InfoMartDBSchema#DimensionViews|Dimension views]] provide read-only access to certain configuration details. [[TenantViews|Tenant-specific views]] can be created by using a Genesys-provided script to give each tenant access to only its own data and prevent users from accidentally changing the contents of the underlying database. | ||
| + | |||
| + | ===Indexes=== | ||
| + | Genesys Info Mart supplies out-of-box indexes to facilitate purging and transformation of data. The number of indexes would be smaller in a partitioned database where purging is based on partitions. | ||
[[Category:V:GIM:8.5DRAFT]] | [[Category:V:GIM:8.5DRAFT]] | ||
Revision as of 18:50, August 8, 2016
Genesys Info Mart Overview
Genesys Info Mart data resides in the Genesys Info Mart database schema. A separate Tenant User database schema can be added for each tenant as required. This page describes how data is organized and how it can be accessed through views.
Star Schemas
Genesys Info Mart uses multidimensional modeling to create a constellation of star schemas. These star schemas create a database for storing contact center data that can be retrieved by using SQL queries. Star schemas support queries that speed the retrieval of the stored data.
Fact and Dimension Tables
The types of tables that make up the Genesys Info Mart star schemas are fact tables and dimension tables. Fact tables are the large tables in the middle of a star schema. They represent business measures, such as how long customers wait in a queue, how long and how often agents put customers on hold, or how long agents talk to customers. Fact tables are surrounded by a set of slowly-changing dimension tables. Fact tables represent a many-to-many relationship between dimensions; that is, there are many facts in a single fact table, and these facts are related to many dimensions in various dimension tables. Fact tables reference dimensions by using surrogate key columns. Dimension tables describe the attributes that are common to many facts in the associated fact tables. For example, dimensions that are related to interactions might include the date and time at which each interaction started, the required skills for the various service types that are requested by customers, and the value of various customers to the business.
Views
Genesys Info Mart supplies read-only views for both single-tenant and multi-tenant deployments. Dimension views provide read-only access to certain configuration details. Tenant-specific views can be created by using a Genesys-provided script to give each tenant access to only its own data and prevent users from accidentally changing the contents of the underlying database.
Indexes
Genesys Info Mart supplies out-of-box indexes to facilitate purging and transformation of data. The number of indexes would be smaller in a partitioned database where purging is based on partitions.