# US 2022/0036382 A1 · Data integration hub

> Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt

- Number: US 2022/0036382 A1
- Document ID: US20220036382A1
- Status: Published application
- Kind: A1
- Application number: 17/450,814
- Filed: 2021-10-13
- Published: 2022-02-03
- Earliest claimed: 2015-04-17
- Assignees: Poarch Band of Creek Indians, DBA PCI Gaming Authority
- Applicants: Poarch Band of Creek Indians, DBA PCI Gaming Authority
- Inventors: Candy Kirby Fralick; James Dorris; Ronald Nesbitt; John Enriquez
- Web page: https://patentgrep.com/patent/US20220036382A1

## CPC

- G06Q 30/0201: Market modelling; Market analysis; Collecting market data
- G06Q 10/067: Enterprise or organisation modelling
- G06Q: INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR

## Abstract

A data integration hub system includes a centralized database storing data according to a dimensional modeling schema. The data integration hub system accepts an external dataset from an external data source that stores data according to a database schema that differs from the dimensional modeling schema of the central database. The data integration hub translates the external data set into a first importable format compatible with the dimensional modeling scheme of the centralized database, and imports the translated external dataset into the centralized database. The data integration hub also accepts online platform data from an online platform and imports the online platform data into the centralized database. In some cases, the data integration hub translated the online platform data prior to importation. The data integration hub generates client valuation profiles based on the data imported from the external data source and the online platform.

## Claims

### Claim at position 1

-20. (canceled)

### Claim 21

A data integration system, comprising:
a centralized database including a plurality of fact tables with data related to observable events and a plurality of dimensional tables with attributes for the data contained in the fact tables;
at least one processor that is configured to execute a set of instructions to:
receive an external dataset from an external data source, the external data source storing data according to an external database schema;
translate the external dataset into a first importable format compatible with the centralized database and generate extracted data;
import the extracted data into the centralized database using one or more insert statements;
receive online platform data from an online platform, the online platform comprising a server associated with a website that sends the online platform data for storage in the centralized database;
translate the online platform data into a second importable format compatible with the centralized database; and
import the translated online platform data into the centralized database;
wherein the dimensional tables provide a context surrounding each observable event, the context including information relating to at least two of the following types: who is in the observable event, what is the observable event, where the observable event occurs, when the observable event occurs, why the observable event occurs, and how the observable event occurs.

### Claim 22 (depends on 21)

The data integration system of claim 21, wherein at least one fact table comprises a set of numeric values and at least one key that references a row of a dimensional table.

### Claim 23 (depends on 22)

The data integration system of claim 22, wherein the at least fact table contains information for a single grain that represents the lowest level of data to be captured by the system and stored in a row of the fact table.

### Claim 24 (depends on 23)

The data integration system of claim 23, wherein a one-to-one relationship exists between each key in the fact table and the row of the dimensional table referenced by that key.

### Claim 25 (depends on 21)

The data integration system of claim 21, wherein the centralized database stores data according to a dimensional modeling schema, the external database schema being different than the dimensional modeling schema of the centralized database.

### Claim 26 (depends on 21)

The data integration system of claim 21, wherein the first importable format and the second importable format are the same.

### Claim 27 (depends on 21)

The data integration system of claim 21, wherein the at least one processor is further configured to translate the received external dataset into the first importable format by using one or more scripts that parse the external dataset.

### Claim 28 (depends on 27)

The data integration system of claim 27, wherein the at least one processor is further configured to extract data from the parsed dataset and generate the one or more insert statements to add the extracted data to the centralized database.

### Claim 29 (depends on 21)

The data integration system of claim 21 wherein the at least one processor is further configured to directly import the received online platform data into the centralized database when the received online platform data is compatible with the centralized database.

### Claim 30

A computer-implemented method for integrating data from a plurality of sources into a centralized database including fact tables with data related to observable events and dimensional tables with attributes for the data contained in the fact tables, the method comprising the following steps performed by at least one processor:
receiving an external dataset from an external data source, the external data source storing data according to an external database schema;
translating the external dataset into a first importable format compatible with the centralized database and generating extracted data;
importing the extracted data into the centralized database using one or more insert statements;
receiving online platform data from an online platform comprising a server associated with a website that sends the online platform data for storage in the centralized database;
translating the online platform data into a second importable format compatible with the centralized database; and
importing the translated online platform data into the centralized database;
wherein the dimensional tables provide a context surrounding each observable event, the context including information relating to at least two of the following types:
who is in the observable event, what is the observable event, where the observable event occurs, when the observable event occurs, why the observable event occurs, and how the observable event occurs.

### Claim 31 (depends on 30)

The method of claim 30, wherein at least one fact table comprises a set of numeric values and at least one key that references a row of a dimensional table.

### Claim 32 (depends on 31)

The method of claim 31, wherein the at least one fact table contains information for a single grain that represents the lowest level of data to be captured and stored in a row of the fact table.

### Claim 33 (depends on 32)

The method of claim 32, wherein a one-to-one relationship exists between each key in the fact table and the row of the dimensional table referenced by that key.

### Claim 34 (depends on 30)

The method of claim 30, wherein the centralized database stores data according to a dimensional modeling schema, the external database schema being different than the dimensional modeling schema of the centralized database.

### Claim 35 (depends on 30)

The method of claim 30, wherein the first importable format and the second importable format are the same.

### Claim 36 (depends on 30)

The method of claim 30, further comprising:
translating the received external dataset into the first importable format by using one or more scripts that parse the external dataset.

### Claim 37 (depends on 36)

The method of claim 36, further comprising:
extracting data from the parsed dataset; and
generating the one or more insert statements to add the extracted data to the centralized database

### Claim 38 (depends on 30)

The method of claim 30, further comprising:
directly importing the received online platform data into the centralized database when the received online platform data is compatible with the centralized database.
