Data warehousing for biomedical informatics. (2015)

• Record Type: Book
• Further Information: Note: Richard E. Biehl.
• Authors: Biehl, Richard E
• Contents: Biomedical Data Warehousing; Nature of Biomedical Data; Nature of Warehoused Data; Business Requirements; Functional Requirements; Never-Finished Warehouse; Organizational Readiness; Implementation Strategy; ; SECTION I ALPHA VERSION; ; Dimensional Data Modeling; Evolution of Data Warehouses; The Star Schema; Transposing Dimensional Schema; Anticipating Dimensions; Affinity Analysis; ; Understanding Source Data; Implicit versus Explicit Data; Semantic Layers; Information Artifacts; Biomedical Context; Clinical Picture; Ontological Levels; Epistemological Levels; Conclusions; ; Biomedical Warehouse; Biomedical Star; Biomedical Facts; Master Dimensions; Reference Dimensions; Almanac Dimensions; Analysis Dimensions; Control Dimensions; Requirements Alignment; ; Star Dimension Design Pattern; Structure of a Dimension; Master Data: Definition Tables; Slowly Changing Dimensions; Source Keys: Context and Reference Tables; Fact Participation: Group and Bridge Tables; Interconnections: Hierarchy Tables; Connecting to Facts; Dimension Navigation; ; Loading Alpha Version; Throw-Away Code; Selecting and Preparing Sources; Generating Surrogate Keys; Simple Dimensions and Facts; Recap of Simple ETLs; Complicated Dimensions and Facts; Finalizing Alpha Structures; V&V of Alpha Version; ; SECTION II BETA VERSION; ; Completing the Design; Unit of Measure; Metadata Mappings; Control Dimensions; Reinitializing the Warehouse; ; Data Sourcing; Source Mapping Challenges; Dimensionalizing Facts; Sourcing Your Data; ; Generalizing ETL Workflows; Standardizing Source Data; Source Data Intake Jobs; SDI Design Pattern; Source Data Consolidation; External versus Internal Sourcing; Single Point of Function; ETL "Pipes"; Metadata Transformation; Data Control Pipe; Wide versus Deep Data; ; ETL Reference Pipe; Metadata Transformation; Reference Composite; Resolve References; Unresolved References; Reference Entries; Alias Entries; Bridges and Groups; Hierarchy Entries; Fiat Hierarchies; Natural Hierarchies; ; ETL Definition Pipe; Processing Complexities; Example Master Loads; Insert New Definitions; New Orphans; Orphan Auto-Adoption; Definition Change Processing; Building SCD Transaction Sets; Applying Transactions to Dimensions; Performance Concerns; ; ETL Fact Pipe; Metadata Transformation; Bridges and Groups; Build Facts; Finalize Dimensions; Set Control Dimensions; Insert Fact Values; Superseding Facts; ; Finalizing Beta; Audit Trail Facts; Datafeed Dimension; Verification and Validation; Preparing for Gamma; ; SECTION III GAMMA VERSION; ; Finalizing ETL Workflows; Alternatively Sourced Keys; Sourced Metadata; Standard Data Editing; Value-Level UOM; Undetermined Dimensionality; ETL Transactions; Target States; Superseded Facts; Continuous Functional Evolution; ; Establishing Data Controls; Finalizing Warehouse Design; Redaction Control Settings; Data Monitoring; Surrogate Merges; Security Controls; Implementing Dataset Controls; Warehouse Support Team; ; Building out the Data; Minimize Data Seams; Shifting toward Metrics; Populating Metric Values; Populating Control Values; Populating Displays; ; Delivering Data; Warehousing Use Cases; Privacy-Oriented Usage Profiles; Metadata Browsing; Cohort Identification; Fact Count Queries; Timeline Generation; Business Intelligence; Alternative Data Views; ; Finalizing Gamma; Business Requirements; Technical Challenges; Functional Challenges; Going Live; ; SECTION IV RELEASE 1.0; ; Knowledge Synthesis; Fact Counts; Derivative Data; Timeline Analysis; Statistical Analyses; Statistical Process Control; Semantic Annotation; ; Data Governance; Organizing for Governance; Governance Opportunities; Index;
• Edition: 1st
• Publisher Details: Boca Raton : Auerbach
• Publication Date: 2015
• Extent: 1 online resource, illustrations (black and white)
• Subjects: 610.2855745; Medical informatics; Data warehousing
• Languages: English
• ISBNs: 9781482215229
• Related ISBNs: 9781482215212
• Notes: Note: Description based on CIP data; item not viewed.
• Access Rights: Legal Deposit; Only available on premises controlled by the deposit library and to one user at any one time; The Legal Deposit Libraries (Non-Print Works) Regulations (UK).
• Access Usage: Restricted: Printing from this resource is governed by The Legal Deposit Libraries (Non-Print Works) Regulations (UK) and UK copyright law currently in force.