Udostępnij za pośrednictwem


Relational Schemas

You can use the relational schemas to better understand the way in which fact tables and dimension tables relate to one another in the Team Foundation data cube.

In This Section

  • Build Schema
    Describes the relationships between the three Build fact tables and the related measures (dimensions) in the data warehouse.

  • Code Coverage Schema
    Describes the relationships between the Run Coverage and Build Coverage fact tables and the related measures (dimensions) in the data warehouse

  • Load Testing Schema
    Describes the relationships between the five Load Test fact tables and the related measures (dimensions) in the data warehouse.

  • Source Control Schema
    Describes the relationships between the Code Churn fact table and the related measures (dimensions) in the data warehouse.

  • Test Results Schema
    Describes the relationships between the Test Result fact table and the related measures (dimensions) in the data warehouse.

  • Work Items Schema
    Describes the relationships between the three Work Item fact tables and the related measures (dimensions) in the data warehouse.

External Resources

Working with the Cube Schema

See Also

Other Resources

Understanding the Structure of the Data Warehouse Cube