{"id":"https://openalex.org/W1649428069","doi":"https://doi.org/10.3233/fi-2014-1139","title":"Query Rewriting Based on Meta-Granular Aggregation","display_name":"Query Rewriting Based on Meta-Granular Aggregation","publication_year":2014,"publication_date":"2014-01-01","ids":{"openalex":"https://openalex.org/W1649428069","doi":"https://doi.org/10.3233/fi-2014-1139","mag":"1649428069"},"language":"en","primary_location":{"id":"doi:10.3233/fi-2014-1139","is_oa":false,"landing_page_url":"https://doi.org/10.3233/fi-2014-1139","pdf_url":null,"source":{"id":"https://openalex.org/S39012697","display_name":"Fundamenta Informaticae","issn_l":"0169-2968","issn":["0169-2968","1875-8681"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310318577","host_organization_name":"IOS Press","host_organization_lineage":["https://openalex.org/P4310318577"],"host_organization_lineage_names":["IOS Press"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Fundamenta Informaticae","raw_type":"journal-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/A5046435870","display_name":"Piotr Wi\u015bniewski","orcid":"https://orcid.org/0000-0003-3777-642X"},"institutions":[{"id":"https://openalex.org/I3019271933","display_name":"Nicolaus Copernicus University","ror":"https://ror.org/0102mm775","country_code":"PL","type":"education","lineage":["https://openalex.org/I3019271933"]}],"countries":["PL"],"is_corresponding":true,"raw_author_name":"Piotr Wi\u015bniewski","raw_affiliation_strings":["Faculty of Mathematics and Computer Science, Nicolaus Copernicus University, Toru\u0144, Poland. pikonrad@mat.umk.pl"],"affiliations":[{"raw_affiliation_string":"Faculty of Mathematics and Computer Science, Nicolaus Copernicus University, Toru\u0144, Poland. pikonrad@mat.umk.pl","institution_ids":["https://openalex.org/I3019271933"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5071225072","display_name":"Krzysztof Stencel","orcid":"https://orcid.org/0000-0001-6356-4872"},"institutions":[{"id":"https://openalex.org/I4654613","display_name":"University of Warsaw","ror":"https://ror.org/039bjqg32","country_code":"PL","type":"education","lineage":["https://openalex.org/I4654613"]}],"countries":["PL"],"is_corresponding":false,"raw_author_name":"Krzysztof Stencel","raw_affiliation_strings":["Institute of Informatics, University of Warsaw, Warsaw, Poland. stencel@mimuw.edu.pl","Institute of Informatics, University of Warsaw, Warsaw, Poland. stencel@mimuw.edu.pl#TAB#"],"affiliations":[{"raw_affiliation_string":"Institute of Informatics, University of Warsaw, Warsaw, Poland. stencel@mimuw.edu.pl","institution_ids":["https://openalex.org/I4654613"]},{"raw_affiliation_string":"Institute of Informatics, University of Warsaw, Warsaw, Poland. stencel@mimuw.edu.pl#TAB#","institution_ids":["https://openalex.org/I4654613"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5046435870"],"corresponding_institution_ids":["https://openalex.org/I3019271933"],"apc_list":null,"apc_paid":null,"fwci":0.6896,"has_fulltext":false,"cited_by_count":2,"citation_normalized_percentile":{"value":0.72057322,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":94},"biblio":{"volume":"135","issue":"4","first_page":"537","last_page":"551"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9994000196456909,"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"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9994000196456909,"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/T11106","display_name":"Data Management and Algorithms","score":0.9993000030517578,"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/T11010","display_name":"Logic, Reasoning, and Knowledge","score":0.9966999888420105,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"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/rewriting","display_name":"Rewriting","score":0.7751673460006714},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.6339554786682129},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.41598808765411377},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.39088699221611023},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.3401525020599365}],"concepts":[{"id":"https://openalex.org/C154690210","wikidata":"https://www.wikidata.org/wiki/Q1668499","display_name":"Rewriting","level":2,"score":0.7751673460006714},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6339554786682129},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.41598808765411377},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.39088699221611023},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.3401525020599365}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.3233/fi-2014-1139","is_oa":false,"landing_page_url":"https://doi.org/10.3233/fi-2014-1139","pdf_url":null,"source":{"id":"https://openalex.org/S39012697","display_name":"Fundamenta Informaticae","issn_l":"0169-2968","issn":["0169-2968","1875-8681"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310318577","host_organization_name":"IOS Press","host_organization_lineage":["https://openalex.org/P4310318577"],"host_organization_lineage_names":["IOS Press"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Fundamenta Informaticae","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/8","score":0.6399999856948853,"display_name":"Decent work and economic growth"}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":22,"referenced_works":["https://openalex.org/W1537538497","https://openalex.org/W1556530724","https://openalex.org/W1917859741","https://openalex.org/W1975731516","https://openalex.org/W2002711156","https://openalex.org/W2028740113","https://openalex.org/W2041563709","https://openalex.org/W2081593332","https://openalex.org/W2098082683","https://openalex.org/W2106867122","https://openalex.org/W2113599028","https://openalex.org/W2120108467","https://openalex.org/W2126321570","https://openalex.org/W2150716099","https://openalex.org/W2151310484","https://openalex.org/W2159726625","https://openalex.org/W2201991527","https://openalex.org/W2248652221","https://openalex.org/W2394538003","https://openalex.org/W2572666456","https://openalex.org/W2615052440","https://openalex.org/W2766000922"],"related_works":["https://openalex.org/W2899084033","https://openalex.org/W2748952813","https://openalex.org/W2120204135","https://openalex.org/W1796293478","https://openalex.org/W2168276503","https://openalex.org/W2139396251","https://openalex.org/W1577544887","https://openalex.org/W1573537275","https://openalex.org/W2105713543","https://openalex.org/W4205908955"],"abstract_inverted_index":{"Analytic":[0],"database":[1,45,176,247],"queries":[2,19,136,217],"are":[3],"exceptionally":[4],"time":[5],"consuming.":[6],"Decision":[7],"support":[8],"systems":[9],"employ":[10],"various":[11],"execution":[12],"techniques":[13],"in":[14,32,72,141,228],"order":[15,98],"to":[16,107,133,164,183,190,235,250],"accelerate":[17],"such":[18],"and":[20,61,90,121,152,167,180,218,257],"reduce":[21],"their":[22,59],"resource":[23],"consumption.":[24],"Probably":[25],"the":[26,44,48,80,86,101,138,161,185,225,229,237],"most":[27],"important":[28],"of":[29,34,40,50,58,82,116,149,160,188,231,233,255,260],"them":[30],"consists":[31],"materialization":[33],"partial":[35,69,97],"results.":[36],"However,":[37],"any":[38],"introduction":[39],"derived":[41],"objects":[42],"into":[43],"schema":[46],"increases":[47],"cost":[49,210],"software":[51],"development,":[52],"since":[53],"programmers":[54],"must":[55],"take":[56],"care":[57],"usage":[60],"synchronization.":[62],"In":[63],"this":[64,150],"article":[65],"we":[66,111,122,172,181,207,240],"consider":[67],"using":[68,158],"aggregations":[70],"materialized":[71],"additional":[73],"tables.":[74],"The":[75],"idea":[76],"is":[77,119,178],"based":[78],"on":[79,88,204],"concept":[81],"metagranules":[83,118,189,234],"that":[84,99,113,174,212],"represent":[85],"information":[87,139],"grouping":[89],"used":[91],"aggregations.":[92],"Metagranules":[93],"have":[94],"a":[95,114,124,128,175,201,209],"natural":[96],"guides":[100],"optimisation":[102],"process.":[103],"We":[104,126,143,222],"present":[105,127],"solutions":[106],"two":[108],"problems.":[109],"Firstly,":[110],"assume":[112,173],"set":[115,187],"stored":[117,140],"given":[120,179],"optimize":[123],"query.":[125],"novel":[129],"query":[130],"rewriting":[131],"method":[132,151],"make":[134],"analytic":[135],"use":[137],"metagranules.":[142],"also":[144,199],"describe":[145],"our":[146],"proof-of-concept":[147],"implementation":[148],"perform":[153],"an":[154],"extensive":[155],"experimental":[156],"evaluation":[157],"databases":[159],"size":[162],"up":[163,249],"0:5":[165,251],"TiB":[166,252],"6":[168],"billions":[169,254],"rows.":[170,262],"Secondly,":[171],"workload":[177],"want":[182],"select":[184],"optimal":[186,244],"materialize.":[191],"Although":[192],"each":[193],"metagranule":[194],"accelerates":[195],"some":[196],"queries,":[197],"it":[198],"imposes":[200],"significant":[202],"overhead":[203],"updates.":[205,221],"Therefore,":[206],"propose":[208],"model":[211],"includes":[213],"both":[214],"benefits":[215],"for":[216,220],"penalties":[219],"experiment":[223],"with":[224,253],"complete":[226],"search":[227],"space":[230],"sets":[232,245],"find":[236],"optimum.":[238],"Finally,":[239],"empirically":[241],"verify":[242],"identified":[243],"against":[246],"instances":[248],"rows":[256],"hundreds":[258],"millions":[259],"aggregated":[261]},"counts_by_year":[{"year":2017,"cited_by_count":1},{"year":2014,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}