Linked by Eugenia Loli on Mon 13th Nov 2006 03:17 UTC, submitted by samyem
Databases After 2 years in development, the Firebird Project today officially releases the much-anticipated version 2.0 of its open source Firebird relational database software during the opening session of the fourth international Firebird Conference in Prague, Czech Republic.
Thread beginning with comment 181658
To read all comments associated with this story, please click here.
Materialized views
by djangoxl on Mon 13th Nov 2006 07:24 UTC
djangoxl
Member since:
2006-03-10

Does anyone know if Firebird can handle materialized views? I would love to try it out for a Business Intelligence application.......

Reply Score: 1

RE: Materialized views
by ggeldenhuys on Mon 13th Nov 2006 07:36 in reply to "Materialized views"
ggeldenhuys Member since:
2006-11-13

I didn't know what Materialized views where, so googled it. This is what I found someone else posted a few months back, so not sure if 2.0 supports it.
** Begin Quote **
I think you'll find that materialized views, at least as far as doing refresh-on-commit and query rewriting, are a really advanced feature that only Oracle has. In many warehousing or decision support applications, they are a must have feature that makes the difference between project success and failure.

Assuming you aren't in such a high performance setting, you can often simulate a materialized view by simply populating a transformation table using stored procedures. In such settings, I think either Firebird or PostgreSQL would work fine, cost less, and avoid icky proprietary licence restrictions.
** End Quote **

Reply Parent Score: 1