CERTS Database Brochure

To facilitate research in restructured electricity markets, the Consortium for Electric Reliability Technology Solutions (CERTS) has been collecting and maintaining a database of California electricity market information that covers the entire period that the California Power Exchange (CalPX) and California Independent System Operator (CAISO) have been operating, that is, since 1 April 1998. All data currently in place are in the public domain. To the best of our knowledge, this is the most complete data set freely available with up-to-date data from each California market. In June 2000, with funding from the Department of Energy (DoE), Berkeley Lab initiated the process of building a database on a more robust and readily accessible platform, that is, an Oracle 8i database running on Solaris with web-enabled query capability. The maintenance of such a database enhances the ability of CERTS to conduct research on reliability of power systems in restructured markets, electricity market operation, and efficient design of competitive electricity markets. This document describes the database as it currently exists and plans for its improvement.