{"id":"https://openalex.org/W2063281504","doi":"https://doi.org/10.1145/1007568.1007666","title":"Parallel SQL execution in Oracle 10g","display_name":"Parallel SQL execution in Oracle 10g","publication_year":2004,"publication_date":"2004-06-13","ids":{"openalex":"https://openalex.org/W2063281504","doi":"https://doi.org/10.1145/1007568.1007666","mag":"2063281504"},"language":"en","primary_location":{"id":"doi:10.1145/1007568.1007666","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1007568.1007666","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2004 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/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":true,"raw_author_name":"Thierry Cruanes","raw_affiliation_strings":["Oracle +Corp., Redwood Shores, CA","Oracle +Corp., Redwood Shores, CA#TAB#"],"affiliations":[{"raw_affiliation_string":"Oracle +Corp., Redwood Shores, CA","institution_ids":["https://openalex.org/I1342911587"]},{"raw_affiliation_string":"Oracle +Corp., Redwood Shores, CA#TAB#","institution_ids":["https://openalex.org/I1342911587"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5004037878","display_name":"Beno\u00eet Dageville","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":"Benoit Dageville","raw_affiliation_strings":["Oracle +Corp., Redwood Shores, CA","Oracle +Corp., Redwood Shores, CA#TAB#"],"affiliations":[{"raw_affiliation_string":"Oracle +Corp., Redwood Shores, CA","institution_ids":["https://openalex.org/I1342911587"]},{"raw_affiliation_string":"Oracle +Corp., Redwood Shores, CA#TAB#","institution_ids":["https://openalex.org/I1342911587"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5065640934","display_name":"Bhaskar Ghosh","orcid":"https://orcid.org/0000-0002-3203-6126"},"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":"Bhaskar Ghosh","raw_affiliation_strings":["Oracle +Corp., Redwood Shores, CA","Oracle +Corp., Redwood Shores, CA#TAB#"],"affiliations":[{"raw_affiliation_string":"Oracle +Corp., Redwood Shores, CA","institution_ids":["https://openalex.org/I1342911587"]},{"raw_affiliation_string":"Oracle +Corp., Redwood Shores, CA#TAB#","institution_ids":["https://openalex.org/I1342911587"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5084497894"],"corresponding_institution_ids":["https://openalex.org/I1342911587"],"apc_list":null,"apc_paid":null,"fwci":0.927,"has_fulltext":false,"cited_by_count":19,"citation_normalized_percentile":{"value":0.79905893,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":96},"biblio":{"volume":null,"issue":null,"first_page":"850","last_page":"854"},"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.9995999932289124,"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.9995999932289124,"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.9988999962806702,"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/T10715","display_name":"Distributed and Parallel Computing Systems","score":0.9965000152587891,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8678731918334961},{"id":"https://openalex.org/keywords/oracle","display_name":"Oracle","score":0.8138113021850586},{"id":"https://openalex.org/keywords/oracle-unified-method","display_name":"Oracle Unified Method","score":0.7344574332237244},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.7079643607139587},{"id":"https://openalex.org/keywords/pl/sql","display_name":"PL/SQL","score":0.6993337869644165},{"id":"https://openalex.org/keywords/exploit","display_name":"Exploit","score":0.5334826707839966},{"id":"https://openalex.org/keywords/architecture","display_name":"Architecture","score":0.5158945322036743},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.4343792796134949},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.42205002903938293},{"id":"https://openalex.org/keywords/distributed-computing","display_name":"Distributed computing","score":0.32363325357437134},{"id":"https://openalex.org/keywords/parallel-computing","display_name":"Parallel computing","score":0.3215215802192688},{"id":"https://openalex.org/keywords/software-engineering","display_name":"Software engineering","score":0.23606514930725098},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.22429382801055908},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.14673596620559692},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.1224115788936615}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8678731918334961},{"id":"https://openalex.org/C55166926","wikidata":"https://www.wikidata.org/wiki/Q2892946","display_name":"Oracle","level":2,"score":0.8138113021850586},{"id":"https://openalex.org/C22664368","wikidata":"https://www.wikidata.org/wiki/Q4045949","display_name":"Oracle Unified Method","level":5,"score":0.7344574332237244},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.7079643607139587},{"id":"https://openalex.org/C32145003","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"PL/SQL","level":5,"score":0.6993337869644165},{"id":"https://openalex.org/C165696696","wikidata":"https://www.wikidata.org/wiki/Q11287","display_name":"Exploit","level":2,"score":0.5334826707839966},{"id":"https://openalex.org/C123657996","wikidata":"https://www.wikidata.org/wiki/Q12271","display_name":"Architecture","level":2,"score":0.5158945322036743},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.4343792796134949},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.42205002903938293},{"id":"https://openalex.org/C120314980","wikidata":"https://www.wikidata.org/wiki/Q180634","display_name":"Distributed computing","level":1,"score":0.32363325357437134},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.3215215802192688},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.23606514930725098},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.22429382801055908},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.14673596620559692},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.1224115788936615},{"id":"https://openalex.org/C142362112","wikidata":"https://www.wikidata.org/wiki/Q735","display_name":"Art","level":0,"score":0.0},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.0},{"id":"https://openalex.org/C153349607","wikidata":"https://www.wikidata.org/wiki/Q36649","display_name":"Visual arts","level":1,"score":0.0},{"id":"https://openalex.org/C38652104","wikidata":"https://www.wikidata.org/wiki/Q3510521","display_name":"Computer security","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/1007568.1007666","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1007568.1007666","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2004 ACM SIGMOD international conference on Management of data","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":11,"referenced_works":["https://openalex.org/W130164395","https://openalex.org/W175221152","https://openalex.org/W206955312","https://openalex.org/W1593000629","https://openalex.org/W1605782097","https://openalex.org/W2008750849","https://openalex.org/W2075827270","https://openalex.org/W2102951036","https://openalex.org/W2129885727","https://openalex.org/W2134179408","https://openalex.org/W2158237121"],"related_works":["https://openalex.org/W3173015391","https://openalex.org/W2279364242","https://openalex.org/W105399545","https://openalex.org/W46000520","https://openalex.org/W2421816313","https://openalex.org/W2620116098","https://openalex.org/W2738717226","https://openalex.org/W606272627","https://openalex.org/W23253958","https://openalex.org/W2327539013"],"abstract_inverted_index":{"This":[0,49],"paper":[1,35],"describes":[2],"the":[3,13,19,41],"new":[4,46],"architecture":[5,22,66],"and":[6,64,79,91],"optimizations":[7],"for":[8],"parallel":[9,25,98],"SQL":[10,26],"execution":[11,27],"in":[12,33,45,83],"Oracle":[14,60,84],"10g":[15,85],"database.":[16],"Based":[17],"on":[18],"fundamental":[20],"shared-disk":[21],"underpinning":[23],"Oracle's":[24,37],"engine":[28,38,82],"since":[29],"Oracle7,":[30],"we":[31,76],"show":[32,74],"this":[34],"how":[36,75],"responds":[39],"to":[40,61,86],"challenges":[42],"of":[43],"performing":[44],"grid-computing":[47],"environments.":[48],"is":[50],"made":[51],"possible":[52],"by":[53,71,93],"using":[54,94],"advanced":[55],"optimization":[56],"techniques,":[57],"which":[58],"enable":[59],"exploit":[62],"data":[63],"system":[65],"dynamically":[67],"without":[68],"being":[69],"constrained":[70],"them.":[72],"We":[73],"have":[77],"evolved":[78],"re-architected":[80],"our":[81],"make":[87],"it":[88],"more":[89],"efficient":[90],"manageable":[92],"a":[95],"single":[96],"global":[97],"plan":[99],"model.":[100]},"counts_by_year":[{"year":2024,"cited_by_count":1},{"year":2022,"cited_by_count":1},{"year":2021,"cited_by_count":1},{"year":2020,"cited_by_count":1},{"year":2015,"cited_by_count":2},{"year":2014,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}
