{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,3,11]],"date-time":"2025-03-11T04:22:44Z","timestamp":1741666964844,"version":"3.38.0"},"reference-count":19,"publisher":"SAGE Publications","issue":"4","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["IDT"],"published-print":{"date-parts":[[2022,12,20]]},"abstract":"<jats:p>A trajectory is a set of traces left by a moving object. It contains spatio-temporal information about where and when that object was, as well as other semantical relevant information. It is described by a continuation of movement. Data concerning moving objects and their trajectories can be stored in a Trajectory Data Warehouses for organization, managing, and analysis purposes. This work is dedicated to semantic trajectory data warehouses. A logical schema is proposed, called S-TrODW, where an object relational framework is used. The main novelty of the S-TrODW model is the integration of trajectories and their segments in the fact table by means of a nested relation. An algorithm is presented for transforming the flat star schema (with non-nested trajectory segments) to the S-TrODW schema. The proposal is validated through a case study dealing with freight transportation. A more natural modelling and queries formulation, as well as the improvement of query execution time are among the contributions of this paper compared to other works.<\/jats:p>","DOI":"10.3233\/idt-220123","type":"journal-article","created":{"date-parts":[[2022,11,29]],"date-time":"2022-11-29T16:19:38Z","timestamp":1669738778000},"page":"679-690","source":"Crossref","is-referenced-by-count":1,"title":["A novel approach for handling semantic trajectories on data warehouses"],"prefix":"10.1177","volume":"16","author":[{"given":"Georgia","family":"Garani","sequence":"first","affiliation":[{"name":"University of Thessaly, Gaiopolis, Larisa, Greece"}]},{"given":"Francisco Javier Moreno","family":"Arboleda","sequence":"additional","affiliation":[{"name":"Universidad Nacional de Colombia, Sede Medell\u00edn, Colombia"}]},{"given":"Vassilios S.","family":"Verykios","sequence":"additional","affiliation":[{"name":"School of Science and Technology, Hellenic Open University, Patras, Greece"}]}],"member":"179","reference":[{"unstructured":"Inmon WH. Building the Data Warehouse. 4th ed. Indianapolis (IND): Wiley Publishing; 2005.","key":"10.3233\/IDT-220123_ref1"},{"issue":"3","key":"10.3233\/IDT-220123_ref2","doi-asserted-by":"publisher","first-page":"1","DOI":"10.5121\/ijmit.2010.2301","article-title":"Mobile Information Collectors\u2019 Trajectory Data Warehouse Design","volume":"2","author":"Oueslati","year":"2010","journal-title":"Int J Manag Inf Technol"},{"key":"10.3233\/IDT-220123_ref3","first-page":"8","article-title":"A Framework for Trajectory Data Warehousing","author":"Marketos","year":"2008","journal-title":"7th ACM International Workshop on Data Engineering for Wireless and Mobile Access 2008; 2008 Jun 13; Vancouver"},{"issue":"170","key":"10.3233\/IDT-220123_ref4","doi-asserted-by":"publisher","first-page":"1","DOI":"10.3390\/ijgi8040170","article-title":"Mobility Data Warehouses","volume":"8","author":"Vaisman","year":"2019","journal-title":"ISPRS Int J Geo-Inf"},{"key":"10.3233\/IDT-220123_ref5","first-page":"407","article-title":"Analysing trajectories of mobile users: from data warehouses to recommender systems","volume":"31","author":"Nardini","year":"2018","journal-title":"A Comprehensive Guide Through the Italian Database Research Over the Last 25 Years. Studies in Big Data"},{"issue":"2","key":"10.3233\/IDT-220123_ref6","doi-asserted-by":"publisher","first-page":"240","DOI":"10.5626\/JCSE.2007.1.2.211","article-title":"Trajectory data warehouses: design and implementation issues","volume":"1","author":"Orlando","year":"2007","journal-title":"J Comput Sci Eng"},{"issue":"3","key":"10.3233\/IDT-220123_ref7","doi-asserted-by":"publisher","first-page":"1","DOI":"10.5753\/jidm.2011.1421","article-title":"From Conceptual Modeling to Logical Representation of Trajectories in DBMS-OR and DW Systems","volume":"2","author":"Leal","year":"2011","journal-title":"J Inf Data Manag"},{"key":"10.3233\/IDT-220123_ref8","first-page":"57","article-title":"Modeling Herd Trajectory Data Warehouse","author":"Arfaoui","year":"2011","journal-title":"SSRG Int J Eng Trends Technol"},{"key":"10.3233\/IDT-220123_ref9","doi-asserted-by":"publisher","first-page":"6","DOI":"10.1109\/TIME.2012.29","article-title":"Spatio-temporal Data Warehouses and Mobility Data: Current Status and Research Issues","author":"Zim\u00e1nyi","year":"2012","journal-title":"Proceedings of 19th International Symposium on Temporal Representation and Reasoning 2012"},{"key":"10.3233\/IDT-220123_ref10","doi-asserted-by":"crossref","first-page":"47","DOI":"10.1145\/2666158.2666180","article-title":"A Semantic Model for Movement Data Warehouses","author":"Fileto","year":"2014","journal-title":"Proceedings of 17th International Workshop on Data Warehousing and OLAP 2014"},{"key":"10.3233\/IDT-220123_ref11","doi-asserted-by":"publisher","first-page":"273","DOI":"10.1007\/s10707-013-0181-3","article-title":"A general framework for trajectory data warehousing and visual OLAP","volume":"18","author":"Leonardi","year":"2014","journal-title":"Geoinformatica"},{"key":"10.3233\/IDT-220123_ref12","doi-asserted-by":"publisher","first-page":"83","DOI":"10.4018\/978-1-5225-5516-2.ch004","article-title":"A Trajectory Ontology Design Pattern for Semantic Trajectory Data Warehouses: Behavior Analysis and Animal Tracking Case Studies","author":"Manaa","year":"2019","journal-title":"Emerging Perspectives in Big Data Warehousing"},{"issue":"1","key":"10.3233\/IDT-220123_ref13","doi-asserted-by":"publisher","first-page":"53","DOI":"10.1007\/s41324-019-00269-x","article-title":"A Survey on Trajectory Data Warehouse","volume":"28","author":"Alsahfi","year":"2020","journal-title":"Spat Inf Res"},{"issue":"1","key":"10.3233\/IDT-220123_ref14","doi-asserted-by":"publisher","first-page":"1","DOI":"10.1007\/s13755-020-00117-5","article-title":"A semantic trajectory data warehouse for improving nursing productivity","volume":"8","author":"Garani","year":"2020","journal-title":"Health Inf Sci Syst"},{"issue":"4","key":"10.3233\/IDT-220123_ref15","doi-asserted-by":"publisher","first-page":"22","DOI":"10.4018\/jdwm.2012100102","article-title":"Integrating Star and Snowflake Schemas in Data Warehouses","volume":"8","author":"Garani","year":"2012","journal-title":"Int J Data Warehous Min"},{"key":"10.3233\/IDT-220123_ref16","doi-asserted-by":"crossref","first-page":"127","DOI":"10.1007\/978-3-319-14139-8_15","article-title":"Mob-Warehouse: a semantic approach for mobility analysis with a trajectory data warehouse","volume":"8697","author":"Wagner","year":"2014","journal-title":"Advances in Conceptual Modeling. ER Workshops: Proceedings of International Conference on Conceptual Modeling"},{"issue":"4","key":"10.3233\/IDT-220123_ref17","doi-asserted-by":"publisher","first-page":"279","DOI":"10.3233\/IDT-130169","article-title":"An Improved Approach for Automatic Selection of Multi-tables Indexes in Ralational Data Warehouses Using Maximal Frequent Itemsets","volume":"7","author":"Ziani","year":"2013","journal-title":"Intell Decis Technol"},{"key":"10.3233\/IDT-220123_ref18","doi-asserted-by":"publisher","first-page":"1","DOI":"10.1109\/ECACE.2019.8679429","article-title":"Solving Multiple Depot Vehicle Routing Problem (MDVRP) using Genetic Algorithm","author":"Mahmud","year":"2019","journal-title":"Proceedings of International Conference on Electrical, Computer and Communication Engineering 2019"},{"key":"10.3233\/IDT-220123_ref19","doi-asserted-by":"crossref","first-page":"213","DOI":"10.1007\/978-3-540-75177-9_9","article-title":"Privacy and Security in Spatio-temporal Data and Trajectories","author":"Verykios","year":"2008","journal-title":"Mobility, Data Mining and Privacy"}],"container-title":["Intelligent Decision Technologies"],"original-title":[],"link":[{"URL":"https:\/\/content.iospress.com\/download?id=10.3233\/IDT-220123","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,3,10]],"date-time":"2025-03-10T15:58:03Z","timestamp":1741622283000},"score":1,"resource":{"primary":{"URL":"https:\/\/journals.sagepub.com\/doi\/full\/10.3233\/IDT-220123"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2022,12,20]]},"references-count":19,"journal-issue":{"issue":"4"},"URL":"https:\/\/doi.org\/10.3233\/idt-220123","relation":{},"ISSN":["1872-4981","1875-8843"],"issn-type":[{"type":"print","value":"1872-4981"},{"type":"electronic","value":"1875-8843"}],"subject":[],"published":{"date-parts":[[2022,12,20]]}}}