WO2007011915A2 - Data warehouse for distributed gaming systems - Google Patents

Data warehouse for distributed gaming systems Download PDF

Info

Publication number
WO2007011915A2
WO2007011915A2 PCT/US2006/027786 US2006027786W WO2007011915A2 WO 2007011915 A2 WO2007011915 A2 WO 2007011915A2 US 2006027786 W US2006027786 W US 2006027786W WO 2007011915 A2 WO2007011915 A2 WO 2007011915A2
Authority
WO
WIPO (PCT)
Prior art keywords
data
reports
systems
analysis
staging
Prior art date
Application number
PCT/US2006/027786
Other languages
French (fr)
Other versions
WO2007011915A3 (en
Inventor
John A. Beatty
Original Assignee
Wms Gaming Inc.
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Wms Gaming Inc. filed Critical Wms Gaming Inc.
Priority to US11/996,014 priority Critical patent/US20080248875A1/en
Publication of WO2007011915A2 publication Critical patent/WO2007011915A2/en
Publication of WO2007011915A3 publication Critical patent/WO2007011915A3/en

Links

Classifications

    • GPHYSICS
    • G07CHECKING-DEVICES
    • G07FCOIN-FREED OR LIKE APPARATUS
    • G07F17/00Coin-freed apparatus for hiring articles; Coin-freed facilities or services
    • G07F17/32Coin-freed apparatus for hiring articles; Coin-freed facilities or services for games, toys, sports, or amusements
    • G07F17/3225Data transfer within a gaming system, e.g. data sent between gaming machines and users
    • G07F17/3232Data transfer within a gaming system, e.g. data sent between gaming machines and users wherein the operator is informed
    • GPHYSICS
    • G07CHECKING-DEVICES
    • G07FCOIN-FREED OR LIKE APPARATUS
    • G07F17/00Coin-freed apparatus for hiring articles; Coin-freed facilities or services
    • G07F17/32Coin-freed apparatus for hiring articles; Coin-freed facilities or services for games, toys, sports, or amusements
    • GPHYSICS
    • G07CHECKING-DEVICES
    • G07FCOIN-FREED OR LIKE APPARATUS
    • G07F17/00Coin-freed apparatus for hiring articles; Coin-freed facilities or services
    • G07F17/32Coin-freed apparatus for hiring articles; Coin-freed facilities or services for games, toys, sports, or amusements
    • G07F17/3225Data transfer within a gaming system, e.g. data sent between gaming machines and users
    • G07F17/3232Data transfer within a gaming system, e.g. data sent between gaming machines and users wherein the operator is informed
    • G07F17/3234Data transfer within a gaming system, e.g. data sent between gaming machines and users wherein the operator is informed about the performance of a gaming system, e.g. revenue, diagnosis of the gaming system

Definitions

  • the present invention related to gaming systems, and in particular to a data warehouse for distributed gaming systems.
  • Gaming machines such as slot machines, produce large amounts of data.
  • Casinos use slot data collection systems that track every aspect of every event surrounding a gaming device, including individual player performance. These data collection systems are limited in physical scope. Each system is confined to collect data from a particular business entity, such as a casino, or set of casinos owned by a single business entity. Different business entities may have different architecture gaming devices with different architectures and different data formats and structures. Further, gaming device in different jurisdictions may generate data in different formats as a result of different requirements in such jurisdictions. There is a need for a data collection system that can operate across business entities and jurisdictions, where such business entities and jurisdictions may have different gaming devices with different architectures and different data formats and structures.
  • 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.
  • FIG. 1 is a block diagram of a gaming machine according to an example embodiment.
  • FIG. 2 is a block diagram of a data warehouse coupled to gaming systems in multiple jurisdictions.
  • the functions or algorithms described herein are implemented in software or a combination of software and human implemented procedures in one embodiment.
  • the software comprises computer executable instructions stored on computer readable media such as memory or other type of storage devices.
  • computer readable media is also used to represent carrier waves on which the software is transmitted.
  • modules which are software, hardware, firmware or any combination thereof. Multiple functions are performed in one or more modules as desired, and the embodiments described are merely examples.
  • the software is executed on a digital signal processor, ASIC, microprocessor, or other type of processor operating on a computer system, such as a personal computer, server or other computer system.
  • casino game or gaming device encompasses, without limitation, slot machines, video poker machines, roulette tables, poker tables, craps tables and any other game of chance offered by a gaming establishment wherein for example the game qualifies as regulated and/or licensed gaming equipment.
  • a typical gaming system is first described, followed by a description of warehousing data from multiple such gaming systems coupled to on line transaction processing systems (OLTP), located in multiple jurisdictions.
  • OTP on line transaction processing systems
  • the gaming device 100 includes a coin slot 102 and bill acceptor 124.
  • Players can place coins in the coin slot 102 and paper money or ticket vouchers in the bill acceptor 124.
  • Other devices can be used for accepting payment.
  • credit/debit card readers/validators can be used for accepting payment.
  • the gaming device 100 can perform electronic funds transfers and financial transfers to procure monies from house financial accounts. When a player inserts money in the gaming device 100, a number of credits corresponding to the amount deposited is shown in a credit display. After depositing the appropriate amount of money, a player can begin playing the game by pulling an arm or pushing a play button.
  • the play button can be any play activator used by the player to start a game or sequence of events in the gaming device 100.
  • the gaming device 100 also includes a bet display 112 and a "bet one" button.
  • the player places a bet by pushing the bet one button.
  • the player can increase the bet by one credit each time the player pushes the bet one button.
  • the number of credits shown in the credit display 106 decreases by one, and the number of credits shown in the bet display 112 increases by one.
  • a player may "cash out” by pressing a cash out button 116.
  • the gaming device 100 dispenses a number of coins, corresponding to the number of remaining credits, into the coin tray 118.
  • the gaming device 100 may employ other payout mechanisms such as credit slips, which are redeemable by a cashier, or electronically recordable cards, which track player credits.
  • the gaming device 100 also includes one or more display devices.
  • the embodiment shown in FIG. 1 includes a primary display unit 104 and a secondary display unit 106.
  • the primary display unit 104 displays a plurality of reels 120.
  • the gaming device displays three reels, while an alternative embodiment displays five reels.
  • the reels are in video form.
  • the display units can display any visual representation or exhibition, including moving physical objects (e.g., mechanical reels and wheels), dynamic lighting, and video images.
  • each reel 120 includes a plurality of symbols such as bells, hearts, fruits, numbers, letters, bars or other images, which correspond to a theme associated with the gaming device 100. Furthermore, as shown in FIG.
  • the gaming device 100 includes a primary sound unit 128 and a secondary sound unit 130.
  • the primary and secondary sound units include speakers or other suitable sound projection devices.
  • the gaming device may be a portable gaming device, such as a handheld gaming device.
  • FIG. 2 illustrates a system 200 for warehousing data from multiple such gaming devices coupled to on line transaction processing systems (OLTP), located in multiple jurisdictions.
  • OLTP on line transaction processing systems
  • Three OLTP systems are shown in three different jurisdictions at 205, 210 and 215.
  • the OLTP systems may also be located in different independent business entities. As few as one OLTP system, or many more than three may be handled in system 200.
  • the first OLTP system 205 is shown in further detail. It handles data processes that perform individual transactions with defined, atomic units of measure.
  • One such transaction in a gaming machine environment is a handle pull on a slot machine.
  • Meter data is sent to system 205 to an application server, WAP (wide area progressive system) 220 which may be coupled to one or more gaming devices.
  • WAP wide area progressive system
  • a WAP is provided for each of multiple different types of gaming device themes. For example, multiple gaming devices with a Clint Eastwood progressive theme may be serviced by one WAP, and gaming devices with a Monopoly® progressive theme will be serviced by a separate WAP.
  • the separate WAPs are actually separate computer systems, but may be combined in a rack for convenience.
  • the separate WAPs may be implemented as virtual machines.
  • a common server 225 maybe used to run other applications, such as a new application 245.
  • the common server 225 is also coupled to two common physical devices, one or more gaming devices, and acts as a data collection device. In one example application, a coin count over a given period is accumulated.
  • OLTP 205 provides for isolation of transactions data from other applications by the use of separate servers, either real or virtual. This ensures consistency of the data and integrity of results.
  • a history/staging server 230 provides small, private and isolated sets of transaction data at each jurisdiction's central site. In one example, collections from a machine or set of machines may be collected for a time period, such as a day, and then rolled in to the history/staging server 230. Out-of- transaction data processes, like invoicing or performance reports may be removed from this data. Additional OLTP like applications, such as persistent state, participation data collection or mini-tournament enrollment may be easily implemented while still maintaining such isolation.
  • Such a strap-on approach provides flexibility to accept most future applications that use a gaming device, including applications involving downloadable game components.
  • data is transferred from WAP 220 and common server 225 to the history/staging server 230.
  • Some data massaging may take place to ensure that the data is complete to maintain the ability of the OLTP system 205 to continue to provide jurisdictional reports locally, as illustrated at 235.
  • History tables are maintained at history/staging server 230 to enable the provision of such reports.
  • staging tables contain massaged data at a detailed level. The staging tables may also track historic changes to common data, such as a casino's sales representatives.
  • checksums are used in the history/staging server 230 for each fact row.
  • a fact row may have up to twenty or more attributes. If one of the attributes changes, a new row containing a checksum for the contributing attributes is created.
  • a network 240 is used to transport periodic sets of data from history/staging server 230 from each of the jurisdictions, to an ETL (extract, transform and load) program 250, which may be located at a central location as shown.
  • ETL extract, transform and load
  • some or all of the functions of the ETL program 250 may be implemented in each jurisdiction, such as prior to history/staging server 230, or prior to transmission to a centrally located ETL 250.
  • portions of the extract, transform and load program or system are distributed between the multiple transaction processing systems and a central location.
  • the extract and transform functions may be implemented in each OLTP jurisdiction either in or prior to the history/staging server 230.
  • Program 250 verifies the consistency and integrity of the data, configures the incoming data with proper data warehouse identifiers, and finally inserts the data into a data warehouse 255.
  • the data is effectively cleansed to conform to the needs of the warehouse 255 and end users.
  • Multi-jurisdictional data is handled by ensuring that fact tables have an adequate number of fields for each jurisdiction. For instance, if only one jurisdiction requires two colors, two fields are provided for each jurisdiction.
  • Data warehouse 255 has the ability to stand alone without any shared resources. It maintains historic data from multiple jurisdictions accurately for every desired component of the data facts, and quickly and reliably presents its contents to requesting applications. Data warehouse 255 also keeps track of slowly changing dimensions, such as a name change of a casino. It may be a relational or modified relational type of database, or other form if desired. Data warehouse 255 is a robust and fruitful source of reports as indicated at 265 and 270. Such reports may be predefined or ad hoc, and may be requested and delivered via a network, such as the Internet or an Intranet.
  • An OLAP (on line analytical processing) process withdraws data from the data warehouse 255 and creates multiple objects, such as cubes 260 that are populated for data analysis and data mining. Summary and aggregate values may be calculated from the data. Various data mining applications that execute against these calculated values execute independently, and provide analysis reports and data mining as indicated at 270. OLAP process 260 has capability to condense, expand, slice and dice the data for trend analysis, performance comparisons, and status tracking, among many other analytical uses. Data mining services provide the ability to troll through various data structures and note similar or dissimilar patterns between various physical objects or stored events.
  • the OLAP process 260 enables analysts, managers and executives to gain insight into data through fast, consistent, interactive access to a wide variety of possible views of information that has been transformed from raw data to reflect the real dimensionality of the enterprise as understood by the user. Data is arranged and viewed through various combinations and permutations. Data retrieval speed is enhanced by precalculating data to provide various summary and aggregate levels in concert with user requirements. OLAP objects, often known as dimensions and cubes as represented in FIG. 2, store the results of such precalculated data. The precalculations may be done daily in off-peak hours.
  • OLAP data may be assembled in many different ways.
  • attributes for physical items are assembled. Different examples includes slant-top slots next to a restaurant, casinos that are 30 days late on their invoices, slots currently offline, etc.
  • Data may also be assembled by the type of time used for each fact. Examples include hour, shift, day, week, fiscal quarter, calendar year, etc. Further assembly may be based on the number of facts collected. Examples include amount of coin in, number of handle pulls, amount of drop box door open events, etc. Such assemblies of information would provide a very quick response to a request for a comparative trend analysis report showing the average coin in per shift during the last three months across each jurisdiction between two new themes, for example. This is just one illustration of the types of data assemblies. Further assemblies may be formed, based on historical or anticipated requests to enhance performance.

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.

Description

DATA WAREHOUSE FOR DISTRIBUTED GAMING SYSTEMS
RELATED APPLICATIONS
This application claims the priority benefit of U.S. Provisional Application Serial No. 60/700,093 filed July 18, 2005, the content of which is incorporated herein by reference.
COPYRIGHT
A portion of the disclosure of this patent document contains material to which the claim of copyright protection is made. The copyright owner has no objection to the facsimile reproduction by any person of the patent document or the patent disclosure, as it appears in the U.S. Patent and Trademark Office file or records, but reserves all other rights whatsoever. Copyright 2006, WMS Gaming, Inc.
FIELD
The present invention related to gaming systems, and in particular to a data warehouse for distributed gaming systems.
BACKGROUND
Gaming machines, such as slot machines, produce large amounts of data. Casinos use slot data collection systems that track every aspect of every event surrounding a gaming device, including individual player performance. These data collection systems are limited in physical scope. Each system is confined to collect data from a particular business entity, such as a casino, or set of casinos owned by a single business entity. Different business entities may have different architecture gaming devices with different architectures and different data formats and structures. Further, gaming device in different jurisdictions may generate data in different formats as a result of different requirements in such jurisdictions. There is a need for a data collection system that can operate across business entities and jurisdictions, where such business entities and jurisdictions may have different gaming devices with different architectures and different data formats and structures.
SUMMARY
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.
DESCRIPTION OF THE DRAWING
FIG. 1 is a block diagram of a gaming machine according to an example embodiment.
FIG. 2 is a block diagram of a data warehouse coupled to gaming systems in multiple jurisdictions.
DETAILED DESCRIPTION
In the following description, reference is made to the accompanying drawings that form a part hereof, and in which is shown by way of illustration specific embodiments which may be practiced. These embodiments are described in sufficient detail to enable those skilled in the art to practice the invention, and it is to be understood that other embodiments may be utilized and that structural, logical and electrical changes may be made without departing from the scope of the present invention. The following description is, therefore, not to be taken in a limited sense, and the scope of the present invention is defined by the appended claims.
The functions or algorithms described herein are implemented in software or a combination of software and human implemented procedures in one embodiment. The software comprises computer executable instructions stored on computer readable media such as memory or other type of storage devices. The term "computer readable media" is also used to represent carrier waves on which the software is transmitted. Further, such functions correspond to modules, which are software, hardware, firmware or any combination thereof. Multiple functions are performed in one or more modules as desired, and the embodiments described are merely examples. The software is executed on a digital signal processor, ASIC, microprocessor, or other type of processor operating on a computer system, such as a personal computer, server or other computer system.
As used herein, the term casino game or gaming device encompasses, without limitation, slot machines, video poker machines, roulette tables, poker tables, craps tables and any other game of chance offered by a gaming establishment wherein for example the game qualifies as regulated and/or licensed gaming equipment.
A typical gaming system is first described, followed by a description of warehousing data from multiple such gaming systems coupled to on line transaction processing systems (OLTP), located in multiple jurisdictions.
As illustrated in FIG. 1, the gaming device 100 includes a coin slot 102 and bill acceptor 124. Players can place coins in the coin slot 102 and paper money or ticket vouchers in the bill acceptor 124. Other devices can be used for accepting payment. For example, credit/debit card readers/validators can be used for accepting payment. Additionally, the gaming device 100 can perform electronic funds transfers and financial transfers to procure monies from house financial accounts. When a player inserts money in the gaming device 100, a number of credits corresponding to the amount deposited is shown in a credit display. After depositing the appropriate amount of money, a player can begin playing the game by pulling an arm or pushing a play button. The play button can be any play activator used by the player to start a game or sequence of events in the gaming device 100.
As shown in FIG. 1, the gaming device 100 also includes a bet display 112 and a "bet one" button. The player places a bet by pushing the bet one button. The player can increase the bet by one credit each time the player pushes the bet one button. When the player pushes the bet one button, the number of credits shown in the credit display 106 decreases by one, and the number of credits shown in the bet display 112 increases by one.
A player may "cash out" by pressing a cash out button 116. When a player cashes out, the gaming device 100 dispenses a number of coins, corresponding to the number of remaining credits, into the coin tray 118. The gaming device 100 may employ other payout mechanisms such as credit slips, which are redeemable by a cashier, or electronically recordable cards, which track player credits.
The gaming device 100 also includes one or more display devices. The embodiment shown in FIG. 1 includes a primary display unit 104 and a secondary display unit 106. In one embodiment, the primary display unit 104 displays a plurality of reels 120. In one embodiment, the gaming device displays three reels, while an alternative embodiment displays five reels. In one embodiment, the reels are in video form. According to embodiments of the invention, the display units can display any visual representation or exhibition, including moving physical objects (e.g., mechanical reels and wheels), dynamic lighting, and video images. In one embodiment, each reel 120 includes a plurality of symbols such as bells, hearts, fruits, numbers, letters, bars or other images, which correspond to a theme associated with the gaming device 100. Furthermore, as shown in FIG. 1, the gaming device 100 includes a primary sound unit 128 and a secondary sound unit 130. In one embodiment, the primary and secondary sound units include speakers or other suitable sound projection devices. In some embodiments, the gaming device may be a portable gaming device, such as a handheld gaming device.
FIG. 2 illustrates a system 200 for warehousing data from multiple such gaming devices coupled to on line transaction processing systems (OLTP), located in multiple jurisdictions. Three OLTP systems are shown in three different jurisdictions at 205, 210 and 215. The OLTP systems may also be located in different independent business entities. As few as one OLTP system, or many more than three may be handled in system 200.
The first OLTP system 205 is shown in further detail. It handles data processes that perform individual transactions with defined, atomic units of measure. One such transaction in a gaming machine environment is a handle pull on a slot machine. Meter data is sent to system 205 to an application server, WAP (wide area progressive system) 220 which may be coupled to one or more gaming devices. In one embodiment, a WAP is provided for each of multiple different types of gaming device themes. For example, multiple gaming devices with a Clint Eastwood progressive theme may be serviced by one WAP, and gaming devices with a Monopoly® progressive theme will be serviced by a separate WAP. In one embodiment, the separate WAPs are actually separate computer systems, but may be combined in a rack for convenience. In a further embodiment, the separate WAPs may be implemented as virtual machines.
A common server 225 maybe used to run other applications, such as a new application 245. The common server 225 is also coupled to two common physical devices, one or more gaming devices, and acts as a data collection device. In one example application, a coin count over a given period is accumulated.
OLTP 205 provides for isolation of transactions data from other applications by the use of separate servers, either real or virtual. This ensures consistency of the data and integrity of results. A history/staging server 230 provides small, private and isolated sets of transaction data at each jurisdiction's central site. In one example, collections from a machine or set of machines may be collected for a time period, such as a day, and then rolled in to the history/staging server 230. Out-of- transaction data processes, like invoicing or performance reports may be removed from this data. Additional OLTP like applications, such as persistent state, participation data collection or mini-tournament enrollment may be easily implemented while still maintaining such isolation. Such a strap-on approach provides flexibility to accept most future applications that use a gaming device, including applications involving downloadable game components. At periodic intervals, upon certain events, or in real time, data is transferred from WAP 220 and common server 225 to the history/staging server 230. Some data massaging may take place to ensure that the data is complete to maintain the ability of the OLTP system 205 to continue to provide jurisdictional reports locally, as illustrated at 235. History tables are maintained at history/staging server 230 to enable the provision of such reports. Additionally, staging tables contain massaged data at a detailed level. The staging tables may also track historic changes to common data, such as a casino's sales representatives.
In one embodiment, checksums are used in the history/staging server 230 for each fact row. A fact row may have up to twenty or more attributes. If one of the attributes changes, a new row containing a checksum for the contributing attributes is created.
A network 240 is used to transport periodic sets of data from history/staging server 230 from each of the jurisdictions, to an ETL (extract, transform and load) program 250, which may be located at a central location as shown. In various embodiments, some or all of the functions of the ETL program 250 may be implemented in each jurisdiction, such as prior to history/staging server 230, or prior to transmission to a centrally located ETL 250. Further, portions of the extract, transform and load program or system are distributed between the multiple transaction processing systems and a central location. In one example, the extract and transform functions may be implemented in each OLTP jurisdiction either in or prior to the history/staging server 230. Program 250 verifies the consistency and integrity of the data, configures the incoming data with proper data warehouse identifiers, and finally inserts the data into a data warehouse 255. The data is effectively cleansed to conform to the needs of the warehouse 255 and end users. Multi-jurisdictional data is handled by ensuring that fact tables have an adequate number of fields for each jurisdiction. For instance, if only one jurisdiction requires two colors, two fields are provided for each jurisdiction.
Data warehouse 255 has the ability to stand alone without any shared resources. It maintains historic data from multiple jurisdictions accurately for every desired component of the data facts, and quickly and reliably presents its contents to requesting applications. Data warehouse 255 also keeps track of slowly changing dimensions, such as a name change of a casino. It may be a relational or modified relational type of database, or other form if desired. Data warehouse 255 is a robust and fruitful source of reports as indicated at 265 and 270. Such reports may be predefined or ad hoc, and may be requested and delivered via a network, such as the Internet or an Intranet.
An OLAP (on line analytical processing) process withdraws data from the data warehouse 255 and creates multiple objects, such as cubes 260 that are populated for data analysis and data mining. Summary and aggregate values may be calculated from the data. Various data mining applications that execute against these calculated values execute independently, and provide analysis reports and data mining as indicated at 270. OLAP process 260 has capability to condense, expand, slice and dice the data for trend analysis, performance comparisons, and status tracking, among many other analytical uses. Data mining services provide the ability to troll through various data structures and note similar or dissimilar patterns between various physical objects or stored events.
The OLAP process 260 enables analysts, managers and executives to gain insight into data through fast, consistent, interactive access to a wide variety of possible views of information that has been transformed from raw data to reflect the real dimensionality of the enterprise as understood by the user. Data is arranged and viewed through various combinations and permutations. Data retrieval speed is enhanced by precalculating data to provide various summary and aggregate levels in concert with user requirements. OLAP objects, often known as dimensions and cubes as represented in FIG. 2, store the results of such precalculated data. The precalculations may be done daily in off-peak hours.
OLAP data may be assembled in many different ways. In one embodiment, attributes for physical items are assembled. Different examples includes slant-top slots next to a restaurant, casinos that are 30 days late on their invoices, slots currently offline, etc. Data may also be assembled by the type of time used for each fact. Examples include hour, shift, day, week, fiscal quarter, calendar year, etc. Further assembly may be based on the number of facts collected. Examples include amount of coin in, number of handle pulls, amount of drop box door open events, etc. Such assemblies of information would provide a very quick response to a request for a comparative trend analysis report showing the average coin in per shift during the last three months across each jurisdiction between two new themes, for example. This is just one illustration of the types of data assemblies. Further assemblies may be formed, based on historical or anticipated requests to enhance performance.

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.
PCT/US2006/027786 2005-07-18 2006-07-18 Data warehouse for distributed gaming systems WO2007011915A2 (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
US11/996,014 US20080248875A1 (en) 2005-07-18 2006-07-18 Data Warehouse for Distributed Gaming Systems

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
US70009305P 2005-07-18 2005-07-18
US60/700,093 2005-07-18

Publications (2)

Publication Number Publication Date
WO2007011915A2 true WO2007011915A2 (en) 2007-01-25
WO2007011915A3 WO2007011915A3 (en) 2007-03-15

Family

ID=37669496

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/US2006/027786 WO2007011915A2 (en) 2005-07-18 2006-07-18 Data warehouse for distributed gaming systems

Country Status (2)

Country Link
US (1) US20080248875A1 (en)
WO (1) WO2007011915A2 (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US9342946B2 (en) 2007-10-01 2016-05-17 Aristocrat Technologies Australia Pty Limited Gaming system and a method of gaming

Families Citing this family (57)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6676127B2 (en) 1997-03-13 2004-01-13 Shuffle Master, Inc. Collating and sorting apparatus
US6655684B2 (en) 1998-04-15 2003-12-02 Shuffle Master, Inc. Device and method for forming and delivering hands from randomly arranged decks of playing cards
US6254096B1 (en) 1998-04-15 2001-07-03 Shuffle Master, Inc. Device and method for continuously shuffling cards
US8590896B2 (en) 2000-04-12 2013-11-26 Shuffle Master Gmbh & Co Kg Card-handling devices and systems
US8337296B2 (en) 2001-09-28 2012-12-25 SHFL entertaiment, Inc. Method and apparatus for using upstream communication in a card shuffler
US7753373B2 (en) 2001-09-28 2010-07-13 Shuffle Master, Inc. Multiple mode card shuffler and card reading device
US7677565B2 (en) 2001-09-28 2010-03-16 Shuffle Master, Inc Card shuffler with card rank and value reading capability
US8616552B2 (en) 2001-09-28 2013-12-31 Shfl Entertainment, Inc. Methods and apparatuses for an automatic card handling device and communication networks including same
US8011661B2 (en) 2001-09-28 2011-09-06 Shuffle Master, Inc. Shuffler with shuffling completion indicator
US6886829B2 (en) 2002-02-08 2005-05-03 Vendingdata Corporation Image capturing card shuffler
US9126102B2 (en) 2002-05-20 2015-09-08 Bally Gaming, Inc. Four-card poker game with variable wager
US20160136511A9 (en) 2002-05-20 2016-05-19 Bally Gaming, Inc. Four Card Poker Game with Variable Wager
US9183705B2 (en) 2004-09-10 2015-11-10 Bally Gaming, Inc. Methods of playing wagering games
US20060284376A1 (en) 2005-06-17 2006-12-21 Shuffle Master, Inc. Casino table variant of Texas hold'em poker
US20060066048A1 (en) 2004-09-14 2006-03-30 Shuffle Master, Inc. Magnetic jam detection in a card shuffler
US7764836B2 (en) 2005-06-13 2010-07-27 Shuffle Master, Inc. Card shuffler with card rank and value reading capability using CMOS sensor
US7556266B2 (en) 2006-03-24 2009-07-07 Shuffle Master Gmbh & Co Kg Card shuffler with gravity feed system for playing cards
US8579289B2 (en) 2006-05-31 2013-11-12 Shfl Entertainment, Inc. Automatic system and methods for accurate card handling
US8342525B2 (en) 2006-07-05 2013-01-01 Shfl Entertainment, Inc. Card shuffler with adjacent card infeed and card output compartments
US8353513B2 (en) 2006-05-31 2013-01-15 Shfl Entertainment, Inc. Card weight for gravity feed input for playing card shuffler
US8070574B2 (en) 2007-06-06 2011-12-06 Shuffle Master, Inc. Apparatus, system, method, and computer-readable medium for casino card handling with multiple hand recall feature
US8919775B2 (en) 2006-11-10 2014-12-30 Bally Gaming, Inc. System for billing usage of an automatic card handling device
US8825743B2 (en) * 2007-07-12 2014-09-02 Cornell University Semantic transactions in online applications
US8832601B2 (en) * 2008-05-31 2014-09-09 Red Hat, Inc. ETL tool utilizing dimension trees
US20140089297A1 (en) * 2008-06-20 2014-03-27 New BIS Safe Luxco S.á r.l. System and method for analysing data from multiple perspectives
US8874502B2 (en) * 2008-08-29 2014-10-28 Red Hat, Inc. Real time datamining
US10102262B2 (en) * 2008-08-29 2018-10-16 Red Hat, Inc. Creating reports using dimension trees
US8150879B2 (en) * 2008-08-29 2012-04-03 Red Hat, Inc. Building custom dimension trees
US8914418B2 (en) 2008-11-30 2014-12-16 Red Hat, Inc. Forests of dimension trees
US8219547B2 (en) * 2009-03-13 2012-07-10 Microsoft Corporation Indirect database queries with large OLAP cubes
US7988152B2 (en) 2009-04-07 2011-08-02 Shuffle Master, Inc. Playing card shuffler
US8967621B2 (en) 2009-04-07 2015-03-03 Bally Gaming, Inc. Card shuffling apparatuses and related methods
US8800993B2 (en) 2010-10-14 2014-08-12 Shuffle Master Gmbh & Co Kg Card handling systems, devices for use in card handling systems and related methods
US8485527B2 (en) 2011-07-29 2013-07-16 Savant Shuffler LLC Card shuffler
US9731190B2 (en) 2011-07-29 2017-08-15 Bally Gaming, Inc. Method and apparatus for shuffling and handling cards
US9120007B2 (en) 2012-01-18 2015-09-01 Bally Gaming, Inc. Network gaming architecture, gaming systems, and related methods
US8974305B2 (en) 2012-01-18 2015-03-10 Bally Gaming, Inc. Network gaming architecture, gaming systems, and related methods
WO2013158466A1 (en) 2012-04-15 2013-10-24 Shfl Entertainment, Inc. Interactive financial transactions
US10128000B1 (en) 2012-04-19 2018-11-13 Kaiser Foundation Hospitals Computer system and method for delivering operational intelligence for ambulatory team based care and virtual medicine
US8960674B2 (en) 2012-07-27 2015-02-24 Bally Gaming, Inc. Batch card shuffling apparatuses including multi-card storage compartments, and related methods
US9378766B2 (en) 2012-09-28 2016-06-28 Bally Gaming, Inc. Card recognition system, card handling device, and method for tuning a card handling device
US9511274B2 (en) 2012-09-28 2016-12-06 Bally Gaming Inc. Methods for automatically generating a card deck library and master images for a deck of cards, and a related card processing apparatus
CN106457036B (en) 2014-04-11 2019-11-22 巴利游戏公司 Method and apparatus for shuffling and handling board
US9474957B2 (en) 2014-05-15 2016-10-25 Bally Gaming, Inc. Playing card handling devices, systems, and methods for verifying sets of cards
USD764599S1 (en) 2014-08-01 2016-08-23 Bally Gaming, Inc. Card shuffler device
US9566501B2 (en) 2014-08-01 2017-02-14 Bally Gaming, Inc. Hand-forming card shuffling apparatuses including multi-card storage compartments, and related methods
US9504905B2 (en) 2014-09-19 2016-11-29 Bally Gaming, Inc. Card shuffling device and calibration method
US9993719B2 (en) 2015-12-04 2018-06-12 Shuffle Master Gmbh & Co Kg Card handling devices and related assemblies and components
US10339765B2 (en) 2016-09-26 2019-07-02 Shuffle Master Gmbh & Co Kg Devices, systems, and related methods for real-time monitoring and display of related data for casino gaming devices
US10933300B2 (en) 2016-09-26 2021-03-02 Shuffle Master Gmbh & Co Kg Card handling devices and related assemblies and components
US10796591B2 (en) 2017-04-11 2020-10-06 SpoonRead Inc. Electronic document presentation management system
US11896891B2 (en) 2018-09-14 2024-02-13 Sg Gaming, Inc. Card-handling devices and related methods, assemblies, and components
US11376489B2 (en) 2018-09-14 2022-07-05 Sg Gaming, Inc. Card-handling devices and related methods, assemblies, and components
US11338194B2 (en) 2018-09-28 2022-05-24 Sg Gaming, Inc. Automatic card shufflers and related methods of automatic jam recovery
US11898837B2 (en) 2019-09-10 2024-02-13 Shuffle Master Gmbh & Co Kg Card-handling devices with defect detection and related methods
US11173383B2 (en) 2019-10-07 2021-11-16 Sg Gaming, Inc. Card-handling devices and related methods, assemblies, and components
US11710373B2 (en) * 2020-01-23 2023-07-25 SpoonRead Inc. Distributed ledger based distributed gaming system

Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5761647A (en) * 1996-05-24 1998-06-02 Harrah's Operating Company, Inc. National customer recognition system and method
US6302793B1 (en) * 1998-07-02 2001-10-16 Station Casinos, Inc. Multi-property player tracking system
US6645077B2 (en) * 2000-10-19 2003-11-11 Igt Gaming terminal data repository and information distribution system

Family Cites Families (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6275937B1 (en) * 1997-11-06 2001-08-14 International Business Machines Corporation Collaborative server processing of content and meta-information with application to virus checking in a server network
US8033913B2 (en) * 1999-06-03 2011-10-11 Igt Gaming machine update and mass storage management
AU2001288936A1 (en) * 2000-09-07 2002-03-22 Closingguard.Com, Inc. System and method of managing financial transactions over an electronic network
US6749510B2 (en) * 2001-02-07 2004-06-15 Wms Gaming Inc. Centralized gaming system with modifiable remote display terminals
US20050085291A1 (en) * 2003-10-15 2005-04-21 Kenilworth Systems Corporation Method and system for supplying funds to a terminal for remote wagering
US20050085293A1 (en) * 2003-10-15 2005-04-21 Kenilworth Systems Corporation. Method and system for supplying funds to a terminal for remote wagering

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5761647A (en) * 1996-05-24 1998-06-02 Harrah's Operating Company, Inc. National customer recognition system and method
US6302793B1 (en) * 1998-07-02 2001-10-16 Station Casinos, Inc. Multi-property player tracking system
US6645077B2 (en) * 2000-10-19 2003-11-11 Igt Gaming terminal data repository and information distribution system

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US9342946B2 (en) 2007-10-01 2016-05-17 Aristocrat Technologies Australia Pty Limited Gaming system and a method of gaming
US9886823B2 (en) 2007-10-01 2018-02-06 Aristocrat Technologies Australia Pty Limited Gaming system and a method of gaming

Also Published As

Publication number Publication date
WO2007011915A3 (en) 2007-03-15
US20080248875A1 (en) 2008-10-09

Similar Documents

Publication Publication Date Title
US20080248875A1 (en) Data Warehouse for Distributed Gaming Systems
US20230419779A1 (en) Gaming Monetary Instrument Tracking System
US9142087B2 (en) Gaming method and apparatus for employing negative outcomes
US9576420B2 (en) Method and apparatus for conditional payouts in a gaming device
US6878063B2 (en) Method for implementing scheduled return play at gaming machine networks
US8512132B2 (en) Universally compliant multi-currency progressive jackpot system
US8096883B2 (en) System and method for delivering wager gaming machine information
AU2006214434A1 (en) System and method for automatic progressive link dispersal
US20200387890A1 (en) Categorized Virtual Currency Tracking, Purchasing, and Redemption Systems, and Method of Use and Doing Business
US10115269B2 (en) Method and system of wagering
US8235807B1 (en) System for managing accounting
US8241117B1 (en) Accounting system
WO2007059080A2 (en) Transmitting content in wagering networks
US20140274346A1 (en) System and method for providing a list of monetary instruments associated with a system
AU2010202240B2 (en) A gaming system, a gaming server and a gaming method
US20230079094A1 (en) System and method for casino jackpot processing and marker payment
US20090137302A1 (en) Client-server network configurations for gaming systems
MX2007008890A (en) System for communicating with a player.
AU2008200170A1 (en) Method for Implementing Scheduled Return Play at Gaming Machine Networks

Legal Events

Date Code Title Description
121 Ep: the epo has been informed by wipo that ep was designated in this application
DPE1 Request for preliminary examination filed after expiration of 19th month from priority date (pct application filed from 20040101)
WWE Wipo information: entry into national phase

Ref document number: 11996014

Country of ref document: US

NENP Non-entry into the national phase

Ref country code: DE

122 Ep: pct application non-entry in european phase

Ref document number: 06787659

Country of ref document: EP

Kind code of ref document: A2

DPE1 Request for preliminary examination filed after expiration of 19th month from priority date (pct application filed from 20040101)