Method and apparatus for testing data warehouses

• US 8,930,763 B2
• Filed: 06/15/2012
• Issued: 01/06/2015
• Est. Priority Date: 06/15/2011
• Status: Active Grant

• Current Assignee: Agile Software Pty Ltd (Oracle Corporation)
• Original Assignee: Agile Software Pty Ltd (Oracle Corporation)
• Inventors: Funnell, Ian Clive
• Primary Examiner(s): GUYTON, PHILIP A
• Application Number:
  US13/524,814
• Publication Number:
  US 20120324289A1
• Time in Patent Office: 935 Days
• Field of Search: 714/32, 714/38.1, 717/124, 717/168
• US Class Current: 714/38.1
• CPC Class Codes: G06F 11/3688 for test execution, e.g. scheduling of test suites

Abstract

Disclosed is a method of qualifying a change to software modules in a data warehouse comprising a database storing a plurality of data sets and said plurality of warehouse software modules, the method comprising determining if a change has been made to any of the software modules; selecting the software modules which are affiliated with the change to construct a reduced schedule of software modules; identifying the tests which are affiliated with the change to thereby identify a reduced set of tests; executing the reduced schedule of warehouse software; running the reduced set of tests; and if no warehouse software execution errors arise and no warehouse test execution errors or failures arise, qualifying the change to the one or more software modules as a success.

Claims

1. A method of qualifying a change to one or more software modules in a plurality of software modules in a data warehouse, said data warehouse comprising a database storing a plurality of data sets and said plurality of warehouse software modules, wherein prior to effecting the change to the one or more software modules, test data has been loaded into the data warehouse, a complete schedule of the plurality of software modules has been executed to populate the data sets from the loaded test data, and a complete set of warehouse tests has been run, and found to pass, in regard to the populated data sets, the method comprising the steps of:

determining if a change has been made to any of the plurality of software modules;

selecting from the plurality of software modules the software modules which are affiliated with the change to thereby construct a reduced schedule of software modules;

identifying from the complete set of warehouse tests the tests which are affiliated with the change to thereby identify a reduced set of tests;

executing the reduced schedule of warehouse software whilst continuing to respect an order of the software modules in the complete schedule;

running the reduced set of tests; and

if no warehouse software execution errors arise from execution of the reduced schedule of warehouse software, and no warehouse test execution errors or failures arise from execution of the reduced set of tests, qualifying the change to the one or more software modules as a success, or otherwise as a failure;

wherein the step of determining if a change has been made comprises periodically checking contents of a data set in the database, said data set containing metadata about software promotion of a change software module.

2. A method according to claim 1, wherein the step of constructing the reduced schedule of software modules comprises one or more of scanning source code of the software modules held in the database, and querying metadata from a software development tool if one is in use in effecting the change to thereby construct the reduced schedule of software modules.

3. A method according to claim 1, wherein the step of constructing the reduced schedule of software modules comprises the steps of:

(a) scanning source code of the changed software modules to identify names of data sets;

(b) determining, for each data set identified in the changed software modules, names of immediate parent data sets;

(c) determining, for each data set identified in the changed software modules, names of children at any depth;

(d) determine, for the data sets identified in the steps (a)-(c), software modules that populate the identified data sets;

(e) determining, for each software module in the plurality of software modules, a list of parent software modules which must precede said each software module in a desired order of execution;

(f) removing software modules that do not involve data sets identified in the steps (a)-(c);

(g) for each software module removed by the step (f), making the children of the removed software module depend upon the parent software modules of the software module being removed; and

making those parent software modules the parents of the children of the software module being removed.

4. A method according to claim 3, wherein the step of identifying from the complete set of warehouse tests the tests which are affiliated with the change comprises scanning SQL text of all tests in the complete set of tests, to thereby identify tests which involve data sets identified by the steps (a)-(c).

5. An apparatus for qualifying a change to one or more software modules in a data warehouse, said data warehouse comprising a database storing a plurality of data sets and said plurality of warehouse software modules, wherein prior to effecting the change to the one or more software modules, test data has been loaded into the data warehouse, a complete schedule of the plurality of software modules has been executed to populate the data sets from the loaded test data, and a complete set of warehouse tests has been run, and found to pass, in regard to the populated data sets, said apparatus comprising:

a processor; and

a computer readable storage device containing a program for directing the processor to execute a method comprising the steps of;

determining if a change has been made to any of the plurality of software modules;

selecting from the plurality of software modules the software modules which are affiliated with the change to thereby construct a reduced schedule of software modules;

identifying from the complete set of warehouse tests the tests which are affiliated with the change to thereby identify a reduced set of tests;

executing the reduced schedule of warehouse software whilst continuing to respect an order of the software modules in the complete schedule;

running the reduced set of tests; and

if no warehouse software execution errors arise from execution of the reduced schedule of warehouse software, and no warehouse test execution errors or failures arise from execution of the reduced set of tests, qualifying the change to the one or more software modules as a success, or otherwise as a failure;

wherein the step of determining if a change has been made comprises periodically checking contents of a data set in the database, said data set containing metadata about software promotion of a change software module.

6. A non-transitory computer readable data storage medium containing a program for directing a processor to execute a method of qualifying a change to one or more software modules in a plurality of software modules in a data warehouse, said data warehouse comprising a database storing a plurality of data sets and said plurality of warehouse software modules, wherein prior to effecting the change to the one or more software modules, test data has been loaded into the data warehouse, a complete schedule of the plurality of software modules has been executed to populate the data sets from the loaded test data, and a complete set of warehouse tests has been run, and found to pass, in regard to the populated data sets, the method comprising the steps of:

determining if a change has been made to any of the plurality of software modules;

selecting from the plurality of software modules the software modules which are affiliated with the change to thereby construct a reduced schedule of software modules;

identifying from the complete set of warehouse tests the tests which are affiliated with the change to thereby identify a reduced set of tests;

executing the reduced schedule of warehouse software whilst continuing to respect an order of the software modules in the complete schedule;

running the reduced set of tests; and

if no warehouse software execution errors arise from execution of the reduced schedule of warehouse software, and no warehouse test execution errors or failures arise from execution of the reduced set of tests, qualifying the change to the one or more software modules as a success, or otherwise as a failure;

wherein the step of determining if a change has been made comprises periodically checking contents of a data set in the database, said data set containing metadata about software promotion of a change software module.

7. A non-transitory computer readable data storage medium containing a program for directing a processor to execute a method of qualifying a change to one or more software modules in a plurality of software modules in a data warehouse, said data warehouse comprising a database storing a plurality of data sets and said plurality of warehouse software modules, wherein prior to effecting the change to the one or more software modules, test data has been loaded into the data warehouse, a complete schedule of the plurality of software modules has been executed to populate the data sets from the loaded test data, and a complete set of warehouse tests has been run, and found to pass, in regard to the populated data sets, the program comprising:

computer program code for determining if a change has been made to any of the plurality of software modules;

computer program code for selecting from the plurality of software modules the software modules which are affiliated with the change to thereby construct a reduced schedule of software modules;

computer program code for identifying from the complete set of warehouse tests the tests which are affiliated with the change to thereby identify a reduced set of tests;

computer program code for executing the reduced schedule of warehouse software whilst continuing to respect an order of the software modules in the complete schedule;

computer program code for running the reduced set of tests; and

computer program code for, if no warehouse software execution errors arise from execution of the reduced schedule of warehouse software, and no warehouse test execution errors or failures arise from execution of the reduced set of tests, qualifying the change to the one or more software modules as a success, or otherwise as a failure;

wherein the computer program code for determining if a change has been made comprises computer program code for periodically checking contents of a data set in the database, said data set containing metadata about software promotion of a change software module.