Abstract:Purpose: Data generated in the care of patients are widely used to support clinical research and quality improvement, which has hastened the development of self-service query tools. User interface design for such tools, execution of query activity, and underlying application architecture have not been widely reported, and existing tools reflect a wide heterogeneity of methods and technical frameworks. We describe the design, application architecture, and use of a self-service model for enterprise data delivery within Duke Medicine. Methods: Our query platform, the Duke Enterprise Data Unified Content Explorer (DEDUCE), supports enhanced data exploration, cohort identification, and data extraction from our enterprise data warehouse (EDW) using a series of modular environments that interact with a central keystone module, Cohort Manager (CM). A data-driven application architecture is implemented through three components: an application data dictionary, the concept of "smart dimensions", and dynamically-generated user interfaces. Results: DEDUCE CM allows flexible hierarchies of EDW queries within a grid-like workspace. A cohort "join" functionality allows switching between filters based on criteria occurring within or across patient encounters. To date, 674 users have been trained and activated in DEDUCE, and logon activity shows a steady increase, with variability between months. A comparison of filter conditions and export criteria shows that these activities have different patterns of usage across subject areas. Conclusions: Organizations with sophisticated EDWs may find that users benefit from development of advanced query functionality, complimentary to the user interfaces and infrastructure used in other well-published models. Driven by its EDW context, the DEDUCE application architecture was also designed to be responsive to source data and to allow modification through alterations in metadata rather than programming, allowing an agile response to source system changes.

User Profile-Driven Data Warehouse Summary for Adaptive OLAP Queries

Data Warehouse Native Feature Based OLAP Querying with Keywords

A Survey of User-Centric Data Warehouses: From Personalization to Recommendation

Towards the Next Generation of Data Warehouse Personalization System: A Survey and a Comparative Study

Building MultiView Analyst Profile From Multidimensional Query Logs: From Consensual to Conflicting Preferences

DROLAP - A Dense-Region Based Approach to On-Line Analytical Processing

A Complex Data Warehouse for Personalized, Anticipative Medicine

Optimized Design of Materialized Views in a Real-Life Data Warehousing Environment

Data warehouse on Manpower Employment for Decision Support System

A Peta-Scale Data Movement and Analysis in Data Warehouse (APSDMADW)

User Profiling Approaches, Modeling, and Personalization

A Data Warehouse Design for a Typical University Information System

Dynamic construction of user defined virtual cubes

Toward a New Approach for Modeling Dependability of Data Warehouse System

Adapting OLAP Analysis to the User’s Interest Through Virtual Cubes

Warehousing Web Data

Quality-based framework for requirement analysis in data warehouse

Dynamic index selection in data warehouses

Ontology based data warehouses federation management system

User profile model: A user dimension based classification

Modular design, application architecture, and usage of a self-service model for enterprise data delivery: the Duke Enterprise Data Unified Content Explorer (DEDUCE)