Industries Addressing the 2000-2001 Western Energy Crisis
If you would like to order copies of any of these databases please contact our Public Reference Room by email, and they will provide copies to you for a fee.
It consists of multiple, complex electronic trading systems, which were accessed through a set of programs installed on trader workstations. The total data base storage is around 2.0 TB.
|ERMS||300 GB (estimated)|
|UNIFY Gas (SQL Server)||54 GB|
|UNIFY Financial (SQL Server)||7 GB|
|UNIFY Power (SQL Server)||50 GB (estimated)|
|ENRON Online||112 GB|
|Global Facilities||2 GB|
|Phoenix (Index Rate Server)||20 GB|
|Total Estimated Data to be Hosted||~ 1177 GB|
|Reserved for backups||500 GB|
|Reserved for custom Oracle data sets||300 GB|
|Total Estimated Database Storage||~2.0 TB|
Summary of Enron's Energy Major Business Process
EnronOnline (EOL). EOL, a system providing the trader with an ability to set and control a range of bids/asks and market positions without having to resort to phone calls, and real-time access to energy markets using the Internet. Enron Online (EOL) is a web-based deal capture system to initiate and complete transactions in a variety of commodities, including power and natural gas. These transactions included both the purchase and sale of commodities. EOL supported over 8,000 transactions/day, totaling about $3 billion of energy products daily.
- Stack Manager: The Stack Manager is a special client-server program written in Visual Basic that allowed an Enron trader to create a stack of prices at different volumes for a specific product, and save it to the EOL database.
- The Product Manager is a specialized client-server program written in Visual Basic that allowed Enron Online product managers to create product types and, based on the product types, create products for trading on EOL.
EOL worked in tandem with front-office tools, such as Sitara for physical gas and EnPower, which provided data management capabilities for decision support, such as portfolio management, position management and risk management. Trade information flowed through these systems along multiple paths, depending on the type of trade, whether gas or power, physical or financial, etc
- EnPower- EnPower is the central repository for Electric power trading data. EnPower'sdata storage mechanism consists primarily of relational database tables within Oracle. The EnPower database consists of over 550 relational tables, which contain about 7,900 individual non-unique columns of information. Some of the tables contain over a million rows of information.
- Sitara- The Sitara system was used to capture physical gas deals. Physical gas deals that originated in EOL would also flow into Sitara. Sitara's data storage mechanism consists primarily of relational database tables within Oracle. The primary Sitara database consists of 122 tables with over 1000 data columns. A number of the tables contain over two million rows of data, with some containing over 4 million rows.
- TAGG/ERMS - ERMS is the Energy Risk Management System. It contains transaction information pertaining to physical and financial deals involving gas, financial deals involving power, and physical and financial deals involving all other commodities. Functions provided by ERMS include: risk management, valuation, position management, curve management for rates/pricing, and management reporting. TAGG/ERMS is built on the Oracle database.
- Unify - Unify is the deal settlement processing system within the Enron trade infrastructure. Unify is built on a Microsoft SQL Server 8.0 database running on a Windows 2000 server. Each Unify database has about 490 tables, with over 3500 non-unique columns. There are a number of tables with over a million rows.
- RisktRAC - RisktRAC is the global risk aggregation system. Some of the inputs into RisktRAC are: valued deals from EnPower, MTM (mark to market) data, open position data, and curve data from ERMS. RisktRAC has about 179 tables with over 4900 non-unique columns. A number of tables contain over 10 million rows of data, with some close to 200 million rows
- CPR - The Cash Position Reporting tool works in conjunction with Sitara and allows traders read-only access to data in Sitara. This is to assist the traders in completing their position reporting with regard to gas deals.