{"id":"https://openalex.org/W2119046278","doi":"https://doi.org/10.1145/1989323.1989335","title":"Scalable query rewriting","display_name":"Scalable query rewriting","publication_year":2011,"publication_date":"2011-06-12","ids":{"openalex":"https://openalex.org/W2119046278","doi":"https://doi.org/10.1145/1989323.1989335","mag":"2119046278"},"language":"en","primary_location":{"id":"doi:10.1145/1989323.1989335","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1989323.1989335","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2011 ACM SIGMOD International Conference on Management of data","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/A5000674196","display_name":"George Konstantinidis","orcid":"https://orcid.org/0000-0002-3962-9303"},"institutions":[{"id":"https://openalex.org/I1174212","display_name":"University of Southern California","ror":"https://ror.org/03taz7m60","country_code":"US","type":"education","lineage":["https://openalex.org/I1174212"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"George Konstantinidis","raw_affiliation_strings":["Information Sciences Institute / University of Southern California, Los Angeles, CA, USA","[Information Sciences Institute, University of Southern California, Los Angeles, CA, USA]"],"affiliations":[{"raw_affiliation_string":"Information Sciences Institute / University of Southern California, Los Angeles, CA, USA","institution_ids":["https://openalex.org/I1174212"]},{"raw_affiliation_string":"[Information Sciences Institute, University of Southern California, Los Angeles, CA, USA]","institution_ids":["https://openalex.org/I1174212"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5033175043","display_name":"Jos\u00e9 Luis Ambite","orcid":"https://orcid.org/0000-0003-0087-080X"},"institutions":[{"id":"https://openalex.org/I1174212","display_name":"University of Southern California","ror":"https://ror.org/03taz7m60","country_code":"US","type":"education","lineage":["https://openalex.org/I1174212"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Jos\u00e9 Luis Ambite","raw_affiliation_strings":["Information Sciences Institute / University of Southern California, Los Angeles, CA, USA","[Information Sciences Institute, University of Southern California, Los Angeles, CA, USA]"],"affiliations":[{"raw_affiliation_string":"Information Sciences Institute / University of Southern California, Los Angeles, CA, USA","institution_ids":["https://openalex.org/I1174212"]},{"raw_affiliation_string":"[Information Sciences Institute, University of Southern California, Los Angeles, CA, USA]","institution_ids":["https://openalex.org/I1174212"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5000674196"],"corresponding_institution_ids":["https://openalex.org/I1174212"],"apc_list":null,"apc_paid":null,"fwci":5.2511,"has_fulltext":false,"cited_by_count":34,"citation_normalized_percentile":{"value":0.95759042,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":90,"max":99},"biblio":{"volume":null,"issue":null,"first_page":"97","last_page":"108"},"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.9998999834060669,"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.9998999834060669,"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.9995999932289124,"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/T10215","display_name":"Semantic Web and Ontologies","score":0.9968000054359436,"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/computer-science","display_name":"Computer science","score":0.8201289176940918},{"id":"https://openalex.org/keywords/rewriting","display_name":"Rewriting","score":0.7427903413772583},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.547749936580658},{"id":"https://openalex.org/keywords/scalability","display_name":"Scalability","score":0.5461170077323914},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.41133207082748413},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.35616058111190796},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.24622204899787903}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8201289176940918},{"id":"https://openalex.org/C154690210","wikidata":"https://www.wikidata.org/wiki/Q1668499","display_name":"Rewriting","level":2,"score":0.7427903413772583},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.547749936580658},{"id":"https://openalex.org/C48044578","wikidata":"https://www.wikidata.org/wiki/Q727490","display_name":"Scalability","level":2,"score":0.5461170077323914},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.41133207082748413},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.35616058111190796},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.24622204899787903}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1145/1989323.1989335","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1989323.1989335","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2011 ACM SIGMOD International Conference on Management of data","raw_type":"proceedings-article"},{"id":"pmh:oai:eprints.soton.ac.uk:504279","is_oa":false,"landing_page_url":"http://doi.org/10.1145/1989323.1989335>).","pdf_url":null,"source":{"id":"https://openalex.org/S4306401019","display_name":"ePrints Soton (University of Southampton)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I43439940","host_organization_name":"University of Southampton","host_organization_lineage":["https://openalex.org/I43439940"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"acceptedVersion","is_accepted":true,"is_published":false,"raw_source_name":null,"raw_type":"PeerReviewed"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[{"id":"https://openalex.org/F4320332161","display_name":"National Institutes of Health","ror":"https://ror.org/01cwqze88"},{"id":"https://openalex.org/F4320337375","display_name":"National Center for Research Resources","ror":"https://ror.org/04pw6fb54"}],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":23,"referenced_works":["https://openalex.org/W85930010","https://openalex.org/W1259047570","https://openalex.org/W1483941173","https://openalex.org/W1507099003","https://openalex.org/W1558832481","https://openalex.org/W1879587332","https://openalex.org/W1975733288","https://openalex.org/W1979514837","https://openalex.org/W1992673035","https://openalex.org/W2002658260","https://openalex.org/W2019720483","https://openalex.org/W2050882124","https://openalex.org/W2094394144","https://openalex.org/W2097989803","https://openalex.org/W2122816361","https://openalex.org/W2132694984","https://openalex.org/W2145285202","https://openalex.org/W2146067979","https://openalex.org/W2152191782","https://openalex.org/W2155094138","https://openalex.org/W3005907268","https://openalex.org/W6633513001","https://openalex.org/W6682610116"],"related_works":["https://openalex.org/W2120204135","https://openalex.org/W2139396251","https://openalex.org/W1796293478","https://openalex.org/W1577544887","https://openalex.org/W2168276503","https://openalex.org/W1573537275","https://openalex.org/W2105713543","https://openalex.org/W4205908955","https://openalex.org/W174435416","https://openalex.org/W2132239740"],"abstract_inverted_index":{"In":[0],"this":[1],"paper":[2],"we":[3,42,56],"consider":[4,24],"the":[5,50,74],"problem":[6,51],"of":[7,96],"answering":[8],"queries":[9,29,104],"using":[10,105],"views,":[11,31],"which":[12,32,68],"is":[13,34,38],"important":[14],"for":[15,44],"data":[16,21,39],"integration,":[17,40],"query":[18],"optimization,":[19],"and":[20,30,64,77],"warehouses.":[22],"We":[23],"its":[25],"simplest":[26],"form,":[27],"conjunctive":[28],"already":[33],"NP-complete.":[35],"Our":[36],"context":[37],"so":[41],"search":[43],"maximally-contained":[45],"rewritings.":[46],"By":[47],"looking":[48],"at":[49],"from":[52],"a":[53,61],"graph":[54],"perspective":[55],"are":[57],"able":[58],"to":[59],"gain":[60],"better":[62],"insight":[63],"develop":[65],"an":[66,90],"algorithm":[67],"compactly":[69],"represents":[70],"common":[71],"patterns":[72],"in":[73,89],"source":[75],"descriptions,":[76],"(optionally)":[78],"pushes":[79],"some":[80],"computation":[81],"offline.":[82],"This":[83],"together":[84],"with":[85],"other":[86],"optimizations":[87],"result":[88],"experimental":[91],"performance":[92],"about":[93],"two":[94],"orders":[95],"magnitude":[97],"faster":[98],"than":[99],"current":[100],"state-of-the-art":[101],"algorithms,":[102],"rewriting":[103],"over":[106],"10000":[107],"views":[108],"within":[109],"seconds.":[110]},"counts_by_year":[{"year":2022,"cited_by_count":2},{"year":2021,"cited_by_count":3},{"year":2020,"cited_by_count":2},{"year":2019,"cited_by_count":3},{"year":2018,"cited_by_count":2},{"year":2017,"cited_by_count":2},{"year":2016,"cited_by_count":1},{"year":2015,"cited_by_count":4},{"year":2014,"cited_by_count":7},{"year":2013,"cited_by_count":5},{"year":2012,"cited_by_count":3}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2016-06-24T00:00:00"}