Search
Filters
Close

97123 A System For Storing Cathodic Protection Measurement Data

Product Number: 51300-97123-SG
ISBN: 97123 1997 CP
Author: T.J. Bowrnao, E.I. Husa
$0.00
$20.00
$20.00
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
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
PRICE BREAKS - The more you buy, the more you save
Quantity
1+
5+
Price
$20.00
$20.00
Product tags
Also Purchased
Picture for 10034 Cathodic Protection - It's All About Current
Available for download

10034 Cathodic Protection - It's All About Current

Product Number: 51300-10034-SG
ISBN: 10034 2010 CP
Author: Dennis Janda
Publication Date: 2010
$20.00
Picture for 10092 Solar Powered Cathodic Protection System
Available for download

10092 Solar Powered Cathodic Protection System

Product Number: 51300-10092-SG
ISBN: 10092 2010 CP
Author: Edwin Piedmont and Thomas Tehada
Publication Date: 2010
$20.00