Target Table Star Schemas

Measure Tables

ChangeMgmt_Measure Table

The ChangeMgmt_Measure measure table contains metrics collected from ClearQuest.

Display Name

Description

Non-additive

Type

Reference Type

(Table it References)

Unique Key

Submitdate_fk

Reference

SubmitDate_Dim

State_fk

Reference

State_Dim

Severity_fk

Reference

Severity_Dim

Project_fk

Reference

Project_Dim

Owner_fk

Reference

Owner_Dim

Iteration_fk

Reference

Iteration_Dim

Collectiondate_fk

Reference

Collectiondate

Calendardate_fk

Reference

Calendardate

Coll_instance_log_id

String

Num Change Requests

Existence measure

Integer

ClearCase_Measure Table

Display Name

Description

Non-additive

Type

Reference Type

(Table it References)

Unique Key

Artifactname_fk

Reference

ArtifactName_Dim

Artifacttype_fk

Reference

ArtifactType_Dim

Branch_fk

Reference

Branch_Dim

Build_fk

Reference

Build_Dim

Calendardate_fk

Reference

Calendardate

Coll_instance_log_id

String

Collectiondate_fk

Reference

Collectiondate

Lines Changed

Integer

Lines Deleted

Integer

Lines Inserted

Integer

Num ClearCase Data

Existence measure

Integer

Operation_fk

Reference

Operation_Dim

Operationdate_fk

Reference

Operationdate

Project_fk

Reference

Project_Dim

User_fk

Reference

Owner_Dim

Version_fk

Reference

Version_Dim

Vob_fk

Reference

Vob_Dim

Coverage_Measure Table

Display Name

Description

Non-additive

Type

Reference Type

(Table it References)

Unique Key

Artifactname_fk

Reference

ArtifactName_Dim

Artifacttype_fk

Reference

ArtifactType_Dim

Build_fk

Reference

Build_Dim

Calendardate_fk

Reference

Calendardate

Coll_instance_log_id

String

Collectiondate_fk

Reference

Collectiondate

Functions Hit

Integer

Functions Missed

Integer

Lines Hit

Integer

Lines Missed

Integer

Num Coverage Data

Existence measure

Integer

Parentmodule_fk

Reference

ParentModule_Dim

Parentsource_fk

Reference

ParentSource_Dim

Project_fk

Reference

Project_Dim

Design_Measure Table

Display Name

Description

Non-additive

Type

Reference Type

(Table it References)

Unique Key

Abstract_fk

Reference

Abstract_Dim

Artifactname_fk

Reference

ArtifactName_Dim

Artifacttype_fk

Reference

ArtifactType_Dim

Build_fk

Reference

Build_Dim

Calendardate_fk

Reference

Calendardate

Coll_instance_log_id

String

Collectiondate_fk

Reference

Collectiondate

Concurrency_fk

Reference

Concurreny_Dim

Exportcontrol_fk

Reference

ExportControl_Dim

Global_fk

Reference

Global_Dim

Isucpkg_fk

Reference

IsUCPackage

Kind_fk

Reference

Kind_Dim

Num Design Item

Existence measure

Integer

Parentclass_fk

Reference

ParentClass_Dim

Parentpackage_fk

Reference

ParentPackage_Dim

Persistence_fk

Reference

Persistence_Dim

Project_fk

Reference

Project_Dim

Stereotype_fk

Reference

Stereotype_Dim

Feature_Req_Measure Table

Display Name

Description

Non-additive

Type

Reference Type

(Table it References)

Unique Key

Artifactname_fk

Reference

ArtifactName_Dim

Artifacttype_fk

Reference

ArtifactType_Dim

Calendardate_fk

Reference

Calendardate

Coll_instance_log_id

String

Collectiondate_fk

Reference

Collectiondate

Cost_fk

Reference

Cost_Dim

Difficulty_fk

Reference

Difficulty_Dim

Iteration

Reference

Iteration_Dim

Level_fk

Reference

Level_Dim

Num Feature Reqs

Existence measure

Integer

Owner_fk

Reference

Owner_Dim

Priority_fk

Reference

Prioirity_Dim

Project_fk

Reference

Project_Dim

Stability_fk

Reference

Stability_Dim

State_fk

Reference

State_Dim

Purify_Measure Table

Display Name

Description

Non-additive

Type

Reference Type

(Table it References)

Unique Key

Artifactname_fk

Reference

ArtifactName_Dim

Artifacttype_fk

Reference

ArtifactType_Dim

Build_fk

Reference

Build_Dim

Calendardate_fk

Reference

Calendardate

Coll_instance_log_id

String

Collectiondate_fk

Reference

Collectiondate

Description_fk

Reference

Description_Dim

Num Purify Data

Existence measure

Integer

Project_fk

Reference

Project_Dim

testCase_Measure Table

Display Name

Description

Non-additive

Type

Reference Type

(Table it References)

Unique Key

AcceptanceCriteria_fk

Reference

AcceptanceCriteria_fk

Calendardate_fk

Reference

Calendardate

Coll_instance_log_id

String

Collectiondate_fk

Reference

Collectiondate

configured_fk

Reference

Description_Dim

numTestCases

Existence measure

Integer

Owner_fk

Reference

Owner_Dim

Suspect_fk

Reference

Suspect_Dim

TestCaseName

Reference

TestCaseName_Dim

UseCase_Measure Table

Display Name

Description

Non-additive

Type

Reference Type

(Table it References)

Unique Key

Actualiteration_fk

Reference

ActualIteration_Dim

Artifactname_fk

Reference

ArtifactName_Dim

Artifacttype_fk

Reference

ArtifactType_Dim

Calendardate_fk

Reference

Calendardate

Coll_instance_log_id

String

Collectiondate_fk

Reference

Collectiondate

Cost_fk

Reference

Cost_Dim

Difficulty_fk

Reference

Difficulty_Dim

Iteration

Reference

Iteration_Dim

Level_fk

Reference

Level_Dim

Num Use Case

Existence measure

Integer

Owner_fk

Reference

Owner_Dim

Priority_fk

Reference

Priority_Dim

Project_fk

Reference

Project_Dim

Stability_fk

Reference

Stability_Dim

State_fk

Reference

State_Dim

Dimension Tables

Abstract_Dim Table

Display Name

Description

Non-additive

Type

Reference Type

(Table it References)

Unique Key

Abstract

String

Y

AcceptanceCriteria_Dim Table

Display Name

Description

Non-additive

Type

Reference Type

(Table it References)

Unique Key

AcceptanceCriteria

String

Y

ActualIteration_Dim Table

Display Name

Description

Non-additive

Type

Reference Type

(Table it References)

Unique Key

Actual Iteration

String

Y

ArtifactName_Dim Table

Display Name

Description

Non-additive

Type

Reference Type

(Table it References)

Unique Key

Artifact Name

String

Y

ArtifactType_Dim Table

Display Name

Description

Non-additive

Type

Reference Type

(Table it References)

Unique Key

Artifact Type

String

Y

Branch_Dim Table

Display Name

Description

Non-additive

Type

Reference Type

(Table it References)

Unique Key

Branch

String

Y

Build_Dim Table

Display Name

Description

Non-additive

Type

Reference Type

(Table it References)

Unique Key

Build

String

Y

Calendardate Table

Display Name

Description

Non-additive

Type

Reference Type

(Table it References)

Unique Key

Calendardate_daynum

Integer

Calendardate_dayofmonth

Integer

Calendardate_dayofyear

Integer

Calendardate_daystr

String

Calendardate_monthly

Integer

Calendardate_mthnum

Integer

Calendardate_mthofyear

Integer

Calendardate_mthstr

String

Calendardate_name

String

Y

Calendardate_qtrofyear

Integer

Calendardate_quarterly

Integer

Calendardate_quarternum

Integer

Calendardate_quarterstr

String

Calendardate_weekly

Integer

Calendardate_weeknum

Integer

Calendardate_weekofyear

Integer

Calendardate_weekstr

String

Calendardate_yearly

Integer

Calendardate_yearnum

Integer

Calendardate_yearstr

String

Collectiondate Table

Display Name

Description

Non-additive

Type

Reference Type

(Table it References)

Unique Key

Collectiondate_daynum

Integer

Collectiondate_dayofmonth

Integer

Collectiondate_dayofyear

Integer

Collectiondate_daystr

String

Collectiondate_monthly

Integer

Collectiondate_mthnum

Integer

Collectiondate_mthofyear

Integer

Collectiondate_mthstr

String

Collectiondate_name

String

Y

Collectiondate_qtrofyear

Integer

Collectiondate_quarterly

Integer

Collectiondate_quarternum

Integer

Collectiondate_quarterstr

String

Collectiondate_weekly

Integer

Collectiondate_weeknum

Integer

Collectiondate_weekofyear

Integer

Collectiondate_weekstr

String

Collectiondate_yearly

Integer

Collectiondate_yearnum

Integer

Collectiondate_yearstr

String

Concurrency_Dim Table

Display Name

Description

Non-additive

Type

Reference Type

(Table it References)

Unique Key

Concurrency

String

Y

Configured_Dim Table

Display Name

Description

Non-additive

Type

Reference Type

(Table it References)

Unique Key

Configured

String

Y

Cost_Dim Table

Display Name

Description

Non-additive

Type

Reference Type

(Table it References)

Unique Key

Cost

String

Y

Description_Dim Table

Display Name

Description

Non-additive

Type

Reference Type

(Table it References)

Unique Key

Description

String

Y

Difficulty_Dim Table

Display Name

Description

Non-additive

Type

Reference Type

(Table it References)

Unique Key

Difficulty

String

Y

ExportControl_Dim Table

Display Name

Description

Non-additive

Type

Reference Type

(Table it References)

Unique Key

ExportControl

String

Y

Global_Dim Table

Display Name

Description

Non-additive

Type

Reference Type

(Table it References)

Unique Key

Global

String

Y

IsUCPackage_Dim Table

Display Name

Description

Non-additive

Type

Reference Type

(Table it References)

Unique Key

Is Use Case Pkg

String

Y

Iteration_Dim Table

Display Name

Description

Non-additive

Type

Reference Type

(Table it References)

Unique Key

iteration

String

Y

Kind_Dim Table

Display Name

Description

Non-additive

Type

Reference Type

(Table it References)

Unique Key

Kind

String

Y

Level_Dim Table

Display Name

Description

Non-additive

Type

Reference Type

(Table it References)

Unique Key

Level

String

Y

Operation_Dim Table

Display Name

Description

Non-additive

Type

Reference Type

(Table it References)

Unique Key

Operation

String

Y

Operationdate Table

Display Name

Description

Non-additive

Type

Reference Type

(Table it References)

Unique Key

Operationdate_daynum

Integer

Operationdate_dayofmonth

Integer

Operationdate_dayofyear

Integer

Operationdate_daystr

String

Operationdate_monthly

Integer

Operationdate_mthnum

Integer

Operationdate_mthofyear

Integer

Operationdate_mthstr

String

Operationdate_name

String

Y

Operationdate_qtrofyear

Integer

Operationdate_quarterly

Integer

Operationdate_quarternum

Integer

Operationdate_quarterstr

String

Operationdate_weekly

Integer

Operationdate_weeknum

Integer

Operationdate_weekofyear

Integer

Operationdate_weekstr

String

Operationdate_yearly

Integer

Operationdate_yearnum

Integer

Operationdate_yearstr

String

Owner_Dim Table

Display Name

Description

Non-additive

Type

Reference Type

(Table it References)

Unique Key

Owner

String

Y

ParentClass_Dim Table

Display Name

Description

Non-additive

Type

Reference Type

(Table it References)

Unique Key

Parent Class

String

Y

ParentModule_Dim Table

Display Name

Description

Non-additive

Type

Reference Type

(Table it References)

Unique Key

Parent Module

String

Y

ParentPackage_Dim Table

Display Name

Description

Non-additive

Type

Reference Type

(Table it References)

Unique Key

Parent Package

String

Y

ParentSource_Dim Table

Display Name

Description

Non-additive

Type

Reference Type

(Table it References)

Unique Key

Parent Source

String

Y

Persistence_Dim Table

Display Name

Description

Non-additive

Type

Reference Type

(Table it References)

Unique Key

Persistence

String

Y

PlannedIteration_Dim Table

Display Name

Description

Non-additive

Type

Reference Type

(Table it References)

Unique Key

PlannedIteration

String

Y

Priority_Dim Table

Display Name

Description

Non-additive

Type

Reference Type

(Table it References)

Unique Key

Priority

String

Y

Project_Dim Table

Display Name

Description

Non-additive

Type

Reference Type

(Table it References)

Unique Key

Project

String

Y

Severity_Dim Table

..

Display Name

Description

Non-additive

Type

Reference Type

(Table it References)

Unique Key

Severity

String

Y

..

..

Stability_Dim Table

..

Display Name

Description

Non-additive

Type

Reference Type

(Table it References)

Unique Key

Stability

String

Y

..

..

State_Dim Table

..

Display Name

Description

Non-additive

Type

Reference Type

(Table it References)

Unique Key

State

String

Y

..

..

Stability_Dim Table

..

Display Name

Description

Non-additive

Type

Reference Type

(Table it References)

Unique Key

Stability

String

Y

..

..

State_Dim Table

..

Display Name

Description

Non-additive

Type

Reference Type

(Table it References)

Unique Key

State

String

Y

..

..

Stereotype_Dim Table

..

Display Name

Description

Non-additive

Type

Reference Type

(Table it References)

Unique Key

Stereotype

String

Y

..

..

Submitdate Table

. ..

Display Name

Description

Non-additive

Type

Reference Type

(Table it References)

Unique Key

Severity

String

Y

..

..

Suspect_Dim Table

..

Display Name

Description

Non-additive

Type

Reference Type

(Table it References)

Unique Key

Suspect

String

Y

..

..

testCaseName_Dim Table

..

Display Name

Description

Non-additive

Type

Reference Type

(Table it References)

Unique Key

testCaseName

String

Y

..

..

Version_Dim Table

..

Display Name

Description

Non-additive

Type

Reference Type

(Table it References)

Unique Key

Version

String

Y

..

..

Vob_Dim Table

..

Display Name

Description

Non-additive

Type

Reference Type

(Table it References)

Unique Key

Vob

String

Y

..

..

..