A German scientific research institute is using an open-source database running on Linux and x86 hardware to store global seismic activity data and to interpret that data. The purpose is to ensure that countries around the world are in compliance with the terms of the nuclear test ban treaty.

The most recent nuclear test to violate the Comprehensive Nuclear Test Ban Treaty (CTBTO) was North Korea, in late 2006. The world was alerted to the testing thanks to the efforts of monitoring stations around the world, including four stations under the auspices of the German Federal Institute for Geosciences and Natural Resources (BGR).

The CTBTO calls for global monitoring to ensure compliance with the treaty. Monitoring stations worldwide use infrasound, hydroacoustic and radionuclide technologies. It also tests for underground movement that is usually associated with earthquakes, called seismic activity, to ensure that no country can get away with secret underground nuclear testing.

The BGR, an official primary seismic monitoring station for the CTBTO, oversees the activities of four seismic monitoring stations (of about 50), keeping track of all kinds of seismic activity and interpreting the results. The BGR stores the data in a database used by CTBTO member nations to determine compliance with the terms of the Nuclear Test Ban Treaty. The BGR also monitors natural seismic activity that occurs in conjunction with earthquakes, including the recent 7.9-magnitude quake that rocked China's Sichuan Province in May.

The BGR was a longtime Sun SPARC and Solaris customer, using the Ingres database to store data retrieved from instruments that monitor global seismic activity. "The database is used to store evaluations of seismic waveform data from German stations, and earthquake information from various international geological services, such as the United States Geological Survey," said Markus Dohmann, BGR geophysicist. "The database forms the basis for our scientific work in the field of seismology and provides information on current earthquake alerts in Germany, Europe and across the globe. The Earthquake Monitor System (ERMOS) displays this earthquake information in a Web application in the form of epicenter maps."

The BGR had been running the Ingres database for more than 20 years, Dohmann said, and the institute was happy with its performance. A highly reliable, stable database is crucial to the BGR. Its contractual obligation to the CTBTO includes a minimum of 98 percent data availability and uptime, and Dohmann said Ingres worked just fine in that role. When Ingres released its database as open-source software in 2004, Dohmann started thinking about the potential benefits of a switch to open source, not only for BGR's applications, but also for its entire infrastructure.