System and method for computer-assisted improvement of business intelligence ecosystem

• US 9,953,279 B1
• Filed: 10/22/2012
• Issued: 04/24/2018
• Est. Priority Date: 10/21/2011
• Status: Active Grant

• Current Assignee: Motio Incorporated (Peak6 LLC)
• Original Assignee: Motio Incorporated (Peak6 LLC)
• Inventors: Hankins, Lance W., Moore, Jr., J. Lynn, Siler, Jeremy D.
• Primary Examiner(s): Gills, Kurtis
• Application Number:
  US13/657,753
• Time in Patent Office: 2,010 Days
• Field of Search: 705 739
• CPC Class Codes: G06Q 10/06 Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
• CPC Class Codes: G06Q 10/067 Enterprise or organisation modelling

Abstract

In various implementations, improvement of a business intelligence ecosystem may include analyzing component(s) of a business intelligence ecosystem, identifying candidate improvements, applying at least a portion of candidate improvements, and/or verifying effects of the candidate improvements. Candidate improvements for business intelligence artifact(s), underlying data sources, BI environment configurations, metadata models, and/or computing resources may be analyzed and identified.

Claims

1. A computer implemented method for improving a business intelligence ecosystem, the method comprising:

receiving, from a user device, a selection of a business intelligence artifact;

determining one or more execution profiles for the selected business intelligence artifact;

determining an initial examination score for the selected business intelligence artifact;

identifying, via one or more improvement modules on a server, one or more candidate improvements to the business intelligence ecosystem based on a configurable set of rules;

applying, via the one or more improvement modules on a server, one or more of the identified candidate improvements to modify the business intelligence ecosystem in which one or more of the candidate improvements was identified;

executing the selected business intelligence artifact in the modified business intelligence ecosystem, wherein the selected business intelligence artifact is executed at least partially based on one or more of the execution profiles;

determining examination data for the business intelligence artifact executed in the modified business intelligence ecosystem;

reverting, via the one or more improvement modules, modifications to the modified business intelligence ecosystem by reverting the applied one or more candidate improvements; and

identifying, via the one or more improvement modules, one or more qualified selected improvements based on a comparison of the examination data and the initial examination score, wherein at least one of the qualified selected improvements comprises at least one of the identified candidate improvements.

2. The method of claim 1 further comprising determining whether to apply one or more of the qualified selected improvements to the business intelligence ecosystem.

3. The method of claim 1 further comprising applying the qualified selected improvements to the business intelligence ecosystem.

4. The method of claim 1 further comprising determining one or more business intelligence ecosystem dependencies of the selected business intelligence artifact.

5. The method of claim 1 wherein modifying the business intelligence ecosystem by allowing the one or more improvement modules to applying one or more of the identified candidate improvements comprises applying one or more of the identified candidate improvements to at least one of:

the selected business intelligence artifact;

an associated metadata model;

one or more underlying data sources;

one or more business intelligence ecosystem components;

or

a configuration of one or more of the business intelligence ecosystem components.

6. The method of claim 1 further comprising storing at least one of the identified qualified selected improvements.

7. The method of claim 1 wherein determining the initial examination score comprises:

executing the selected business intelligence artifact at least partially based on at least one of the determined execution profiles; and

determining examination data based at least partially on data from monitoring the business intelligence ecosystem during at least one of;

the execution of the selected business intelligence artifact;

a period of time prior to the execution of the selected business intelligence artifact;

or

a period of time after the execution of the selected business intelligence artifact.

8. The method of claim 1 wherein identifying one or more candidate improvements comprises:

retrieving a set of configurable rules;

applying one or more of the configurable rules of the retrieved set of configurable rules to at least one of;

the selected business intelligence artifact,

the initial examination score,

an associated metadata model,

one or more underlying data sources, or

one or more business intelligence ecosystem components; and

determining at least one of the candidate improvements based at least partially on the application of one or more of the configurable rules.

9. The method of claim 1 wherein identifying one or more qualified selected improvements is based at least partially on at least one of:

an initial examination score;

or

an examination test of at least one of;

at least a part of the selected business intelligence artifact,

at least a part of related business intelligence artifacts, or

at least a part of other components in the business intelligence ecosystem.

10. The method of claim 1 further comprising:

generating a set of instructions associated with applying at least one of the qualified selected improvements to the business intelligence ecosystem; and

receiving a confirmation that at least one of the qualified selected improvements to the business intelligence ecosystem was applied at least partially based on the generated instructions.

11. A computer implemented method for improving a business intelligence ecosystem, the method comprising:

receiving, from a user device, a selection of one or more business intelligence artifacts;

determining one or more execution profiles for each of the selected business intelligence artifacts;

determining a set of metadata models associated with one or more of the selected business intelligence artifact;

identifying a set of data sources associated with the set of metadata models;

determining an initial examination score for at least one of the selected business intelligence artifacts;

determining information related to one or more associated data sources of the set of data sources associated with the set of metadata models;

identifying, via one or more improvement modules on a server, one or more candidate improvements to the business intelligence ecosystem based at least partially on the initial examination score the determined information, and a configurable set of rules;

modifying the business intelligence ecosystem by applying, via the one or more improvement modules, one or more of the identified candidate improvements to at least one of;

one or more of the metadata models;

one or more of the associated data sources;

or

one or more of the business intelligence ecosystem components;

executing one or more of the selected business intelligence artifacts in the modified business intelligence ecosystem, wherein one or more of the selected business intelligence artifacts are executed at least partially based on one or more of the determined execution profiles;

applying an examination test on one or more of the selected business intelligence artifacts executed in the modified business intelligence ecosystem;

determining examination data based at least partially on the examination test; and

identifying, via the one or more improvement modules, one or more qualified selected improvements based on a comparison of the examination data and the initial examination score, wherein at least one of the qualified selected improvements comprises at least one of the identified candidate improvements.

12. The method of claim 11 further comprising reverting the modifications to the modified business intelligence ecosystem, via the one or more improvement modules, by reverting the applied one or more candidate improvements.

13. The method of claim 11 further comprising:

generating a listing for presentation to the user based at least partially on one or more of the metadata models; and

receiving a selection of at least one of the metadata models from the listing;

wherein modifying the business intelligence ecosystem comprises modifying at least one of the selected metadata models by applying one or more of the identified candidate improvements to at least one of the selected metadata models.

14. The method of claim 11 further comprising:

determining whether to apply one or more of the identified qualified selected improvements to at least one of the metadata models or the associated data sources; and

applying one or more of the identified qualified selected improvements to at least one of the metadata models or the associated data sources if a determination is made to apply one or more of the qualified selected improvements.

15. The method of claim 11 wherein the initial examination score comprises at least one of:

execution data related to at least one of the selected business intelligence artifacts;

or

non-execution data related to at least one of the selected business intelligence artifacts.

16. The method of claim 11 wherein the examination data comprises at least one of:

execution data related to at least one of the selected business intelligence artifacts;

or

non-execution data related to at least one of the selected business intelligence artifacts.

17. The method of claim 11 further comprising determining information related to the identified set of data sources;

wherein identifying one or more candidate improvements to at least one of the selected business intelligence artifacts is based at least partially on the initial examination score and determined information related to the identified set of data sources.

18. The method of claim 11 further comprising applying an examination test to at least a portion of the set of data sources;

wherein determining the information related to the identified set of data sources is at least partially based on the examination test of at least a portion of the set of data sources.

19. The method of claim 11 further comprising determining information related to at least one of:

one or more metadata models of the set of metadata models;

or one or more business intelligence ecosystem components, and wherein identifying one or more candidate improvements to the business intelligence ecosystem based at least partially on the determined information further comprises identifying one or more candidate improvements to the business intelligence ecosystem based at least partially on determined information related to at least one of one or more of the metadata models of the set of metadata models or one or more of the business intelligence ecosystem components.