Category Archives: Data Warehouse

Vertica for the Cloud

Posted on December 11, 2008 by Jay Jakosky

While I have my head in the clouds, I should mention that Vertica has a cloud solution that they manage for you. Not new, but gives some perspective. With competitive offerings in the $10-20k per terabyte, this is an attractive … Continue reading →

Posted in Data Warehouse, Database | Tagged , , , | 1 Comment

How One-Second Results Change Everything

Posted on September 22, 2008 by Jay Jakosky

There’s a point where query response time is low enough that it changes the analysis game completely. This is the amount of time that a decision maker is willing to wait to get the next answer. Not the first answer, … Continue reading →

Posted in Business Intelligence, Data Warehouse, Interactive Analysis, QlikView | Tagged , , | 3 Comments

InfoBright Open-Source Column-Store DBMS

Posted on September 16, 2008 by Jay Jakosky

I wondered if InfoBright would do this. Before going open-source their website described the product as a kind of bulk-storage and not a data warehouse. A place to put data that you need to remain accessible but which you don’t … Continue reading →

Posted in Data Warehouse, Database, QlikView | Tagged , , , | 7 Comments

Low-Cost Data Analysis & Visualization: It’s Getting Better All The Time

Posted on September 7, 2008 by Jay Jakosky

Over the weekend I have revisited Tableau, enjoyed some success with MonetDB, tried to turn MySQL into a hundred million row data warehouse, been underwhelmed with Firebird, installed Greenplum and spent many frustrated hours with Talend Open Studio, Pentaho Kettle … Continue reading →

Posted in Business Intelligence, Data Warehouse, Database, Interactive Analysis, QlikView, Visualization | Tagged , , , , , , , , | 5 Comments

How well do Netezza, Greenplum, Vertica and others handle 12-way joins?

Posted on November 26, 2007 by Jay Jakosky

In my world, which is corporate software systems, I have a transactional database that is usually in second normal form and has very few aggregates. Building reports directly means joining at least 4 tables, often 8, and sometimes as many … Continue reading →

Posted in Data Warehouse, Database | 4 Comments

2007 Magic Quadrant for Data Warehouse

Posted on October 28, 2007 by Jay Jakosky

Gartner released the updated quadrant for DW DBMS software and appliances. DATAllegro seems too far below Netezza in ability to execute. DATAllegro has large, proven installations. Their recent releases run on Dell blades with EMC storage instead of the customized … Continue reading →

Posted in Data Warehouse, Database | 2 Comments

TeraData Performance at KiloData Prices

Posted on August 7, 2007 by Jay Jakosky

What if you could turn on a massively parallel business intelligence database cluster with a few lines of code? What if you could leverage in-house and outsourced resources for computation and storage as needed? What if you could expand your … Continue reading →

Posted in Business Intelligence, Data Warehouse, Database | Tagged , , , , | Leave a comment

More on Vertica

Posted on February 16, 2007 by Jay Jakosky

The ideas in this paper will be incorporated into the Vertica database product. And unfortunately it won’t be open source. At least that’s what one company employee commented on Slashdot. In the same way that RAID design options (e.g. 1, … Continue reading →

Posted in Data Warehouse, Database | Tagged , , | 2 Comments

What’s Vertica?

Posted on February 16, 2007 by Jay Jakosky

Started by a major contributor to the Ingres and Postgres projects, Vertica is implementing a read-optimized database that is an excellent fit for the data warehouse world. Given the founder’s support of open-source, I expect this company will follow the … Continue reading →

Posted in Data Warehouse, Database | Tagged , , | Leave a comment