{"id":"https://openalex.org/W2075339457","doi":"https://doi.org/10.1145/2345316.2345346","title":"Performance comparisons of spatial data processing techniques for a large scale mobile phone dataset","display_name":"Performance comparisons of spatial data processing techniques for a large scale mobile phone dataset","publication_year":2012,"publication_date":"2012-07-01","ids":{"openalex":"https://openalex.org/W2075339457","doi":"https://doi.org/10.1145/2345316.2345346","mag":"2075339457"},"language":"en","primary_location":{"id":"doi:10.1145/2345316.2345346","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2345316.2345346","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 3rd International Conference on Computing for Geospatial Research and Applications","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/A5073817266","display_name":"Apichon Witayangkurn","orcid":"https://orcid.org/0000-0003-1454-1820"},"institutions":[{"id":"https://openalex.org/I74801974","display_name":"The University of Tokyo","ror":"https://ror.org/057zh3y96","country_code":"JP","type":"education","lineage":["https://openalex.org/I74801974"]},{"id":"https://openalex.org/I4210143862","display_name":"Tokyo Metropolitan Komaba High School","ror":"https://ror.org/048a7w867","country_code":"JP","type":"education","lineage":["https://openalex.org/I4210143862"]}],"countries":["JP"],"is_corresponding":true,"raw_author_name":"Apichon Witayangkurn","raw_affiliation_strings":["The University of Tokyo, Komaba, Tokyo, Japan"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"The University of Tokyo, Komaba, Tokyo, Japan","institution_ids":["https://openalex.org/I4210143862","https://openalex.org/I74801974"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5011630316","display_name":"Teerayut Horanont","orcid":"https://orcid.org/0000-0002-3452-8845"},"institutions":[{"id":"https://openalex.org/I74801974","display_name":"The University of Tokyo","ror":"https://ror.org/057zh3y96","country_code":"JP","type":"education","lineage":["https://openalex.org/I74801974"]},{"id":"https://openalex.org/I4210143862","display_name":"Tokyo Metropolitan Komaba High School","ror":"https://ror.org/048a7w867","country_code":"JP","type":"education","lineage":["https://openalex.org/I4210143862"]}],"countries":["JP"],"is_corresponding":false,"raw_author_name":"Teerayut Horanont","raw_affiliation_strings":["The University of Tokyo, Komaba, Tokyo, Japan"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"The University of Tokyo, Komaba, Tokyo, Japan","institution_ids":["https://openalex.org/I4210143862","https://openalex.org/I74801974"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5105206953","display_name":"Ryosuke Shibasaki","orcid":"https://orcid.org/0000-0001-8760-244X"},"institutions":[{"id":"https://openalex.org/I74801974","display_name":"The University of Tokyo","ror":"https://ror.org/057zh3y96","country_code":"JP","type":"education","lineage":["https://openalex.org/I74801974"]}],"countries":["JP"],"is_corresponding":false,"raw_author_name":"Ryosuke Shibasaki","raw_affiliation_strings":["The University of Tokyo, Kashiwa-shi, Chiba, Japan"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"The University of Tokyo, Kashiwa-shi, Chiba, Japan","institution_ids":["https://openalex.org/I74801974"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5073817266"],"corresponding_institution_ids":["https://openalex.org/I4210143862","https://openalex.org/I74801974"],"apc_list":null,"apc_paid":null,"fwci":0.4952,"has_fulltext":false,"cited_by_count":16,"citation_normalized_percentile":{"value":0.67786211,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":98},"biblio":{"volume":null,"issue":null,"first_page":"1","last_page":"6"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9990000128746033,"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.9990000128746033,"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.9976999759674072,"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.9939000010490417,"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/computer-science","display_name":"Computer science","score":0.7947202920913696},{"id":"https://openalex.org/keywords/spatial-query","display_name":"Spatial query","score":0.7324799299240112},{"id":"https://openalex.org/keywords/scalability","display_name":"Scalability","score":0.6775494813919067},{"id":"https://openalex.org/keywords/spatial-database","display_name":"Spatial database","score":0.592054009437561},{"id":"https://openalex.org/keywords/global-positioning-system","display_name":"Global Positioning System","score":0.5905313491821289},{"id":"https://openalex.org/keywords/java","display_name":"Java","score":0.5809286236763},{"id":"https://openalex.org/keywords/spatial-analysis","display_name":"Spatial analysis","score":0.5806348919868469},{"id":"https://openalex.org/keywords/mobile-phone","display_name":"Mobile phone","score":0.5394760966300964},{"id":"https://openalex.org/keywords/cloud-computing","display_name":"Cloud computing","score":0.5109771490097046},{"id":"https://openalex.org/keywords/suite","display_name":"Suite","score":0.48591986298561096},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.4693281054496765},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.4651084542274475},{"id":"https://openalex.org/keywords/big-data","display_name":"Big data","score":0.45313116908073425},{"id":"https://openalex.org/keywords/scale","display_name":"Scale (ratio)","score":0.4451959729194641},{"id":"https://openalex.org/keywords/mobile-computing","display_name":"Mobile computing","score":0.43608373403549194},{"id":"https://openalex.org/keywords/data-processing","display_name":"Data processing","score":0.4251026511192322},{"id":"https://openalex.org/keywords/domain","display_name":"Domain (mathematical analysis)","score":0.4145393669605255},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.34926044940948486},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.18752670288085938},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.13780245184898376},{"id":"https://openalex.org/keywords/geography","display_name":"Geography","score":0.11456668376922607},{"id":"https://openalex.org/keywords/cartography","display_name":"Cartography","score":0.0918099582195282},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.08327421545982361}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7947202920913696},{"id":"https://openalex.org/C172722865","wikidata":"https://www.wikidata.org/wiki/Q2302053","display_name":"Spatial query","level":5,"score":0.7324799299240112},{"id":"https://openalex.org/C48044578","wikidata":"https://www.wikidata.org/wiki/Q727490","display_name":"Scalability","level":2,"score":0.6775494813919067},{"id":"https://openalex.org/C203689450","wikidata":"https://www.wikidata.org/wiki/Q2302053","display_name":"Spatial database","level":3,"score":0.592054009437561},{"id":"https://openalex.org/C60229501","wikidata":"https://www.wikidata.org/wiki/Q18822","display_name":"Global Positioning System","level":2,"score":0.5905313491821289},{"id":"https://openalex.org/C548217200","wikidata":"https://www.wikidata.org/wiki/Q251","display_name":"Java","level":2,"score":0.5809286236763},{"id":"https://openalex.org/C159620131","wikidata":"https://www.wikidata.org/wiki/Q1938983","display_name":"Spatial analysis","level":2,"score":0.5806348919868469},{"id":"https://openalex.org/C2777421447","wikidata":"https://www.wikidata.org/wiki/Q17517","display_name":"Mobile phone","level":2,"score":0.5394760966300964},{"id":"https://openalex.org/C79974875","wikidata":"https://www.wikidata.org/wiki/Q483639","display_name":"Cloud computing","level":2,"score":0.5109771490097046},{"id":"https://openalex.org/C79581498","wikidata":"https://www.wikidata.org/wiki/Q1367530","display_name":"Suite","level":2,"score":0.48591986298561096},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.4693281054496765},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4651084542274475},{"id":"https://openalex.org/C75684735","wikidata":"https://www.wikidata.org/wiki/Q858810","display_name":"Big data","level":2,"score":0.45313116908073425},{"id":"https://openalex.org/C2778755073","wikidata":"https://www.wikidata.org/wiki/Q10858537","display_name":"Scale (ratio)","level":2,"score":0.4451959729194641},{"id":"https://openalex.org/C144543869","wikidata":"https://www.wikidata.org/wiki/Q2738570","display_name":"Mobile computing","level":2,"score":0.43608373403549194},{"id":"https://openalex.org/C138827492","wikidata":"https://www.wikidata.org/wiki/Q6661985","display_name":"Data processing","level":2,"score":0.4251026511192322},{"id":"https://openalex.org/C36503486","wikidata":"https://www.wikidata.org/wiki/Q11235244","display_name":"Domain (mathematical analysis)","level":2,"score":0.4145393669605255},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.34926044940948486},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.18752670288085938},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.13780245184898376},{"id":"https://openalex.org/C205649164","wikidata":"https://www.wikidata.org/wiki/Q1071","display_name":"Geography","level":0,"score":0.11456668376922607},{"id":"https://openalex.org/C58640448","wikidata":"https://www.wikidata.org/wiki/Q42515","display_name":"Cartography","level":1,"score":0.0918099582195282},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.08327421545982361},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.0},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.0},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.0},{"id":"https://openalex.org/C134306372","wikidata":"https://www.wikidata.org/wiki/Q7754","display_name":"Mathematical analysis","level":1,"score":0.0},{"id":"https://openalex.org/C166957645","wikidata":"https://www.wikidata.org/wiki/Q23498","display_name":"Archaeology","level":1,"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/2345316.2345346","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2345316.2345346","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 3rd International Conference on Computing for Geospatial Research and Applications","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"display_name":"Sustainable cities and communities","score":0.5400000214576721,"id":"https://metadata.un.org/sdg/11"}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":12,"referenced_works":["https://openalex.org/W1544119352","https://openalex.org/W1977367431","https://openalex.org/W1993892970","https://openalex.org/W2009155608","https://openalex.org/W2088600013","https://openalex.org/W2119528150","https://openalex.org/W2120787923","https://openalex.org/W2140251882","https://openalex.org/W2143394441","https://openalex.org/W2145725688","https://openalex.org/W2169628462","https://openalex.org/W6632514215"],"related_works":["https://openalex.org/W2122098189","https://openalex.org/W4251016002","https://openalex.org/W2171008029","https://openalex.org/W2031915568","https://openalex.org/W78322106","https://openalex.org/W2362227810","https://openalex.org/W98693435","https://openalex.org/W2371994896","https://openalex.org/W2372693033","https://openalex.org/W2358687972"],"abstract_inverted_index":{"Mobile":[0],"technology,":[1],"especially":[2],"mobile":[3,12,18,106],"phone,":[4],"is":[5,49,99,152],"very":[6],"popular":[7],"nowadays.":[8],"Increasing":[9],"number":[10,117],"of":[11,16,23,71,102,128,187,242],"users":[13,108],"and":[14,38,80,86,230],"availability":[15],"GPS-embedded":[17],"phones":[19],"generate":[20],"large":[21],"amount":[22],"GPS":[24,72,100],"trajectories":[25,101],"that":[26,74,151],"can":[27],"be":[28],"used":[29,162],"in":[30,54,84,109,224,231,236],"various":[31,129],"research":[32],"areas":[33],"such":[34,45],"as":[35],"people":[36],"mobility":[37],"transportation":[39],"planning.":[40],"However,":[41,193],"how":[42],"to":[43,63,189,208],"handle":[44],"a":[46,50,65,137,153,206],"large-scale":[47,76,225],"dataset":[48,98],"significant":[51],"issue":[52],"particularly":[53,135],"spatial":[55,133,157,166,198,210,219,243],"analysis":[56],"domain.":[57],"In":[58,140],"this":[59,141],"paper,":[60],"we":[61,124,143,161,174,204,233],"aimed":[62],"explore":[64],"suitable":[66],"way":[67,155],"for":[68,112,131,136,156,238],"extracting":[69],"geo-location":[70],"coordinate":[73],"achieve":[75],"support,":[77],"fast":[78],"processing,":[79],"easily":[81],"scalable":[82],"both":[83],"storage":[85],"calculation":[87],"speed.":[88],"Geo-locations":[89],"are":[90],"cities,":[91],"zones,":[92],"or":[93],"any":[94],"interesting":[95],"points.":[96],"Our":[97],"1.5":[103],"million":[104],"individual":[105],"phone":[107],"Japan":[110],"accumulated":[111],"one":[113],"year.":[114],"The":[115],"total":[116],"was":[118],"approximately":[119],"9.2":[120],"billion":[121],"records.":[122],"Therefore,":[123],"conducted":[125],"performance":[126],"comparisons":[127],"methods":[130,229],"processing":[132,226,239],"data,":[134],"huge":[138],"dataset.":[139],"work,":[142],"first":[144],"processed":[145],"data":[146,158],"on":[147,176,182,185,212],"PostgreSQL":[148],"with":[149,165,218],"PostGIS":[150],"traditional":[154],"processing.":[159],"Second,":[160],"java":[163],"application":[164],"library":[167],"called":[168],"Java":[169],"Topology":[170],"suite":[171],"(JTS).":[172],"Third,":[173],"tried":[175],"Hadoop":[177,188],"Cloud":[178],"Computing":[179],"Platform":[180],"focusing":[181],"using":[183],"Hive":[184],"top":[186],"allow":[190],"SQL-like":[191],"support.":[192],"Hadoop/Hive":[194,237],"did":[195],"not":[196],"support":[197,211,220],"query":[199],"at":[200],"the":[201,215],"moment.":[202],"Hence,":[203],"proposed":[205],"solution":[207],"enable":[209],"Hive.":[213],"As":[214],"results,":[216],"Hadoop/hive":[217],"performed":[221],"best":[222],"result":[223],"among":[227],"evaluated":[228],"addition,":[232],"recommended":[234],"techniques":[235],"different":[240],"types":[241],"data.":[244]},"counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2022,"cited_by_count":1},{"year":2021,"cited_by_count":5},{"year":2020,"cited_by_count":1},{"year":2019,"cited_by_count":2},{"year":2018,"cited_by_count":1},{"year":2017,"cited_by_count":2},{"year":2016,"cited_by_count":1},{"year":2015,"cited_by_count":1},{"year":2013,"cited_by_count":1}],"updated_date":"2026-05-17T08:19:37.847499","created_date":"2025-10-10T00:00:00"}