主权项 |
1. A testing and extract, transform and load (TETL) system for managing test data generated by test platforms operable to test hardware or software components of information technology systems, the TETL system comprising:
a communications server including a network interface to receive system under test (SUT) test data instances for each SUT tested by the test platforms; a database server including at least one storage device to store the SUT test data instances in intermediate tables, wherein the test data instances are for a plurality of projects in a plurality of domains, and the domains include a plurality of entities; an analytics server including at least one hardware processor to: determine project schemas for SUTs tested by the test platforms; determine fields from each project schema common to all the project schemas; create a common view of the test data instances from the fields determined to be common to all project schemas; determine fields from each project schema that are not common to all the project schemas; and create a master view with all the fields from the common view and the fields determined not to be common to all the project schemas, wherein the database server is to load data from the intermediate tables for the master view into target tables in a data warehouse, wherein the target tables include fields corresponding to the master view and comprising fields identifying projects, domains and entities, and fields for measured test data determined by the test platforms. |