130 likes | 318 Views
MAHI Research Database. Project Status Report August 9, 2001. 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,
E N D
MAHI Research Database Project Status Report August 9, 2001
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
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 Overcome the limitations
New Approaches Are Needed • XML Based, Open, Standardized Infrastructure • Available • Flexible • Extensible • Scaleable • Interoperable • Exchangeable • Integrable • Shareable • Secure
Component Input sources User Interface Stakeholders Proposed Architecture Management Interface System Engineer Analysis Interface (SAS, ACC) Researcher L HL7 L Validation Integration Analysis Query Interface Doctor/Nurse Patient ODB T T ASCII Business Report Interface Manager Repository
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
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
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
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
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
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
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
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