Western Area Power Administration, 114 Parkshore Drive, Folsom, CA 95630

70 -- DATA SHARING SYSTEM SOL WN11110 DUE 063000 POC Janna Buwalda (916) 353-4471 E-MAIL: click here to contact the technical POC, JRMILLER@wapa.gov. This is a market survey for written information only (including that supplied on or by means of electronic or machine-readable media). This is not a solicitation announcement for proposals, and no contract will be awarded from this announcement. No reimbursement will be made for any costs associated with providing information in response to this announcement and any follow-up information requests. This market survey is for information and planning purposes only, and is not to be construed as a commitment by the Government. This request for information in no way implies either implicitly or explicitly that respondents will be compensated in any way by the Government. All information and media provided become the property of the Western Area Power Administration, Sierra Nevada Region, and will not be returned. In general, what is sought from each responder is a description of the solution(s) which that responder would consider appropriate for the described need, together with supporting information justifying that view, and a very rough estimate of what such a solution (or solutions) may cost, both initially, and over its (their) entire lifetime(s). Western Area Power Administration, Sierra Nevada Region (Folsom, California), is interested in possible sources for an information system which effectively integrates various database systems within the region so as to enable users to access both current and historical data in a manner that appears to them to be natural to their particular disciplines, unified, and logically coherent as if they were interacting with a single database in which all of the information from the disparate component databases appears to be a consistent, orderly whole. They should ideally be able to navigate this single logical database, formulate queries against it, and construct reports without relying unduly upon the assistance of information technology staff personnel. The constituent source databases, and the organizations within the region that populate and maintain them, should not suffer excessive demands upon their performance, time, and other resources as a result of such user accesses to the unified logical database. In particular, the burden for formulating new queries and reports should fall mainly upon the user rather than the supplier of the data. Such an information system could be a physical data warehouse, a virtual data warehouse, or some other system which provides for logical interconnection of scattered individual databases and extended storage of data which those individual databases may not keep long enough to satisfy the users' needs for access to historical data. To test these concepts and to gain experience with different approaches that may be promising, the Sierra Nevada Region will be undertaking a pilot project to acquire or implement a similar, but much more narrowly focused system. It is desired that this initial system be sufficiently well planned and designed that it could be expanded into the full-blown system by fully employing the infrastructure alreadyacquired without wasteful duplication. The pilot system is to serve the needs of a user in the electric power system transmission maintenance department of the Sierra Nevada Region who wishes to access and analyze power system equipment operational data in an Oracle database populated by a supervisory control and data acquisition (SCADA) system belonging to the power system operations department in the same facility. The maintenance user wants to, for any specified date and time interval: (1) obtain the number of trip and close operations for each member of a specified set of power circuit breakers in substations, and/or the accumulation of interrupted current squared for that breaker; (2) obtain the number of open and close operations for each member of a specified set of disconnect switches, and/or the elapsed time since the most recent operation of that switch; (3) obtain an approximation to the integral over time of the apparent power through each member of a specified of power transformers during periods of transformer overload, together with the maximum winding or oil temperature of that transformer during each such period; and (4) perform general searches of the database of alarms and events to aid in forensic analyses of past occurrences (for example, what alarms and events were associated with a specified power circuit breaker over a specified date/time interval?). The SCADA system feeds two tables in the Oracle database: (a) analog data (bus voltages, real and reactive power flows through breakers and switches, transformer temperatures, etc.) sampled periodically and retained for a limited period of time; and (b) event and alarm log data, time and date stamped, and kept for a longer, but still limited period of time. The retention period in this database is about one-fifth to one-tenth of that needed for the maintenance user's queries and analyses. Initially, both this database, and the pilot system that accesses it will be restricted to one substation containing 18 power circuit breakers, 33 disconnect switches, and 1 transformer of interest, but later they will be expanded to include all of the Sierra Nevada Region's substations, for a total of 178 breakers, 536 disconnect switches, and 10 transformers of interest. The expansion should not occasion any restructuring of the database of the pilot system (only the addition of new data items into an already extant structure), nor any addition of hardware, other than perhaps some more mass storage. Information may be faxed to (916) 985-1933 or mailed to Western Area Power Adminstration, Attn: J. Buwalda, 114 Parkshore Drive, Folsom, CA 95630. Posted 06/19/00 (W-SN466278). (0171)

Loren Data Corp. http://www.ld.com (SYN# 0249 20000621\70-0010.SOL)