Technological advances in sensing technologies and wireless telecommunication devices enable research fields related to the management of trajectory data. The challenge after storing the data is the implementation of appropriate analytics for extracting useful knowledge. However, traditional data warehousing systems and techniques were not designed for analyzing trajectory data. In this paper, the authors demonstrate a framework that transforms the traditional data cube model into a trajectory warehouse. As a proof-of-concept, the authors implement T-Warehouse, a system that incorporates all the required steps for Visual Trajectory Data Warehousing, from trajectory reconstruction and ETL processing to Visual OLAP analysis on mobility data.<\/p>","DOI":"10.4018\/jdwm.2011010101","type":"journal-article","created":{"date-parts":[[2011,2,15]],"date-time":"2011-02-15T20:29:07Z","timestamp":1297801747000},"page":"1-23","source":"Crossref","is-referenced-by-count":18,"title":["Visual Mobility Analysis using T-Warehouse"],"prefix":"10.4018","volume":"7","author":[{"given":"A.","family":"Raffaet\u00e0","sequence":"first","affiliation":[{"name":"Universit\u00e0 Ca\u2019 Foscari Venezia, Italy"}]},{"given":"L.","family":"Leonardi","sequence":"additional","affiliation":[{"name":"Universit\u00e0 Ca\u2019 Foscari Venezia, Italy"}]},{"given":"G.","family":"Marketos","sequence":"additional","affiliation":[{"name":"University of Piraeus, Greece"}]},{"given":"G.","family":"Andrienko","sequence":"additional","affiliation":[{"name":"Fraunhofer Institute for Intelligent Analysis and Information Systems, Germany"}]},{"given":"N.","family":"Andrienko","sequence":"additional","affiliation":[{"name":"Fraunhofer Institute for Intelligent Analysis and Information Systems, Germany"}]},{"given":"E.","family":"Frentzos","sequence":"additional","affiliation":[{"name":"University of Piraeus, Greece"}]},{"given":"N.","family":"Giatrakos","sequence":"additional","affiliation":[{"name":"University of Piraeus, Greece"}]},{"given":"S.","family":"Orlando","sequence":"additional","affiliation":[{"name":"Universit\u00e0 Ca\u2019 Foscari Venezia, Italy"}]},{"given":"N.","family":"Pelekis","sequence":"additional","affiliation":[{"name":"University of Piraeus, Greece"}]},{"given":"A.","family":"Roncato","sequence":"additional","affiliation":[{"name":"Universit\u00e0 Ca\u2019 Foscari Venezia, Italy"}]},{"given":"C.","family":"Silvestri","sequence":"additional","affiliation":[{"name":"Universit\u00e0 Ca\u2019 Foscari Venezia, Italy"}]}],"member":"2432","reference":[{"key":"jdwm.2011010101-0","unstructured":"Agarwal, S., Agrawal, R., Deshpande, P., Gupta, A., Naughton, J., Ramakrishnan, R., et al. (1996). On the computation of multidimensional aggregates. In Proceedings of VLDB (pp. 506\u2013521)."},{"key":"jdwm.2011010101-1","doi-asserted-by":"crossref","unstructured":"Andrienko, G., & Andrienko, N. (2008). Spatio-temporal aggregation for visual analysis of movements. In Proceedings of IEEE Symposium on Visual Analytics Science and Technology (pp. 51\u201358). Washington, DC: IEEE Computer Society Press.","DOI":"10.1109\/VAST.2008.4677356"},{"key":"jdwm.2011010101-2","doi-asserted-by":"publisher","DOI":"10.1145\/1345448.1345455"},{"issue":"2","key":"jdwm.2011010101-3","doi-asserted-by":"crossref","first-page":"117","DOI":"10.3138\/carto.42.2.117","article-title":"Designing visual analytics methods for massive collections of movement data.","volume":"42","author":"N.Andrienko","year":"2007","journal-title":"Cartographica"},{"key":"jdwm.2011010101-4","doi-asserted-by":"publisher","DOI":"10.1016\/j.datak.2005.08.001"},{"key":"jdwm.2011010101-5","author":"I.Drecki","year":"2000","journal-title":"Tourism in New Zealand - international visitors on the move (a1 cartographic plate)"},{"key":"jdwm.2011010101-6","doi-asserted-by":"publisher","DOI":"10.1016\/S0167-9473(02)00294-3"},{"key":"jdwm.2011010101-7","doi-asserted-by":"publisher","DOI":"10.1016\/0022-0000(85)90041-8"},{"key":"jdwm.2011010101-8","first-page":"73","article-title":"Information, Place and Cyberspace: Issues in Accessibility","author":"P.Forer","year":"2000","journal-title":"Time and Sequencing: Substitution at the Physical\/Virtual Interface"},{"key":"jdwm.2011010101-9","doi-asserted-by":"crossref","unstructured":"Fredrikson, A., North, C., Plaisant, C., & Shneiderman, B. (1999). Temporal, geographical and categorical aggregations viewed through coordinated displays: a case study with highway incident data. In Proceedings of the Workshop on New Paradigms in Information Visualization and Manipulation (pp. 26\u201334).","DOI":"10.1145\/331770.331780"},{"issue":"3","key":"jdwm.2011010101-10","doi-asserted-by":"crossref","first-page":"28","DOI":"10.4018\/jdwm.2009070102","article-title":"A survey on spatio-temporal data warehousing.","volume":"5","author":"L.G\u00f3mez","year":"2009","journal-title":"International Journal of Data Warehousing and Mining"},{"key":"jdwm.2011010101-11","doi-asserted-by":"publisher","DOI":"10.1023\/A:1009726021843"},{"key":"jdwm.2011010101-12","doi-asserted-by":"publisher","DOI":"10.1080\/13658810701349037"},{"key":"jdwm.2011010101-13","doi-asserted-by":"crossref","unstructured":"Han, J., Stefanovic, N., & Kopersky, K. (1998). Selective materialization: An efficient method for spatial data cube construction. In Proceedings of PAKDD (pp. 144\u2013158).","DOI":"10.1007\/3-540-64383-4_13"},{"key":"jdwm.2011010101-14","unstructured":"Kimball, R., Ross, M., Thornthwaite, W., Mundy, J., & Becker, B. (2008). The Data Warehouse Lifecycle Toolkit, 2nd Edition: Practical Techniques for Building Data Warehouse and Intellingent Business Systems. New York: John Wiley & Sons."},{"key":"jdwm.2011010101-15","doi-asserted-by":"crossref","unstructured":"Marketos, G., Frentzos, E., Ntoutsi, I., Pelekis, N., Raffaet\u00e0, A., & Theodoridis, Y. (2008). Building real world trajectory warehouses. In Proceedings of 7th International ACM Workshop on Data Engineering for Wireless and Mobile Access (pp. 8\u201315).","DOI":"10.1145\/1626536.1626539"},{"issue":"2","key":"jdwm.2011010101-16","doi-asserted-by":"crossref","first-page":"240","DOI":"10.5626\/JCSE.2007.1.2.211","article-title":"Trajectory Data Warehouses: Design and Implementation Issues.","volume":"1","author":"S.Orlando","year":"2007","journal-title":"Journal of Computing Science and Engineering"},{"key":"jdwm.2011010101-17","doi-asserted-by":"crossref","unstructured":"Pelekis, N., Frentzos, E., Giatrakos, N., & Theodoridis, Y. (2008). HERMES: aggregative LBS via a trajectory DB engine. In Proceedings of the ACM SIGMOD International Conference on Management of Data (pp. 1255\u20131258). New York: ACM.","DOI":"10.1145\/1376616.1376748"},{"key":"jdwm.2011010101-18","doi-asserted-by":"crossref","unstructured":"Pelekis, N., Theodoridis, Y., Vosinakis, S., & Panayiotopoulos, T. (2006). Hermes \u2013 a framework for location-based data management. In Proceedings of EDBT (pp. 1130\u20131134).","DOI":"10.1007\/11687238_75"},{"key":"jdwm.2011010101-19","unstructured":"Pfoser, D., Jensen, C. S., & Theodoridis, Y. (2000). Novel Approaches in Query Processing for Moving Object Trajectories. In Proceedings of VLDB (pp. 395\u2013406)."},{"key":"jdwm.2011010101-20","unstructured":"Tao, Y., Kollios, G., Considine, J., Li, F., & Papadias, D. (2004). Spatio-temporal aggregation using sketches. In Proceedings of ICDE (pp. 214\u2013225)."},{"key":"jdwm.2011010101-21","doi-asserted-by":"crossref","unstructured":"Tao, Y., & Papadias, D. (2005). Historical spatio-temporal aggregation. Proceedings of ACM TOIS, 23, 61\u2013102.","DOI":"10.1145\/1055709.1055713"},{"key":"jdwm.2011010101-22","author":"J.Thomas","year":"2005","journal-title":"Illuminating the Path: The Research and development Agenda for Visual Analytics"},{"key":"jdwm.2011010101-23","doi-asserted-by":"publisher","DOI":"10.1559\/152304087783875273"},{"key":"jdwm.2011010101-24","doi-asserted-by":"crossref","unstructured":"Vaisman, A., & Zim\u00e1nyi, E. (2009). What is spatio-temporal data warehousing? In Proceedings of the 11th International Conference on Data Warehousing and Knowledge Discovery (pp. 9\u201323). Berlin: Springer-Verlag.","DOI":"10.1007\/978-3-642-03730-6_2"}],"container-title":["International Journal of Data Warehousing and Mining"],"original-title":[],"language":"ng","link":[{"URL":"https:\/\/www.igi-global.com\/viewtitle.aspx?TitleId=49638","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2022,6,1]],"date-time":"2022-06-01T22:51:16Z","timestamp":1654123876000},"score":1,"resource":{"primary":{"URL":"https:\/\/services.igi-global.com\/resolvedoi\/resolve.aspx?doi=10.4018\/jdwm.2011010101"}},"subtitle":[""],"short-title":[],"issued":{"date-parts":[[2011,1,1]]},"references-count":25,"journal-issue":{"issue":"1","published-print":{"date-parts":[[2011,1]]}},"URL":"https:\/\/doi.org\/10.4018\/jdwm.2011010101","relation":{},"ISSN":["1548-3924","1548-3932"],"issn-type":[{"value":"1548-3924","type":"print"},{"value":"1548-3932","type":"electronic"}],"subject":[],"published":{"date-parts":[[2011,1,1]]}}}