Storage

05:08 PM
Connect Directly
Twitter
RSS
E-Mail
50%
50%

Statistics Firm Switches From Oracle To Postgres

Genscape stores energy stats in Postgres Plus Advanced Server, a relational database system with Oracle-compatible features from EnterpriseDB.

Genscape, a marketer of energy industry statistics to commodities and financial traders, has implemented Postgres Plus Advanced Server in place of Oracle as the system that stores its proprietary data on the North American natural gas market.

Genscape maintains acoustic monitoring devices at major natural gas depots and underground storage chambers. By measuring the sound level of a depot's rumbling pumps and applying its proprietary algorithms, it can determine how much natural gas is being stored in the chamber.

By listening to the whine of gas passing through an open exit valve, it can estimate how much natural gas is being released into distribution pipelines. "Tone tells volume," said Steve Delaney, director of data services at Genscape, in an interview Tuesday.

The combination gives Genscape a set of near real time statistics on the movement of natural gas in the market. When Genscape combines that proprietary information with publicly available information, it has a product that is valuable to energy traders and investors in energy companies, Delaney said.

Genscape stores that information in Postgres Plus Advanced Server, a relational database system with Oracle-compatible features from EnterpriseDB. It is a commercial product based on the PostgreSQL open source code system, and makes reports available in various forms for Genscape to sell as its NatGas RT service.

Energy equity and commodities traders plug Genscape information into their models and use the results to make trades or advise investors on the market, Delaney said.

The Lousiville firm spent up to six months evaluating the alternatives and testing applications before implementing Postgres Plus Advanced Server in place of Oracle last April. In one application, a SQL statement calling for natural gas data to be updated through a particular insert method needed to be changed, as did one SQL query to allow it to perform efficiently with PostgreSQL.

Previous
1 of 2
Next
Comment  | 
Print  | 
More Insights
Cartoon
Hot Topics
4
VMware Launches Hyper-Converged Infrastructure Appliance
Marcia Savage, Managing Editor, Network Computing,  8/25/2014
3
Cloud Storage: How To Pick A Provider
Crystal Bedell, freelance writer,  8/26/2014
3
Aspiring To Smarter Storage
Howard Marks, Network Computing Blogger,  8/21/2014
White Papers
Register for Network Computing Newsletters
Current Issue
Video
Slideshows
Twitter Feed