{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,9,30]],"date-time":"2025-09-30T04:09:58Z","timestamp":1759205398618},"reference-count":34,"publisher":"IGI Global","issue":"2","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":[],"published-print":{"date-parts":[[2019,4]]},"abstract":"<jats:p>In the era of Big Data, more and more stream data is available. In the same way, Decision Support Systems (DSS) tools, such as data warehouses and alert systems, become more and more sophisticated, and conceptual modeling tools are consequently mandatory for successfully DSS projects. Formalisms such as UML and ER have been widely used in the context of classical information and data warehouse systems, but they have not been investigated yet for stream data warehouses to deal with alert systems. Therefore, in this article, the authors introduce the notion of Active Stream Data Warehouse (ASDW) and this article proposes a UML profile for designing Active Stream Data Warehouses. Indeed, this article extends the ICSOLAP profile to take into account continuous and window OLAP queries. Moreover, this article studies the duality of the stream and OLAP decision-making process and the authors propose a set of ECA rules to automatically trigger OLAP operators. The UML profile is implemented in a new OLAP architecture, and it is validated using an environmental case study concerning the wind monitoring.<\/jats:p>","DOI":"10.4018\/ijdwm.2019040101","type":"journal-article","created":{"date-parts":[[2019,3,21]],"date-time":"2019-03-21T17:13:08Z","timestamp":1553188388000},"page":"1-21","source":"Crossref","is-referenced-by-count":5,"title":["Design and Implementation of Active Stream Data Warehouses"],"prefix":"10.4018","volume":"15","author":[{"given":"Sandro","family":"Bimonte","sequence":"first","affiliation":[{"name":"National Research Institute of Science and Technology for Environment and Agriculture, Aubi\u00e8re, France"}]},{"given":"Omar","family":"Boussaid","sequence":"additional","affiliation":[{"name":"Eric Lyon2, Bron, France"}]},{"given":"Michel","family":"Schneider","sequence":"additional","affiliation":[{"name":"LIMOS, Aubiere, France"}]},{"given":"Fabien","family":"Ruelle","sequence":"additional","affiliation":[{"name":"Eric Lyon2, Bron, France"}]}],"member":"2432","reference":[{"key":"IJDWM.2019040101-0","unstructured":"Balazinska, M., Kwon, Y., Kuchta, N., & Lee, D. (2007, January). Moirae: History-Enhanced Monitoring. In CIDR (pp. 375-386)."},{"key":"IJDWM.2019040101-1","doi-asserted-by":"publisher","DOI":"10.4018\/IJDWM.2016100104"},{"key":"IJDWM.2019040101-2","unstructured":"Bokefode, J. D., Modani, D. G., & Babu, A. S. (2013). A novel approach for updates in streaming data warehouses by scalable scheduling. IJERT, 2(7)."},{"key":"IJDWM.2019040101-3","doi-asserted-by":"publisher","DOI":"10.1016\/j.csi.2014.06.004"},{"key":"IJDWM.2019040101-4","doi-asserted-by":"publisher","DOI":"10.1016\/j.datak.2010.02.006"},{"key":"IJDWM.2019040101-5","unstructured":"Esper. (n.d.). Retrieved from http:\/\/www.espertech.com\/"},{"key":"IJDWM.2019040101-6","first-page":"114","volume":"Vol. 11","author":"L.Golab","year":"2011","journal-title":"Consistency in a Stream Warehouse"},{"key":"IJDWM.2019040101-7","doi-asserted-by":"crossref","first-page":"847","DOI":"10.1145\/1559845.1559934","article-title":"Stream warehousing with DataDepot.","author":"L.Golab","year":"2009","journal-title":"Proceedings of the 2009 ACM SIGMOD International Conference on Management of data"},{"key":"IJDWM.2019040101-8","doi-asserted-by":"publisher","DOI":"10.1109\/TKDE.2011.45"},{"key":"IJDWM.2019040101-9","doi-asserted-by":"publisher","DOI":"10.1145\/776985.776986"},{"key":"IJDWM.2019040101-10","doi-asserted-by":"publisher","DOI":"10.4018\/jdwm.2009010101"},{"key":"IJDWM.2019040101-11","author":"W. H.Inmon","year":"1996","journal-title":"Building the Data Warehouse"},{"key":"IJDWM.2019040101-12","first-page":"4","article-title":"Data stream warehousing","author":"T.Johnson","year":"2015","journal-title":"Tidalrace"},{"key":"IJDWM.2019040101-13","author":"R.Kimball","year":"1996","journal-title":"The Data Warehouse Toolkit: Practical Techniques for Building Dimensional Data Warehouses"},{"key":"IJDWM.2019040101-14","article-title":"Analytics over Continuous and DisContinuous (ACDC) Streams: The Truviso Approach.","author":"S.Krishnamurthy","year":"2010","journal-title":"Proc. ACM Sigmod"},{"key":"IJDWM.2019040101-15","unstructured":"Lawrence, H., & Anisha, S. S. (2014). Data Updates on Streaming Data Warehouses Using XOR Based Key Expansion Algorithm. IJESRT, 3(4)."},{"key":"IJDWM.2019040101-16"},{"key":"IJDWM.2019040101-17","unstructured":"Nguyen, T. M., & Tjoa, A. M. (2006). Zero-latency data warehousing (ZLDWH): the state-of-the-art and experimental implementation approaches. In RIVF (pp. 167-176)"},{"key":"IJDWM.2019040101-18","unstructured":"Object Management Group (OMG). (2011). Unified Modeling Language (OMG UML), Infrastructure, Version 2.4, ."},{"key":"IJDWM.2019040101-19","author":"M. M. A.Pandit","journal-title":"Multitrack Algorithm for Updating Streaming Data Warehouses."},{"key":"IJDWM.2019040101-20","doi-asserted-by":"publisher","DOI":"10.1016\/j.jcss.2007.04.008"},{"key":"IJDWM.2019040101-21","doi-asserted-by":"publisher","DOI":"10.1007\/978-1-4419-8656-6"},{"key":"IJDWM.2019040101-22","doi-asserted-by":"crossref","unstructured":"Polyzotis, N. Skiadopoulos, S., Vassiliadis P., Simitsis A., & Frantzell N-E. (2007). Supporting Streaming Updates in an Active DataWarehouse. In IEEE 23rd International Conference on Data Engineering ICDE 2007 (pp. 476-485).","DOI":"10.1109\/ICDE.2007.367893"},{"issue":"4","key":"IJDWM.2019040101-23","first-page":"15","article-title":"Real-Time Business Intelligence for the Utilities Industry.","volume":"3","author":"J.Popeanga","year":"2012","journal-title":"Database Systems Journal"},{"key":"IJDWM.2019040101-24","unstructured":"Postgis. (n.d.). Retrieved from http:\/\/www.postgis.net\/"},{"key":"IJDWM.2019040101-25","unstructured":"Quartet. (n.d.). Retrieved fromhttps:\/\/quartetfs.com\/"},{"key":"IJDWM.2019040101-26","doi-asserted-by":"crossref","unstructured":"Rusu, L., Rahayu, W., & Taniar, D. (2004). On Building XML Data Warehouses. In 5th International Conference on Intelligent Data Engineering and Automated Learning (IDEAL 2004) (pp. 293-299). Springer.","DOI":"10.1007\/978-3-540-28651-6_43"},{"key":"IJDWM.2019040101-27","doi-asserted-by":"publisher","DOI":"10.4018\/jdwm.2005040102"},{"issue":"2","key":"IJDWM.2019040101-28","first-page":"1082","article-title":"An Efficient Algorithm for Update Scheduling in Streaming Data Warehouses.","volume":"5","author":"B.Saikiran","year":"2014","journal-title":"International Journal of Computer Science and Information Technologies"},{"issue":"47","key":"IJDWM.2019040101-29","first-page":"33","article-title":"Operational and real-time Business Intelligence.","volume":"3","author":"D. I.Sandu","year":"2008","journal-title":"Informatica Economic\u0103 Journal"},{"key":"IJDWM.2019040101-30","doi-asserted-by":"publisher","DOI":"10.1109\/2945.981851"},{"key":"IJDWM.2019040101-31","doi-asserted-by":"publisher","DOI":"10.1002\/spe.479"},{"key":"IJDWM.2019040101-32","doi-asserted-by":"publisher","DOI":"10.1016\/S0169-023X(01)00042-8"},{"key":"IJDWM.2019040101-33","doi-asserted-by":"crossref","unstructured":"Torlone, R. (2003). Conceptual multidimensional models. In Multidimensional databases: Problems and solutions (pp. 69-90). Hershey, PA: IGI Global.","DOI":"10.4018\/978-1-59140-053-0.ch003"}],"container-title":["International Journal of Data Warehousing and Mining"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/www.igi-global.com\/viewtitle.aspx?TitleId=225804","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2022,5,5]],"date-time":"2022-05-05T21:49:15Z","timestamp":1651787355000},"score":1,"resource":{"primary":{"URL":"http:\/\/services.igi-global.com\/resolvedoi\/resolve.aspx?doi=10.4018\/IJDWM.2019040101"}},"subtitle":[""],"short-title":[],"issued":{"date-parts":[[2019,4]]},"references-count":34,"journal-issue":{"issue":"2"},"URL":"https:\/\/doi.org\/10.4018\/ijdwm.2019040101","relation":{},"ISSN":["1548-3924","1548-3932"],"issn-type":[{"value":"1548-3924","type":"print"},{"value":"1548-3932","type":"electronic"}],"subject":[],"published":{"date-parts":[[2019,4]]}}}