{"id":"https://openalex.org/W2902368476","doi":"https://doi.org/10.1587/transinf.2018edp7058","title":"Currency Preserving Query: Selecting the Newest Values from Multiple Tables","display_name":"Currency Preserving Query: Selecting the Newest Values from Multiple Tables","publication_year":2018,"publication_date":"2018-11-30","ids":{"openalex":"https://openalex.org/W2902368476","doi":"https://doi.org/10.1587/transinf.2018edp7058","mag":"2902368476"},"language":"en","primary_location":{"id":"doi:10.1587/transinf.2018edp7058","is_oa":true,"landing_page_url":"https://doi.org/10.1587/transinf.2018edp7058","pdf_url":"https://www.jstage.jst.go.jp/article/transinf/E101.D/12/E101.D_2018EDP7058/_pdf","source":{"id":"https://openalex.org/S2486202937","display_name":"IEICE Transactions on Information and Systems","issn_l":"0916-8532","issn":["0916-8532","1745-1361"],"is_oa":true,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4320800604","host_organization_name":"Institute of Electronics, Information and Communication Engineers","host_organization_lineage":["https://openalex.org/P4320800604"],"host_organization_lineage_names":["Institute of Electronics, Information and Communication Engineers"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IEICE Transactions on Information and Systems","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"diamond","oa_url":"https://www.jstage.jst.go.jp/article/transinf/E101.D/12/E101.D_2018EDP7058/_pdf","any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5100716223","display_name":"Mohan Li","orcid":"https://orcid.org/0000-0002-2290-046X"},"institutions":[{"id":"https://openalex.org/I37987034","display_name":"Guangzhou University","ror":"https://ror.org/05ar8rn06","country_code":"CN","type":"education","lineage":["https://openalex.org/I37987034"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Mohan LI","raw_affiliation_strings":["Guangzhou University"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Guangzhou University","institution_ids":["https://openalex.org/I37987034"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5065867178","display_name":"Yanbin Sun","orcid":"https://orcid.org/0000-0002-8157-5337"},"institutions":[{"id":"https://openalex.org/I37987034","display_name":"Guangzhou University","ror":"https://ror.org/05ar8rn06","country_code":"CN","type":"education","lineage":["https://openalex.org/I37987034"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Yanbin SUN","raw_affiliation_strings":["Guangzhou University"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Guangzhou University","institution_ids":["https://openalex.org/I37987034"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I37987034"],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":true,"cited_by_count":1,"citation_normalized_percentile":{"value":0.1760619,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":94},"biblio":{"volume":"E101.D","issue":"12","first_page":"3059","last_page":"3072"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11719","display_name":"Data Quality and Management","score":0.9998999834060669,"subfield":{"id":"https://openalex.org/subfields/1803","display_name":"Management Science and Operations Research"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},"topics":[{"id":"https://openalex.org/T11719","display_name":"Data Quality and Management","score":0.9998999834060669,"subfield":{"id":"https://openalex.org/subfields/1803","display_name":"Management Science and Operations Research"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9973000288009644,"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/T12016","display_name":"Web Data Mining and Analysis","score":0.9923999905586243,"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.8616151213645935},{"id":"https://openalex.org/keywords/heuristics","display_name":"Heuristics","score":0.6049373745918274},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.5769286751747131},{"id":"https://openalex.org/keywords/table","display_name":"Table (database)","score":0.5350908041000366},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.4765204191207886},{"id":"https://openalex.org/keywords/graph","display_name":"Graph","score":0.44171157479286194},{"id":"https://openalex.org/keywords/query-expansion","display_name":"Query expansion","score":0.441048264503479},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.37653693556785583},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.3375905156135559}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8616151213645935},{"id":"https://openalex.org/C127705205","wikidata":"https://www.wikidata.org/wiki/Q5748245","display_name":"Heuristics","level":2,"score":0.6049373745918274},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.5769286751747131},{"id":"https://openalex.org/C45235069","wikidata":"https://www.wikidata.org/wiki/Q278425","display_name":"Table (database)","level":2,"score":0.5350908041000366},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.4765204191207886},{"id":"https://openalex.org/C132525143","wikidata":"https://www.wikidata.org/wiki/Q141488","display_name":"Graph","level":2,"score":0.44171157479286194},{"id":"https://openalex.org/C99016210","wikidata":"https://www.wikidata.org/wiki/Q5488129","display_name":"Query expansion","level":2,"score":0.441048264503479},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.37653693556785583},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.3375905156135559},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1587/transinf.2018edp7058","is_oa":true,"landing_page_url":"https://doi.org/10.1587/transinf.2018edp7058","pdf_url":"https://www.jstage.jst.go.jp/article/transinf/E101.D/12/E101.D_2018EDP7058/_pdf","source":{"id":"https://openalex.org/S2486202937","display_name":"IEICE Transactions on Information and Systems","issn_l":"0916-8532","issn":["0916-8532","1745-1361"],"is_oa":true,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4320800604","host_organization_name":"Institute of Electronics, Information and Communication Engineers","host_organization_lineage":["https://openalex.org/P4320800604"],"host_organization_lineage_names":["Institute of Electronics, Information and Communication Engineers"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IEICE Transactions on Information and Systems","raw_type":"journal-article"}],"best_oa_location":{"id":"doi:10.1587/transinf.2018edp7058","is_oa":true,"landing_page_url":"https://doi.org/10.1587/transinf.2018edp7058","pdf_url":"https://www.jstage.jst.go.jp/article/transinf/E101.D/12/E101.D_2018EDP7058/_pdf","source":{"id":"https://openalex.org/S2486202937","display_name":"IEICE Transactions on Information and Systems","issn_l":"0916-8532","issn":["0916-8532","1745-1361"],"is_oa":true,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4320800604","host_organization_name":"Institute of Electronics, Information and Communication Engineers","host_organization_lineage":["https://openalex.org/P4320800604"],"host_organization_lineage_names":["Institute of Electronics, Information and Communication Engineers"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IEICE Transactions on Information and Systems","raw_type":"journal-article"},"sustainable_development_goals":[],"awards":[{"id":"https://openalex.org/G864097663","display_name":null,"funder_award_id":"61702223","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"},{"id":"https://openalex.org/G8781063685","display_name":null,"funder_award_id":"61702220","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"}],"funders":[{"id":"https://openalex.org/F4320321001","display_name":"National Natural Science Foundation of China","ror":"https://ror.org/01h0zpd94"},{"id":"https://openalex.org/F4320335787","display_name":"Fundamental Research Funds for the Central Universities","ror":null}],"has_content":{"pdf":true,"grobid_xml":true},"content_urls":{"pdf":"https://content.openalex.org/works/W2902368476.pdf","grobid_xml":"https://content.openalex.org/works/W2902368476.grobid-xml"},"referenced_works_count":28,"referenced_works":["https://openalex.org/W1521736627","https://openalex.org/W1965950877","https://openalex.org/W1979101951","https://openalex.org/W2003684739","https://openalex.org/W2011039300","https://openalex.org/W2073545563","https://openalex.org/W2075669347","https://openalex.org/W2081129187","https://openalex.org/W2092770599","https://openalex.org/W2108991785","https://openalex.org/W2110313425","https://openalex.org/W2114887670","https://openalex.org/W2117366235","https://openalex.org/W2118966355","https://openalex.org/W2137242774","https://openalex.org/W2139789109","https://openalex.org/W2162061797","https://openalex.org/W2189447200","https://openalex.org/W2211160973","https://openalex.org/W2251214202","https://openalex.org/W2271831620","https://openalex.org/W2296063924","https://openalex.org/W2401610261","https://openalex.org/W2407689013","https://openalex.org/W2611804663","https://openalex.org/W2611988335","https://openalex.org/W3146259567","https://openalex.org/W4291714342"],"related_works":["https://openalex.org/W2096359267","https://openalex.org/W2006459955","https://openalex.org/W2146885082","https://openalex.org/W2538384344","https://openalex.org/W2572349046","https://openalex.org/W4386051213","https://openalex.org/W185198413","https://openalex.org/W3125756434","https://openalex.org/W3049728138","https://openalex.org/W2348136644"],"abstract_inverted_index":{"In":[0,127],"many":[1],"applications,":[2],"tables":[3,119,168],"are":[4,98,227],"distributively":[5],"stored":[6,99],"in":[7,65,96,100,189],"different":[8,34,105,155],"data":[9,18,46,63,94,106,156,242],"sources,":[10],"but":[11],"the":[12,30,37,55,59,62,66,88,93,123,132,144,151,166,174,190,208,231,246,251],"frequency":[13],"of":[14,43,61,92,153,210,250],"updates":[15],"on":[16,117,173,237],"each":[17],"source":[19],"is":[20,162,183,218],"different.":[21,71],"Some":[22],"techniques":[23],"have":[24,109],"been":[25],"proposed":[26,163,252],"to":[27,54,120,142,149,164,185,196,220,229,244],"effectively":[28],"express":[29],"temporal":[31,56],"orders":[32],"between":[33],"values,":[35],"and":[36,139,169,192,223,240,248],"most":[38,89],"current,":[39],"i.e.":[40],"up-to-date,":[41],"value":[42],"a":[44,75,79,101,114,159,179,186,198,201],"given":[45],"item":[47],"can":[48,112],"be":[49,70,84,221],"easily":[50],"picked":[51],"up":[52],"according":[53],"orders.":[57],"However,":[58],"currency":[60,136,146,180,213],"items":[64,95],"same":[67],"table":[68,80],"may":[69,108],"That":[72],"is,":[73],"when":[74],"user":[76],"asks":[77],"for":[78],"D,":[81],"it":[82],"cannot":[83],"ensured":[85],"that":[86,178],"all":[87,122],"current":[90,125],"values":[91],"D":[97],"single":[102],"table.":[103],"Since":[104],"sources":[107],"overlaps,":[110],"we":[111,130,176,206,234],"construct":[113],"conjunctive":[115,133],"query":[116,134,148,182,199],"multiple":[118],"get":[121],"required":[124],"values.":[126],"this":[128],"paper,":[129],"formalize":[131],"as":[135],"preserving":[137,147,181,214],"query,":[138],"study":[140,207],"how":[141],"generate":[143,197],"minimized":[145,212],"reduce":[150],"cost":[152],"visiting":[154],"sources.":[157],"First,":[158],"graph":[160],"model":[161],"represent":[165],"distributed":[167],"their":[170],"relationships.":[171],"Based":[172],"model,":[175],"prove":[177],"equivalent":[184],"terminal":[187,202],"tree":[188],"graph,":[191],"give":[193],"an":[194],"algorithm":[195],"from":[200],"tree.":[203],"After":[204],"that,":[205],"problem":[209,217],"finding":[211],"query.":[215],"The":[216],"proved":[219],"NP-hard,":[222],"some":[224],"heuristics":[225],"strategies":[226],"provided":[228],"solve":[230],"problem.":[232],"Finally,":[233],"conduct":[235],"experiments":[236],"both":[238],"synthetic":[239],"real":[241],"sets":[243],"verify":[245],"effectiveness":[247],"efficiency":[249],"techniques.":[253]},"counts_by_year":[{"year":2023,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}