{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,6,19]],"date-time":"2025-06-19T04:24:43Z","timestamp":1750307083587,"version":"3.41.0"},"reference-count":16,"publisher":"Association for Computing Machinery (ACM)","issue":"2","license":[{"start":{"date-parts":[[2012,6,1]],"date-time":"2012-06-01T00:00:00Z","timestamp":1338508800000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/www.acm.org\/publications\/policies\/copyright_policy#Background"}],"content-domain":{"domain":["dl.acm.org"],"crossmark-restriction":true},"short-container-title":["SIGAPP Appl. Comput. Rev."],"published-print":{"date-parts":[[2012,6]]},"abstract":"<jats:p>This paper deals with the design and implementation of a data model and operations for dealing with continuously changing spatial data in Oracle 11g object-relational DBMS. The data model relies on abstract data types but we introduce modifications to the internal structure of the spatiotemporal data representations proposed in the literature, to reduce storage requirements and to enable the reuse of data during the execution of queries. We show how to implement spatiotemporal operations relying on the spatial functions released by the underlying DBMS and how to use the alternative data representations to reduce the volume of temporary data created in the evaluation of spatiotemporal operations. We also demonstrate how to use the proposed data types and operations for storage and manipulation of moving objects data using SQL. Finally, we discuss on the advantages and disadvantages of the proposed solutions.<\/jats:p>","DOI":"10.1145\/2340416.2340417","type":"journal-article","created":{"date-parts":[[2012,7,31]],"date-time":"2012-07-31T13:42:45Z","timestamp":1343742165000},"page":"7-17","update-policy":"https:\/\/doi.org\/10.1145\/crossmark-policy","source":"Crossref","is-referenced-by-count":4,"title":["A spatiotemporal extension for dealing with moving objects with extent in Oracle 11g"],"prefix":"10.1145","volume":"12","author":[{"given":"Lu\u00eds","family":"Matos","sequence":"first","affiliation":[{"name":"University of Aveiro, Aveiro, Portugal"}]},{"given":"Jos\u00e9","family":"Moreira","sequence":"additional","affiliation":[{"name":"University of Aveiro, Aveiro, Portugal"}]},{"given":"Alexandre","family":"Carvalho","sequence":"additional","affiliation":[{"name":"University of Porto, Porto, Portugal"}]}],"member":"320","published-online":{"date-parts":[[2012,6]]},"reference":[{"key":"e_1_2_1_1_1","series-title":"Lecture Notes in Computer Science","doi-asserted-by":"crossref","first-page":"263","DOI":"10.1007\/978-3-540-45081-8_7","volume-title":"Spatio-Temporal Databases: The CHOROCHRONOS Approach","author":"Breunig M.","year":"2003"},{"key":"e_1_2_1_2_1","doi-asserted-by":"publisher","DOI":"10.1016\/j.datak.2008.06.008"},{"key":"e_1_2_1_3_1","doi-asserted-by":"publisher","DOI":"10.1023\/A:1026086723558"},{"key":"e_1_2_1_4_1","doi-asserted-by":"publisher","DOI":"10.1109\/MDM.2006.133"},{"key":"e_1_2_1_5_1","doi-asserted-by":"publisher","DOI":"10.1145\/342009.335426"},{"key":"e_1_2_1_6_1","doi-asserted-by":"publisher","DOI":"10.1023\/A:1011464022461"},{"key":"e_1_2_1_7_1","doi-asserted-by":"publisher","DOI":"10.1145\/352958.352963"},{"key":"e_1_2_1_8_1","doi-asserted-by":"publisher","DOI":"10.1080\/136588100240813"},{"key":"e_1_2_1_9_1","doi-asserted-by":"publisher","DOI":"10.1109\/NCM.2008.31"},{"key":"e_1_2_1_10_1","doi-asserted-by":"publisher","DOI":"10.1109\/RAST.2007.4283959"},{"key":"e_1_2_1_11_1","series-title":"Lecture Notes in Computer Science","volume-title":"editors","author":"Koubarakis M.","year":"2003"},{"key":"e_1_2_1_12_1","doi-asserted-by":"publisher","DOI":"10.1093\/comjnl\/46.6.680"},{"key":"e_1_2_1_14_1","doi-asserted-by":"publisher","DOI":"10.1145\/1376616.1376748"},{"key":"e_1_2_1_16_1","doi-asserted-by":"publisher","DOI":"10.1007\/11687238_75"},{"key":"e_1_2_1_17_1","doi-asserted-by":"publisher","DOI":"10.1007\/s00778-005-0161-9"},{"key":"e_1_2_1_18_1","doi-asserted-by":"publisher","DOI":"10.5555\/1996686.1996707"}],"container-title":["ACM SIGAPP Applied Computing Review"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/2340416.2340417","content-type":"unspecified","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.1145\/2340416.2340417","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,6,18]],"date-time":"2025-06-18T09:34:18Z","timestamp":1750239258000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/2340416.2340417"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2012,6]]},"references-count":16,"journal-issue":{"issue":"2","published-print":{"date-parts":[[2012,6]]}},"alternative-id":["10.1145\/2340416.2340417"],"URL":"https:\/\/doi.org\/10.1145\/2340416.2340417","relation":{},"ISSN":["1559-6915","1931-0161"],"issn-type":[{"type":"print","value":"1559-6915"},{"type":"electronic","value":"1931-0161"}],"subject":[],"published":{"date-parts":[[2012,6]]},"assertion":[{"value":"2012-06-01","order":2,"name":"published","label":"Published","group":{"name":"publication_history","label":"Publication History"}}]}}