>> +1, This is a smart idea. How did you test it? AFAIK, we can test it
> with:
>
> 1. For any query like SELECT xxx, we create view like CREATE MATERIAL VIEW
> mv_name as SELECT xxx; to test if the features in the query are supported.
No I didn't test the correctness of IVM with TPC-DS data for now.
TPC-DS comes with a data generator and we can test IVM something like:
SELECT * FROM IVM_vew EXCEPT SELECT ... (TPC-DS original query);
If this produces 0 row, then the IVM is correct for the initial data.
(of course actually we need to add appropreate ORDER BY and LIMIT
clause to the SELECT statement for IVM if neccessary).
> 2. Update the data and then compare the result with SELECT XXX with SELECT
> * from mv_name to test if the data is correctly sync.
I wanted to test the data updating but I am still struggling how to
extract correct updating data from TPC-DS data set.
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp