{"id":"https://openalex.org/W4388822797","doi":"https://doi.org/10.1007/s10115-023-02009-y","title":"How to manage massive spatiotemporal dataset from stationary and non-stationary sensors in commercial DBMS?","display_name":"How to manage massive spatiotemporal dataset from stationary and non-stationary sensors in commercial DBMS?","publication_year":2023,"publication_date":"2023-11-20","ids":{"openalex":"https://openalex.org/W4388822797","doi":"https://doi.org/10.1007/s10115-023-02009-y"},"language":"en","primary_location":{"id":"doi:10.1007/s10115-023-02009-y","is_oa":true,"landing_page_url":"https://doi.org/10.1007/s10115-023-02009-y","pdf_url":"https://link.springer.com/content/pdf/10.1007/s10115-023-02009-y.pdf","source":{"id":"https://openalex.org/S81770430","display_name":"Knowledge and Information Systems","issn_l":"0219-1377","issn":["0219-1377","0219-3116"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319900","host_organization_name":"Springer Science+Business Media","host_organization_lineage":["https://openalex.org/P4310319900","https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Science+Business Media","Springer Nature"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Knowledge and Information Systems","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"hybrid","oa_url":"https://link.springer.com/content/pdf/10.1007/s10115-023-02009-y.pdf","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5087157844","display_name":"Vincenzo Norman Vitale","orcid":"https://orcid.org/0000-0002-0365-8575"},"institutions":[{"id":"https://openalex.org/I71267560","display_name":"University of Naples Federico II","ror":"https://ror.org/05290cv24","country_code":"IT","type":"education","lineage":["https://openalex.org/I71267560"]}],"countries":["IT"],"is_corresponding":true,"raw_author_name":"Vincenzo Norman Vitale","raw_affiliation_strings":["Department of Information Technology and Electrical Engineering (DIETI), University of Naples \u2018Federico II\u2019, Corso Umberto I 40, 80138, Naples, Italy","Department of Information Technology and Electrical Engineering (DIETI), University of Naples 'Federico II', Corso Umberto I 40, 80138, Naples, Italy"],"raw_orcid":"https://orcid.org/0000-0002-0365-8575","affiliations":[{"raw_affiliation_string":"Department of Information Technology and Electrical Engineering (DIETI), University of Naples \u2018Federico II\u2019, Corso Umberto I 40, 80138, Naples, Italy","institution_ids":["https://openalex.org/I71267560"]},{"raw_affiliation_string":"Department of Information Technology and Electrical Engineering (DIETI), University of Naples 'Federico II', Corso Umberto I 40, 80138, Naples, Italy","institution_ids":["https://openalex.org/I71267560"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5106313970","display_name":"Sergio Di Martino","orcid":"https://orcid.org/0000-0002-1019-9004"},"institutions":[{"id":"https://openalex.org/I71267560","display_name":"University of Naples Federico II","ror":"https://ror.org/05290cv24","country_code":"IT","type":"education","lineage":["https://openalex.org/I71267560"]}],"countries":["IT"],"is_corresponding":true,"raw_author_name":"Sergio Di Martino","raw_affiliation_strings":["Department of Information Technology and Electrical Engineering (DIETI), University of Naples \u2018Federico II\u2019, Corso Umberto I 40, 80138, Naples, Italy","Department of Information Technology and Electrical Engineering (DIETI), University of Naples 'Federico II', Corso Umberto I 40, 80138, Naples, Italy"],"raw_orcid":"https://orcid.org/0000-0002-1019-9004","affiliations":[{"raw_affiliation_string":"Department of Information Technology and Electrical Engineering (DIETI), University of Naples \u2018Federico II\u2019, Corso Umberto I 40, 80138, Naples, Italy","institution_ids":["https://openalex.org/I71267560"]},{"raw_affiliation_string":"Department of Information Technology and Electrical Engineering (DIETI), University of Naples 'Federico II', Corso Umberto I 40, 80138, Naples, Italy","institution_ids":["https://openalex.org/I71267560"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5000697088","display_name":"Adriano Peron","orcid":"https://orcid.org/0000-0002-7111-3171"},"institutions":[{"id":"https://openalex.org/I142444530","display_name":"University of Trieste","ror":"https://ror.org/02n742c10","country_code":"IT","type":"education","lineage":["https://openalex.org/I142444530"]}],"countries":["IT"],"is_corresponding":false,"raw_author_name":"Adriano Peron","raw_affiliation_strings":["University of Trieste, Piazzale Europa, 1, 34127, Trieste, Italy"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Trieste, Piazzale Europa, 1, 34127, Trieste, Italy","institution_ids":["https://openalex.org/I142444530"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5085213521","display_name":"Massimiliano Russo","orcid":"https://orcid.org/0000-0003-4953-9341"},"institutions":[{"id":"https://openalex.org/I71267560","display_name":"University of Naples Federico II","ror":"https://ror.org/05290cv24","country_code":"IT","type":"education","lineage":["https://openalex.org/I71267560"]}],"countries":["IT"],"is_corresponding":false,"raw_author_name":"Massimiliano Russo","raw_affiliation_strings":["Department of Information Technology and Electrical Engineering (DIETI), University of Naples \u2018Federico II\u2019, Corso Umberto I 40, 80138, Naples, Italy","Department of Information Technology and Electrical Engineering (DIETI), University of Naples 'Federico II', Corso Umberto I 40, 80138, Naples, Italy"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Department of Information Technology and Electrical Engineering (DIETI), University of Naples \u2018Federico II\u2019, Corso Umberto I 40, 80138, Naples, Italy","institution_ids":["https://openalex.org/I71267560"]},{"raw_affiliation_string":"Department of Information Technology and Electrical Engineering (DIETI), University of Naples 'Federico II', Corso Umberto I 40, 80138, Naples, Italy","institution_ids":["https://openalex.org/I71267560"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5048520148","display_name":"Ermanno Battista","orcid":"https://orcid.org/0000-0001-9680-3040"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Ermanno Battista","raw_affiliation_strings":["IVM srl, Via Benedetto Brin, 59, 80142, Naples, Italy"],"raw_orcid":"https://orcid.org/0000-0001-9680-3040","affiliations":[{"raw_affiliation_string":"IVM srl, Via Benedetto Brin, 59, 80142, Naples, Italy","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5087157844","https://openalex.org/A5106313970"],"corresponding_institution_ids":["https://openalex.org/I71267560"],"apc_list":{"value":2290,"currency":"EUR","value_usd":2890},"apc_paid":{"value":2290,"currency":"EUR","value_usd":2890},"fwci":0.5219,"has_fulltext":true,"cited_by_count":3,"citation_normalized_percentile":{"value":0.63792993,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":94,"max":97},"biblio":{"volume":"66","issue":"3","first_page":"2063","last_page":"2088"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9998999834060669,"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.9998999834060669,"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/T11980","display_name":"Human Mobility and Location-Based Analysis","score":0.9908999800682068,"subfield":{"id":"https://openalex.org/subfields/3313","display_name":"Transportation"},"field":{"id":"https://openalex.org/fields/33","display_name":"Social Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T10757","display_name":"Geographic Information Systems Studies","score":0.9887999892234802,"subfield":{"id":"https://openalex.org/subfields/3305","display_name":"Geography, Planning and Development"},"field":{"id":"https://openalex.org/fields/33","display_name":"Social Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/search-engine-indexing","display_name":"Search engine indexing","score":0.8260321617126465},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8055773973464966},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.5853046178817749},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5288326144218445},{"id":"https://openalex.org/keywords/temporal-database","display_name":"Temporal database","score":0.4229889512062073},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.3255802392959595}],"concepts":[{"id":"https://openalex.org/C75165309","wikidata":"https://www.wikidata.org/wiki/Q2258979","display_name":"Search engine indexing","level":2,"score":0.8260321617126465},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8055773973464966},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.5853046178817749},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5288326144218445},{"id":"https://openalex.org/C77277458","wikidata":"https://www.wikidata.org/wiki/Q1969246","display_name":"Temporal database","level":2,"score":0.4229889512062073},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.3255802392959595}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1007/s10115-023-02009-y","is_oa":true,"landing_page_url":"https://doi.org/10.1007/s10115-023-02009-y","pdf_url":"https://link.springer.com/content/pdf/10.1007/s10115-023-02009-y.pdf","source":{"id":"https://openalex.org/S81770430","display_name":"Knowledge and Information Systems","issn_l":"0219-1377","issn":["0219-1377","0219-3116"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319900","host_organization_name":"Springer Science+Business Media","host_organization_lineage":["https://openalex.org/P4310319900","https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Science+Business Media","Springer Nature"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Knowledge and Information Systems","raw_type":"journal-article"},{"id":"pmh:oai:arts.units.it:11368/3070239","is_oa":true,"landing_page_url":"https://link.springer.com/article/10.1007/s10115-023-02009-y","pdf_url":null,"source":{"id":"https://openalex.org/S4306400480","display_name":"ArTS Archivio della ricerca di Trieste (University of Trieste https://www.units.it/)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I142444530","host_organization_name":"University of Trieste","host_organization_lineage":["https://openalex.org/I142444530"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"info:eu-repo/semantics/article"}],"best_oa_location":{"id":"doi:10.1007/s10115-023-02009-y","is_oa":true,"landing_page_url":"https://doi.org/10.1007/s10115-023-02009-y","pdf_url":"https://link.springer.com/content/pdf/10.1007/s10115-023-02009-y.pdf","source":{"id":"https://openalex.org/S81770430","display_name":"Knowledge and Information Systems","issn_l":"0219-1377","issn":["0219-1377","0219-3116"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319900","host_organization_name":"Springer Science+Business Media","host_organization_lineage":["https://openalex.org/P4310319900","https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Science+Business Media","Springer Nature"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Knowledge and Information Systems","raw_type":"journal-article"},"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/9","display_name":"Industry, innovation and infrastructure","score":0.5699999928474426}],"awards":[{"id":"https://openalex.org/G5340240799","display_name":null,"funder_award_id":"#B61B20000300005","funder_id":"https://openalex.org/F4320324632","funder_display_name":"Ministero dello Sviluppo Economico"}],"funders":[{"id":"https://openalex.org/F4320309590","display_name":"Universit\u00e0 degli Studi di Napoli Federico II","ror":"https://ror.org/05290cv24"},{"id":"https://openalex.org/F4320324632","display_name":"Ministero dello Sviluppo Economico","ror":"https://ror.org/011z3ff80"}],"has_content":{"grobid_xml":false,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W4388822797.pdf"},"referenced_works_count":55,"referenced_works":["https://openalex.org/W1539221976","https://openalex.org/W2000618191","https://openalex.org/W2001703222","https://openalex.org/W2013374182","https://openalex.org/W2051265785","https://openalex.org/W2080582518","https://openalex.org/W2108179552","https://openalex.org/W2114773789","https://openalex.org/W2140669960","https://openalex.org/W2144232511","https://openalex.org/W2293066912","https://openalex.org/W2293715777","https://openalex.org/W2295939521","https://openalex.org/W2416981224","https://openalex.org/W2546677102","https://openalex.org/W2605843372","https://openalex.org/W2606130348","https://openalex.org/W2608820626","https://openalex.org/W2734431066","https://openalex.org/W2734809833","https://openalex.org/W2736427214","https://openalex.org/W2739750598","https://openalex.org/W2749874879","https://openalex.org/W2762329652","https://openalex.org/W2783067697","https://openalex.org/W2811245417","https://openalex.org/W2811266402","https://openalex.org/W2889201433","https://openalex.org/W2896241044","https://openalex.org/W2901850888","https://openalex.org/W2913259953","https://openalex.org/W2921126716","https://openalex.org/W2945221590","https://openalex.org/W2953014100","https://openalex.org/W2954621898","https://openalex.org/W2962736902","https://openalex.org/W2972137370","https://openalex.org/W2982290348","https://openalex.org/W2989043121","https://openalex.org/W2993308207","https://openalex.org/W2999891794","https://openalex.org/W3027702097","https://openalex.org/W3036544642","https://openalex.org/W3040753047","https://openalex.org/W3045623656","https://openalex.org/W3093770653","https://openalex.org/W3107562388","https://openalex.org/W3132317140","https://openalex.org/W3137759927","https://openalex.org/W3160345694","https://openalex.org/W3160950340","https://openalex.org/W3197025840","https://openalex.org/W4230180466","https://openalex.org/W4242599275","https://openalex.org/W6630602962"],"related_works":["https://openalex.org/W3024364549","https://openalex.org/W4206019083","https://openalex.org/W2048865712","https://openalex.org/W1976265003","https://openalex.org/W2370378377","https://openalex.org/W2188505374","https://openalex.org/W1558342070","https://openalex.org/W2698961929","https://openalex.org/W1554228447","https://openalex.org/W1596616643"],"abstract_inverted_index":{"Abstract":[0],"The":[1,29],"growing":[2],"diffusion":[3],"of":[4,17,26,89,93,111,121,129,202],"the":[5,15,23,32,68,87,94,108,122,130,145,153,159,164,174,182],"latest":[6],"information":[7],"and":[8,31,39,72,125,194],"communication":[9],"technologies":[10],"in":[11,140],"different":[12,100,187],"contexts":[13],"allowed":[14],"constitution":[16],"enormous":[18],"sensing":[19],"networks":[20],"that":[21,173],"form":[22],"underlying":[24],"texture":[25],"smart":[27],"environments.":[28],"amount":[30],"speed":[33],"at":[34],"which":[35,185],"these":[36,200],"environments":[37],"produce":[38],"consume":[40],"data":[41,48],"are":[42],"starting":[43],"to":[44,67,77,103],"challenge":[45],"current":[46],"spatial":[47],"management":[49],"technologies.":[50],"In":[51,83],"this":[52],"work,":[53],"we":[54,85,156],"report":[55],"on":[56,152],"our":[57],"experience":[58,190],"handling":[59,141],"real-world":[60],"spatiotemporal":[61,105],"datasets:":[62],"a":[63,73,78,118,127,136],"stationary":[64],"dataset":[65,75,147],"referring":[66,76],"parking":[69],"monitoring":[70,81],"system":[71],"non-stationary":[74,146],"train-mounted":[79],"railway":[80],"system.":[82],"particular,":[84],"present":[86],"results":[88],"an":[90],"empirical":[91],"comparison":[92],"retrieval":[95],"performances":[96],"achieved":[97],"by":[98,162,178,181],"three":[99],"off-the-shelf":[101],"settings":[102],"manage":[104],"data,":[106],"namely":[107],"well-established":[109],"combination":[110,128],"PostgreSQL":[112],"+":[113],"PostGIS":[114],"with":[115,133,167],"standard":[116,175],"indexing,":[117],"clustered":[119],"version":[120],"same":[123],"setup,":[124],"then":[126],"basic":[131],"setup":[132,166],"Timescale":[134],",":[135],"storage":[137],"extension":[138],"specialized":[139],"temporal":[142],"data.":[143,203],"Since":[144],"has":[148],"put":[149],"much":[150],"pressure":[151],"configurations":[154],"above,":[155],"furtherly":[157],"investigated":[158],"advantages":[160],"achievable":[161],"combining":[163],"TSMS":[165],"state-of-the-art":[168],"indexing":[169,176],"techniques.":[170],"Results":[171],"showed":[172],"is":[177],"far":[179],"outperformed":[180],"other":[183],"solutions,":[184],"have":[186],"trade-offs.":[188],"This":[189],"may":[191],"help":[192],"researchers":[193],"practitioners":[195],"facing":[196],"similar":[197],"problems":[198],"managing":[199],"types":[201]},"counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2025,"cited_by_count":2}],"updated_date":"2026-06-13T06:13:01.061226","created_date":"2025-10-10T00:00:00"}