{"id":"https://openalex.org/W1987288934","doi":"https://doi.org/10.1145/1594156.1594161","title":"Validating the Oracle SQL engine","display_name":"Validating the Oracle SQL engine","publication_year":2009,"publication_date":"2009-06-29","ids":{"openalex":"https://openalex.org/W1987288934","doi":"https://doi.org/10.1145/1594156.1594161","mag":"1987288934"},"language":"en","primary_location":{"id":"doi:10.1145/1594156.1594161","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1594156.1594161","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the Second International Workshop on Testing Database Systems","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/A5051343710","display_name":"Allison Lee","orcid":"https://orcid.org/0000-0002-9464-0927"},"institutions":[{"id":"https://openalex.org/I1342911587","display_name":"Oracle (United States)","ror":"https://ror.org/006c77m33","country_code":"US","type":"company","lineage":["https://openalex.org/I1342911587"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Allison Lee","raw_affiliation_strings":["Oracle USA, Redwood Shores, CA","Oracle USA, Redwood Shores, CA#TAB#"],"affiliations":[{"raw_affiliation_string":"Oracle USA, Redwood Shores, CA","institution_ids":["https://openalex.org/I1342911587"]},{"raw_affiliation_string":"Oracle USA, Redwood Shores, CA#TAB#","institution_ids":["https://openalex.org/I1342911587"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5003966028","display_name":"Mohamed Za\u00eft","orcid":null},"institutions":[{"id":"https://openalex.org/I1342911587","display_name":"Oracle (United States)","ror":"https://ror.org/006c77m33","country_code":"US","type":"company","lineage":["https://openalex.org/I1342911587"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Mohamed Zait","raw_affiliation_strings":["Oracle USA, Redwood Shores, CA","Oracle USA, Redwood Shores, CA#TAB#"],"affiliations":[{"raw_affiliation_string":"Oracle USA, Redwood Shores, CA","institution_ids":["https://openalex.org/I1342911587"]},{"raw_affiliation_string":"Oracle USA, Redwood Shores, CA#TAB#","institution_ids":["https://openalex.org/I1342911587"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5084497894","display_name":"Thierry Cruanes","orcid":null},"institutions":[{"id":"https://openalex.org/I1342911587","display_name":"Oracle (United States)","ror":"https://ror.org/006c77m33","country_code":"US","type":"company","lineage":["https://openalex.org/I1342911587"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Thierry Cruanes","raw_affiliation_strings":["Oracle USA, Redwood Shores, CA","Oracle USA, Redwood Shores, CA#TAB#"],"affiliations":[{"raw_affiliation_string":"Oracle USA, Redwood Shores, CA","institution_ids":["https://openalex.org/I1342911587"]},{"raw_affiliation_string":"Oracle USA, Redwood Shores, CA#TAB#","institution_ids":["https://openalex.org/I1342911587"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5087534251","display_name":"Rafi Ahmed","orcid":"https://orcid.org/0000-0002-3336-1094"},"institutions":[{"id":"https://openalex.org/I1342911587","display_name":"Oracle (United States)","ror":"https://ror.org/006c77m33","country_code":"US","type":"company","lineage":["https://openalex.org/I1342911587"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Rafi Ahmed","raw_affiliation_strings":["Oracle USA, Redwood Shores, CA","Oracle USA, Redwood Shores, CA#TAB#"],"affiliations":[{"raw_affiliation_string":"Oracle USA, Redwood Shores, CA","institution_ids":["https://openalex.org/I1342911587"]},{"raw_affiliation_string":"Oracle USA, Redwood Shores, CA#TAB#","institution_ids":["https://openalex.org/I1342911587"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5101346829","display_name":"Yali Zhu","orcid":null},"institutions":[{"id":"https://openalex.org/I1342911587","display_name":"Oracle (United States)","ror":"https://ror.org/006c77m33","country_code":"US","type":"company","lineage":["https://openalex.org/I1342911587"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Yali Zhu","raw_affiliation_strings":["Oracle USA, Redwood Shores, CA","Oracle USA, Redwood Shores, CA#TAB#"],"affiliations":[{"raw_affiliation_string":"Oracle USA, Redwood Shores, CA","institution_ids":["https://openalex.org/I1342911587"]},{"raw_affiliation_string":"Oracle USA, Redwood Shores, CA#TAB#","institution_ids":["https://openalex.org/I1342911587"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":5,"corresponding_author_ids":["https://openalex.org/A5051343710"],"corresponding_institution_ids":["https://openalex.org/I1342911587"],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":{"value":0.08573795,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"1","last_page":"7"},"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.9998000264167786,"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.9998000264167786,"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.9968000054359436,"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/T11986","display_name":"Scientific Computing and Data Management","score":0.9947999715805054,"subfield":{"id":"https://openalex.org/subfields/1802","display_name":"Information Systems and Management"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.9224795699119568},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8606685996055603},{"id":"https://openalex.org/keywords/sargable","display_name":"Sargable","score":0.7896909713745117},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.7600815296173096},{"id":"https://openalex.org/keywords/query-expansion","display_name":"Query expansion","score":0.6864461898803711},{"id":"https://openalex.org/keywords/query-language","display_name":"Query language","score":0.5563778877258301},{"id":"https://openalex.org/keywords/rdf-query-language","display_name":"RDF query language","score":0.5549411177635193},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.544418454170227},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.5401446223258972},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.5163594484329224},{"id":"https://openalex.org/keywords/query-plan","display_name":"Query plan","score":0.5099564790725708},{"id":"https://openalex.org/keywords/web-query-classification","display_name":"Web query classification","score":0.5045114755630493},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.4602052569389343},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.44258826971054077},{"id":"https://openalex.org/keywords/materialized-view","display_name":"Materialized view","score":0.4312700033187866},{"id":"https://openalex.org/keywords/online-aggregation","display_name":"Online aggregation","score":0.41667264699935913},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.20537537336349487},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.10939529538154602}],"concepts":[{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.9224795699119568},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8606685996055603},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.7896909713745117},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.7600815296173096},{"id":"https://openalex.org/C99016210","wikidata":"https://www.wikidata.org/wiki/Q5488129","display_name":"Query expansion","level":2,"score":0.6864461898803711},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.5563778877258301},{"id":"https://openalex.org/C96956885","wikidata":"https://www.wikidata.org/wiki/Q6138701","display_name":"RDF query language","level":5,"score":0.5549411177635193},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.544418454170227},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.5401446223258972},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.5163594484329224},{"id":"https://openalex.org/C2779729312","wikidata":"https://www.wikidata.org/wiki/Q784232","display_name":"Query plan","level":5,"score":0.5099564790725708},{"id":"https://openalex.org/C118689300","wikidata":"https://www.wikidata.org/wiki/Q7978614","display_name":"Web query classification","level":4,"score":0.5045114755630493},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4602052569389343},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.44258826971054077},{"id":"https://openalex.org/C98199447","wikidata":"https://www.wikidata.org/wiki/Q2445044","display_name":"Materialized view","level":4,"score":0.4312700033187866},{"id":"https://openalex.org/C24028149","wikidata":"https://www.wikidata.org/wiki/Q7094056","display_name":"Online aggregation","level":5,"score":0.41667264699935913},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.20537537336349487},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.10939529538154602}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/1594156.1594161","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1594156.1594161","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the Second International Workshop on Testing Database Systems","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":12,"referenced_works":["https://openalex.org/W1504218467","https://openalex.org/W1556422040","https://openalex.org/W1804205637","https://openalex.org/W1902008843","https://openalex.org/W2003789154","https://openalex.org/W2040856861","https://openalex.org/W2063281504","https://openalex.org/W2117480765","https://openalex.org/W2141575847","https://openalex.org/W2610862665","https://openalex.org/W4251192040","https://openalex.org/W6680987061"],"related_works":["https://openalex.org/W3125756434","https://openalex.org/W2955368753","https://openalex.org/W2410487789","https://openalex.org/W2941854747","https://openalex.org/W906795786","https://openalex.org/W2406556739","https://openalex.org/W2161787409","https://openalex.org/W2384082882","https://openalex.org/W4248548228","https://openalex.org/W2037168816"],"abstract_inverted_index":{"The":[0,41],"query":[1,36,39,44,75,87,132,147,180,186,192,201,214],"engine":[2],"is":[3,11,38,46,162],"the":[4,14,31,49,59,63,67,83,86,103,107,117,125,137,143,170,176,179],"component":[5],"inside":[6],"a":[7,24,130,154,189,197,205],"database":[8,25],"system":[9],"that":[10,173,182,210,217],"responsible":[12],"for":[13,129],"compilation":[15,37,187],"and":[16,56,78,114],"execution":[17,51,127],"of":[18,30,35,43,74,85,106,116,178],"every":[19],"SQL":[20,144],"statement":[21,145],"submitted":[22],"by":[23,90,136],"user":[26],"or":[27,157],"application.":[28],"One":[29],"most":[32],"important":[33],"steps":[34],"optimization.":[40,193],"goal":[42],"optimization":[45,82,101,148,161,215],"to":[47,62,123,142,199,207],"find":[48,124],"best":[50,126],"plan":[52,128],"based":[53],"on":[54,191],"metadata":[55],"statistics":[57],"about":[58],"objects":[60],"related":[61],"tables":[64,108],"referenced":[65],"in":[66],"statement.":[68],"There":[69],"are":[70,88,211],"two":[71],"distinct":[72],"kinds":[73],"optimization:":[76],"logical":[77,81,138],"physical.":[79],"During":[80],"structures":[84,181],"changed":[89],"applying":[91],"transformations":[92],"such":[93],"as":[94,134],"view":[95],"merging,":[96],"subquery":[97],"unnesting,":[98],"etc.":[99],"Physical":[100],"considers":[102],"physical":[104],"properties":[105,115],"(disk":[109],"layout,":[110],"access":[111],"methods,":[112],"size)":[113],"relational":[118],"algebra":[119],"operations":[120],"(commuting":[121],"joins)":[122],"given":[131],"shape":[133],"presented":[135],"optimization.The":[139],"changes":[140],"made":[141],"during":[146,175,185,213],"can":[149],"be":[150,219],"temporary":[151],"(to":[152],"cost":[153],"particular":[155],"optimization)":[156],"permanent":[158],"(after":[159],"an":[160],"considered":[163],"final).":[164],"In":[165],"this":[166],"paper":[167],"we":[168],"discuss":[169],"quality":[171],"problems":[172],"occur":[174],"manipulation":[177],"take":[183],"place":[184],"with":[188],"focus":[190],"We":[194],"propose":[195],"(1)":[196],"method":[198,206],"validate":[200,208],"structure":[202],"change;":[203],"(2)":[204],"plans":[209],"discarded":[212],"but":[216],"may":[218],"picked":[220],"under":[221],"different":[222],"circumstances.":[223]},"counts_by_year":[],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}