Build Schema

  • Article

The following diagram shows the relationships between the Build, Build Changeset, and Build Project fact tables and the related measures (dimensions) in the data warehouse.

Schema showing relationship among data elements

The Build schema references three fact tables:

  • Build Changeset fact table (dbo.Build Changeset)

  • Build Project fact table (dbo.Build Project)

  • Build Details fact table (dbo.Build Details)

The Build schema also references nine dimension tables:

  • Build dimension table (dbo.Build)

  • File dimension table (dbo.File)

  • Build Flavor dimension table (dbo.Build Flavor)

  • Build Status dimension table (dbo.Build Status)

  • Build Quality dimension table (dbo.Build Quality)

  • Changeset dimension table (dbo.Changeset)

  • Platform dimension table (dbo.Platform)

  • Team Project (dbo.Team Project) (see Shared Dimensions)

  • Date (dbo.Date) (see Shared Dimensions)

Build Changeset Fact Table

The following table describes the columns in the Build Changeset fact table. The table contains one row for each changeset included in the build.

Field Description

__ID

Record ID for the table (used internally).

__LastUpdatedTime

Date and time the record was last inserted or updated.

__TrackingId

Identifying number that is used by the warehouse infrastructure to track the record.

Build

Foreign key to the Build dimension table.

Changeset

Foreign key to the Changeset dimension table.

Team Project

Foreign key to the Team Project dimension table.

Build Project Fact Table

The following table describes the columns in the Build Project fact table. The table contains one row for each compilation of a file.

Field Description

__ID

Record ID for the table (used internally).

Compile Errors

Number of compile errors generated during the build.

Compile Warnings

Number of compile warnings generated during the build.

Static Analysis Errors

Number of static analysis errors generated during the build.

Static Analysis Warnings

Number of static analysis warnings generated during the build.

__LastUpdatedTime

Date and time the record was last inserted or updated.

__TrackingId

Identifying number that is used by the warehouse infrastructure to track the record.

Build

Foreign key to the Build dimension table.

Date

Foreign key to the Date dimension table.

Platfom

Foreign key to the Platform dimension table.

Flavor

Foreign key to the Build Flavor dimension table.

Source Project

Foreign key to the File dimension table.

Team Project

Foreign key to the Team Project dimension table.

Build Details Fact Table

The following table describes the columns in the Build Details fact table.

Field Description

__ID

Record ID for the table (used internally).

Logical Tracking ID

Identifying number that is used by the work item tracking warehouse adapter to determine how much work item history is already present in the warehouse.

Build Duration

Length of time, in minutes, to complete the build.

__LastUpdatedTime

Date and time the record was last inserted or updated.

__TrackingId

Identifying number that is used by the warehouse infrastructure to track the record.

Build

Foreign key to the Build dimension table.

Date

Foreign key to the Date dimension table.

Build Quality

Foreign key to the Build Quality dimension table.

Build Status

Foreign key to the Build Status dimension table.

Team Project

Foreign key to the Team Project dimension table.

Build Dimension Table

The following table describes the columns in the Build dimension table. The table contains one row for each team build.

Field Description

__ID

Record ID for the table (used internally).

Build Artifact Moniker

Identification number that is used to link an object, such as a work item, with a specific build.

Build

Number or name used to uniquely identify the build.

Build Type

Name of the build type set in the New Team Build Type Creation Wizard. For more information, see How to: Create a New Build Type.

Selected from the Team Builds node in Team Explorer. For more information, see How to: Run a Build on a Build Type.

Drop Location

The server and share where the completed build will be put.

Build Start Time

Date and time the build began.

__LastUpdatedTime

Date and time the record was last inserted or updated.

__DimensionMemberActive

Whether the dimension member has been fully populated (used internally).

File Dimension Table

The following table describes the columns in the File dimension table.

Field Description

__ID

Record ID for the table (used internally).

File

Name of the source file set in the New Team Build Type Creation Wizard. For more information, see How to: Create a New Build Type.

Parent Path

The full path of the parent node in the [area|iteration|file path] hierarchy. For example, if the data row represents the file “/a/b/c”, the parent path is “/a/b”.

File Path

Full network path of the location of the source file. Set in the New Team Build Type Creation Wizard. For more information, see How to: Create a New Build Type.

File Extension

Extension to the file name. Set in the New Team Build Type Creation Wizard. For more information, see How to: Create a New Build Type.

__Parent_ID

A reference to the key that contains information about this [area|iteration|file path] node in the hierarchy. For example, if the data row represents the file “/a/b/c,” the parent_ID will contain the key value of the row that contains “/a/b.”

__LastUpdatedTime

Date and time the record was last inserted or updated.

__DimensionMemberActive

Value describing whether the dimension member has been fully populated (used internally).

Build Flavor Dimension Table

The following table describes the columns in the Build Flavor dimension table.

Field Description

__ID

Record ID for the table (used internally).

Build Flavor

The configuration of the build. The possible values include the following:

  • Debug

  • Release

  • Any valid configuration created by the process template.

Set in the New Team Build Type Creation Wizard. For more information, see How to: Create a New Build Type.

__LastUpdatedTime

Date and time the record was last inserted or updated.

__DimensionMemberActive

Whether the dimension member has been fully populated (used internally).

Build Status Dimension Table

The following table describes the columns in the Build Status dimension table.

Field Description

__ID

Record ID for the table (used internally).

Build Status

The updated status as the build proceeds. The possible values are as follows:

  • Build Initializing

  • Getting Sources

  • Compilation Started

  • Compilation Completed

  • Testing Started

  • Testing Completed

  • Successfully Completed

  • Failed

  • Stopped

__LastUpdatedTime

Date and time the record was last inserted or updated.

__DimensionMemberActive

Value describing whether the dimension member has been fully populated (used internally).

Build Quality Dimension Table

The following table describes the columns in the Build Quality dimension table.

Field Description

__ID

Record ID for the table (used internally).

Build Quality

The current quality of the build. The possible values are controlled by the process template. Set manually by the user in the Build browser. For more information, see How to: Set Build Quality.

__LastUpdatedTime

Date and time the record was last inserted or updated.

__DimensionMemberActive

Whether the dimension member has been fully populated (used internally).

Changeset Dimension Table

The following table describes the columns in the Changeset dimension table.

Field Description

__ID

Record ID for the table (used internally).

Changeset ID

The Changeset ID which included the file changes.

Changeset

The check-in comment associated with the changeset.

__LastUpdatedTime

Date and time the record was last inserted or updated.

__DimensionMemberActive

Whether the dimension member has been fully populated (used internally).

Platform Dimension Table

The following table describes the columns in the Platform dimension table.

Field Description

__ID

Record ID for the table (used internally).

Platform

The platform for which the build was made. The possible values include the following:

  • X86

  • X64

  • Itanium

  • Win32

  • Any CPU

  • .NET

  • Mixed Platforms

  • Any valid platform created by the process template.

This is set in the New Team Build Type Creation Wizard. For more information, see How to: Create a New Build Type.

__LastUpdatedTime

Date and time the record was last inserted or updated.

__DimensionMemberActive

Whether the dimension member has been fully populated (used internally).

See Also

Concepts

Build Perspective

Other Resources

Relational Schemas