News for hackers. Stuff that matters.
Re:Runaway complexity in Big Data... and a plan to stop it by ebiester on Wednesday September 26, 2012 @05:47AM (#4574867)
Perhaps my DBA-fu is limited, but what databases are doing soft real time materialized view maintenance? The big boys seems to do recomputation for materialized views rather than updating the materialized view on insert or update. I tried to google for this, but saw only research papers rather than implementation.

I know that in places I worked, Materialized views were mostly limited in the application realm because too many of them over enough data brought the DB to its knees.

Re:Runaway complexity in Big Data... and a plan to stop it by Evbn on Thursday September 27, 2012 @02:45AM (#4579645)
Oracle updates views on update. Pstgres allows you to write a trigger to do the same.