Data Warehousing

Overview

The ZEMA Energy Database is one of the most comprehensive energy databases around. No matter what kind of data you want, we either collect it or will collect and centralize it for you. It maintains a full history and continuously updates itself meaning you have as much market data as possible as fresh as possible. This fully automated database meets all your market data needs and integrates with your internal systems and analysis.

Our products create and update a data fortress that resides inside the walls of your organization so that full control and access is yours. Where other providers only offer remote services, we offer solutions that create local rigorous corporate backend systems.

Not only do we collect and centralize external data but we also automate the collection of your internal data. There is no better way to centralize and organize your corporate information. You can store your own forward curves, trade data, generation, meter data or anything else as naturally and easily.

We believe in empowering our clients, that's why we use open architecture solutions…where our competition often use black box, legacy or remote solutions, we use technology that makes sense today. Why access and integrate your systems remotely and allow others to control how you obtain your information when you can do it with proper proven technologies and design?

Integration with your systems is important, so go ahead and integrate with the ZEMA Energy Database.

There is no need for fancy application specific programming languages, you can use standard SQL or connect through any ODBC compliant applications. You can connect to anything including your risk, analytic, trade and settlement systems.

We Collect it all...

• Power Pools and Exchanges
• Stocks, bonds, FX rates, interest rates, options
• Oil, Gas and Power
• Weather
• Brokers, vendors and OTC
• Futures and forwards
• Transmission, pipelines, transportation
• Hydrology, steam flow, precipitation
• Storage and capacity
• Demographics and statistics
• European pricing and FX feeds
• Public, subscription and client data

If it's not on the list, we'll build it in no time.

Why Automation Makes Sense

Is your company still downloading energy market data manually or with ad hoc data loaders from public and vendor source sites? If so, you could be experiencing data entry errors, time delays in getting information, data gaps and unnecessary dependencies on individuals or groups within your own organization. ZEMA can make your operation more efficient and effective when it comes to acquiring energy market data.

Complete automation of your data management process is the only way to ensure data is accurate and highly available to the different department throughout your organization. As a result, ZEMA creates a powerful backend database that can be used in all aspects of trade and analysis and can be fully integrated with your other systems.

Not only do we provide you with a database we provide you with support for building an infrastructure. Our database services include:

• System and Information Flow Analysis
• Data Automation
• System Migration
• Infrastructure Development and Support
• Analysis and Extraction
• Process Flow Audits

ZE PowerGroup offers subscription services that can easily port to your site when you are ready do so. We use the same tools that we license to create our own data fortress that you can access through the web. When integration and ownership are not important, then our subscription service is the way to go.

Our goals are to:

• Ensure data is highly available, timely and accurate
• Make information fully available for integration with downstream systems
• Build a real time and historical market database that is constantly updated
• Rapidly deploy our applications to all your users through web based technologies
• Fully support and maintain the application to handle constant market changes
• Build a scalable solution that grows with your needs
• Save resources and build efficiencies
• Provide a superior and lower cost solution
• Assist in enhancing your profitability and bottom-line

Tech Talk

• Fully Open Architecture Database
• Complete database documentation
• ODBC compliant
• Fully scalable
• Easy to support and maintain
• Rapid integration with your systems
• Relational Database
• Connect using Toad, PL/SQL Developer or other SQL tools
• Create your own views on top of market data