Feed on
Posts
Comments

Archive for August, 2007

SQLite Star Query Part II

Posted in BI, ETL, Palo, SQLite, VBA, excel, olap, xLite on August 31, 2007 | No Comments »

In my previous post I looked at simulating a bitmap-join in SQLite using a sub-query and the INTERSECT command. The problem is of course, this is a simulation, SQLite lacks bitmap indices and although the sub-query will read only the fact table’s index B-trees (avoiding accessing the fact table proper) and should be [...]

Read Full Post »

SQLite Star Query

Posted in BI, ETL, SQLite, olap on August 30, 2007 | 1 Comment »

While investigating the nature of SQLite’s query optimisation strategy I came across this 2004 presentation by D. Richard Hipp which provides a excellent overview of SQLite’s technical architecture. The reason I’m looking at the optimiser is to figure out if SQLite can handle a star-schema query.
First impressions were not promising as [...]

Read Full Post »

10,000 hits …

Posted in news, tagged on August 25, 2007 | 2 Comments »

Sometime during August I recorded my 10,000th hit on this blog. OK, that doesn’t put me in the A-list ( more like the does-anybody-know-what-comes-after-Z-list) but it’s a start. I started the blog in February 2006 as a destination for my del.icio.us feed auto-posts, but my first real post wasn’t until December 2006. [...]

Read Full Post »

It’s still raining….

Posted in Ireland, tagged , , , on August 17, 2007 | 1 Comment »

Fantastic picture from a July post to the Ice Cream Ireland blog. It’s now mid-way through August and it’s still raining…

Read Full Post »

Rain Radar

Posted in Ireland, tagged on August 11, 2007 | No Comments »

As those of you reading this from Ireland or the UK know, this has been a very very very wet summer. The most useful technology for dealing with it has been breathable wet gear on the principle that there’s no such thing as bad weather just bad clothing. But on two occasions this [...]

Read Full Post »

What use is a blog to a small business?

Posted in Ireland, Web2.0, tagged , on August 10, 2007 | No Comments »

In future when Frank Fullard is asked that question (and the associated “What would I blog about?”) he’s going to point to the Ice Cream Ireland site. I’ve been in their shop in Dingle (if you like ice cream you’ll love it) but I was unaware they also had an outlet in Killarney, now [...]

Read Full Post »

Palo 2.0 (beta) released.

Posted in BI, Palo, excel, olap on August 4, 2007 | 1 Comment »

The latest 2.0 version (beta) of Palo has just be released. You can download it here……
The major enhancement over V1.5 is the addition of server-side rules. The rule syntax is similar to that found in TM1 or Essbase e.g. ['Profit%Sales'] = ['Profit']/['Cost of Sales']*100 but Palo rules are restricted to ’stand alone’ [...]

Read Full Post »

Talend and Perl

Posted in ETL, Palo, Talend, olap, tagged on August 3, 2007 | 2 Comments »

I’ve downloaded V2.1 of the open source Talend ETL tool; lots of new connectors added and the Java SQLite connector no longer requires a JNI adapter. I’ve evaluated Talend in the past mainly concentrating on its Java code generating capability, this time I revisited the original Perl generator. Why? Well I know Perl, [...]

Read Full Post »