Build Schema

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 definition. For more information, see How to: Create a Build Definition.

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.

Parent Path

The full path of the parent node in the 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 source file.

File Extension

Extension of the name of the source file.

__Parent_ID

A reference to the key that contains information about this 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. For more information, see How to: Create a Build Definition.

__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.

__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. 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. For more information, see How to: Create a Build Definition.

__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