# US 2014/0207729 A1 · Rapid Provisioning of Information for Business Analytics

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

- Number: US 2014/0207729 A1
- Document ID: US20140207729A1
- Status: Published application
- Kind: A1
- Application number: 14/222,597
- Filed: 2014-03-22
- Published: 2014-07-24
- Earliest claimed: 2012-11-13
- Assignees: International Business Machines Corporation
- Applicants: International Business Machines Corporation
- Inventors: Manoj Kumar
- Web page: https://patentgrep.com/patent/US20140207729A1

## CPC

- G06F 16/254: {Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses}
- G06F 16/00: Information retrieval; Database structures therefor; File system structures therefor
- G06Q 10/10: Office automation; Time management
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)
- 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

An approach is provided in which a system creates schema terms based upon matching input data query requirements to industry terms. In turn, the system generates a query and an associative map, which includes data organized according to the schema terms. The system executes the query, which retrieves the data from the associative map and loads the data into one or more storage areas.

## Claims

### Claim 1

A method comprising:
creating, by one or more processors, one or more schema terms based upon matching one or more data requirements to one or more industry terms;
generating, by one or more of the processors, an associative map that includes data organized according to the one or more schema terms;
creating, by one or more of the processors, a query based upon one or more of the schema terms; and
executing the query by one or more of the processors, wherein the execution retrieves the data from the associative map and loads the data in one or more storage areas.

### Claim 2 (depends on 1)

The method of claim 1 further comprising:
storing the one or more schema terms in a schema terms dictionary;
providing the one or more schema terms stored in the schema terms dictionary to a user;
receiving one or more schema term selections from the user that selects one or more of the schema terms; and
including the selected schema terms in the query during the creation of the query.

### Claim 3 (depends on 2)

The method of claim 2 wherein the one or more storage areas are accessible to the user for analytical processing.

### Claim 4 (depends on 2)

The method of claim 2 wherein the schema terms dictionary includes only the one or more schema terms utilized during the generation of the associative map.

### Claim 5 (depends on 2)

The method of claim 2 further comprising:
generating a mapping script based upon the one or more schema terms stored in the schema terms dictionary; and
sending the mapping script to one or more feed adapters.

### Claim 6 (depends on 5)

The method of claim 5 further comprising:
executing the mapping script by the one or more feed adapters, wherein the execution retrieves the data from one or more operational data storage areas and stores the data in the associative map.

### Claim 7 (depends on 1)

The method of claim 1 further comprising:
creating one or more application-specific schema terms based upon matching one or more application-specific data requirements to one or more of the industry terms;
creating an application-specific mapping script that includes one or more of the application-specific schema terms;
executing the application-specific mapping script, wherein the execution of the application-specific mapping script retrieves application-specific data corresponding to the one or more application-specific schema terms from one or more operational data storage areas and adds the application-specific data to the associative map;
providing the one or more application-specific schema terms to a user;
receiving one or more application-specific schema term selections from the user that selects one or more of the application-specific schema terms;
including the selected application-specific schema terms in an application-specific query; and
executing the application-specific query, wherein the execution of the application-specific query retrieves the application-specific data from the associative map and loads the application-specific data in one or more of the storage areas.

### Claim 8 (depends on 1)

The method of claim 1 wherein:
the associative map is an associative map table that includes one or more column headers corresponding to one or more of the schema terms; and
the associative map table includes one or more row tags corresponding to one or more of the schema terms.

### Claim 9 (depends on 1)

The method of claim 1 wherein the one or more industry terms are retrieved from standardized data models corresponding to an enterprise data warehouse.

### Claim 10

A method comprising:
creating, by one or more processors, one or more schema terms based upon matching one or more general user data requirements to one or more industry terms;
retrieving one or more application specific data requirements from computer memory;
identifying, by one or more of the processors, one or more of the application specific data requirements that fail to correspond to one of the schema terms;
creating, by one or more of the processors, one or more application-specific schema terms based upon matching the one or more identified application-specific data requirements to one or more of the industry terms;
creating, by one or more of the processors, an application-specific mapping script that includes one or more of the application-specific schema terms;
executing, by one or more of the processors, the application-specific mapping script, wherein the execution of the application-specific mapping script retrieves application-specific data corresponding to the one or more application-specific schema terms from one or more operational data storage areas and includes the application-specific data in an associative map;
providing the one or more application-specific schema terms to a user;
receiving one or more application-specific schema term selections from the user that selects one or more of the application-specific schema terms;
including the selected application-specific schema terms in an application-specific query; and
executing, by one or more of the processors, the application-specific query, wherein the execution of the application-specific query retrieves the application-specific data from the associative map and loads the application-specific data in one or more storage areas accessible to the user to perform business analytics on the loaded application-specific data.
