MySQL/mod_python Antarctic Geophysical Data Database

ISTI, in collaboration with the Department of Physics at Siena College, has designed a prototype Antarctic Geophysical Data website available. This project used the open source mod_python module for Apache to talk to a MySQL database. The database schema maintains all of the information about the waveform data collected by several stations in Antarctica. The web interface allows researchers to obtain customized data sets over the web or view plots of the data (using IML).

PHP Sybase Hazardous Chemicals Tracking Database
Designed and implemented a PHP replacement interface to a legacy Sybase curses based application. ISTI improved the workflow of the application and created new reports that allow the database users to find locations and quantities of hazardous chemicals more easily. The work was performed for Lamont-Doherty Earth Observatory to meet rigorous EPA standards.

DHI CORBA Database Interfaces
ISTI integrated the IRIS CORBA framework for Seismologic data known as the Data Handling Interface (DHI) to the Northern California and Southern California Data Centers. The work involved writing Oracle PL/SQL stored procedures and CORBA to link the data centers to the common CORBA interface so users can transparently access data at these two data centers using the DHI protocol and tools.

PHP Sybase Hazardous Chemicals Tracking Database
Designed revamped and improved parts of a pre-existing legacy web page done with PHP and MySQL. The new improvements included an improved login announcement system and also changes to allow users to be informed of new developments on the web page since they last logged in.

Data Analysis Java Servlets
ISTI designed and implemented two data analysis servlets for the IRIS Data Management System QUACK framework. The servlets were created to monitor time quality and noise levels of seismic waveforms (Timerlet and Noiselet, respectively). The servlets are used daily to monitor the seismogram data flow into the the disk storage buffers. You can query the data generated by the servlets using QuackQuery.

Java Servlet Development
Designed and implemented a Java Servlet for determining Basin Depth in the Los Angeles Basin. The Servlet was developed using JDK1.2.2 and the Apache Tomcat servlet engine. It was developed under the Windows OS, and deployed on both the Solaris and Linux OS's. The customer for this project was the University of Southern California.
Check out our servlet in action at SCEC.

JDBC Java Servlet Development
ISTI designed and implemented a Java Servlet for an intranet-based procurement processing database. The system allowed purchasing agents to perform procurement tasks and lookups. Interaction between the servlet and PERL CGIs allowed report printing to be easily integrated from an existing legacy system. The servlet system was also integrated with the customers financial accounting system for account validation. The database backend used is Sybase and JDBC is used to communicate between the servlet and the RDBMS. The Servlet engine that is used for this project is the Jakarta Tomcat engine on a Solaris Enterprise server.

SwimWare.com Web Site
Ported a a Microsoft ASP based database-backed swim practice website to free software. This also involved an upgrade to the existing site by including administrator web pages to monitor and edit the backend database. This work was performed under Linux and FreeBSD UNIX using Apache with mod_perl and Perl CGI's.

Contracts & Grants Database
Designed and implemented a Sybase database (under ASE 11.9 on Solaris) for tracking a university's proposals and resulting grants. The front-end for this project was a Microsoft ACCESS 2000 interface deployed on Windows 2000.

JobForceNY Web Site
Designed and implemented a database-backed regional-employment website. This work was performed under Linux and FreeBSD Unix using Apache with mod_perl and Perl CGI's. Interested in using this software? THIS DOMAIN WAS CLOSED IN 2001.

PASSCAL Software Suite
ISTI developers are the principal authors of a software package to process and archive RefTek acquired seismic data. This software uses a PostgreSQL RDBMS to maintain data and processing flow. The project involved using Tcl/Tk & C under three operating systems: SunOS, Linux, and Solaris.

K2MSEED - PDB Integration
ISTI, in cooperation with Kinemetrics Inc, developed a utility to integrate Kinemetrics K2 seismic dataloggers into the PASSCAL DataBase (PDB) System. The new development used the C++ and Tcl/Tk languages under Linux and Solaris to seemlessly integrate the flow of K2 data into miniSEED and SEED volumes (k2mseed, tk2mseed). This work was funded by the U.S. Geological Survey and the software is available in the public domain at the following URL: http://www.passcal.nmt.edu.

NCEER Strong Motion Database
ISTI developers designed the first network accessible database of strong motion accelerograms. This project involved a Sybase database with three GUIs for obtaining waveform data from Internet (X Windows application) or dialup (curses dumb terminal) or WWW (Perl CGIs using sybperl).

Insurance Agency Client WWW Database
ISTI Developed a web interface to allow insurance quotes to be polled on the web using Perl CGI. Forms data gets converted into a Microsoft Access database. The work is done on the BSDI, Linux, and Windows95 operating systems.

On-line Retail Outlet
ISTI Improved remote data retrieval using Perl/Expect scripts to make a client's store to HQ transfer of corporate data more robust.  The project involved input of data into a corporate Oracle database.

PETDB RIDGE Geochemistry WWW Database
Provided assistance in design of a relational schema for storing geochemical data collected from the Sea Floor. The project involved Oracle,PostgreSQL, and Microsoft Access database work. ISTI developed a Access frontend for data entry and Perl CGI scripts for database query through a web forms interface. Solaris, Windows95, and Linux were the operating systems used. The web forms were implemented in Perl CGI using Apache as the web server.

Sybase Administration Database
We provide support for a University's Administration Sybase databases. This involved writing customized SQL procedures, troubleshooting custom applications in APTworkbench, performance tuning of the Sybase 11 server, and monitoring server up-time.

J2EE Personnel Database
ISTI designed and developed a Java Application using Sybase's PowerJ to operate with a Human Resources database for a major university. The application, known as JSalCard, replaces a legacy system which used APT forms for dumb terminals. JSalCard provides a platform independent front-end to access the Sybase database and is currently used on Windows XP and RedHat Linux. Due to limitations in the PowerJ IDE, ISTI had to hand code much of the application. JDBC was used for communications with the database. To isolate the business logic, ISTI placed much of the intelligence for the application in the database server using stored procedures. Existing reporting tools were used for printing and were accessed via perl CGIs. ISTI produced a cost-effective solution to saving a legacy system.