Using new replication features of Oracle 7 in emergency management system

摘要

Pacific Northwest Laboratory is developing an application for the Army and the Federal Emergency Management Agency to support emergency management of hazards resulting from the accidental release of chemical agents during their storage or destruction. This application, called the Federal Emergency Management Information System (FEMIS), uses Oracle 7.1 in a client/server configuration. At each Army site where FEMIS is deployed, there will be two or more servers and about 25 users on client personal computers (PCs) connected to each server. The Oracle Data Base Management System is configured as a multiserver, distributed data base using partitioning to share information between the Oracle instances. The information in the individual partitioned tables is merged by Union operators to form a set of site-wide views. This data base contains more than 180 tables and about 40 additional site views. Oracle snapshot replication was chosen rather than distributed queries in order to achieve autonomous operation and improve failure tolerance. The presentation will describe this architecture and discuss how the data was partitioned. Some useful techniques for generating the scripts that produce the data base will also be discussed.