{"id":"https://openalex.org/W1589887494","doi":"https://doi.org/10.1109/icde.2015.7113398","title":"PGWinFunc: Optimizing Window Aggregate Functions in PostgreSQL and its application for trajectory data","display_name":"PGWinFunc: Optimizing Window Aggregate Functions in PostgreSQL and its application for trajectory data","publication_year":2015,"publication_date":"2015-04-01","ids":{"openalex":"https://openalex.org/W1589887494","doi":"https://doi.org/10.1109/icde.2015.7113398","mag":"1589887494"},"language":"en","primary_location":{"id":"doi:10.1109/icde.2015.7113398","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icde.2015.7113398","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2015 IEEE 31st International Conference on Data Engineering","raw_type":"proceedings-article"},"type":"conference-paper","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/A5101019620","display_name":"Jiansong Ma","orcid":null},"institutions":[{"id":"https://openalex.org/I4210139618","display_name":"Shanghai Key Laboratory of Trustworthy Computing","ror":"https://ror.org/030qbr085","country_code":"CN","type":"facility","lineage":["https://openalex.org/I4210139618"]},{"id":"https://openalex.org/I66867065","display_name":"East China Normal University","ror":"https://ror.org/02n96ep67","country_code":"CN","type":"education","lineage":["https://openalex.org/I66867065"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Jiansong Ma","raw_affiliation_strings":["Shanghai Key Laboratory of Trustworthy Computing, East China Normal University, Shanghai, China","[Shanghai Key Laboratory of Trustworthy Computing, East China Normal University, China]"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Shanghai Key Laboratory of Trustworthy Computing, East China Normal University, Shanghai, China","institution_ids":["https://openalex.org/I4210139618","https://openalex.org/I66867065"]},{"raw_affiliation_string":"[Shanghai Key Laboratory of Trustworthy Computing, East China Normal University, China]","institution_ids":["https://openalex.org/I66867065"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5066499031","display_name":"Yu Cao","orcid":"https://orcid.org/0000-0002-3486-5518"},"institutions":[{"id":"https://openalex.org/I4210103679","display_name":"Beijing Emergency Medical Center","ror":"https://ror.org/018zkg706","country_code":"CN","type":"healthcare","lineage":["https://openalex.org/I4210103679"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Yu Cao","raw_affiliation_strings":["EMC Labs, Beijing, China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"EMC Labs, Beijing, China","institution_ids":["https://openalex.org/I4210103679"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100344628","display_name":"Xiaoling Wang","orcid":"https://orcid.org/0000-0002-4594-6946"},"institutions":[{"id":"https://openalex.org/I4210139618","display_name":"Shanghai Key Laboratory of Trustworthy Computing","ror":"https://ror.org/030qbr085","country_code":"CN","type":"facility","lineage":["https://openalex.org/I4210139618"]},{"id":"https://openalex.org/I66867065","display_name":"East China Normal University","ror":"https://ror.org/02n96ep67","country_code":"CN","type":"education","lineage":["https://openalex.org/I66867065"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Xiaoling Wang","raw_affiliation_strings":["Shanghai Key Laboratory of Trustworthy Computing, East China Normal University, Shanghai, China","[Shanghai Key Laboratory of Trustworthy Computing, East China Normal University, China]"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Shanghai Key Laboratory of Trustworthy Computing, East China Normal University, Shanghai, China","institution_ids":["https://openalex.org/I4210139618","https://openalex.org/I66867065"]},{"raw_affiliation_string":"[Shanghai Key Laboratory of Trustworthy Computing, East China Normal University, China]","institution_ids":["https://openalex.org/I66867065"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5101941946","display_name":"Chaoyong Wang","orcid":null},"institutions":[{"id":"https://openalex.org/I4210139618","display_name":"Shanghai Key Laboratory of Trustworthy Computing","ror":"https://ror.org/030qbr085","country_code":"CN","type":"facility","lineage":["https://openalex.org/I4210139618"]},{"id":"https://openalex.org/I66867065","display_name":"East China Normal University","ror":"https://ror.org/02n96ep67","country_code":"CN","type":"education","lineage":["https://openalex.org/I66867065"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Chaoyong Wang","raw_affiliation_strings":["Shanghai Key Laboratory of Trustworthy Computing, East China Normal University, Shanghai, China","[Shanghai Key Laboratory of Trustworthy Computing, East China Normal University, China]"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Shanghai Key Laboratory of Trustworthy Computing, East China Normal University, Shanghai, China","institution_ids":["https://openalex.org/I4210139618","https://openalex.org/I66867065"]},{"raw_affiliation_string":"[Shanghai Key Laboratory of Trustworthy Computing, East China Normal University, China]","institution_ids":["https://openalex.org/I66867065"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100768380","display_name":"Cheqing Jin","orcid":"https://orcid.org/0000-0002-9381-9175"},"institutions":[{"id":"https://openalex.org/I4210139618","display_name":"Shanghai Key Laboratory of Trustworthy Computing","ror":"https://ror.org/030qbr085","country_code":"CN","type":"facility","lineage":["https://openalex.org/I4210139618"]},{"id":"https://openalex.org/I66867065","display_name":"East China Normal University","ror":"https://ror.org/02n96ep67","country_code":"CN","type":"education","lineage":["https://openalex.org/I66867065"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Cheqing Jin","raw_affiliation_strings":["Shanghai Key Laboratory of Trustworthy Computing, East China Normal University, Shanghai, China","[Shanghai Key Laboratory of Trustworthy Computing, East China Normal University, China]"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Shanghai Key Laboratory of Trustworthy Computing, East China Normal University, Shanghai, China","institution_ids":["https://openalex.org/I4210139618","https://openalex.org/I66867065"]},{"raw_affiliation_string":"[Shanghai Key Laboratory of Trustworthy Computing, East China Normal University, China]","institution_ids":["https://openalex.org/I66867065"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5101511862","display_name":"Aoying Zhou","orcid":"https://orcid.org/0000-0002-4665-7302"},"institutions":[{"id":"https://openalex.org/I4210139618","display_name":"Shanghai Key Laboratory of Trustworthy Computing","ror":"https://ror.org/030qbr085","country_code":"CN","type":"facility","lineage":["https://openalex.org/I4210139618"]},{"id":"https://openalex.org/I66867065","display_name":"East China Normal University","ror":"https://ror.org/02n96ep67","country_code":"CN","type":"education","lineage":["https://openalex.org/I66867065"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Aoying Zhou","raw_affiliation_strings":["Shanghai Key Laboratory of Trustworthy Computing, East China Normal University, Shanghai, China","[Shanghai Key Laboratory of Trustworthy Computing, East China Normal University, China]"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Shanghai Key Laboratory of Trustworthy Computing, East China Normal University, Shanghai, China","institution_ids":["https://openalex.org/I4210139618","https://openalex.org/I66867065"]},{"raw_affiliation_string":"[Shanghai Key Laboratory of Trustworthy Computing, East China Normal University, China]","institution_ids":["https://openalex.org/I66867065"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.4856,"has_fulltext":false,"cited_by_count":3,"citation_normalized_percentile":{"value":0.54183527,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":95},"biblio":{"volume":null,"issue":null,"first_page":"1448","last_page":"1451"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":1.0,"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":1.0,"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.9991999864578247,"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.9973999857902527,"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/trajectory","display_name":"Trajectory","score":0.81890469789505},{"id":"https://openalex.org/keywords/aggregate","display_name":"Aggregate (composite)","score":0.7466347217559814},{"id":"https://openalex.org/keywords/window","display_name":"Window (computing)","score":0.7358543276786804},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.6806937456130981},{"id":"https://openalex.org/keywords/sliding-window-protocol","display_name":"Sliding window protocol","score":0.41789495944976807},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.3745654821395874},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.09673455357551575}],"concepts":[{"id":"https://openalex.org/C13662910","wikidata":"https://www.wikidata.org/wiki/Q193139","display_name":"Trajectory","level":2,"score":0.81890469789505},{"id":"https://openalex.org/C4679612","wikidata":"https://www.wikidata.org/wiki/Q866298","display_name":"Aggregate (composite)","level":2,"score":0.7466347217559814},{"id":"https://openalex.org/C2778751112","wikidata":"https://www.wikidata.org/wiki/Q835016","display_name":"Window (computing)","level":2,"score":0.7358543276786804},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6806937456130981},{"id":"https://openalex.org/C102392041","wikidata":"https://www.wikidata.org/wiki/Q592860","display_name":"Sliding window protocol","level":3,"score":0.41789495944976807},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3745654821395874},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.09673455357551575},{"id":"https://openalex.org/C1276947","wikidata":"https://www.wikidata.org/wiki/Q333","display_name":"Astronomy","level":1,"score":0.0},{"id":"https://openalex.org/C192562407","wikidata":"https://www.wikidata.org/wiki/Q228736","display_name":"Materials science","level":0,"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/C159985019","wikidata":"https://www.wikidata.org/wiki/Q181790","display_name":"Composite material","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/icde.2015.7113398","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icde.2015.7113398","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2015 IEEE 31st International Conference on Data Engineering","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/11","display_name":"Sustainable cities and communities","score":0.8100000023841858}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":5,"referenced_works":["https://openalex.org/W2014167660","https://openalex.org/W2035089573","https://openalex.org/W2038692154","https://openalex.org/W2066679214","https://openalex.org/W2110839100"],"related_works":["https://openalex.org/W2106570241","https://openalex.org/W3014558862","https://openalex.org/W2000311527","https://openalex.org/W2109246626","https://openalex.org/W2767142087","https://openalex.org/W2167004500","https://openalex.org/W2356691358","https://openalex.org/W3144654663","https://openalex.org/W1983035395","https://openalex.org/W2185414581"],"abstract_inverted_index":{"In":[0],"modern":[1],"cities,":[2],"more":[3,5],"and":[4,23,38,44,50,74,100,117,125],"people":[6],"drive":[7],"the":[8,12,35,41,90,97,104,115,120,129],"vehicles,":[9],"equipped":[10],"with":[11,107,110],"GPS":[13],"devices,":[14],"which":[15],"create":[16],"a":[17,30,52,63],"large":[18],"scale":[19],"of":[20,119],"trajectories.":[21],"Gathering":[22],"analyzing":[24],"these":[25],"large-scale":[26,105],"trajectory":[27,59],"data":[28,60],"provide":[29],"new":[31],"opportunity":[32],"to":[33,39,57,88],"understand":[34],"city":[36],"dynamics":[37],"reveal":[40],"hidden":[42],"social":[43],"economic":[45],"phenomena.":[46],"This":[47],"paper":[48],"designs":[49],"implements":[51],"tool,":[53],"named":[54],"as":[55,96],"PGWinFunc,":[56],"analyze":[58],"by":[61,131],"extending":[62],"traditional":[64],"relational":[65],"database.":[66],"Firstly":[67],"we":[68,85,126],"introduce":[69],"some":[70],"efficient":[71],"query":[72],"process":[73],"optimization":[75],"methods":[76],"for":[77],"SQL":[78,108],"Window":[79,111],"Aggregate":[80,112],"Functions":[81],"in":[82],"PostgreSQL.":[83],"Secondly,":[84],"present":[86],"how":[87],"mine":[89],"LBS":[91],"(Location-Based":[92],"Service)":[93],"patterns,":[94],"such":[95],"average":[98],"speed":[99],"traffic":[101],"flow,":[102],"from":[103],"trajectories":[106],"expression":[109],"Functions.":[113],"Finally,":[114],"effectiveness":[116],"efficiency":[118],"PGWinFunc":[121],"tool":[122],"are":[123],"demonstrated":[124],"also":[127],"visualized":[128],"results":[130],"BAIDU":[132],"MAP.":[133]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2018,"cited_by_count":1},{"year":2016,"cited_by_count":1}],"updated_date":"2026-07-29T14:22:42.915294","created_date":"2025-10-10T00:00:00"}