We created a secure web-based system that provides access to a clinical data mart, to allow online benchmarking for the individual or office practitioner . Providers used a web-enabled documentation system to document the clinical facts of the encounter. A nightly set of routines extracts data from the online chart into the clinical data mart built in a relational database. The system uses a clinical vocabulary server to map provider-entered strings to normalized clinical concepts. The system loads chart data into a dimensional data model, to simplify data representation and ensure fast query performance.
Providers can access their own profiles from a secure web browser.
P. Van Grevenhof , Mayo Foundation, Rochester, MN, A. S . Physicians and administrators have little hope of responding appropriately to the challenges of the health care market without data to support decision making. Desired Mayo Clinic s Primary Care Practice was to have the ability to access and integrate data from many platforms in many formats from the Enterprise and bring this information to the desktop in a robust interactive display. To really understand what the summarized data represents, the physicians must be able to drill down, download and explore their own detail data. A pilot project was developed to test the capabilities of the development environment, the acceptance Web tools, the ability to deliver timely information and the methodology of using a multi-dimensional database to define the data.