Data Warehouse for Distributed Gaming Systems

• US 20080248875A1
• Filed: 07/18/2006
• Published: 10/09/2008
• Est. Priority Date: 07/18/2005
• Status: Abandoned Application

• Current Assignee: Sg Gaming, Inc. (Light & Wonder Incorporated)
• Original Assignee: Sg Gaming, Inc. (Light & Wonder Incorporated)
• Inventors: Beatty, John A.
• Application Number:
  US11/996,014
• Publication Number:
  US 20080248875A1
• Time in Patent Office: Days
• US Class Current: 463/42
• CPC Class Codes: G07F 17/32 for games, toys, sports, or amusements
• CPC Class Codes: G07F 17/3232 wherein the operator is informed
• CPC Class Codes: G07F 17/3234 about the performance of a gaming system, e.g. revenue, diagnosis of the gaming system

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.

Claims

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.