Update 16.02.2010: I'm allowed now to make the article available as download. It is available HERE.
[ 1 comment ] ( 5 views ) | permalink |
( 2.8 / 104 )An english version of my initially in German published article about building aggregate tables with Firebird is available as download now.
Thanks to Roger Vellacott (Passfield Data Systems Ltd) for proof-reading.
Regards,
Thomas
[ 2 comments ] ( 10 views ) | permalink |
( 3.2 / 253 )My article in German (non German speaking folks, read on) on "Aggregatstabellen mit Firebird" (aggregate tables with Firebird) is now available as download.
This article basically describes a mechanism for pre-aggregating measures in an OLAP database for speeding up aggregate queries, which are common for OLAP scenarios.
The article also presents an implementation of the discussed mechanism in a Firebird 2.1 database in combination with the Open Source OLAP Server Mondrian, which can take advantage of aggregate tables due to its "Query Rewriting" engine.
If there is a bunch of folks out there, who are interested for an English version, I might be able to do that.
The Firebird 2.1 database with the aggregate table implementation is available for a small fee (what would be appropriate? perhaps 15 EUR? contact me, if you are seriously interested).
Thomas
[ 3 comments ] ( 82 views ) | permalink |
( 2.8 / 381 )My article on aggregate tables with Firebird has been published in the current edition of the German magazine Entwickler Magazin. The original title is:
Aggregatstabellen mit Firebird - Performante Abfragen in OLAP-Szenarien mit Aggregatstabellen
The index of contents of this magazine edition is available here.
UPDATE Dec. 2nd, 2008: The article is now available as download. Look here.
Regards,
Thomas
[ add comment ] ( 2 views ) | permalink |
( 2.9 / 254 )I'm a regular author in the German developer magazine Entwickler Magazin of mainly Firebird related articles. With their permission, I'm allowed to make my articles available as download. The articles are in German.
* Edition 03/2004: Serverseitiges Auditing für InterBase
* Edition 05/2004: Roll-Forward-Log für InterBase
* Edition 02/2005: Firebird 1.5
* Edition 05/2005: Eigentümermigration in InterBase und Firebird
* Edition 01/2006: Firebird 2.0 - Teil 1
* Edition 03/2006: Firebird Embedded Server
* Edition 02/2007: Fyracle
* Edition 03/2007: Firebird 2.0 - Teil 2
* Edition 05/2007: Firebird 2.1
* Edition 05/2008: Aggregatstabellen mit Firebird
[ add comment ] ( 3 views ) | permalink |
( 2.8 / 139 )
Calendar
