may 2013 oracle spatial and graph user conference...public healthcare monitoring system •...

May 2013 Oracle Spatial and Graph

User Conference

May 22, 2013 Ronald Reagan Building and International Trade Center

Washington, DC USA

Alex Cordón Geographic Information Officer at

Location Intelligence in Healthcare: A case study of the Brazilian Healthcare Monitoring System

Program Agenda

•  The Brazilian Healthcare System monitoring – Overview – Challenges / Opportunities – Solutions / Results – Video demonstration

Public Healthcare Monitoring System

SUS – Federal Healthcare Unified System –  Potential to monitor healthcare usage of 191 M people. more than 300 million registered users on the database. –  Currently, 20M are partially monitored by the system

Overview

Healthcare Public Portal CADSUS BIM BI Monitoring – Spatially Enabled

The system currently carries 2.8 billion annual outpa6ent

procedures, 19 000 transplants, 236 000 heart surgeries, 9.7 million chemotherapy and

radiotherapy procedures and 11 million hospitaliza6ons.

DATASUS - Federal Ministry of Health Care

V I D E O

BI: Spatially enabled for the Brazilian healthcare

monitoring system


• Geographic distribution • Brazil is 3.2M square miles. 5565 municipalities in 27

States • 6,100 registered hospitals, 45,000 primary Healthcare

units (HCU), more than 200,000 secondary HCU.

• Centrally managed, enterprise-wide database

•  It supports Administrative Functions, Data Inclusion, Online monitoring

Overview

Public Healthcare Monitoring System Challenges / Opportunities

•  Need for Intelligent location of healthcare • Planning and restructuring of the information to make

instantaneous solutions for apparent problems

•  Need for organized and updated information •  For follow up of asymptomatic citizens •  Interactive communication with citizens


•  Geographic data is unavailable to the enterprise. Most records (thousands) do not contain association with spatial coordinates

Challenges / Opportunities

•  Need to integrate spatial data and indicators dynamically for decision making

• Need for better performance on online data processing

Oracle Database Enterprise Edition 11g with Oracle Spatial and Graph Option, Fusion Middleware MapViewer, Business Intelligence Enterprise

Edition, SOA Suite, BPM Suite, Weblogic Server, JVM Jrockit, Data Integration, Service Bus, HTTP Server, Enterprise Manager Grid Control, Service

Registry, Enterprise Gateway...

Complex system architecture BI

Many strategies for getting better performance

•  Infrastructure •  Database • Middleware tuning strategies

Public Healthcare Monitoring System Solution / Results


•  Infrastructure tuning sample:

• Database migration samples (ODI – Oracle Data Integrator):


• Spatial Database Strategies sample:

Topologically constrained Simplification / generalization

of geometric polygons

Improved performance by at least 30% when rendering FOIs


•  It standardized all the information, including the addresses of the healthcare units in a consistent format (geographic coordinates)

 Brazil is the first country in Latin America that is implementing an international protocol for healthcare information exchange based on HL7 protocol, using the Oracle Healthcare Master Person Index –OHMPI.

 Consolidation of vector data in a .5GB central repository.

Currently, the indicators are collected at the following levels:  Region (5); States (27); Municipalities (5565)

Healthcare Units (250.000)

Solution / Results


• Ability to detect, as early as possible, epidemiological problems such as:

• Where the events are happening; • Geographic Extent of events • Possible Health coverage solutions;

• Finding solutions for intelligent health policies dynamically and quickly

• Lower risk and lower cost procedures •  Increasing the impact and the effectiveness of the

system • System efficiency (yield)

Possibilities


• Unified data, Scalability and better communication with citizens

• Improved decision making – thereby making the system more useful for the public and managers

• Now, the organization better understands activities according to the local context

Conclusions

OVERVIEW •  Centrally managed, enterprise-wide database •  Incorporates several internal systems and 27 regional systems •  Supports Business Functions, Data Inclusion, Online monitoring

CHALLENGES / OPPORTUNITIES •  Geographic data unavailable throughout the enterprise. Most

records (thousands) do not contain association with a spatial coordinates

•  Need to integrate spatial data and indicators dynamically •  Need for 80% performance improvement on online data

processing SOLUTIONS •  Unified Portal for registration •  Oracle Database 11g Enterprise Edition with Oracle Spatial and

Graph Option •  Other Oracle solutions:

•  Fusion Middleware MapViewer, Business Intelligence Enterprise Edition, SOA Suite, BPM Suite, WebLogic Server, JVM Jrockit, Data Integration, Service Bus, HTTP Server, Enterprise Manager Grid Control, Service Registry, Enterprise Gateway...

RESULTS •  Achieved 100% performance improvement for performance

for consolidated online data (less than 1 minute) for indicators on BI

•  Standardized all addresses and coordinates for central units of health care in a consistent format

•  Consolidation vector data in .5GB sized central repository •  Unified data and communication with citizens •  Improved decision making thereby making system more

useful to the public and business •  Organization now better understands activities in context of

location

DATASUS / Federal Ministry of Health Care CADSUS – UNIFIED PORTAL – BIM

may 2013 oracle spatial and graph user conference...public healthcare monitoring system •...

Documents