1 / 19

M-Connect

M-Connect. John Pinder. Agenda. Problems? Future development SQL server Oracle Web based Data dictionary Central repository. Problems. Speed Robustness Maintenance. Problem Causes - Speed. Source system data structure ^M("BARNES","FLORENCE","K",1381511376)

aren
Download Presentation

M-Connect

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. M-Connect John Pinder

  2. Agenda • Problems? • Future development • SQL server • Oracle • Web based • Data dictionary • Central repository

  3. Problems • Speed • Robustness • Maintenance

  4. Problem Causes - Speed • Source system data structure • ^M("BARNES","FLORENCE","K",1381511376) • Due to NHAIS user factors Surname Forename Middle Names NHS Number

  5. Problem Causes - Speed • Server workload • Other applications • SQL Server • Oracle • Exchange Server

  6. Problem Causes - Speed • Network traffic • Applications competing for network resource • Ophthalmic • NHAIS ICM • PCIS • Open Exeter

  7. Problem Causes - Robustness • Orphaned licence processes • Caused by cancelling queries in front end • Licence record remains • Limits amount of active connections available

  8. Problem Causes - Maintenance • Upgrade process • Currently hard coded location • Dependant on floppy drive

  9. Problem Causes - Maintenance • Manual startup of M-Connect • Required on Cache reboot • Starts SQL0TCP process • SQL0TCP process not present – M-Connect wont work

  10. Re-development - SQL Server • Fast • Open • Robust • Scalability

  11. Re-development - Oracle • Fast • Open • Robust • Scalability

  12. Current system - Cache • Fast • Open • Robust • Scalability

  13. System Redevelopment • SQL Server, Oracle and Cache all DBMS • All have similar functionality • Data structure problems remain • Server resource issues remain • Network resource issues remain • New upgrade issues

  14. Problem Resolution - Speed • Indexes • e.g. R_PERSON_INDEX_NHS_NUMBER • Used to link on NHS_NUMBER • Provides all 4 fields • Allows direct retrieval of records • Other indexes for GP, Postcode, Date of Birth • Local tables • Using copies of data held locally • Run “harvest” queries overnight

  15. Problem Resolution - Robustness • Orphaned licence records • New routine • Regular execution • Automatic clear down

  16. Problem Resolution - Maintenance • New upgrade routine • Prompt for upgrade file location • Enables files to be copied anywhere • New startup routine • Runs on Cache reboot • Automatic startup SQL0TCP

  17. Data Dictionary • Currently Microsoft Access database • Requires update on each client PC • Migrate to single data dictionary • One copy of data dictionary to update • Ensure all users viewing latest version • Located where all users can view • Web page

  18. Central Repository • Not widely used • Needs promotion • Regular submissions required

  19. Conclusions • Redevelopment offers no improvement • User awareness and education • New upgrade routine • New startup routine • New licence cleardown routine • Data dictionary improvement

More Related