To read all comments associated with this story, please click here.
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 **




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.......