Beyond Facts and Dimensions Flashcards
What two columns do all bridge tables have?
Every bridge table has a ComboKey to which other tables join and a lookup column used to join to its associated dimension table.
Why might a BID choose to use a data mart table when writing a report?
Data mart tables are designed for specific reporting topics. If a report was about opioid orders, the OpioidOrderDataMart consolidates much of the information necessary for a report.
What is found in a -SetDim table in Caboodle?
SetDim tables contain groupers from Chronicles or other sources. Groupers are records from a master file grouped together. Groups of departments can be found in DepartmentSetDim. Groups of immunizations can be found in ImmunizationSetDim.
is used to capture many-to-many relationships between entities in a database. It typically contains two columns:
* ComboKey
* Key
bridge table
is a specialized subset of a data warehouse designed to serve a specific reporting need. It brings together data points from several Data Model Components (DMCs) into one place, making it easier for business intelligence developers to write reports.
data mart
a dimension table that stores lists or sets of records. These sets are typically records in another dimension table.
SetDim table
Lists of Chronicles records, ICD codes, or other concepts used frequently in Hyperspace
VCG Groupers
What is the difference between a MappingFact table and a Bridge table?
Both bridge tables and MappingFact tables are used to map many-to-many relationships. However, Bridge tables use a combo key as part of their definition and always link to a single dimension table while MappingFact tables may link to one or more fact or dimension tables.
True or False: Bridge tables in Caboodle are used to capture one-to-many relationships.
False. Explanation: Bridge tables are used to capture many-to-many relationships, such as the relationship between patients and their diagnoses.
True or False: 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.
True. Explanation: In the FullAccess schema, bridge tables are combined with the dimension they link out to, making it easier to access related data.
True or False: Data marts in Caboodle are used to store historical data for specific reporting needs.
False. Explanation: Data marts bring together data points from several DMCs into one place to serve as comprehensive data sources for specific reporting needs, but they are not specifically for storing historical data.
True or False: SetDim tables in Caboodle store lists or sets of records, often representing groupings of dimension records.
True. Explanation: SetDim tables store lists or sets of records, such as groups of diagnoses or locations, and are used to facilitate reporting.
True or False: The Entity-Attribute-Value (EAV) data structure is used in Caboodle when the attributes being tracked change frequently.
True. Explanation: The EAV model is used when the attributes being tracked change frequently, allowing for a flexible data structure.
True or False: AttributeValueDim tables in Caboodle are typically snapshot tables.
True or False: AttributeValueDim tables in Caboodle are typically snapshot tables.
True or False: The AttributeDim table in Caboodle stores the list of all attributes used by the AttributeValueDim system.
True. Explanation: AttributeDim contains one row per attribute and includes the name and metadata for each attribute used in the AttributeValueDim system.
True or False: Data marts in Caboodle are populated with queries that are easy for report writers to understand and modify.
False. Explanation: Data marts are populated with stored procedures that often contain complex logic, making them less straightforward for report writers to understand and modify.
True or False: The ValueSetEpicId column in SetDim tables is used to store the ID of the VCG grouper from Chronicles.
True. Explanation: The ValueSetEpicId column stores the ID of the VCG grouper, which is used to group sets of dimension records together.
True or False: FlowsheetValueFact and LabComponentResultFact in Caboodle use the EAV model to store their data.
True. Explanation: Both FlowsheetValueFact and LabComponentResultFact use the EAV model to store their data, with attributes stored in separate dimensions.
What is the primary purpose of bridge tables in Caboodle?
A) To store historical data
B) To capture many-to-many relationships
C) To represent deleted entities
D) To track changes over time
B) To capture many-to-many relationships
Which of the following is true about the Entity-Attribute-Value (EAV) data structure in Caboodle?
A) It is used to store lists of records
B) It is used when the attributes being tracked change frequently
C) It is used to capture many-to-many relationships
D) It is used to store historical data
B) It is used when the attributes being tracked change frequently
What is the purpose of SetDim tables in Caboodle?
A) To store lists or sets of records
B) To capture many-to-many relationships
C) To store historical data
D) To represent deleted entities
A) To store lists or sets of records
Which column in a bridge table represents an observed unique combination of key values?
A) Key
B) ComboKey
C) DimKey
D) FactKey
B) ComboKey
What is the primary function of data marts in Caboodle?
A) To store historical data
B) To bring together data points from several DMCs for specific reporting needs
C) To capture many-to-many relationships
D) To store lists or sets of records
B) To bring together data points from several DMCs for specific reporting needs
Which table stores the list of all attributes used by the AttributeValueDim system in Caboodle?
A) AttributeValueDim
B) AttributeDim
C) SetDim
D) DataMart
B) AttributeDim
What type of data structure is used in Caboodle when the collection of data points being tracked changes frequently?
A) Fact table
B) Dimension table
C) Bridge table
D) Entity-Attribute-Value (EAV) model
D) Entity-Attribute-Value (EAV) model
Which of the following is NOT a characteristic of SetDim tables in Caboodle?
A) They store lists or sets of records
B) They capture many-to-many relationships
C) They include a key back to the dimension record included in the grouper
D) They are used to facilitate reporting
B) They capture many-to-many relationships
What is the granularity of the HospitalAdmissionAttributedProviderDataMart table?
A) One row per hospital admission
B) One row per provider-hospital admission association
C) One row per patient
D) One row per diagnosis
B) One row per provider-hospital admission association
Which of the following tables in Caboodle uses the EAV model to store data?
A) DiagnosisDim
B) EncounterFact
C) FlowsheetValueFact
D) DepartmentDim
C) FlowsheetValueFact
What are the primary data sources for a data mart?
registries or caboodle tables
Data marts that are using Caboodle data (non-registry data marts) are not populated with a query, but are instead populated with…what?
with a stored procedure which pulls together the Caboodle data for ease of reporting. The stored procedures often have more complex logic that would not assist a report writer in researching the data.
where do registry data marts extract data?
the Chronicles registry framework
True or False: most registry data marts are extracted to Caboodle?
False. Chronicles registry data is extracted to Clarity, most registry data mart tables are not extracted to Caboodle by default, but a Caboodle Developer can set them up. Registries set up for extraction in this way will end in -RegistryDataMartX.
What do SetDim tables store?
lists, or sets, of records.
True or False: SetDim sets are typically records in another dimension table
True. For example, each diagnosis has a row in DiagnosisDim. These diagnoses are grouped into lists, which are stored in DiagnosisSetDim. Different locations are stored in DepartmentSetDim.
What master file stores groups?
VGC which are lists of Chronicles records, ICD codes, or other concepts used together frequently in Hyperspace. VCG groupers are extracted to the SetDim tables and include a key back to the dimension record included in the grouper.
What is the most common use of SetDim tbales?
VCG
True or False: SmartData is an example of an EAV (entity-attribute-value)
True
True or False: AttributeValueDim tables are typically snapshot tables
True
