Analyzing a query and provisioning data to analytics

• US 9,633,115 B2
• Filed: 04/08/2014
• Issued: 04/25/2017
• Est. Priority Date: 04/08/2014
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Byrne, Brian P., Milman, Ivan M., Oberhofer, Martin, Pandit, Sushain
• Primary Examiner(s): Phillips, III, Albert
• Application Number:
  US14/247,366
• Publication Number:
  US 20150286697A1
• Time in Patent Office: 1,113 Days
• CPC Class Codes: G06F 16/332 Query formulation
• CPC Class Codes: G06F 16/3329 Natural language query formulation or dialogue systems
• CPC Class Codes: G06F 16/3334 Selection or weighting of terms from queries, including natural language queries
• CPC Class Codes: G06F 16/335 Filtering based on additional data, e.g. user or group profiles filtering in web context G06F16/9535, G06F16/9536
• CPC Class Codes: G06F 16/907 Retrieval characterised by using metadata, e.g. metadata not derived from the content or metadata generated manually
• CPC Class Codes: G06F 16/951 Indexing; Web crawling techniques
• CPC Class Codes: G06F 16/9538 Presentation of query results
• CPC Class Codes: G06Q 10/06 Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
• CPC Class Codes: G06Q 50/01 Social networking

Abstract

A user interface is generated that displays a set of selectable terms from a glossary of business terms and is configured to generate a business metadata query that identifies a forum with member profiles. A data movement executable is generated that identifies the forum and an analytical processing environment. The data movement executable is deployed and data is moved from the forum into the analytical processing environment. Analytics are performed on the data from the forum. Metadata is identified from the analytics. The glossary of business terms is updated using the metadata from the analytics.

Claims

1. A system for analyzing a query and provisioning data to analytics, the system comprising:

a user interface to display a set of selectable terms from a glossary of business terms and to generate, in response to a selection of a subset of the set of selectable terms, a business metadata query that identifies at least one forum with a plurality of member profiles;

a generator to generate at least one module from the business metadata query that identifies the at least one forum and an analytical processing environment;

a computing platform to deploy the at least one module to move data from the at least one forum into the analytical processing environment and perform, using the analytical processing environment, analytical operations on the data from the at least one forum; and

a business extender to;

identify metadata from a result of the analytical operations, and

update the glossary of business terms using the identified metadata.

2. The system of claim 1, wherein to generate the at least one module, the generator executes operations to:

analyze technical metadata associated with business metadata to identify a scope of the business metadata query; and

analyze the business metadata query to identify at least one data source, the analytical operations, and the analytical processing environment.

3. The system of claim 1, wherein by deploying the at least one module, the computing platform executes operations to:

read data from at least one data source;

receive data records from the at least one data source based on the data read; and

send the data records to the analytical environment.

4. The system of claim 1, wherein the set of selectable terms includes a customer segment, a product segment, a social media source, and an analytical operation.

5. The system of claim 1, wherein the computing platform is further executes operations to:

receive results in response to the performance of the analytical operations on the data; and

send the results to an analytical user interface.

6. The system of claim 1, wherein to update the glossary of business terms, the business extender executes operations to add new business terms to the glossary of business terms.

7. The system of claim 1, wherein to update the glossary of business terms, the business extender executes operations to further define a set of business terms in the glossary of business terms.

8. A computer program product to analyze a query and provisioning data to analytics, the computer program product including a computer readable storage medium having program instructions embodied therewith, wherein the computer readable storage medium is not a transitory signal per se, the program instructions executable by a processing circuit to cause the processing circuit to perform a method comprising:

generating a user interface that displays a set of selectable terms from a glossary of business terms and generates, in response to selection of terms, a business metadata query that identifies at least one forum with a plurality of member profiles;

generating from the business metadata query at least one module that identifies the at least one forum and an analytical processing environment;

moving data from the at least one forum into the analytical processing environment by deploying the at least one module;

performing, using the analytical processing environment, analytical operations on the data from the at least one forum;

identifying metadata from a result of the analytical operations; and

updating the glossary of business terms using the identified metadata.

9. The computer program product of claim 8, wherein generating the at least one module comprises:

analyzing technical metadata associated with business metadata to identify a scope of the business metadata query; and

analyzing the business metadata query to identify at least one data source, analytical operations, and the analytical processing environment.

10. The computer program product of claim 8, wherein deploying the at least one module comprises:

reading data from at least one data source;

receiving data records from the at least one data source based on the data read; and

sending the data records to the analytical environment.

11. The computer program product of claim 8, wherein the set of selectable terms includes a customer segment, a product segment, a social media source, and an analytical operation.

12. The computer program product of claim 8, wherein the method further comprises:

receiving results in response to the performance of the analytical operations on the data; and

sending the results to an analytical user interface.

13. The computer program product of claim 8, wherein updating the glossary of business terms includes further defining a set of business terms in the glossary of business terms.