Data Warehouse for Distributed Gaming Systems

Abstract

A data warehouse is provided for gaming systems located in multiple jurisdictions. Each jurisdiction collects gaming data from one or more gaming devices. Data from each jurisdiction is extracted, transformed and loaded into a data warehouse. A network, such as the Internet, may be used to transfer the data to the data warehouse. An on-line analytical processing (OLAP) application provides analysis services, such as point-in-time data reports, summary data reports, comparison reports, trend analysis reports and profitability reports, and other data analysis and data mining applications.

1 . A system comprising:
 a staging database coupled to historical database and multiple gaming systems distributed among different jurisdictions;   an extract, transform and load module coupled to the staging database that receives data from the staging database and transforms the data;   a data warehouse coupled to the extract, transform and load module for receiving the transformed data in a form compatible with the data warehouse.   
   
   
       2 . The system of  claim 1 , and further comprising an on-line analytical processing function. 
   
   
       3 . The system of  claim 2  wherein the on-line analytical processing function provides data analysis functions. 
   
   
       4 . The system of  claim 3  wherein the on-line analytical processing system comprises cubes populated for data analysis and data mining. 
   
   
       5 . The system of  claim 4  wherein the on-line analytical processing system provides analysis services, such as point-in-time data reports, summary data reports, comparison reports, trend analysis reports and profitability reports, and other data analysis and data mining applications. 
   
   
       6 . The system of  claim 1  and further comprising a wide area progressive system for each game theme in a jurisdiction. 
   
   
       7 . The system of  claim 6  and further comprising a common server for executing additional applications. 
   
   
       8 . The system of  claim 6  wherein the staging database accumulates historical data from one or more wide area progressive systems. 
   
   
       9 . The system of  claim 8  wherein the staging database comprises information for providing jurisdictional specific reports. 
   
   
       10 . A system comprising:
 multiple transaction processing systems coupled to gaming devices in different jurisdictions providing staging of data collected from the gaming devices;   an extract, transform and load system coupled to the multiple transaction processing systems for extracting data from the collected data in each of the transaction processing systems in multiple jurisdictions; and   a data warehouse coupled to the extract, transform and load system, such that the extract, transform and load systems transforms the extracted data to a format compatible with the data warehouse and loads it into the data warehouse.   
   
   
       11 . The system of  claim 10  wherein portions of the extract, transform and load system are distributed between the multiple transaction processing systems and a central location. 
   
   
       12 . The system of  claim 11  wherein the extract and transform functions may be implemented in each of the multiple transaction processing systems. 
   
   
       13 . The system of  claim 10  wherein the transaction processing system comprises a wide area progressive system for each game theme in a jurisdiction. 
   
   
       14 . The system of  claim 13  wherein the transaction processing system comprises a common server for executing additional applications. 
   
   
       15 . The system of  claim 13  wherein the transaction processing system comprises a history/staging server for accumulating historical data from one or more wide area progressive systems. 
   
   
       16 . The system of  claim 15  wherein the history/staging server comprises information for providing jurisdictional specific reports. 
   
   
       17 . The system of  claim 13  wherein the wide area progressive systems for each game theme comprise a separate computer system. 
   
   
       18 . The system of  claim 13  and further comprising an on-line analytical processing system. 
   
   
       19 . The system of  claim 18  wherein the on-line analytical processing system comprises cubes populated for data analysis and data mining. 
   
   
       20 . The system of  claim 19  wherein the on-line analytical processing system provides analysis services, such as point-in-time data reports, summary data reports, comparison reports, trend analysis reports and profitability reports, and other data analysis and data mining applications. 
   
   
       21 . The system of  claim 10  and further comprising a network coupled to the extract, transform and load system and to the multiple transaction processing systems. 
   
   
       22 . The system of  claim 20  wherein the network comprises an intranet. 
   
   
       23 . A method comprising:
 staging historical data from multiple gaming systems distributed among different jurisdictions and independent business entities;   extracting and transforming data from the staged historical data to a format compatible with a central data warehouse for storing data from multiple jurisdictions and independent business entities; and   loading the transformed data into the central data warehouse.   
   
   
       24 . The method of  claim 23  and further comprising using an on-line analytical processing system to provide analysis services, such as point-in-time data reports, summary data reports, comparison reports, trend analysis reports and profitability reports, and other data analysis and data mining applications. 
   
   
       25 . A computer readable medium having instructions for causing a computer to perform a method, the method comprising:
 staging historical data from multiple gaming systems distributed among different jurisdictions and independent business entities;   extracting and transforming data from the staged historical data to a format compatible with a central data warehouse for storing data from multiple jurisdictions and independent business entities; and   loading the transformed data into the central data warehouse.