{"id":"https://openalex.org/W4312542847","doi":"https://doi.org/10.1109/dsit55514.2022.9943905","title":"Spatiotemporal Indexing and Query Application on Cassandra for Large-Scale Trajectory Data","display_name":"Spatiotemporal Indexing and Query Application on Cassandra for Large-Scale Trajectory Data","publication_year":2022,"publication_date":"2022-07-22","ids":{"openalex":"https://openalex.org/W4312542847","doi":"https://doi.org/10.1109/dsit55514.2022.9943905"},"language":"en","primary_location":{"id":"doi:10.1109/dsit55514.2022.9943905","is_oa":false,"landing_page_url":"https://doi.org/10.1109/dsit55514.2022.9943905","pdf_url":null,"source":{"id":"https://openalex.org/S4363608293","display_name":"2022 5th International Conference on Data Science and Information Technology (DSIT)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"conference"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2022 5th International Conference on Data Science and Information Technology (DSIT)","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/A5049520887","display_name":"Baili Huang","orcid":null},"institutions":[{"id":"https://openalex.org/I4210114105","display_name":"Tsinghua\u2013Berkeley Shenzhen Institute","ror":"https://ror.org/02hhwwz98","country_code":"CN","type":"facility","lineage":["https://openalex.org/I4210114105","https://openalex.org/I95457486","https://openalex.org/I99065089"]},{"id":"https://openalex.org/I99065089","display_name":"Tsinghua University","ror":"https://ror.org/03cve4549","country_code":"CN","type":"education","lineage":["https://openalex.org/I99065089"]}],"countries":["CN"],"is_corresponding":true,"raw_author_name":"Baili Huang","raw_affiliation_strings":["Tsinghua Shenzhen International Graduate School Tsinghua University,Shenzhen,China","Tsinghua Shenzhen International Graduate School Tsinghua University, Shenzhen, China"],"affiliations":[{"raw_affiliation_string":"Tsinghua Shenzhen International Graduate School Tsinghua University,Shenzhen,China","institution_ids":["https://openalex.org/I4210114105","https://openalex.org/I99065089"]},{"raw_affiliation_string":"Tsinghua Shenzhen International Graduate School Tsinghua University, Shenzhen, China","institution_ids":["https://openalex.org/I4210114105","https://openalex.org/I99065089"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5100765837","display_name":"Zhiheng Li","orcid":"https://orcid.org/0000-0002-1523-1114"},"institutions":[{"id":"https://openalex.org/I99065089","display_name":"Tsinghua University","ror":"https://ror.org/03cve4549","country_code":"CN","type":"education","lineage":["https://openalex.org/I99065089"]},{"id":"https://openalex.org/I4210114105","display_name":"Tsinghua\u2013Berkeley Shenzhen Institute","ror":"https://ror.org/02hhwwz98","country_code":"CN","type":"facility","lineage":["https://openalex.org/I4210114105","https://openalex.org/I95457486","https://openalex.org/I99065089"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Zhiheng Li","raw_affiliation_strings":["Tsinghua Shenzhen International Graduate School Tsinghua University,Shenzhen,China","Tsinghua Shenzhen International Graduate School Tsinghua University, Shenzhen, China"],"affiliations":[{"raw_affiliation_string":"Tsinghua Shenzhen International Graduate School Tsinghua University,Shenzhen,China","institution_ids":["https://openalex.org/I4210114105","https://openalex.org/I99065089"]},{"raw_affiliation_string":"Tsinghua Shenzhen International Graduate School Tsinghua University, Shenzhen, China","institution_ids":["https://openalex.org/I4210114105","https://openalex.org/I99065089"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5049520887"],"corresponding_institution_ids":["https://openalex.org/I4210114105","https://openalex.org/I99065089"],"apc_list":null,"apc_paid":null,"fwci":0.2455,"has_fulltext":false,"cited_by_count":2,"citation_normalized_percentile":{"value":0.42401264,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":94,"max":96},"biblio":{"volume":null,"issue":null,"first_page":null,"last_page":null},"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/T11344","display_name":"Traffic Prediction and Management Techniques","score":0.9939000010490417,"subfield":{"id":"https://openalex.org/subfields/2215","display_name":"Building and Construction"},"field":{"id":"https://openalex.org/fields/22","display_name":"Engineering"},"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.9857000112533569,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8464009761810303},{"id":"https://openalex.org/keywords/search-engine-indexing","display_name":"Search engine indexing","score":0.8354110717773438},{"id":"https://openalex.org/keywords/scalability","display_name":"Scalability","score":0.7281684279441833},{"id":"https://openalex.org/keywords/nosql","display_name":"NoSQL","score":0.640526294708252},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.5780297517776489},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5335626602172852},{"id":"https://openalex.org/keywords/spatiotemporal-database","display_name":"Spatiotemporal database","score":0.5278083086013794},{"id":"https://openalex.org/keywords/benchmark","display_name":"Benchmark (surveying)","score":0.5083252787590027},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.49005115032196045},{"id":"https://openalex.org/keywords/query-expansion","display_name":"Query expansion","score":0.450204998254776},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.3630649447441101},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.251289039850235},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.1595485806465149},{"id":"https://openalex.org/keywords/database-tuning","display_name":"Database tuning","score":0.1425875723361969}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8464009761810303},{"id":"https://openalex.org/C75165309","wikidata":"https://www.wikidata.org/wiki/Q2258979","display_name":"Search engine indexing","level":2,"score":0.8354110717773438},{"id":"https://openalex.org/C48044578","wikidata":"https://www.wikidata.org/wiki/Q727490","display_name":"Scalability","level":2,"score":0.7281684279441833},{"id":"https://openalex.org/C2779599972","wikidata":"https://www.wikidata.org/wiki/Q82231","display_name":"NoSQL","level":3,"score":0.640526294708252},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.5780297517776489},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5335626602172852},{"id":"https://openalex.org/C98080885","wikidata":"https://www.wikidata.org/wiki/Q7574095","display_name":"Spatiotemporal database","level":5,"score":0.5278083086013794},{"id":"https://openalex.org/C185798385","wikidata":"https://www.wikidata.org/wiki/Q1161707","display_name":"Benchmark (surveying)","level":2,"score":0.5083252787590027},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.49005115032196045},{"id":"https://openalex.org/C99016210","wikidata":"https://www.wikidata.org/wiki/Q5488129","display_name":"Query expansion","level":2,"score":0.450204998254776},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.3630649447441101},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.251289039850235},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.1595485806465149},{"id":"https://openalex.org/C107535962","wikidata":"https://www.wikidata.org/wiki/Q2459880","display_name":"Database tuning","level":4,"score":0.1425875723361969},{"id":"https://openalex.org/C13280743","wikidata":"https://www.wikidata.org/wiki/Q131089","display_name":"Geodesy","level":1,"score":0.0},{"id":"https://openalex.org/C205649164","wikidata":"https://www.wikidata.org/wiki/Q1071","display_name":"Geography","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/dsit55514.2022.9943905","is_oa":false,"landing_page_url":"https://doi.org/10.1109/dsit55514.2022.9943905","pdf_url":null,"source":{"id":"https://openalex.org/S4363608293","display_name":"2022 5th International Conference on Data Science and Information Technology (DSIT)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"conference"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2022 5th International Conference on Data Science and Information Technology (DSIT)","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.800000011920929,"id":"https://metadata.un.org/sdg/11","display_name":"Sustainable cities and communities"}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":22,"referenced_works":["https://openalex.org/W220519675","https://openalex.org/W1497953515","https://openalex.org/W1747608304","https://openalex.org/W1784115556","https://openalex.org/W1922563430","https://openalex.org/W1995900572","https://openalex.org/W2031473446","https://openalex.org/W2098292500","https://openalex.org/W2100946521","https://openalex.org/W2159772324","https://openalex.org/W2161159200","https://openalex.org/W2768531189","https://openalex.org/W2891969677","https://openalex.org/W2902921501","https://openalex.org/W2911262853","https://openalex.org/W2952570444","https://openalex.org/W3010383195","https://openalex.org/W3028871849","https://openalex.org/W3210372918","https://openalex.org/W6608654248","https://openalex.org/W6675130837","https://openalex.org/W6754597926"],"related_works":["https://openalex.org/W3007123324","https://openalex.org/W2350026801","https://openalex.org/W2607457115","https://openalex.org/W4315629472","https://openalex.org/W791400509","https://openalex.org/W3028871849","https://openalex.org/W2363027842","https://openalex.org/W2161902337","https://openalex.org/W3160365504","https://openalex.org/W4312542847"],"abstract_inverted_index":{"The":[0,106,156,185,200,223],"fast-growing":[1],"urban":[2],"traffic":[3,9],"produces":[4],"a":[5,13,27,47,141,248],"huge":[6],"volume":[7],"of":[8,64,81,174,191,202],"data":[10,21,134,151],"which":[11,40,51],"becomes":[12],"problem":[14],"when":[15],"storing,":[16],"querying":[17,152],"and":[18,35,62,77,96,153,178],"analyzing":[19,78,154],"large-scale":[20,65,149],"in":[22,148],"traditional":[23],"database":[24,58,127,183],"technologies.":[25,184],"As":[26],"viable":[28],"alternative,":[29],"NoSQL":[30],"databases":[31],"offer":[32],"high":[33,36],"scalability":[34],"input/output":[37],"throughput":[38],"features":[39],"potentially":[41],"accommodate":[42],"the":[43,56,85,93,99,103,114,125,131,160,167,172,175,189,192,197,203,214,218,235,239],"needs.":[44],"We":[45,83],"propose":[46],"spatiotemporal":[48,66,108,150,231,244],"indexing":[49,61,119,232,245],"method":[50,142,194],"can":[52,246],"be":[53],"applied":[54,112],"to":[55,69,113,137,144,165,170,196,212],"Cassandra":[57,115,126],"for":[59,74],"efficient":[60],"storing":[63],"datasets":[67],"aiming":[68],"provide":[70,247],"an":[71],"effective":[72],"framework":[73],"processing,":[75],"querying,":[76],"large":[79],"amounts":[80],"data.":[82,222],"improve":[84],"Z-order":[86],"curve":[87],"by":[88,209],"adding":[89],"temporal":[90],"information":[91],"as":[92,251],"third":[94],"dimension":[95],"then":[97],"encode":[98],"resultant's":[100],"values":[101],"with":[102],"Geohash":[104],"standard.":[105],"resulting":[107],"hash":[109],"code":[110],"is":[111,121,163,206],"database.":[116],"A":[117],"corresponding":[118],"structure":[120],"designed":[122],"so":[123],"that":[124,230],"will":[128],"physically":[129],"store":[130],"spatiotemporally":[132],"neighbouring":[133],"points":[135],"close":[136],"each":[138],"other.":[139],"Such":[140],"aims":[143],"increase":[145],"query":[146,213,224,236],"efficiency":[147,173,201],"applications.":[155],"dataset":[157,252],"acquired":[158],"from":[159],"real":[161],"applications":[162],"used":[164],"conduct":[166],"computational":[168,186],"experiments":[169,187,225],"validate":[171],"proposed":[176,193,204],"approach":[177],"benchmark":[179],"against":[180],"some":[181],"existing":[182],"reveal":[188],"superiority":[190],"compared":[195],"ordinary":[198,240],"methodologies,":[199],"methodology":[205],"validated":[207],"further":[208],"applying":[210],"it":[211],"vehicle":[215],"trajectories":[216],"gathering":[217],"real-time":[219],"air":[220],"quality":[221],"on":[226],"two":[227],"benchmarks":[228],"illustrate":[229],"sig-nificantly":[233],"improves":[234],"performance":[237,250],"over":[238],"methodology.":[241],"In":[242],"addition,":[243],"stable":[249],"size":[253],"increases.":[254]},"counts_by_year":[{"year":2024,"cited_by_count":2}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}
