{"id":"https://openalex.org/W1966825413","doi":"https://doi.org/10.1145/2245276.2245280","title":"Representation and management of spatiotemporal data in object-relational databases","display_name":"Representation and management of spatiotemporal data in object-relational databases","publication_year":2012,"publication_date":"2012-03-26","ids":{"openalex":"https://openalex.org/W1966825413","doi":"https://doi.org/10.1145/2245276.2245280","mag":"1966825413"},"language":"en","primary_location":{"id":"doi:10.1145/2245276.2245280","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2245276.2245280","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 27th Annual ACM Symposium on Applied Computing","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5057707223","display_name":"Lu\u00eds M. O. de Matos","orcid":null},"institutions":[{"id":"https://openalex.org/I60858718","display_name":"University of Aveiro","ror":"https://ror.org/00nt41z93","country_code":"PT","type":"education","lineage":["https://openalex.org/I60858718"]}],"countries":["PT"],"is_corresponding":true,"raw_author_name":"Lu\u00eds Matos","raw_affiliation_strings":["University of Aveiro, Santiago, Portugal","University of Aveiro, Santiago, Portugal#TAB#"],"affiliations":[{"raw_affiliation_string":"University of Aveiro, Santiago, Portugal","institution_ids":["https://openalex.org/I60858718"]},{"raw_affiliation_string":"University of Aveiro, Santiago, Portugal#TAB#","institution_ids":["https://openalex.org/I60858718"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5088231809","display_name":"Jos\u00e9 Moreira","orcid":"https://orcid.org/0000-0003-4633-6944"},"institutions":[{"id":"https://openalex.org/I60858718","display_name":"University of Aveiro","ror":"https://ror.org/00nt41z93","country_code":"PT","type":"education","lineage":["https://openalex.org/I60858718"]}],"countries":["PT"],"is_corresponding":false,"raw_author_name":"Jos\u00e9 Moreira","raw_affiliation_strings":["University of Aveiro, Santiago, Aveiro, Portugal","University of Aveiro, Santiago, Aveiro, Portugal#TAB#"],"affiliations":[{"raw_affiliation_string":"University of Aveiro, Santiago, Aveiro, Portugal","institution_ids":["https://openalex.org/I60858718"]},{"raw_affiliation_string":"University of Aveiro, Santiago, Aveiro, Portugal#TAB#","institution_ids":["https://openalex.org/I60858718"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5004878476","display_name":"Alexandre Carvalho","orcid":"https://orcid.org/0000-0002-4345-6222"},"institutions":[{"id":"https://openalex.org/I182534213","display_name":"Universidade do Porto","ror":"https://ror.org/043pwc612","country_code":"PT","type":"education","lineage":["https://openalex.org/I182534213"]}],"countries":["PT"],"is_corresponding":false,"raw_author_name":"Alexandre Carvalho","raw_affiliation_strings":["University of Porto, Porto, Portugal","University of Porto , Porto, Portugal"],"affiliations":[{"raw_affiliation_string":"University of Porto, Porto, Portugal","institution_ids":["https://openalex.org/I182534213"]},{"raw_affiliation_string":"University of Porto , Porto, Portugal","institution_ids":["https://openalex.org/I182534213"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5057707223"],"corresponding_institution_ids":["https://openalex.org/I60858718"],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":3,"citation_normalized_percentile":{"value":0.04994857,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":94},"biblio":{"volume":null,"issue":null,"first_page":"13","last_page":"20"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9991999864578247,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9991999864578247,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9965999722480774,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10538","display_name":"Data Mining Algorithms and Applications","score":0.9857000112533569,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7929622530937195},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.6404483318328857},{"id":"https://openalex.org/keywords/spatiotemporal-database","display_name":"Spatiotemporal database","score":0.6123972535133362},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5922682285308838},{"id":"https://openalex.org/keywords/representation","display_name":"Representation (politics)","score":0.591356635093689},{"id":"https://openalex.org/keywords/data-model","display_name":"Data model (GIS)","score":0.5868287682533264},{"id":"https://openalex.org/keywords/object","display_name":"Object (grammar)","score":0.563477635383606},{"id":"https://openalex.org/keywords/data-modeling","display_name":"Data modeling","score":0.5464621186256409},{"id":"https://openalex.org/keywords/database-model","display_name":"Database model","score":0.5125800967216492},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.4974870979785919},{"id":"https://openalex.org/keywords/volume","display_name":"Volume (thermodynamics)","score":0.4965894818305969},{"id":"https://openalex.org/keywords/spatial-analysis","display_name":"Spatial analysis","score":0.4678265452384949},{"id":"https://openalex.org/keywords/relational-database-management-system","display_name":"Relational database management system","score":0.45959481596946716},{"id":"https://openalex.org/keywords/data-management","display_name":"Data management","score":0.426556259393692},{"id":"https://openalex.org/keywords/relational-model","display_name":"Relational model","score":0.4251352846622467},{"id":"https://openalex.org/keywords/spatial-database","display_name":"Spatial database","score":0.42060330510139465},{"id":"https://openalex.org/keywords/temporal-database","display_name":"Temporal database","score":0.4190906286239624},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.4118679165840149},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.1845507025718689},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.12711185216903687},{"id":"https://openalex.org/keywords/database-testing","display_name":"Database testing","score":0.10966941714286804}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7929622530937195},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.6404483318328857},{"id":"https://openalex.org/C98080885","wikidata":"https://www.wikidata.org/wiki/Q7574095","display_name":"Spatiotemporal database","level":5,"score":0.6123972535133362},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5922682285308838},{"id":"https://openalex.org/C2776359362","wikidata":"https://www.wikidata.org/wiki/Q2145286","display_name":"Representation (politics)","level":3,"score":0.591356635093689},{"id":"https://openalex.org/C100463513","wikidata":"https://www.wikidata.org/wiki/Q5227322","display_name":"Data model (GIS)","level":2,"score":0.5868287682533264},{"id":"https://openalex.org/C2781238097","wikidata":"https://www.wikidata.org/wiki/Q175026","display_name":"Object (grammar)","level":2,"score":0.563477635383606},{"id":"https://openalex.org/C67186912","wikidata":"https://www.wikidata.org/wiki/Q367664","display_name":"Data modeling","level":2,"score":0.5464621186256409},{"id":"https://openalex.org/C5968703","wikidata":"https://www.wikidata.org/wiki/Q267136","display_name":"Database model","level":3,"score":0.5125800967216492},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.4974870979785919},{"id":"https://openalex.org/C20556612","wikidata":"https://www.wikidata.org/wiki/Q4469374","display_name":"Volume (thermodynamics)","level":2,"score":0.4965894818305969},{"id":"https://openalex.org/C159620131","wikidata":"https://www.wikidata.org/wiki/Q1938983","display_name":"Spatial analysis","level":2,"score":0.4678265452384949},{"id":"https://openalex.org/C24394798","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database management system","level":3,"score":0.45959481596946716},{"id":"https://openalex.org/C1668388","wikidata":"https://www.wikidata.org/wiki/Q1149776","display_name":"Data management","level":2,"score":0.426556259393692},{"id":"https://openalex.org/C40207289","wikidata":"https://www.wikidata.org/wiki/Q755662","display_name":"Relational model","level":3,"score":0.4251352846622467},{"id":"https://openalex.org/C203689450","wikidata":"https://www.wikidata.org/wiki/Q2302053","display_name":"Spatial database","level":3,"score":0.42060330510139465},{"id":"https://openalex.org/C77277458","wikidata":"https://www.wikidata.org/wiki/Q1969246","display_name":"Temporal database","level":2,"score":0.4190906286239624},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.4118679165840149},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.1845507025718689},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.12711185216903687},{"id":"https://openalex.org/C78161392","wikidata":"https://www.wikidata.org/wiki/Q5227414","display_name":"Database testing","level":4,"score":0.10966941714286804},{"id":"https://openalex.org/C17744445","wikidata":"https://www.wikidata.org/wiki/Q36442","display_name":"Political science","level":0,"score":0.0},{"id":"https://openalex.org/C127313418","wikidata":"https://www.wikidata.org/wiki/Q1069","display_name":"Geology","level":0,"score":0.0},{"id":"https://openalex.org/C199539241","wikidata":"https://www.wikidata.org/wiki/Q7748","display_name":"Law","level":1,"score":0.0},{"id":"https://openalex.org/C62520636","wikidata":"https://www.wikidata.org/wiki/Q944","display_name":"Quantum mechanics","level":1,"score":0.0},{"id":"https://openalex.org/C121332964","wikidata":"https://www.wikidata.org/wiki/Q413","display_name":"Physics","level":0,"score":0.0},{"id":"https://openalex.org/C94625758","wikidata":"https://www.wikidata.org/wiki/Q7163","display_name":"Politics","level":2,"score":0.0},{"id":"https://openalex.org/C62649853","wikidata":"https://www.wikidata.org/wiki/Q199687","display_name":"Remote sensing","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/2245276.2245280","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2245276.2245280","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 27th Annual ACM Symposium on Applied Computing","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":18,"referenced_works":["https://openalex.org/W1492921812","https://openalex.org/W1535066875","https://openalex.org/W1568752909","https://openalex.org/W1597347311","https://openalex.org/W1978006057","https://openalex.org/W1983631993","https://openalex.org/W2012490709","https://openalex.org/W2032521898","https://openalex.org/W2038230692","https://openalex.org/W2089045415","https://openalex.org/W2105390081","https://openalex.org/W2115061876","https://openalex.org/W2119366289","https://openalex.org/W2127211454","https://openalex.org/W2128813778","https://openalex.org/W2561675875","https://openalex.org/W2613621456","https://openalex.org/W4253188717"],"related_works":["https://openalex.org/W3085968255","https://openalex.org/W1491042988","https://openalex.org/W1579443643","https://openalex.org/W2045503597","https://openalex.org/W2171091549","https://openalex.org/W4294334189","https://openalex.org/W124328752","https://openalex.org/W2708337673","https://openalex.org/W2483382562","https://openalex.org/W2356400104"],"abstract_inverted_index":{"This":[0],"paper":[1],"deals":[2],"with":[3,16],"the":[4,37,41,47,56,61,64,75,80,87,93,100,109,114],"design":[5],"and":[6,12,53,83,111],"implementation":[7],"of":[8,40,58,63,95,102,113],"a":[9],"data":[10,20,25,30,43,59,89,97],"model":[11,26],"operations":[13,72],"for":[14],"dealing":[15],"continuously":[17],"changing":[18],"spatial":[19,76],"in":[21,46,99],"object-relational":[22],"DBMS.":[23],"The":[24],"relies":[27],"on":[28,74,108],"abstract":[29],"types":[31],"but":[32],"we":[33],"introduce":[34],"modifications":[35],"to":[36,49,54,69,85,91],"internal":[38],"structure":[39],"spatiotemporal":[42,71,103],"representations":[44,90],"proposed":[45,115],"literature,":[48],"reduce":[50,92],"storage":[51],"requirements":[52],"enable":[55],"reutilization":[57],"during":[60],"execution":[62],"queries.":[65],"We":[66,105],"show":[67],"how":[68,84],"implement":[70],"relying":[73],"functions":[77],"released":[78],"by":[79],"underlying":[81],"DBMS":[82],"use":[86],"alternative":[88],"volume":[94],"temporary":[96],"created":[98],"evaluation":[101],"operations.":[104],"also":[106],"discuss":[107],"advantages":[110],"disadvantages":[112],"solutions.":[116]},"counts_by_year":[{"year":2020,"cited_by_count":1},{"year":2019,"cited_by_count":1},{"year":2018,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}