Caboodle chapter 1
caboodle - ANSData warehouse that combines epic and non epic data in a single unified
data model designed for efficient reporting. Dimensional database
Chronicles - ANSEpics hierarchical operational database written in M language.
Clarity - ANSEpics relational normalized database for analytical reporting
DMC. - ANSCollection of metadata tables , views, stored procedures and reporting table
make up a DMC
Dimension table - ANSProvides contexts to records in fact tables
Fact table - ANSTrack measurable events like medication orders
Bridge tables - ANSCapture many to many relationships between DMC's
Info DMC - ANSPerform specific metadata tasks like matching records
Datamart - ANSConsolidates information from other DMC's to support reporting.
Caboodle DMC primary key - ANSMatches name of DMC with"key" as the suffix. I.E. patient
key goes to patientdim
Mappingfact - ANSSimilar to bridge tables. Map many to many relationships
Setdim - ANSHas multiple values to a dimension
Eventfact tables - ANSTrack events by time
Caboodle console - ANSWeb based application for administrative tools are accessible
Caboodle dictionary - ANSMetadata information about caboodles reporting database
Dictionary editor - ANSInformation on packages, stored procs, ETL dependencies and
column info
Executions page - ANSMonitor and review executions
Work Queue - ANSPage with issues that arise during ETL that requires attention
Configuration page - ANSWhere to manage system settings, users and ETL parameters
caboodle - ANSData warehouse that combines epic and non epic data in a single unified
data model designed for efficient reporting. Dimensional database
Chronicles - ANSEpics hierarchical operational database written in M language.
Clarity - ANSEpics relational normalized database for analytical reporting
DMC. - ANSCollection of metadata tables , views, stored procedures and reporting table
make up a DMC
Dimension table - ANSProvides contexts to records in fact tables
Fact table - ANSTrack measurable events like medication orders
Bridge tables - ANSCapture many to many relationships between DMC's
Info DMC - ANSPerform specific metadata tasks like matching records
Datamart - ANSConsolidates information from other DMC's to support reporting.
Caboodle DMC primary key - ANSMatches name of DMC with"key" as the suffix. I.E. patient
key goes to patientdim
Mappingfact - ANSSimilar to bridge tables. Map many to many relationships
Setdim - ANSHas multiple values to a dimension
Eventfact tables - ANSTrack events by time
Caboodle console - ANSWeb based application for administrative tools are accessible
Caboodle dictionary - ANSMetadata information about caboodles reporting database
Dictionary editor - ANSInformation on packages, stored procs, ETL dependencies and
column info
Executions page - ANSMonitor and review executions
Work Queue - ANSPage with issues that arise during ETL that requires attention
Configuration page - ANSWhere to manage system settings, users and ETL parameters
