Home Site Map Search Contact Us About Us About Us
Copyright © 2000
Projects
Up Projects Samples

Database Projects

PeopleSoft Database Tuning

Tuned the ORACLE System Global Area (SGA) for a fortune 50 company's PeopleSoft database.  This database is running on a 10 processor Sun server with 9GB RAM, and was experiencing extremely poor performance.  After modifying the SGA parameters to properly use the available system resources, reports and queries that once took minutes now take seconds. Also asked  the client to rebuild the database indexes since they were extremely out of balance, yielding more performance enhancements. 

ORACLE Instance Consolidation

Consolidated approximately 25 UNIX based ORACLE 6 and 7 instances into 3 NT based ORACLE 8 instances, greatly reducing the support costs associated with the related applications.  Installed and configured NT on the servers, Installed ORACLE 8, and initialized the instances.  Wrote and executed all of the DDL to create the ORACLE objects, users, and permissions.

Real-Time Operational Data Store

Designed and implemented a real-time process data operational data store that currently stores over 500 million rows in one location. This design was adopted and deployed throughout refineries within the largest US refining organization.  Installed NT and ORACLE 8 on several Dell 6300 machines to host the production and backup databases.

Yield Accounting Operational Data Store

Designed and implemented a yield accounting operational data store that serves as the core for a large refinery’s process data related financial reporting system.  A third party developer used a portion of this design as the database for a yield accounting product that is currently used in refineries throughout the world.

Data Dictionary Implementation

Installed and configured a network based multi-user version of System Architect, and served as the technical backup for all other database designers using this tool.  Documented entity and attribute definitions, generated entity relationship diagrams (ERDs), generated DDL, and reverse engineered ORACLE databases into the dictionary.  Also designed and created a SQL Server database that stores the entity, attribute, and business term data.

Alarm Management System

Worked with several University of Delaware chemical engineering students to translate their theses on alarm management into a database design.  This design is the first step towards creating an application that will provide refinery operators with advice during a unit upset based on groups of alarms.

Linear Programming Model and Yield Accounting Integration

Designed and implemented a set of ORACLE tables to store data from a linear programming (LP) model used to optimize a refinery's profitability.  Cross referenced the LP model with the actual data contained in the yield accounting operational data store.  Created several SQR programs to generate reports depicting actual versus forecast data, and developed a set of UNIX scripts to extract the data from the LP, transfer it to the ORACLE system, and load it into ORACLE with another SQR program.

Odor Expert System

Designed and implemented a database to support a Gensym G2 based expert system used to track and analyze refinery odor complaints.  This application required the use of sophisticated queries that used longitude and latitude to identify a complainant's location.

Refinery Blender Pump Sheet Database

Designed and implemented a database to support a client server application that tracks unit rundowns, blends, tank car/truck loading, and receipts and shipments within a refinery.  Created a database link to a third party application's database and created a set of views that allowed the application to pull blend configuration data out of the real-time blending system.

Refinery Traffic Database

Designed and implemented a database to support a client server application that tracks truck and railcar movement within a refinery.  Also connected the user PC's to an AS400 to allow third party invoices to be printed locally.

ODBC & SQL*Net Rollout and Maintenance

Created a set of scripts that deploys all ODBC and SQL*Net components and configuration settings required for clients to access ORACLE 6, 7, and 8 databases from both 16-bit and 32-bit applications.  These scripts have been used, virtually unchanged, since 1996 to maintain all client ODBC and SQL*Net settings on a 700 PC network.  All PC's have the same ODBC and SQL*Net settings, which greatly reduces the configuration required when machines are changed out.

ORACLE and UNIX Installation

Installed ORACLE 7 and AT&T System 5 UNIX on several NCR 3450/3550 class machines, and developed documentation describing everything related to the installation process from slicing the disks to applying operating system and ORACLE patches.  This documentation was later presented to NCR by the client as an example of how the installation process should be documented.

ORACLE Data Loader

Designed and developed a suite of NT services with Visual Basic that load text files into an ORACLE 8 database at the rate of 10,000 records per second.  These services are highly configurable, and report a variety of statistics and error conditions for review by the application administrators.  The services are also self healing, so that a failure does not require operator intervention for the 24X7 loading process to continue.