MAHI Research Database

1
MAHI Research Database

• Project Status Report
• August 9, 2001

2
Project Goals

• Improve medical database system using new
  technologies
• Focus on flexible, shareable, scaleable, domain
  independent architecture
• Development of models for
• data validation,
• data integration and storage,
• data extraction and analysis

3
Overcome the limitations

• Limitations of the MAHI database system?
• Increasing data point and table (Scalability,
  Extensibility, Flexibility)
• Add-hoc data validation and management
  (Scalability, Extensibility, Flexibility)
• Inefficient data acquisition- slow and expensive
  query through recursive and cross referencing
  (Availability)
• Abnormal/primitive data integration
  (Integrability)
• No data access control (Security)
• Local representation and no standardization
  (Interoperability, Exchangeability, Sharability)
• Stumbling blocks
• Making the old way faster is the right thing?
• Legacy technology makes it hard to build system

4
New Approaches Are Needed

• XML Based, Open, Standardized Infrastructure
• Available
• Flexible
• Extensible
• Scaleable
• Interoperable
• Exchangeable
• Integrable
• Shareable
• Secure

5
Proposed Architecture
Management Interface
System Engineer
Analysis Interface (SAS, ACC)
Researcher
L
HL7
Validation
Integration
Analysis
L
Query Interface
Doctor/Nurse Patient
ODB
T
T
ASCII
Business Report Interface
Manager
Repository
6
Overview of Project

• Phase-1 June - August, 2001
• Data Validation
• Phase-2(a) September - December, 2001
• Data Repository-I
• Phase-2(b) January - May, 2002
• Data Repository-II
• Phase-3 June - August, 2002
• Data Analysis
• Phase-4 September- May, 2003
• System enhancement
• Documentation

7
Phase-1 June - Aug, 2001

• Requirements/Domain analysis (30)
• Learning about MAHI database system
• Meet stakeholders
• Technology review and analysis
• System Architecture an XML-based information
  system (20)
• Prototype development Data validation (50)
• Deliverables
• Demo (planned in August)
• Working demo system (data validation)
• System specification and architecture design

8
Phase-2(a) Sep - Dec, 2001

• System Development
• Enhancement of the data validation component
  (20)
• Data integration and storage (70)
• Supporting tool development (XML schema editor,
  visualization tool) (10)
• Research Publishing journal and conference
  papers
• Deliverables
• Demo (planned in December)
• Working demo system (Validation Repository-1)
• System specification and architecture design

9
Phase-2(a) Directions

• Issues
• Data integration for multiple databases
• Data exchanging between XML and databases
• Seamless Integration with the current MAHI system
• Data conversion of legacy database
• Technologies
• XML Repository
• Multiple Relational Databases
• IBM SQL Server, IBM DB-2, Oracle
• Data Warehouses/OLAP
• IBM DB-2, IBM SQL Server

10
Phase-2(b) Jan - May, 2002

• System Development
• Data integration and storage (80)
• Integration of the data validation and
  repository (10)
• Supporting tool development (XML schema editor,
  visualization tool) (10)
• Research publishing journal and conference
  papers
• Deliverables
• Demo (planned in May)
• Working demo system (Validation Repository)
• System design specification and implementation
  documentation

11
Phase-3 June - Aug, 2002

• System Development
• Data analysis (80)
• Integration of the data validation, repository,
  analysis (10)
• Supporting tool development (XML schema editor,
  visualization tool) (10)
• Research Publishing journal and conference
  papers
• Deliverables
• Demo (planned in August)
• Working demo system (Validation Repository
  Analysis)
• System design specification and implementation
  documentation
• Tutorial

12
Phase-4 Sep - May, 2002/3

• System Development
• Integration of the data validation, repository,
  analysis (10)
• Testing, system enhancement, documentation (40)
• Supporting tool development (XML schema editor,
  visualization tool) (50)
• Research Publishing journal and conference
  papers
• Deliverables
• Demos (planned in Dec and May)
• Working system and Tools
• Complete system documentation and user manual
• Tutorial

13
Scheduling

• 2001
• August Phase-1 (data validation) demo
• December Phase-2(a) (data repository-1) demo
• 2002
• May Phase-2(b) (data repository-2) demo
• August Phase-3 (data analysis) demo
• November system tutorial-1
• December Phase-4 (a) demo
• 2003
• March system tutorial-2
• May complete system demo and system tutorial-3