Supplemental system for business intelligence systems

• US 9,785,907 B2
• Filed: 03/21/2016
• Issued: 10/10/2017
• Est. Priority Date: 01/03/2006
• Status: Active Grant

• Current Assignee: Motio Incorporated (Peak6 LLC)
• Original Assignee: Motio Incorporated (Peak6 LLC)
• Inventors: Hankins, Lance W., Moore, Roger P.
• Primary Examiner(s): NGUYEN, PHONG H
• Application Number:
  US15/076,437
• Publication Number:
  US 20160203426A1
• Time in Patent Office: 568 Days
• Field of Search: 707638, 707695, 707944
• CPC Class Codes: G06F 11/368 for test version control, e.g. updating test cases to a new software version
• CPC Class Codes: G06F 40/197 Version control for software G06F8/71
• CPC Class Codes: G06F 8/71 Version control security arrangements therefor G06F21/57; Configuration management
• CPC Class Codes: G06Q 10/0637 Strategic management or analysis, e.g. setting a goal or target of an organisation; Planning actions based on goals; Analysis or evaluation of effectiveness of goals
• CPC Class Codes: G06Q 10/067 Enterprise or organisation modelling
• CPC Class Codes: G06Q 10/10 Office automation; Time management
• CPC Class Codes: Y10S 707/944 Business related

Abstract

In various implementations, a supplemental system may be provided. The supplemental system may be coupled to business intelligence environment(s) to facilitate deployment, version control, testing, and/or other processes.

Claims

1. A method comprising:

retrieving a first Business Intelligence Artifact Output, wherein the first Business Intelligence Artifact Output is generated by execution of a first version of a Business Intelligence Artifact in a first Business Intelligence Environment, and wherein a first specification associated with the first version of the Business Intelligence Artifact includes one or more specification markers, and wherein the first Business Intelligence Artifact Output comprises one or more output markers associated with at least one of the specification markers in the first specification;

retrieving a second Business Intelligence Artifact Output, wherein the second Business Intelligence Artifact Output is generated by execution of a second version of the Business Intelligence Artifact in the first Business Intelligence Environment, and wherein a second specification is associated with the second version of the Business Intelligence Artifact, and wherein the second specification includes one or more specification markers; and

wherein the second Business Intelligence Artifact Output comprises one or more output markers associated with at least one of the specification markers in the second specification;

retrieving a set of portions to ignore;

identifying whether one or more differences exist between the first version of the Business Intelligence Artifact and the second version of the Business Intelligence Artifact based at least partially on a comparison of at least one of the output markers in the first Business Intelligence Artifact Output and at least one of the output markers in the second Business Intelligence Artifact Output; and

determining whether one or more of the identified differences are included in the retrieved set of portions to ignore to determine whether differences exist between the first version of the Business Intelligence Artifact and the second version of the Business Intelligence Artifact.

2. The method of claim 1 wherein retrieving the first Business Intelligence Artifact Output comprises:

retrieving the first version of the Business Intelligence Artifact, wherein one or more of the specification markers of the first specification identify portions of the first specification; and

executing the first version of the Business Intelligence Artifact in the first Business Intelligence Environment to generate the first Business Intelligence Artifact Output.

3. The method of claim 1 wherein retrieving the second Business Intelligence Artifact Output comprises:

retrieving the second version of the Business Intelligence Artifact, wherein one or more of the specification markers of the second specification identify portions of the second specification; and

executing the second version of the Business Intelligence Artifact in the first Business Intelligence Environment to generate the second Business Intelligence Artifact Output.

4. The method of claim 1 wherein one or more of the specification markers identify portions of a specification.

5. The method of claim 1 wherein one or more of the output markers comprise a non-visual marker.

6. The method of claim 1 further comprising altering the first specification of the first version of the Business Intelligence Artifact such that one or more specification markers of the first specification are inserted into the first specification to identify one or more portions of the first specification.

7. The method of claim 1 further comprising altering the second specification of the second version of the Business Intelligence Artifact such that one or more specification markers of the second specification are inserted into the second specification to identify one or more portions of the second specification.

8. The method of claim 1 further comprising comparing the first Business Intelligence Artifact Output to the second Business Intelligence Artifact Output, and wherein comparing the first Business Intelligence Artifact Output to the second Business Intelligence Artifact Output comprises:

identifying one or more first output portions of the first Business Intelligence Artifact Output which are not associated with one or more portions identified in the retrieved set of portions to ignore;

identifying one or more second output portions of the second Business Intelligence Artifact Output which are not associated with one or more of the portions identified in the retrieved set of portions to ignore; and

comparing one or more of the first output portions of the first Business Intelligence Artifact Output to one or more of the second output portions of the second Business Intelligence Artifact.

9. The method of claim 1 further comprising identifying one or more differences that exist between the first version of the Business Intelligence Artifact and the second version of the Business Intelligence Artifact based at least partially on the determination of whether one or more of the identified differences are included in the retrieved set of portions to ignore.

10. The method of claim 9 further comprising generating a notification, to be presented to a user, based at least partially on one or more of the identified differences between the first version of the Business Intelligence Artifact and the second version of the Business Intelligence Artifact.

11. The method of claim 9 further comprising saving, in a memory of a Supplemental system, the identified differences between the first version of the Business Intelligence Artifact and the second version of the Business Intelligence Artifact.

12. The method of claim 9 further comprising identifying one or more similarities that exist between the first version of the Business Intelligence Artifact and the second version of the Business Intelligence Artifact based at least partially on the comparison of the first Business Intelligence Artifact Output to the second Business Intelligence Artifact Output.

13. The method of claim 1 further comprising determining that one or more differences do not exist between the first version of the Business Intelligence Artifact and the second version of the Business Intelligence Artifact when each of the identified differences are included in the retrieved set of portions to ignore.

14. A method comprising:

retrieving a first instrumented Business Intelligence Artifact Output produced from an execution of a first version of a first Business Intelligence Artifact;

retrieving at least one first assertion associated with the first Business Intelligence Artifact, wherein one or more specification portions to ignore from the first version of the first Business Intelligence Artifact are associated with at least one of the first assertions;

retrieving a second version of the first Business Intelligence Artifact;

adjusting a specification of the second version of the first Business Intelligence Artifact to produce a second instrumented specification, wherein the second instrumented specification comprises one or more second specification markers to uniquely identify portions of the specification of the second version of the first Business Intelligence Artifact;

executing the second instrumented specification in the Business Intelligence Environment to produce a second instrumented Business Intelligence Artifact Output, wherein the second instrumented Business Intelligence Artifact Output comprises one or more associated output markers emitted by one or more of the second specification markers of the second instrumented specification;

comparing the second instrumented Business Intelligence Artifact Output to the first instrumented Business Intelligence Artifact Output such that output portions that are associated with the specification portions designated in one or more of the specification portions to ignore are restricted from being compared; and

generating an indication that at least one of the first assertions has failed if one or more differences are identified based on the comparison.

15. The method of claim 14 wherein retrieving the first instrumented Business Intelligence Artifact Output produced from the execution of the first version of the first Business Intelligence Artifact further comprises:

adjusting a specification of the first version of the first Business Intelligence Artifact to produce the first instrumented specification, wherein the first instrumented specification comprises one or more first specification markers to uniquely identify portions of the specification of the first version of the first Business Intelligence Artifact, and wherein one or more of the first specification markers are adapted to emit one or more associated output markers into a resultant Business Intelligence Artifact Output; and

executing the first instrumented specification in a Business Intelligence Environment to produce the first instrumented Business Intelligence Artifact Output, wherein the first instrumented Business Intelligence Artifact Output comprises one or more of the associated output markers emitted by one or more of the first specification markers of the first instrumented specification.

16. The method of claim 15 wherein adjusting the specification of the first version of the first Business Intelligence Artifact comprises instrumenting the specification of the first version of the first Business Intelligence Artifact such that one or more of the first specification markers are injected into the specification of the first version of the first Business Intelligence Artifact.

17. The method of claim 14 wherein adjusting the specification of the second version of the first BI Artifact comprises instrumenting the specification of the second version of the first Business Intelligence Artifact such that one or more of the second specification markers are injected into the specification of the second version of the first Business Intelligence Artifact.

18. The method of claim 14 wherein the first instrumented Business Intelligence Artifact Output is associated with at least one of the first assertions.

19. The method of claim 14 further comprising storing, in a memory, the first instrumented Business Intelligence Artifact Output and an association between the first instrumented Business Intelligence Artifact Output and the first version of the Business Intelligence Artifact, wherein the memory comprises a memory of a Supplemental system.

20. The method of claim 14 further comprising generating an indication that at least one of the first assertions has passed if one or more differences are not identified based on the comparison.