|
 |
 |
 |
 |
|
 |
|
 |
|
 |
|
 |
|
 |
|
 |
|
CASE STUDY
Chemistry Data Management System for
Microsoft® Windows – WinCDMS32
GCR & Associates, Inc. (GCR) provides a broad range of technical and consulting services relating the implementation of process and chemistry data management systems. GCR' s flagship application in this sector is the Chemistry Data Management System for Microsoft® Windows (WinCDMS32), and is used at 18 nuclear power plants throughout the U.S. The system is an effective data management application designed specifically to help Chemistry Departments handle vast quantities of technical information. It provides the framework for scheduling, analyzing, and validating tests and test results in chemistry processes. WinCDMS32 has been developed for—and created by—nuclear utility chemistry personnel from the whole spectrum of operating nuclear power plants.
The system can be used for storing, analyzing, and archiving chemistry data obtained from bench tests or from in-line process sensors. As a related component of WinCDMS32, a "multi-parser" program is implemented to receive and parse any number of in-line sensor data feeds, and move them directly into the database. GCR is a Microsoft® Solution Provider, and its WinCDMS32 application conforms to Microsoft® application development standards. The WinCDMS32 program operates on Microsoft® Windows 98, NT 4.0, or 2000 desktops. Data managed by WinCDMS32 may be stored on Microsoft® SQL Server 7.0, Microsoft® SQL Server 2000, Sybase, or Oracle database platforms, as well as, in a Microsoft Access database.
Additionally, GCR can provide remote access to critical chemistry data through the use of remote program servers, or through direct data feeds over the internet or a wide area network. WinCDMS32 is capable of on-line data transfer to the Electric Power Research Institute (EPRI) Smart chemWorks™ program and conforms to software standards and EPRI software acceptance requirements.
The advantages of WinCDMS include:
- One-Time Data Entry
Enter data into WinCDMS32 only once—regardless of their origin. Once chemistry data has been entered, the user can readily recall them to use in trend plots, reports, calculations, and schedules.
- Historical Data Maintenance
WinCDMS32 maintains chemistry test result records within their appropriate historical contexts so that the user can reconstruct tests in the future if necessary—regardless of whether limits, frequencies, or analytical methods have changed over time.
- Data Export
Easily export WinCDMS32 data to such word processing and spreadsheet applications as Microsoft® Word and Excel, to statistical evaluation routines, to peripheral equipment, to an off-site database, or directly to the Internet.
- Data Trend Plots
Graphically display any WinCDMS32 data—individually or in combinations—on trend charts according to a user-defined date range. Groups of plots can be defined and saved re-use.
- User-Defined Parameters
Define site-specific parameters for in-line analyzer data, routine and special chemistry tests, limits and specifications, measurement units, test performance frequency, and other criteria that meet a site's unique requirements.
- Automation
Routine WinCDMS32 processes are automated, including:
- Input Result Screening, which evaluates process data against a variety of user-defined acceptance criteria upon input.
- In-Line Data Transfer, which transfers in-line process data from a variety of sources to the WinCDMS32 database at user-defined intervals.
- Interactive Scheduling, which updates tests schedules and workload status as tasks are completed and data is entered into WinCDMS32.
- Enhanced Communication , wherein various electronic messages can be entered into WinCDMS32 to transmit information from supervisors to shift personnel, to issue special assignments, and to record routine lab activity. Similarly, numerous user-defined routine WinCDMS32 reports can be generated.
