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.

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