{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,12,11]],"date-time":"2025-12-11T20:43:21Z","timestamp":1765485801826},"reference-count":36,"publisher":"Association for Computing Machinery (ACM)","issue":"10","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["Proc. VLDB Endow."],"published-print":{"date-parts":[[2012,6]]},"abstract":"<jats:p>Applications ranging from algorithmic trading to scientific data analysis require realtime analytics based on views over databases that change at very high rates. Such views have to be kept fresh at low maintenance cost and latencies. At the same time, these views have to support classical SQL, rather than window semantics, to enable applications that combine current with aged or historical data.<\/jats:p>\n          <jats:p>\n            In this paper, we present\n            <jats:italic>viewlet transforms<\/jats:italic>\n            , a recursive finite differencing technique applied to queries. The viewlet transform materializes a query and a set of its higher-order deltas as views. These views support each other's incremental maintenance, leading to a reduced overall view maintenance cost. The viewlet transform of a query admits efficient evaluation, the elimination of certain expensive query operations, and aggressive parallelization. We develop viewlet transforms into a workable query execution technique, present a heuristic and cost-based optimization framework, and report on experiments with a prototype dynamic data management system that combines viewlet transforms with an optimizing compilation technique. The system supports tens of thousands of complete view refreshes a second for a wide range of queries.\n          <\/jats:p>","DOI":"10.14778\/2336664.2336670","type":"journal-article","created":{"date-parts":[[2014,6,24]],"date-time":"2014-06-24T12:17:57Z","timestamp":1403612277000},"page":"968-979","source":"Crossref","is-referenced-by-count":72,"title":["DBToaster"],"prefix":"10.14778","volume":"5","author":[{"given":"Yanif","family":"Ahmad","sequence":"first","affiliation":[{"name":"Johns Hopkins University"}]},{"given":"Oliver","family":"Kennedy","sequence":"additional","affiliation":[{"name":"\u00c9cole Polytechnique F\u00e9d\u00e9rale de Lausanne"}]},{"given":"Christoph","family":"Koch","sequence":"additional","affiliation":[{"name":"\u00c9cole Polytechnique F\u00e9d\u00e9rale de Lausanne"}]},{"given":"Milos","family":"Nikolic","sequence":"additional","affiliation":[{"name":"\u00c9cole Polytechnique F\u00e9d\u00e9rale de Lausanne"}]}],"member":"320","published-online":{"date-parts":[[2012,6]]},"reference":[{"key":"e_1_2_1_1_1","first-page":"277","volume-title":"CIDR","author":"Abadi D.","year":"2005","unstructured":"D. Abadi , Y. Ahmad , M. Balazinska , U. Cetintemel , M. Cherniack , J. Hwang , W. Lindner , A. Maskey , A. Rasin , E. Ryvkina , The design of the Borealis stream processing engine . In CIDR , pages 277 -- 289 , 2005 . D. Abadi, Y. Ahmad, M. Balazinska, U. Cetintemel, M. Cherniack, J. Hwang, W. Lindner, A. Maskey, A. Rasin, E. Ryvkina, et al. The design of the Borealis stream processing engine. In CIDR, pages 277--289, 2005."},{"key":"e_1_2_1_2_1","first-page":"496","volume-title":"VLDB","author":"Agrawal S.","year":"2000","unstructured":"S. Agrawal , S. Chaudhuri , and V. R. Narasayya . Automated selection of materialized views and indexes in SQL databases . In VLDB , pages 496 -- 505 , 2000 . S. Agrawal, S. Chaudhuri, and V. R. Narasayya. Automated selection of materialized views and indexes in SQL databases. In VLDB, pages 496--505, 2000."},{"key":"e_1_2_1_3_1","doi-asserted-by":"publisher","DOI":"10.14778\/1687553.1687592"},{"key":"e_1_2_1_4_1","doi-asserted-by":"publisher","DOI":"10.1145\/202106.202107"},{"key":"e_1_2_1_5_1","doi-asserted-by":"publisher","DOI":"10.1109\/18.825794"},{"key":"e_1_2_1_6_1","doi-asserted-by":"publisher","DOI":"10.1145\/16894.16861"},{"key":"e_1_2_1_7_1","doi-asserted-by":"publisher","DOI":"10.1145\/320083.320099"},{"key":"e_1_2_1_8_1","doi-asserted-by":"publisher","DOI":"10.5555\/645480.655434"},{"key":"e_1_2_1_9_1","doi-asserted-by":"publisher","DOI":"10.1145\/233269.233364"},{"key":"e_1_2_1_10_1","doi-asserted-by":"publisher","DOI":"10.1145\/253260.253353"},{"key":"e_1_2_1_11_1","doi-asserted-by":"publisher","DOI":"10.1145\/1061318.1061325"},{"key":"e_1_2_1_12_1","doi-asserted-by":"publisher","DOI":"10.1145\/582353.582380"},{"key":"e_1_2_1_13_1","doi-asserted-by":"publisher","DOI":"10.1145\/1670243.1670244"},{"key":"e_1_2_1_14_1","doi-asserted-by":"publisher","DOI":"10.1145\/223784.223849"},{"key":"e_1_2_1_15_1","doi-asserted-by":"publisher","DOI":"10.1145\/170035.170066"},{"key":"e_1_2_1_16_1","doi-asserted-by":"publisher","DOI":"10.1109\/TKDE.2005.16"},{"key":"e_1_2_1_17_1","first-page":"202","volume-title":"DBPL","author":"Kawaguchi A.","year":"1997","unstructured":"A. Kawaguchi , D. F. Lieuwen , I. S. Mumick , and K. A. Ross . Implementing incremental view maintenance in nested data models . In DBPL , pages 202 -- 221 , 1997 . A. Kawaguchi, D. F. Lieuwen, I. S. Mumick, and K. A. Ross. Implementing incremental view maintenance in nested data models. In DBPL, pages 202--221, 1997."},{"key":"e_1_2_1_18_1","first-page":"284","volume-title":"CIDR","author":"Kennedy O.","year":"2011","unstructured":"O. Kennedy , Y. Ahmad , and C. Koch . DBToaster: Agile views for a dynamic data management system . In CIDR , pages 284 -- 295 , 2011 . O. Kennedy, Y. Ahmad, and C. Koch. DBToaster: Agile views for a dynamic data management system. In CIDR, pages 284--295, 2011."},{"key":"e_1_2_1_19_1","doi-asserted-by":"publisher","DOI":"10.1145\/1807085.1807100"},{"key":"e_1_2_1_20_1","doi-asserted-by":"publisher","DOI":"10.1145\/503099.503100"},{"key":"e_1_2_1_21_1","doi-asserted-by":"publisher","DOI":"10.1145\/1142473.1142543"},{"key":"e_1_2_1_22_1","first-page":"56","volume-title":"ICDE","author":"Zhou J.","year":"2007","unstructured":"P.-\u00c5. Larson and J. Zhou . Efficient maintenance of materialized outer-join views . In ICDE , pages 56 -- 65 , 2007 . P.-\u00c5. Larson and J. Zhou. Efficient maintenance of materialized outer-join views. In ICDE, pages 56--65, 2007."},{"key":"e_1_2_1_23_1","doi-asserted-by":"publisher","DOI":"10.1145\/291889.291895"},{"key":"e_1_2_1_24_1","volume-title":"CIDR","author":"Motwani R.","year":"2003","unstructured":"R. Motwani , J. Widom , et. al. Query processing, approximation, and resource management in a data stream management system . In CIDR , 2003 . R. Motwani, J. Widom, et. al. Query processing, approximation, and resource management in a data stream management system. In CIDR, 2003."},{"key":"e_1_2_1_25_1","doi-asserted-by":"publisher","DOI":"10.5555\/1287369.1287438"},{"key":"e_1_2_1_26_1","doi-asserted-by":"publisher","DOI":"10.1145\/1190216.1190242"},{"key":"e_1_2_1_27_1","doi-asserted-by":"publisher","DOI":"10.1145\/233269.233361"},{"key":"e_1_2_1_28_1","doi-asserted-by":"publisher","DOI":"10.1145\/111197.111215"},{"key":"e_1_2_1_29_1","doi-asserted-by":"publisher","DOI":"10.1145\/342009.335393"},{"key":"e_1_2_1_30_1","doi-asserted-by":"publisher","DOI":"10.5555\/1315451.1315479"},{"key":"e_1_2_1_31_1","unstructured":"Transaction Processing Performance Council. TPC-H benchmark specification. http:\/\/www.tpc.org\/hspec.html.  Transaction Processing Performance Council. TPC-H benchmark specification. http:\/\/www.tpc.org\/hspec.html."},{"key":"e_1_2_1_32_1","doi-asserted-by":"publisher","DOI":"10.1145\/564691.564697"},{"key":"e_1_2_1_33_1","doi-asserted-by":"publisher","DOI":"10.1007\/s00778-003-0107-z"},{"key":"e_1_2_1_34_1","first-page":"231","volume-title":"VLDB","author":"Zhou J.","year":"2007","unstructured":"J. Zhou , P.-\u00c5. Larson, H. G. Elmongui . Lazy maintenance of materialized views . In VLDB , pages 231 -- 242 , 2007 . J. Zhou, P.-\u00c5. Larson, H. G. Elmongui. Lazy maintenance of materialized views. In VLDB, pages 231--242, 2007."},{"key":"e_1_2_1_35_1","doi-asserted-by":"publisher","DOI":"10.1145\/1247480.1247540"},{"key":"e_1_2_1_36_1","first-page":"180","volume-title":"ICAC","author":"Zilio D. C.","year":"2004","unstructured":"D. C. Zilio , C. Zuzarte , S. Lightstone , W. Ma , G. M. Lohman , R. Cochrane , H. Pirahesh , L. S. Colby , J. Gryz , E. Alton , D. Liang , and G. Valentin . Recommending materialized views and indexes with IBM DB2 design advisor . In ICAC , pages 180 -- 188 , 2004 . D. C. Zilio, C. Zuzarte, S. Lightstone, W. Ma, G. M. Lohman, R. Cochrane, H. Pirahesh, L. S. Colby, J. Gryz, E. Alton, D. Liang, and G. Valentin. Recommending materialized views and indexes with IBM DB2 design advisor. In ICAC, pages 180--188, 2004."}],"container-title":["Proceedings of the VLDB Endowment"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.14778\/2336664.2336670","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2022,12,28]],"date-time":"2022-12-28T10:45:46Z","timestamp":1672224346000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.14778\/2336664.2336670"}},"subtitle":["higher-order delta processing for dynamic, frequently fresh views"],"short-title":[],"issued":{"date-parts":[[2012,6]]},"references-count":36,"journal-issue":{"issue":"10","published-print":{"date-parts":[[2012,6]]}},"alternative-id":["10.14778\/2336664.2336670"],"URL":"https:\/\/doi.org\/10.14778\/2336664.2336670","relation":{},"ISSN":["2150-8097"],"issn-type":[{"value":"2150-8097","type":"print"}],"subject":[],"published":{"date-parts":[[2012,6]]}}}