Kevin M. Coonan, M.D. wrote: >Shouldn't heavy weight queries be limited to a separate OLAP platform? This > > This is what I have seen at a large data-processing company where I used to work for. They ran separate tables, optimized for OLAP-queries (wide flat ugly tables with lots of data-redundancy), some tables were kept up to date with triggers, other OLAP tables were updated once every day at night with SQL-select/insert-queries, depending on the purpose. The 'normal' data processing application did not suffer from noteable performance lost.
Oracle supports this in SQL. REFRESH and FAST are optional They call it MATERIALIZED VIEW, http://www.akadia.com/services/ora_materialized_views.html CREATE MATERIALIZED VIEW mv_emp_pk REFRESH FAST START WITH SYSDATE NEXT SYSDATE + 1/48 WITH PRIMARY KEY AS SELECT * FROM emp at remote_db; Bert
