{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,10,17]],"date-time":"2026-10-17T19:55:05Z","timestamp":1792266905454,"version":"4.4.0"},"reference-count":21,"publisher":"Association for Computing Machinery (ACM)","issue":"12","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["Proc. VLDB Endow."],"published-print":{"date-parts":[[2012,8]]},"abstract":"<jats:p>In DataCell, we design streaming functionalities in a modern relational database kernel which targets big data analytics. This includes exploitation of both its storage\/execution engine and its optimizer infrastructure. We investigate the opportunities and challenges that arise with such a direction and we show that it carries significant advantages for modern applications in need for online analytics such as web logs, network monitoring and scientific data management. The major challenge then becomes the efficient support for specialized stream features, e.g., multi-query processing and incremental window-based processing as well as exploiting standard DBMS functionalities in a streaming environment such as indexing.<\/jats:p><jats:p>This demo presents DataCell, an extension of the MonetDB open-source column-store for online analytics. The demo gives users the opportunity to experience the features of DataCell such as processing both stream and persistent data and performing window based processing. The demo provides a visual interface to monitor the critical system components, e.g., how query plans transform from typical DBMS query plans to online query plans, how data flows through the query plans as the streams evolve, how DataCell maintains intermediate results in columnar form to avoid repeated evaluation of the same stream portions, etc. The demo also provides the ability to interactively set the test scenarios and various DataCell knobs.<\/jats:p>","DOI":"10.14778\/2367502.2367535","type":"journal-article","created":{"date-parts":[[2014,6,24]],"date-time":"2014-06-24T12:17:57Z","timestamp":1403612277000},"page":"1910-1913","source":"Crossref","is-referenced-by-count":14,"title":["MonetDB\/DataCell"],"prefix":"10.14778","volume":"5","author":[{"given":"Erietta","family":"Liarou","sequence":"first","affiliation":[{"name":"CWI, Amsterdam, The Netherlands"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Stratos","family":"Idreos","sequence":"additional","affiliation":[{"name":"CWI, Amsterdam, The Netherlands"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Stefan","family":"Manegold","sequence":"additional","affiliation":[{"name":"CWI, Amsterdam, The Netherlands"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Martin","family":"Kersten","sequence":"additional","affiliation":[{"name":"CWI, Amsterdam, The Netherlands"}],"role":[{"vocabulary":"crossref","role":"author"}]}],"member":"320","published-online":{"date-parts":[[2012,8]]},"reference":[{"key":"e_1_2_1_1_1","first-page":"466","volume-title":"ICDE","author":"Abadi D.","year":"2007","unstructured":"D. Abadi , D. Myers , D. DeWitt , and S. Madden . Materialization Strategies in a Column-Oriented DBMS . In ICDE , pages 466 -- 475 , 2007 . D. Abadi, D. Myers, D. DeWitt, and S. Madden. Materialization Strategies in a Column-Oriented DBMS. In ICDE, pages 466--475, 2007."},{"issue":"2","key":"e_1_2_1_2_1","first-page":"1558","volume":"2","author":"Ali M. H.","year":"2009","unstructured":"M. H. Ali Microsoft CEP Server and Online Behavioral Targeting. PVLDB , 2 ( 2 ): 1558 -- 1561 , 2009 . M. H. Ali et al. Microsoft CEP Server and Online Behavioral Targeting. PVLDB, 2(2):1558--1561, 2009.","journal-title":"Microsoft CEP Server and Online Behavioral Targeting. PVLDB"},{"issue":"1","key":"e_1_2_1_3_1","first-page":"19","volume":"26","author":"Arasu A.","year":"2003","unstructured":"A. Arasu STREAM: The Stanford Stream Data Manager. IEEE Data Eng. Bull. , 26 ( 1 ): 19 -- 26 , 2003 . A. Arasu et al. STREAM: The Stanford Stream Data Manager. IEEE Data Eng. Bull., 26(1):19--26, 2003.","journal-title":"STREAM: The Stanford Stream Data Manager. IEEE Data Eng. Bull."},{"key":"e_1_2_1_4_1","doi-asserted-by":"publisher","DOI":"10.1007\/s00778-004-0132-6"},{"key":"e_1_2_1_5_1","doi-asserted-by":"publisher","DOI":"10.1007\/s00778-004-0133-5"},{"key":"e_1_2_1_6_1","first-page":"1093","volume-title":"SIGMOD","author":"Biem A.","year":"2010","unstructured":"A. Biem , E. Bouillet , H. Feng , A. Ranganathan , A. Riabov , O. Verscheure , H. Koutsopoulos , and C. Moran . IBM Infosphere Streams for Scalable, Real-time, Intelligent Transportation services . In SIGMOD , pages 1093 -- 1104 , 2010 . 10.1145\/1807167.1807291 A. Biem, E. Bouillet, H. Feng, A. Ranganathan, A. Riabov, O. Verscheure, H. Koutsopoulos, and C. Moran. IBM Infosphere Streams for Scalable, Real-time, Intelligent Transportation services. In SIGMOD, pages 1093--1104, 2010. 10.1145\/1807167.1807291"},{"key":"e_1_2_1_7_1","first-page":"61","volume-title":"SIGMOD","author":"Blakeley J. A.","year":"1986","unstructured":"J. A. Blakeley , P.-\u00c5. Larson, and F. W. Tompa . Efficiently Updating Materialized Views . In SIGMOD , pages 61 -- 71 , 1986 . 10.1145\/16894.16861 J. A. Blakeley, P.-\u00c5. Larson, and F. W. Tompa. Efficiently Updating Materialized Views. In SIGMOD, pages 61--71, 1986. 10.1145\/16894.16861"},{"key":"e_1_2_1_8_1","volume-title":"CIDR","author":"Chandrasekaran S.","year":"2003","unstructured":"S. Chandrasekaran , O. Cooper , A. Deshpande , M. J. Franklin , J. M. Hellerstein , W. Hong , S. Krishnamurthy , S. Madden , V. Raman , F. Reiss , and M. A. Shah . TelegraphCQ: Continuous Data- flow Processing for an Uncertain World . In CIDR , 2003 . 10.1145\/872757.872857 S. Chandrasekaran, O. Cooper, A. Deshpande, M. J. Franklin, J. M. Hellerstein, W. Hong, S. Krishnamurthy, S. Madden, V. Raman, F. Reiss, and M. A. Shah. TelegraphCQ: Continuous Data- flow Processing for an Uncertain World. In CIDR, 2003. 10.1145\/872757.872857"},{"key":"e_1_2_1_9_1","doi-asserted-by":"crossref","first-page":"379","DOI":"10.1145\/342009.335432","volume-title":"SIGMOD","author":"Chen J.","year":"2000","unstructured":"J. Chen , D. J. Dewitt , F. Tian , and Y. Wang . NiagaraCQ: A Scalable Continuous Query System for Internet Databases . In SIGMOD , pages 379 -- 390 , 2000 . 10.1145\/342009.335432 J. Chen, D. J. Dewitt, F. Tian, and Y. Wang. NiagaraCQ: A Scalable Continuous Query System for Internet Databases. In SIGMOD, pages 379--390, 2000. 10.1145\/342009.335432"},{"key":"e_1_2_1_10_1","first-page":"190","volume-title":"DaWaK","author":"Chen Q.","year":"2010","unstructured":"Q. Chen and M. Hsu . Experience in Extending Query Engine for Continuous Analytics . In DaWaK , pages 190 -- 202 , 2010 . Q. Chen and M. Hsu. Experience in Extending Query Engine for Continuous Analytics. In DaWaK, pages 190--202, 2010."},{"key":"e_1_2_1_11_1","doi-asserted-by":"crossref","first-page":"647","DOI":"10.1145\/872757.872838","volume-title":"SIGMOD","author":"Cranor C. D.","year":"2003","unstructured":"C. D. Cranor , T. Johnson , O. Spatscheck , and V. Shkapenyuk . Gigascope: A Stream Database for Network Applications . In SIGMOD , pages 647 -- 651 , 2003 . 10.1145\/872757.872838 C. D. Cranor, T. Johnson, O. Spatscheck, and V. Shkapenyuk. Gigascope: A Stream Database for Network Applications. In SIGMOD, pages 647--651, 2003. 10.1145\/872757.872838"},{"key":"e_1_2_1_12_1","volume-title":"CIDR","author":"Franklin M. J.","year":"2009","unstructured":"M. J. Franklin , S. Krishnamurthy , N. Conway , A. Li , A. Russakovsky , and N. Thombre . Continuous Analytics: Rethinking Query Processing in a Network-Effect World . In CIDR , 2009 . M. J. Franklin, S. Krishnamurthy, N. Conway, A. Li, A. Russakovsky, and N. Thombre. Continuous Analytics: Rethinking Query Processing in a Network-Effect World. In CIDR, 2009."},{"key":"e_1_2_1_13_1","first-page":"397","volume-title":"CIDR","author":"Girod L.","year":"2007","unstructured":"L. Girod , Y. Mei , R. Newton , S. Rost , A. Thiagarajan , H. Balakrishnan , and S. Madden . The Case for a Signal-Oriented Data Stream Management System . In CIDR , pages 397 -- 406 , 2007 . L. Girod, Y. Mei, R. Newton, S. Rost, A. Thiagarajan, H. Balakrishnan, and S. Madden. The Case for a Signal-Oriented Data Stream Management System. In CIDR, pages 397--406, 2007."},{"key":"e_1_2_1_14_1","first-page":"328","volume-title":"SIGMOD","author":"Griffin T.","year":"1995","unstructured":"T. Griffin and L. Libkin . Incremental Maintenance of Views with Duplicates . In SIGMOD , pages 328 -- 339 , 1995 . 10.1145\/223784.223849 T. Griffin and L. Libkin. Incremental Maintenance of Views with Duplicates. In SIGMOD, pages 328--339, 1995. 10.1145\/223784.223849"},{"key":"e_1_2_1_15_1","first-page":"297","volume-title":"SIGMOD","author":"Idreos S.","year":"2009","unstructured":"S. Idreos , M. Kersten , and S. Manegold . Self-organizing Tuple-reconstruction in Column-stores . In SIGMOD , pages 297 -- 308 , 2009 . 10.1145\/1559845.1559878 S. Idreos, M. Kersten, and S. Manegold. Self-organizing Tuple-reconstruction in Column-stores. In SIGMOD, pages 297--308, 2009. 10.1145\/1559845.1559878"},{"key":"e_1_2_1_16_1","doi-asserted-by":"publisher","DOI":"10.1145\/1516360.1516398"},{"key":"e_1_2_1_17_1","unstructured":"MonetDB. http:\/\/www.monetdb.com. MonetDB. http:\/\/www.monetdb.com."},{"key":"e_1_2_1_18_1","doi-asserted-by":"crossref","unstructured":"J. L. Peterson. Petri Nets. ACM Comput. Surv. 9(3):223--252 1977. 10.1145\/356698.356702 J. L. Peterson. Petri Nets. ACM Comput. Surv . 9(3):223--252 1977. 10.1145\/356698.356702","DOI":"10.1145\/356698.356702"},{"key":"e_1_2_1_19_1","unstructured":"PostgreSQL. http:\/\/www.postgresql.org\/. PostgreSQL. http:\/\/www.postgresql.org\/."},{"key":"e_1_2_1_20_1","first-page":"469","volume-title":"VLDB","author":"Schreier U.","year":"1991","unstructured":"U. Schreier , H. Pirahesh , R. Agrawal , and C. Mohan . Alert: An Architecture for Transforming a Passive DBMS into an Active DBMS . In VLDB , pages 469 -- 478 , 1991 . U. Schreier, H. Pirahesh, R. Agrawal, and C. Mohan. Alert: An Architecture for Transforming a Passive DBMS into an Active DBMS. In VLDB, pages 469--478, 1991."},{"key":"e_1_2_1_21_1","doi-asserted-by":"publisher","DOI":"10.1145\/1331904.1331909"}],"container-title":["Proceedings of the VLDB Endowment"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.14778\/2367502.2367535","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2023,7,14]],"date-time":"2023-07-14T14:43:22Z","timestamp":1689345802000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.14778\/2367502.2367535"}},"subtitle":["online analytics in a streaming column-store"],"short-title":[],"issued":{"date-parts":[[2012,8]]},"references-count":21,"journal-issue":{"issue":"12","published-print":{"date-parts":[[2012,8]]}},"alternative-id":["10.14778\/2367502.2367535"],"URL":"https:\/\/doi.org\/10.14778\/2367502.2367535","relation":{},"ISSN":["2150-8097"],"issn-type":[{"value":"2150-8097","type":"print"}],"subject":[],"published":{"date-parts":[[2012,8]]}}}