Monday, October 18, 2004 - 10:55 AM
2

Upgrading Immunization Registry Database Management Systems

BACKGROUND:
Contra Costa Automated Immunization Registry (CCAIR) was developed using Microsoft dot-NET compilers for user front-end graphical interface and business logic. SQL Server database management system is used as the backend data storage and retrieval. Traditionally system architecture calls for separation of data from business logic into different tiers. Database technology has advanced to make databases more programmable and fault tolerant.

OBJECTIVE:
To leverage new capabilities in next generation of database technology which includes built in disaster recovery, added security via native encryption, more programmability, a new integrated report writer, event notifications, availability of the next-due recommendations during data import and easier deployment via simplified system architecture.

METHOD:
A separate machine was installed with the latest revision of database management system SQL Server 2005 from the vendor for testing. Several new capabilities that came natively with the database system such as replicating the transactions to a remote site with automatic failover and data encryption were tested without modifications of existing CCAIR program logic. Other new capabilities such as putting next-due recommendation algorithm program code written in Visual Basic into stored procedures were tested by making the necessary modifications. Results were compared with the existing setup.

RESULT:
Only a small fraction of the new capabilities were tested. Overall, higher availability of system was achieved. System management was easier.

CONCLUSION:
Migrating current immunization registries to new database management systems can provide many new benefits.

LEARNING OBJECTIVES:
To improve immunization registry by using newer database technologies.

  Recorded presentation

See more of Challenges and Changes in Registry Operations
See more of The 2004 Immunization Registry Conference