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 per cent 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.

Dohmann was already familiar with the concept of open-source software since the BGR was using several open-source tools, such as GMT, a free, open-source collection of 60 Unix tools used to manipulate (x,y) and (x,y,z) data sets and produce Encapsulated PostScript File illustrations, created by the University of Hawaii. The BGR also uses MapServer, an open-source development environment for building spatially enabled Internet applications, created by developers at the University of Minnesota, and the widely available GNU toolset. Because of his familiarity with these open-source licensed tools, Dohmann understood the inner workings of the open-source community, and he knew that open-source software was secure and robust enough to do the critical work of around-the-clock seismic activity monitoring.