{"id":"https://openalex.org/W1904036550","doi":"https://doi.org/10.14778/2824032.2824074","title":"Query optimization in Oracle 12c database in-memory","display_name":"Query optimization in Oracle 12c database in-memory","publication_year":2015,"publication_date":"2015-08-01","ids":{"openalex":"https://openalex.org/W1904036550","doi":"https://doi.org/10.14778/2824032.2824074","mag":"1904036550"},"language":"en","primary_location":{"id":"doi:10.14778/2824032.2824074","doi":"https://doi.org/10.14778/2824032.2824074","is_oa":false,"landing_page_url":"https://doi.org/10.14778/2824032.2824074","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["cwts-core","dongbi-b","norway-2","poland-20","russia-white-list-1","vabb-shw"],"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"conference"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the VLDB Endowment","raw_type":"journal-article"},"volume":null,"type":"article","is_traditional":true,"indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"http://infoscience.epfl.ch/record/210743","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5048369180","display_name":"Dinesh Das","orcid":null,"observed_orcids":[]},"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":"Dinesh Das","raw_affiliation_strings":["Oracle"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Oracle","institution_ids":["https://openalex.org/I1342911587"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5101988437","display_name":"Jiaqi Yan","orcid":"https://orcid.org/0000-0001-6261-6802","observed_orcids":["https://orcid.org/0000-0001-6261-6802"]},"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":"Jiaqi Yan","raw_affiliation_strings":["Oracle"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Oracle","institution_ids":["https://openalex.org/I1342911587"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5003966028","display_name":"Mohamed Za\u00eft","orcid":null,"observed_orcids":[]},"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"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Oracle","institution_ids":["https://openalex.org/I1342911587"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5049684258","display_name":"Satyanarayana R. Valluri","orcid":"https://orcid.org/0000-0003-2314-2928","observed_orcids":["https://orcid.org/0000-0003-2314-2928"]},"institutions":[{"id":"https://openalex.org/I5124864","display_name":"\u00c9cole Polytechnique F\u00e9d\u00e9rale de Lausanne","ror":"https://ror.org/02s376052","country_code":"CH","type":"education","lineage":["https://openalex.org/I2799323385","https://openalex.org/I5124864"]}],"countries":["CH"],"is_corresponding":false,"raw_author_name":"Satyanarayana R. Valluri","raw_affiliation_strings":["EPFL, Switzerland"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"EPFL, Switzerland","institution_ids":["https://openalex.org/I5124864"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5089890915","display_name":"Nirav Vyas","orcid":null,"observed_orcids":[]},"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":"Nirav Vyas","raw_affiliation_strings":["Oracle"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Oracle","institution_ids":["https://openalex.org/I1342911587"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5019479352","display_name":"Ramarajan Krishnamachari","orcid":"https://orcid.org/0009-0006-4547-8739","observed_orcids":["https://orcid.org/0009-0006-4547-8739"]},"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":"Ramarajan Krishnamachari","raw_affiliation_strings":["Oracle"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Oracle","institution_ids":["https://openalex.org/I1342911587"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5005835027","display_name":"Prashant Gaharwar","orcid":null,"observed_orcids":[]},"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":"Prashant Gaharwar","raw_affiliation_strings":["Oracle"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Oracle","institution_ids":["https://openalex.org/I1342911587"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5055961430","display_name":"Jesse Kamp","orcid":null,"observed_orcids":[]},"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":"Jesse Kamp","raw_affiliation_strings":["Oracle"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Oracle","institution_ids":["https://openalex.org/I1342911587"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5103287143","display_name":"Niloy Mukherjee","orcid":null,"observed_orcids":[]},"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":"Niloy Mukherjee","raw_affiliation_strings":["Oracle"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Oracle","institution_ids":["https://openalex.org/I1342911587"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":3.7689,"has_fulltext":false,"cited_by_count":32,"citation_normalized_percentile":{"value":0.93271482,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":88,"max":99},"biblio":{"volume":"8","issue":"12","first_page":"1770","last_page":"1781"},"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.9994999766349792,"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"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9994999766349792,"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"}},{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.00019999999494757503,"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"}},{"id":"https://openalex.org/T10054","display_name":"Parallel Computing and Optimization Techniques","score":0.0,"subfield":{"id":"https://openalex.org/subfields/1708","display_name":"Hardware and Architecture"},"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/query-optimization","display_name":"query optimization","score":0.968999981880188},{"id":"https://openalex.org/keywords/execution-plans","display_name":"execution plans","score":0.7110000252723694},{"id":"https://openalex.org/keywords/cost-model","display_name":"cost model","score":0.7070000171661377},{"id":"https://openalex.org/keywords/query-transformation","display_name":"query transformation","score":0.7519999742507935},{"id":"https://openalex.org/keywords/join-optimization","display_name":"join optimization","score":0.8650000095367432},{"id":"https://openalex.org/keywords/parallel-queries","display_name":"parallel queries","score":0.6549999713897705},{"id":"https://openalex.org/keywords/database-statistics","display_name":"database statistics","score":0.6919999718666077}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8698756694793701},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.6264712810516357},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.5899616479873657},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5868517160415649},{"id":"https://openalex.org/C123593499","wikidata":"https://www.wikidata.org/wiki/Q6008583","display_name":"In-Memory Processing","level":5,"score":0.5668244361877441},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.5409864187240601},{"id":"https://openalex.org/C55166926","wikidata":"https://www.wikidata.org/wiki/Q2892946","display_name":"Oracle","level":2,"score":0.5092300176620483},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.46593254804611206},{"id":"https://openalex.org/C24028149","wikidata":"https://www.wikidata.org/wiki/Q7094056","display_name":"Online aggregation","level":5,"score":0.42606061697006226},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.3474019765853882},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.33164316415786743},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.3109945058822632},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.24885815382003784},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.21797817945480347},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.19840902090072632},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.19215121865272522}],"mesh":[],"locations_count":3,"locations":[{"id":"doi:10.14778/2824032.2824074","doi":"https://doi.org/10.14778/2824032.2824074","is_oa":false,"landing_page_url":"https://doi.org/10.14778/2824032.2824074","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["cwts-core","dongbi-b","norway-2","poland-20","russia-white-list-1","vabb-shw"],"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"conference"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the VLDB Endowment","raw_type":"journal-article"},{"id":"pmh:oai:infoscience.epfl.ch:210743","doi":null,"is_oa":true,"landing_page_url":"http://infoscience.epfl.ch/record/210743","pdf_url":null,"source":{"id":"https://openalex.org/S4306400487","display_name":"Infoscience (Ecole Polytechnique F\u00e9d\u00e9rale de Lausanne)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I5124864","host_organization_name":"\u00c9cole Polytechnique F\u00e9d\u00e9rale de Lausanne","host_organization_lineage":["https://openalex.org/I5124864"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"Text"},{"id":"pmh:oai:infoscience.tind.io:210743","doi":null,"is_oa":true,"landing_page_url":"http://infoscience.epfl.ch/record/210743","pdf_url":null,"source":{"id":"https://openalex.org/S4306400487","display_name":"Infoscience (Ecole Polytechnique F\u00e9d\u00e9rale de Lausanne)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I5124864","host_organization_name":"\u00c9cole Polytechnique F\u00e9d\u00e9rale de Lausanne","host_organization_lineage":["https://openalex.org/I5124864"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by-nc-nd","license_id":"https://openalex.org/licenses/cc-by-nc-nd","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"research article"}],"best_oa_location":{"id":"pmh:oai:infoscience.epfl.ch:210743","doi":null,"is_oa":true,"landing_page_url":"http://infoscience.epfl.ch/record/210743","pdf_url":null,"source":{"id":"https://openalex.org/S4306400487","display_name":"Infoscience (Ecole Polytechnique F\u00e9d\u00e9rale de Lausanne)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I5124864","host_organization_name":"\u00c9cole Polytechnique F\u00e9d\u00e9rale de Lausanne","host_organization_lineage":["https://openalex.org/I5124864"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"Text"},"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":25,"referenced_works":["https://openalex.org/W170130992","https://openalex.org/W176712692","https://openalex.org/W1509841269","https://openalex.org/W1917981011","https://openalex.org/W1967601791","https://openalex.org/W2003789154","https://openalex.org/W2006296837","https://openalex.org/W2014977566","https://openalex.org/W2039910065","https://openalex.org/W2063281504","https://openalex.org/W2079499902","https://openalex.org/W2102729946","https://openalex.org/W2102987499","https://openalex.org/W2123845384","https://openalex.org/W2143522680","https://openalex.org/W2155070484","https://openalex.org/W2170016254","https://openalex.org/W2295880318","https://openalex.org/W2340222647","https://openalex.org/W2396727930","https://openalex.org/W2398519237","https://openalex.org/W2403792048","https://openalex.org/W2405670011","https://openalex.org/W3138367763","https://openalex.org/W4285719527"],"related_works":["https://openalex.org/W2525510215","https://openalex.org/W6986234518","https://openalex.org/W1509841269","https://openalex.org/W2547306460","https://openalex.org/W2293670094","https://openalex.org/W2898401919","https://openalex.org/W7112694154","https://openalex.org/W2088267379","https://openalex.org/W100254115","https://openalex.org/W7024367303"],"abstract_inverted_index":{"Traditional":[0],"on-disk":[1,75],"row":[2,73,140],"major":[3,74,141],"tables":[4,76],"have":[5,78],"been":[6],"the":[7,17,34,56,66,101,116,123,127,136,172,181],"dominant":[8],"storage":[9,85],"mechanism":[10],"in":[11,24,126,154,179],"relational":[12],"databases":[13,50],"for":[14,29,100,109,115,135],"decades.":[15],"Over":[16],"last":[18],"decade,":[19],"however,":[20],"with":[21],"explosive":[22],"growth":[23],"data":[25,39,89],"volume":[26],"and":[27,92,96,165,169,184],"demand":[28],"faster":[30],"analytics,":[31],"has":[32],"come":[33],"recognition":[35],"that":[36,47,106,145],"a":[37,176],"different":[38],"representation":[40],"is":[41,44],"needed.":[42],"There":[43],"widespread":[45],"agreement":[46],"in-memory":[48,80],"column-oriented":[49],"are":[51,107],"best":[52],"suited":[53],"to":[54,77,130],"meet":[55],"realities":[57],"of":[58,186],"this":[59,119],"new":[60,84,88,98],"world.":[61],"Oracle":[62,187],"12c":[63],"Database":[64,188],"In-memory,":[65],"industry's":[67],"first":[68],"dual-format":[69],"database,":[70],"allows":[71],"existing":[72],"complementary":[79],"columnar":[81,143],"representations.":[82],"The":[83],"format":[86,111,138],"brings":[87],"processing":[90],"techniques":[91],"query":[93,102,128,150,161,173],"execution":[94,132],"algorithms":[95],"thus":[97],"challenges":[99],"optimizer.":[103],"Execution":[104],"plans":[105,133],"optimal":[108],"one":[110],"may":[112],"be":[113,147],"sub-optimal":[114],"other.":[117],"In":[118],"paper,":[120],"we":[121],"describe":[122],"changes":[124],"made":[125],"optimizer":[129,174],"generate":[131],"optimized":[134],"specific":[137],"--":[139,144,157,171],"or":[142],"will":[146],"scanned":[148],"during":[149],"execution.":[151],"With":[152],"enhancements":[153],"several":[155],"areas":[156],"statistics,":[158],"cost":[159],"model,":[160],"transformation,":[162],"access":[163],"path":[164],"join":[166],"optimization,":[167],"parallelism,":[168],"cluster-awareness":[170],"plays":[175],"significant":[177],"role":[178],"unlocking":[180],"full":[182],"promise":[183],"performance":[185],"In-Memory.":[189]},"counts_by_year":[{"year":2026,"cited_by_count":6},{"year":2025,"cited_by_count":2},{"year":2024,"cited_by_count":2},{"year":2023,"cited_by_count":2},{"year":2022,"cited_by_count":2},{"year":2021,"cited_by_count":5},{"year":2020,"cited_by_count":4},{"year":2019,"cited_by_count":1},{"year":2018,"cited_by_count":4},{"year":2017,"cited_by_count":2},{"year":2016,"cited_by_count":2}],"updated_date":"2026-11-10T11:39:43.021295","created_date":"2016-06-24T00:00:00"}