1 Introducing Oracle Healthcare Data Model

This chapter introduces the Oracle Healthcare Data Model, which is a standards-based, pre-built approach to healthcare data warehousing.

This chapter includes the following sections:

• What is the Oracle Healthcare Data Model?

• What Are the Benefits of Using the Oracle Healthcare Data Model?

• What Are the Components of the Oracle Healthcare Data Model?

• Oracle Products That Make Up the Oracle Healthcare Data Model

What is the Oracle Healthcare Data Model?

The Oracle Healthcare Data Model provides an integrated view of enterprise-wide clinical and operational healthcare data that is optimized for healthcare business intelligence. This model consists of a logical and physical data model that is designed and pre-tuned for Oracle data warehouses, including the Oracle Exadata Database Machine.

This model was specified and designed through the use of innovative techniques in requirements specification using multiple cross-domain experts in healthcare, software development, and data warehousing as sources of requirements. Additionally, the Key Performance Indicators (KPIs) widely used by healthcare organizations for quality reporting were a significant source of requirements for the model to ensure that the quality reporting needs would be supported by this model. KPI authoring organizations that were used as a source of requirements include but are not limited to the Centers for Medicare and Medicaid Services (CMS), the American Heart Association Get with the Guidelines (AHA GWTG), the Healthcare Financial Management Association (HFMA), and the National Quality Forum (NQF).

By leveraging Oracle's strong healthcare domain expertise, the Oracle Healthcare Data Model provides an industry standard-compliant foundation schema that is modern, relevant, topical, and addresses the needs of most healthcare segments. This normalized foundation provides an integrated base for business information with fully defined entities and relationships. You can take advantage of pre-built and pre-tested solution sets designed by industry experts that deliver relevant insights, are actionable, and aimed at improving both top-line and bottom-line results. The Oracle Healthcare Data Model, combined with Oracle technology, provides all of the components required for a complete and extendable Healthcare Data Model that is designed to reduce complex and costly integration requirements and your total cost of ownership.

With the Oracle Healthcare Data Model you can jump-start the design and implementation of a healthcare data warehouse to quickly achieve a positive return on investment for your data-warehousing project, with a predictable implementation effort.The Oracle Healthcare Data Model offers a single-vendor solution package providing industry-specific metrics and insights that you can act on immediately to improve your bottom line. The Oracle Healthcare Data Model solution takes advantage of Oracle's scalability and reliability, using Oracle's familiar optimization, parallelism, and performance engineering within the database. The Oracle Healthcare Data Model can be used in any application environment and is easily extendable.The Oracle Healthcare Data Model offers a single-vendor solution package that is tightly integrated with the business intelligence platform. With pre-built data mining, Oracle Online Analytical Processing (Oracle OLAP) and dimensional models, the Oracle Healthcare Data Model provides the ability to gain insight across the enterprise. The Oracle Healthcare Data Model provides a single source of truth across the healthcare enterprise analytic applications. These business intelligence solution offerings take advantage of Oracle's scalability and reliability, using Oracle's familiar optimization, parallelism, and performance engineering within the database. The Oracle Healthcare Data Model consists of a logical and physical data model that is designed and pre-tuned for Oracle data warehouses, including the Oracle Exadata Database Machine.The Oracle Healthcare Data Model can be used in any application environment and is easily extendable.

The Oracle Healthcare Data Model includes a sample set of embedded advanced analytics, using Oracle's OLAP and data mining technology. You can see summarized, aggregated information or quickly navigate to drill-down transaction details to better understand issues.

The Oracle Enterprise Healthcare Analytics suite of products including the Oracle Healthcare Data Model, provides a warehousing platform for the development of custom Business Intelligence, analytics, data mining, and performance management applications that facilitates data acquisition, cleansing, integration and transformation of data. The Enterprise Healthcare Analytics suite of products also includes a core set of analytic applications.

For example, the Oracle Healthcare Data Model sample reports demonstrate how you can generate reports to support multiple analytic initiatives in your healthcare organization.

The Oracle Healthcare Data Model supports the following subject areas in healthcare organizations:

• Common Infrastructure, including: Party, Facility - Care Site, Encounter.

• Clinical Core, including: Concern, Observation, Intervention, Order, Patient History, Consent, Advance Directive, Specimen

• Financial and Billing, including: Accounting and Financial, Property and Equipment, HR and Payroll, Master Catalog, Purchasing, Accounts Payable, Inventory, Supply Chain, Health Plan, Contract, and Claims.

The Oracle Healthcare Data Model is engineered specifically for providers to lower Data Warehouse and Analytics development costs, time, and risk. The Oracle Healthcare Data Model includes:

• Support for enterprise-grade software and hardware tools from the world's leading enterprise software vendor.

• A well organized 3rd Normal Form Data Warehouse model that makes it easy for analytic application developers.

• Facilitates data capture, cleansing, and integration.

• Enables rapid deployment of pre-built applications from Oracle and our partner ecosystem.

• Sample pre-built Analytical Model (built using Oracle OLAP and Oracle Data Mining technologies) supporting an initial set of KPIs pertaining to the Clinical Core subject area.

• Is extensible and scalable.

What Are the Benefits of Using the Oracle Healthcare Data Model?

With the Oracle Healthcare Data Model, you can jump-start the design and implementation of a healthcare data warehouse to quickly achieve a positive return on investment for your data warehousing and business intelligence project with a predictable implementation effort.

The Oracle Healthcare Data Model provides the following features:

• Query and Reporting for information: provides extraction of detailed and summary data.

• OLAP for data analysis: provides summaries, trends, and forecasts.

• Data Mining for insight and prediction: provides knowledge discovery of hidden patterns and insights.

The Oracle Healthcare Data Model provides a data warehouse framework that is both adaptable and extendable. The pre-built, pretuned data model allows you to quickly gain value from your data warehousing effort. The Oracle Healthcare Data Model supports diverse analytic requirements and assists in building future analytic applications to provide you with opportunities for insight into detailed healthcare data. Fast, easy and predictable implementation reduces risks and enables you to achieve strategic value more rapidly by eliminating deployment delays and expenses associated with built-from-scratch or proprietary data warehouse solutions.

By leveraging Oracle's strong healthcare domain expertise, the Oracle Healthcare Data Model provides a foundation schema that is modern, relevant, topical, and addresses the needs of most healthcare segments. This normalized foundation provides an integrated base for business information with fully defined entities, attributes, and relationships. You can take advantage of pre-built and pre-tested solution sets designed by industry experts that deliver relevant insights, are actionable, and are aimed at improving care quality and organizational efficiencies, and reducing costs of care and care delivery. The Oracle Healthcare Data Model, combined with Oracle technology, provides all of the components required for a complete and extendable data model that is designed to reduce complex and costly integration requirements and to reduce your total cost of ownership.

What Are the Components of the Oracle Healthcare Data Model?

The Oracle Healthcare Data Model includes the following components:

• Logical Data Model Foundation

  Chapter 2, "Logical Data Model Foundation" describes the logical data model. This provides 3rd Normal Form (3NF) Logical Data Model.

• Logical Model Dimensions

  Chapter 3, "Logical Data Model Dimensions" describes the logical data model dimensions.

• Physical Model

  Chapter 4, "Oracle Healthcare Data Model Physical Data Model" describes the physical data model. The logical to physical mapping is detailed in Chapter 5, "Oracle Healthcare Data Model Logical to Physical Mapping". The physical data model partitions are described in Chapter 6, "Oracle Healthcare Data Model Partitions and Indexes"

• Intra-ETL database packages and SQL scripts to extract, transform, and load (ETL) data from one layer of the Oracle Healthcare Data Model to another.

  The intra-ETL is introduced in Chapter 7, "Oracle Healthcare Data Model Intra-ETL".

  For more details on Intra-ETL, see Appendix A, "Oracle Healthcare Data Model Control Tables" and the Oracle Healthcare Data Model Operations Guide.

• KPIs

  Chapter 8, "Oracle Healthcare Data Model KPIs" describes the Oracle Healthcare Data Model KPIs. This chapter describes the twenty pre-built clinical KPI's.

• OLAP Models for the Oracle Healthcare Data Model

  Chapter 9, "Oracle Healthcare Data Model OLAP Dimensions" and Chapter 10, "Oracle Healthcare Data Model OLAP Cubes and OLAP Facts" describe the OLAP Models.

• Pre-defined Data Mining Models

  These models are described in detail inChapter 11, "Oracle Healthcare Data Model Data Mining Models".

• Utility Scripts

  The utility scripts are described in Chapter 12, "Oracle Healthcare Data Model Utilities".

• Sample reports and sample dashboards

  Chapter 13, "Oracle Healthcare Data Model Sample Reports" covers the sample reports. This chapter describes the sample reports and dashboards.

• Installation scripts

  For more information on installation, refer to the Oracle Healthcare Data Model Installation Guide.

Oracle Products That Make Up the Oracle Healthcare Data Model

Several Oracle technologies are involved in building the infrastructure for healthcare business intelligence.

Oracle Database with OLAP, Data Mining and Partitioning Option

Oracle Healthcare Data Model utilizes a complete Oracle technical stack. It leverages the following data warehousing features of the Oracle database: SQL model, compression, partitioning, advanced statistical functions, data mining, and online analytical processing (OLAP).

Tip:

To achieve cost-effective scalability, availability, and reliability, you can consider using Oracle Real Application Clusters (Oracle RAC) and commodity hardware.

Oracle Development Tools

Use the Oracle tools shown in Table 1-1 to customize the predefined logical and physical models provided with Oracle Healthcare Data Model, or to populate the target relational tables, or OLAP cubes.

Table 1-1 Oracle Development Tools Used with Oracle Healthcare Data Model

Name	Use
Oracle SQL Data Modeler	To create the logical model
SQL Developer or SQL*Plus	To create or modify database objects
Analytic Workspace Manager	To populate the target OLAP cubes

Oracle Business Intelligence Suite Enterprise Edition Presentation Tools

Oracle Business Intelligence Suite Enterprise Edition is a comprehensive suite of enterprise Business Intelligence products that delivers a full range of analysis and reporting capabilities. You can use Oracle Business Intelligence Suite Enterprise Edition Answers and Dashboard presentation tools to customize the predefined sample dashboard reports that are provided with Oracle Healthcare Data Model.