Streaming tables: Native support to streaming data in DBMSs

IEEE Transactions on Systems, Man, and Cybernetics: Systems

Volumn 47, Issue 10, 2017, Pages 2768-2782

  Carafoli, Luca ^a   Mandreoli, Federica ^a   Martoglia, Riccardo ^a   Penzo, Wilma ^b  

^a UNIVERSITY OF MODENA AND REGGIO EMILIA   (Italy)

^b UNIVERSITY OF BOLOGNA   (Italy)

Author keywords

Continuous queries (CQs); data streams; database design; database management system (DBMS); modeling and management; spatial temporal databases

Indexed keywords

DATABASE SYSTEMS; MANAGEMENT INFORMATION SYSTEMS; QUERY LANGUAGES;

CONTINUOUS QUERIES; DATA STREAM; DATA STREAM MANAGEMENT SYSTEMS; DATA-INTENSIVE APPLICATION; DATABASE DESIGN; EXPERIMENTAL EVALUATION; NOVEL ACCESS; STREAMING DATA;

INFORMATION MANAGEMENT;

EID: 85030123824     PISSN: 21682216     EISSN: 21682232     Source Type: Journal    
DOI: 10.1109/TSMC.2017.2664585     Document Type: Article

References (42)

1. S. Chandrasekaran et al., "TelegraphCQ: Continuous dataflow processing for an uncertain world," in Proc. CIDR, 2003, pp. 269-280
2. J. Chen, D. J. DeWitt, F. Tian, and Y. Wang, "NiagaraCQ: A scalable continuous query system for Internet databases," in Proc. SIGMOD, Dallas, TX, USA, 2000, pp. 379-390
3. A. Sun and M. Hu, "Query-guided event detection from news and blog streams," IEEE Trans. Syst., Man, Cybern. A, Syst., Humans, vol. 41, no. 5, pp. 834-839, Sep. 2011
4. B. Babcock, S. Babu, M. Datar, R. Motwani, and J. Widom, "Models and issues in data stream systems," in Proc. PODS, Madison, WI, USA, 2002, pp. 1-16
5. M. Balazinska, Y. Kwon, N. Kuchta, and D. Lee, "Moirae: History-enhanced monitoring," in Proc. CIDR, 2007, pp. 375-386
6. I. Botan, G. Alonso, P. M. Fischer, D. Kossmann, and N. Tatbul, "Flexible and scalable storage management for data-intensive stream processing," in Proc. EDBT, St. Petersburg, Russia, 2009, pp. 934-945
7. S. Chandrasekaran and M. J. Franklin, "PSoup: A system for streaming queries over streaming data," Int. J. Very Large Data Bases, vol. 12, no. 2, pp. 140-156, 2003
8. M. Franklin et al., "Continuous analytics: Rethinking query processing in a network-effect world," in Proc. CIDR, 2009
9. L. Golab, T. Johnson, J. S. Seidel, and V. Shkapenyuk, "Stream warehousing with DataDepot," in Proc. SIGMOD, Providence, RI, USA, 2009, pp. 847-854
10. K. Tufte et al., "Travel time estimation using NiagaraST and latte," in Proc. SIGMOD, Beijing, China, 2007, pp. 1091-1093
11. The PEGASUS Project. Accessed on Apr. 15, 2016. [Online]. Available: http://www.wilab.org/content/progetto-pegasus
12. D. J. Abadi et al., "Aurora: A new model and architecture for data stream management," Int. J. Very Large Data Bases, vol. 12, no. 2, pp. 120-139, 2003
13. A. Arasu, S. Babu, and J. Widom, "The CQL continuous query language: Semantic foundations and query execution," Int. J. Very Large Data Bases, vol. 15, no. 2, pp. 121-142, 2006
14. S. Chandrasekaran and M. Franklin, "Remembrance of streams past: Overload-sensitive management of archived streams," in Proc. VLDB, Toronto, ON, Canada, 2004, pp. 348-359
15. PipelineDB. Accessed on Apr. 15, 2016. [Online]. Available: https://www.pipelinedb.com
16. U. Cetintemel et al., "S-Store: A streaming NewSQL system for big velocity applications," Proc. Very Large Data Bases Endowment, vol. 7, no. 13, pp. 1633-1636, Aug. 2014
17. Q. Chen and M. Hsu, "Cut-and-rewind: Extending query engine for continuous stream analytics," in Transactions on Large-Scale Dataand Knowledge-Centered Systems XXI (LNCS 9260), A. Hameurlain, J. Kueng, R. Wagner, A. Cuzzocrea, and U. Dayal, Eds. Heidelberg, Germany: Springer, 2015, pp. 94-114
18. E. Liarou, R. Goncalves, and S. Idreos, "Exploiting the power of relational databases for efficient stream processing," in Proc. EDBT, St. Petersburg, Russia, 2009, pp. 323-334
19. E. Liarou, S. Idreos, S. Manegold, and M. Kersten, "Enhanced stream processing in a DBMS kernel," in Proc. EDBT, Genoa, Italy, 2013, pp. 501-512
20. J. Arulraj, A. Pavlo, and P. Menon, "Bridging the archipelago between row-stores and column-stores for hybrid workloads," in Proc. SIGMOD, San Francisco, CA, USA, 2016, pp. 583-598
21. J. Dittrich and A. Jindal, "Towards a one size fits all database architecture," in Proc. CIDR, 2011, pp. 195-198
22. P. Unterbrunner, G. Giannikis, G. Alonso, D. Fauser, and D. Kossmann, "Predictable performance for unpredictable workloads," Proc. Very Large Data Bases Endowment, vol. 2, no. 1, pp. 706-717, 2009
23. R. T. Snodgrass, Ed., The TSQL2 Temporal Query Language. Boston, MA, USA: Kluwer, 1995
24. J. Han, G. Le, and J. Du, "Survey on NoSQL database," in Proc. Int. Conf. Pervasive Comput. Appl. (ICPCA), Port Elizabeth, South Africa, 2011, pp. 363-366
25. A. Arasu et al., "Linear road: A stream data management benchmark," in Proc. VLDB, Wuhan, China, 2004, pp. 480-491
26. U. Srivastava and J. Widom, "Flexible time management in data stream systems," in Proc. PODS, Paris, France, 2004, pp. 263-274
27. S. Abiteboul, R. Hull, and V. Vianu, Foundations of Databases. Reading, MA, USA: Addison-Wesley, 1995
28. L. Golab and M. T. Özsu, "Update-pattern-aware modeling and processing of continuous queries," in Proc. SIGMOD, Baltimore, MD, USA, 2005, pp. 658-669
29. M. Ahuja et al., "Peta-scale data warehousing at Yahoo!" in Proc. SIGMOD, Providence, RI, USA, 2009, pp. 855-862
30. L. Golab, S. Garg, and M. T. Özsu, "On indexing sliding windows over online data streams," in Proc. EDBT, Heraklion, Greece, 2004, pp. 712-729
31. J. M. Hellerstein, M. Stonebraker, and J. Hamilton, "Architecture of a database system," Found. Trends Databases, vol. 1, no. 2, pp. 141-259, 2007
32. H. V. Jagadish, P. P. S. Narayan, S. Seshadri, S. Sudarshan, and R. Kanneganti, "Incremental organization for data recording and warehousing," in Proc. VLDB, Athens, Greece, 1997, pp. 16-25
33. G. Graefe, "B-tree indexes for high update rates," SIGMOD Rec., vol. 35, no. 1, pp. 39-44, 2006
34. N. Shivakumar and H. García-Molina, "Wave-indices: Indexing evolving databases," in Proc. SIGMOD, Tucson, AZ, USA, 1997, pp. 381-392
35. InfoSphere Streams. Accessed on Apr. 15, 2016. [Online]. Available: http://www-03.ibm.com/software/products/us/en/infosphere-streams
36. StreamBase. Accessed on Apr. 15, 2016. [Online]. Available: http://www.streambase.com
37. StreamInsight. Accessed on Apr. 15, 2016. [Online]. Available: http://msdn.microsoft.com/en-us/sqlserver/ee476990.aspx
38. A. Witkowski et al., "Continuous queries in oracle," in Proc. VLDB, Vienna, Austria, 2007, pp. 1173-1184
39. Apache Spark. Accessed on Apr. 15, 2016. [Online]. Available: http://spark.apache.org
40. Apache Storm. Accessed on Apr. 15, 2016. [Online]. Available: http://storm.apache.org
41. L. Carafoli, F. Mandreoli, R. Martoglia, and W. Penzo, "A framework for ITS data management in a smart city scenario," in Proc. SMARTGREENS, Aachen, Germany, 2013, pp. 215-221
42. L. Carafoli, F. Mandreoli, R. Martoglia, and W. Penzo, "A data management middleware for ITS services in smart cities," J. Univers. Comput. Sci., vol. 22, no. 2, pp. 228-246, 2016