Caboodle Data Model Study Set
_IsInferred Column - ANS-Identifies rows that are inferred. 5-19
\AttributeDim - ANS-The table that stores the list of all attributes used by the
AttributeValueDim system in Caboodle is called AttributeDim. It has one row per attribute
and contains the name of the attribute ﴾as well as some additional metadata﴿. 6-6
\AttributeValueDims - ANS-DMC, these tables contain attribute‐value pairs and can be
created for different entities. 6-6
\Bridge Tables - ANS-Capture many-to-many relationships. Every bridge table has two
columns. They are called <Name>ComboKey and <Name>Key, which is the name of the
table to which a bridge has been formed. The Key column can be used as a lookup column
to link to the corresponding dimension table. The ComboKey column is a surrogate key that
represents a unique combination of Key values. 6-4
\Bridge Tables in FullAccess Schema - ANS-In the FullAccess schema, bridge tables are
combined with the dimension they link out to in a view that has the same name as the bridge
table. For example, FullAccess.DiagnosisBridge contains the name of the diagnosis, even
though the name is stored in dbo.DiagnosisDim. 6-4
\Caboodle - ANS-A data warehouse, designed to store Epic and non-Epic data. 2-4
\Caboodle Dictionary - ANS-Part of the Cogito Dictionary in Hyperspace integrated into the
Analytics Catalog. Used to research Caboodle database objects. 3-4
\Caboodle table naming conventions - ANS-Dim for dimensions, Fact for facts, Bridge for
bridges, DataMart for data marts, AtributeValueDim for EAV tables, <suffix>X for custom
tables. 2-10
\Change Tracking - ANS-Change tracking is a property of a table that informs us how
Caboodle will be updated when changes are made to the source databases. In Caboodle,
there are two types of change tracking that are possible. 4-4
\Data Mart - ANS-Data marts typically serve as comprehensive data sources for a particular
reporting need, making it easier for business intelligence developers to write particular
reports. 6-9
\dbo schema - ANS-Data source for SlicerDicer. 2-6
\Durable Key - ANS-Snapshot tables have a durable key column which stores the same
value for all rows that correspond to the same entity. This allows for accurate grouping and
summarizing. Used when aggregating data. 4-11
\ER Diagram - ANS-This section in the dictionary will be available for Facts and DataMarts.
Built in a star schema format with investigated table in the middle. 3-6
\ETL process for Caboodle - ANS-Caboodle receives data from Clarity (Epic Data) and from
other databases (non-Epic data). 2-5
\Explain the relationship between the dbo and FullAccess schemas. - ANS-The Cogito
Dictionary reflects the dbo schema. The FullAccess schema contains almost everything in
the dbo schema (minus a few metadata columns) plus additional columns in some tables.
Since FullAccess has more data, report writers should use it when writing queries. However,
report writers should also be familiar with dbo due to its relationship with the Cogito
Dictionary. 2-15
\FullAccess schema - ANS-contains everything for report writers from the dbo schema and
more. 2-6
_IsInferred Column - ANS-Identifies rows that are inferred. 5-19
\AttributeDim - ANS-The table that stores the list of all attributes used by the
AttributeValueDim system in Caboodle is called AttributeDim. It has one row per attribute
and contains the name of the attribute ﴾as well as some additional metadata﴿. 6-6
\AttributeValueDims - ANS-DMC, these tables contain attribute‐value pairs and can be
created for different entities. 6-6
\Bridge Tables - ANS-Capture many-to-many relationships. Every bridge table has two
columns. They are called <Name>ComboKey and <Name>Key, which is the name of the
table to which a bridge has been formed. The Key column can be used as a lookup column
to link to the corresponding dimension table. The ComboKey column is a surrogate key that
represents a unique combination of Key values. 6-4
\Bridge Tables in FullAccess Schema - ANS-In the FullAccess schema, bridge tables are
combined with the dimension they link out to in a view that has the same name as the bridge
table. For example, FullAccess.DiagnosisBridge contains the name of the diagnosis, even
though the name is stored in dbo.DiagnosisDim. 6-4
\Caboodle - ANS-A data warehouse, designed to store Epic and non-Epic data. 2-4
\Caboodle Dictionary - ANS-Part of the Cogito Dictionary in Hyperspace integrated into the
Analytics Catalog. Used to research Caboodle database objects. 3-4
\Caboodle table naming conventions - ANS-Dim for dimensions, Fact for facts, Bridge for
bridges, DataMart for data marts, AtributeValueDim for EAV tables, <suffix>X for custom
tables. 2-10
\Change Tracking - ANS-Change tracking is a property of a table that informs us how
Caboodle will be updated when changes are made to the source databases. In Caboodle,
there are two types of change tracking that are possible. 4-4
\Data Mart - ANS-Data marts typically serve as comprehensive data sources for a particular
reporting need, making it easier for business intelligence developers to write particular
reports. 6-9
\dbo schema - ANS-Data source for SlicerDicer. 2-6
\Durable Key - ANS-Snapshot tables have a durable key column which stores the same
value for all rows that correspond to the same entity. This allows for accurate grouping and
summarizing. Used when aggregating data. 4-11
\ER Diagram - ANS-This section in the dictionary will be available for Facts and DataMarts.
Built in a star schema format with investigated table in the middle. 3-6
\ETL process for Caboodle - ANS-Caboodle receives data from Clarity (Epic Data) and from
other databases (non-Epic data). 2-5
\Explain the relationship between the dbo and FullAccess schemas. - ANS-The Cogito
Dictionary reflects the dbo schema. The FullAccess schema contains almost everything in
the dbo schema (minus a few metadata columns) plus additional columns in some tables.
Since FullAccess has more data, report writers should use it when writing queries. However,
report writers should also be familiar with dbo due to its relationship with the Cogito
Dictionary. 2-15
\FullAccess schema - ANS-contains everything for report writers from the dbo schema and
more. 2-6
