Tag Archives: Database

Writeback in QlikView

Posted on July 2, 2011 by Jay Jakosky

The ability to push data from QlikView back out to a database is beneficial for what-if analysis, financial reporting, CRM dashboards and more. Unfortunately our ability to achieve this, even using custom code, is limited. On the frontend, there are … Continue reading →

Posted in QlikView | Tagged , , , , | 2 Comments

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

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

Improving The Load Process With Multiple ODBC Connections

Posted on August 15, 2008 by Jay Jakosky

One of the most useful tricks shared at the QlikView conference was from Nik Boman on improving the data extraction from databases. ODBC is a slow protocol, running orders of magnitude slower than the database or a typical Ethernet connection. … Continue reading →

Posted in Database, QlikView | Tagged , | 3 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

Heartbeat

Posted on March 28, 2007 by Jay Jakosky

I am glad to hear in a presentation from Vertica, that they will be releasing their product for free use under a certain data set size. I do not know if this is intended to distinguish developers from production systems … Continue reading →

Posted in Database, QlikView, Visualization | 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