Data Warehousing

Optimized Data Warehousing Solutions

Mile High designs and builds data warehouses optimized for risk score management, quality measurement, and value-based payments. Our data model supports all lines of business, not just the CMS-HCC model.  Quality measurement is integrated into the data model, permitting the building of queries and reports that combine all care and documentation gaps.

ERwin Data Modeler Approach

The logical and physical data schemas, source-to-target mappings, and ETL specifications are managed using the Erwin Data Modeler.  ERwin Data Modeler is an industry-leading data modeling solution that provides a simple, visual interface to manage a complex data environment.  On behalf of our clients, ERWin provides Mile High with the ability to do: 1) logical data modeling; 2) physical data modeling; 3) logical-to-physical transformations; 4) forward engineering into SQL Data Definition Language (DDL) scripts; and 5) reverse engineering, if necessary, of an existing data warehouse or data mart that needs to be improved or integrated in our more comprehensive data model.

Logical data modeling is the first step before the design and implementation of a physical data model.  We create logical models from which physical models may be derived.  Our logical model supports entity-type and attribute logical names and descriptions, logical domains and data types, as well as relationship naming.  The physical model creation phase supports the naming and description of tables and columns, user defined data types, primary keys, foreign keys, alternative keys and the naming and definition of constraints.  Physical design of indexes, views, stored procedures and triggers is also included.

Supports Multiple Database Systems

Mile High’s data warehousing process supports a variety of relational database systems. Platforms for which we can generate DDL SQL code include:

  • DB2 (iSeries 5.x/6.x/7.x, LUW 9.x/10.x, ZOS 8.1/9.1/10/11)
  • Informix 7.x/9.x/10.x/11.x
  • MySQL 5.x/6.x
  • ODBC/Generic 2.0/3.0
  • Oracle 10g/11g/12c
  • Progress 9.x/10.x
  • SAS
  • SQL Azure
  • MS SQL Server 2008, 2012/2014
  • Sybase (ASE) 15/16
  • Sybase IQ 12.x
  • Teradata 13/13.1/14/14.1/15

Our data warehouse comes complete with ETL specifications, a comprehensive logical-physical data dictionary, fully populated and up-to-date dimension (look-up) tables, data integrity tests, and report specifications. The Mile High Healthcare Analytics team can provide ongoing support to entities that wish to deploy a uniquely designed, but highly optimized data warehouse for population health analytics.

 

Ready to Start?

Discover Our Free Webinars

Mile High Healthcare Analytics is the proud host of the MHHA Webinar Series. In these sessions, Richard Lieberman and occasional guest speakers from various parts of the industry discuss topics relevant in Medicare Advantage, Medicaid, and the Health Insurance Exchanges.

Get Our Newsletter

Newsletter | Mile High Healthcare Analytics