Goodman on BI
Sun Apr 24 04:14:12 EDT 2011
Home: http://www.nicholasgoodman.com/bt/blog
Feed: http://www.bayontechnologies.com/bt/blog/index.xml

Why OLAP4J 1.0 matters - Julian Hyde and his cohorts on the Mondrian project have been busy at work for nearly 5 years (spec 0.5 done in 2006!) working on the difficult, but worthwhile effort of standardizing client side access to OLAP in Java. They just released version 1.0! This is a big deal; bigger players have attempted and failed [...]

Column Store 101 - I’m often asked, as an initial question of why LucidDB can perform so much better than traditional row store databases like Oracle, SQLServer, DB2, MySQL is HOW? There’s a bunch of reasons and we have entire sections of our Wiki dedicated to the topic, but first and foremost is corner stone of almost every analytic [...]

LucidDB has a new Logo/Mascot - At yesterdays Eigenbase Developer Meetup at SQLstream‘s offices in San Francisco we arrived at a new logo for LucidDB.  DynamoBI is thrilled to have supported and funded the design contest to arrive at our new mascot.  Over the coming months you’ll see the logo make it’s way out to the existing luciddb.org sites, wiki sites, [...]

SaaS or On Site? Who cares with Pentaho On Demand - Pentaho launched their On Demand initiative today: Press Release. While the launch is new, I know that Pentaho has already onboarded some customers in a quiet soft launch and the response has been very positive.  Why wouldn’t it be?  This offering is the best of both worlds, and makes purchasing a business department driven BI [...]

Encrypt PDI passwords - PDI has a basic obfuscation method for making it difficult for casual people to lift passwords for DB connections. I have customers that maintain different versions of a “shared.xml” file that maintain different physical connections to databases (think development, QA/testing, and production). In order to generate the different shared.xml, a user has to usually (per [...]

Asking this question means you don’t get BI market - In almost every technology company, if you’re explaining your business model savvy technology executives ask the question: Who are you selling this too?  What’s his/her title, where does he work?  What’s the size of their company? It’s a question that helps the questioner understand, and the responder clarify exactly who is buying the product.  This [...]

DynamoDB: Time Dimension table with MERGE - So, even with my disclaimer note on the last blog, the DynamoDB developers slapped me around a bit for suggesting using a view for a Time Dimension. The Time Dimension is the most important dimension table and should be an actual table, not a view. Creating the table allows us to perform all kinds of [...]

DynamoDB: Built in Time Dimension support! - DynamoDB (aka LucidDB) is not just another column store database. Our goal is being the best database for actually doing Business Intelligence; while that means being fast and handling large amounts of data there’s a lot of other things BI consultant/developers need. I’ll continue to post about some of the great BI features that DynamoDB [...]

Book Review: Pentaho Reporting 3.5 for Java Developers - I have two customers that if they had access to Will Gormans book, Pentaho Reporting 3.5 for Java Developers, they would not have needed me for their project! That’s how good the book is for those who need to embed Pentaho Reporting into their Java application. The book is certainly geared towards Java developers, and [...]

Dreamhost Uptime Numbers are TERRIBLE! - I don’t care what their marketing stats say, I have my own indepedent verification. I’ve been using Wormly for quite a while monitoring some of my demo sites, and other services that are part of Bayon and part of Dynamo. Since I was already paying for it, I figured I’d turn it loose on this [...]