This paper describes a custom cathodic protection (CP) database, and discusses how this combination of data structure
and software improves the ability to analyze cathodic protection. This may be a unique solution to the task of managing
CP data, and may have value to others. This paper is primarily about the database design, and not about cathodic protection, per se.
Every database project is a balancing act. A developer can create custom software that perfomas complex operations requiring modest operator skiIls. On the other hand, custom software is expensive to both create and maintain. The
Hanford CP data system will be used primarily by one person, the CP Engineer. It was concluded that this position could be trained to use off-the-shelf, general purpose database to store data, and spreadsheet software to perfonn analyses. The database product allows flexibility in data reporting, and enforces referential integrity. The spreadsheet allows many display options. EspeciaIly useful are the graphics. This solution entailed minimal computer coding and may lend itself to adoption by others.
The data structure was designed by a database application developer, with close guidance from the CP engineer. The system will require modest amounts of attention from computer support staff, primarily for new query development. The data structures are provided in this report, and are available electronically.
Keywords: Cathodic Protection Database, Computer, Polarization, Native Potentials, Test Points, Rectifiers, Anodes, Loop, Tap Settings, Access, CP, Excel