{"id":"https://openalex.org/W2116626927","doi":"https://doi.org/10.1145/1061318.1061321","title":"Advanced SQL modeling in RDBMS","display_name":"Advanced SQL modeling in RDBMS","publication_year":2005,"publication_date":"2005-03-01","ids":{"openalex":"https://openalex.org/W2116626927","doi":"https://doi.org/10.1145/1061318.1061321","mag":"2116626927"},"language":"en","primary_location":{"id":"doi:10.1145/1061318.1061321","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1061318.1061321","pdf_url":null,"source":{"id":"https://openalex.org/S90119964","display_name":"ACM Transactions on Database Systems","issn_l":"0362-5915","issn":["0362-5915","1557-4644"],"is_oa":false,"is_in_doaj":false,"is_core":true,"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":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"ACM Transactions on Database Systems","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/A5088270000","display_name":"Andrew Witkowski","orcid":"https://orcid.org/0009-0001-6118-8380"},"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":"Andrew Witkowski","raw_affiliation_strings":["Oracle Corporation, Redwood Shores, CA","Oracle +Corp., Redwood Shores, CA#TAB#"],"affiliations":[{"raw_affiliation_string":"Oracle Corporation, 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/A5032089564","display_name":"Srikanth Bellamkonda","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":"Srikanth Bellamkonda","raw_affiliation_strings":["Oracle Corporation, Redwood Shores, CA","Oracle +Corp., Redwood Shores, CA#TAB#"],"affiliations":[{"raw_affiliation_string":"Oracle Corporation, 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/A5003515555","display_name":"Tolga Bozkaya","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":"Tolga Bozkaya","raw_affiliation_strings":["Oracle Corporation, Redwood Shores, CA","Oracle +Corp., Redwood Shores, CA#TAB#"],"affiliations":[{"raw_affiliation_string":"Oracle Corporation, 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/A5060178716","display_name":"Nathan Folkert","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":"Nathan Folkert","raw_affiliation_strings":["Oracle Corporation, Redwood Shores, CA","Oracle +Corp., Redwood Shores, CA#TAB#"],"affiliations":[{"raw_affiliation_string":"Oracle Corporation, 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/A5041752781","display_name":"Abhinav Gupta","orcid":"https://orcid.org/0000-0002-3630-3244"},"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":"Abhinav Gupta","raw_affiliation_strings":["Oracle Corporation, Redwood Shores, CA","Oracle +Corp., Redwood Shores, CA#TAB#"],"affiliations":[{"raw_affiliation_string":"Oracle Corporation, 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/A5056641209","display_name":"John J. Haydu","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":"John Haydu","raw_affiliation_strings":["Oracle Corporation, Redwood Shores, CA","Oracle +Corp., Redwood Shores, CA#TAB#"],"affiliations":[{"raw_affiliation_string":"Oracle Corporation, 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/A5100721966","display_name":"Lei Sheng","orcid":"https://orcid.org/0000-0002-5725-1375"},"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":"Lei Sheng","raw_affiliation_strings":["Oracle Corporation, Redwood Shores, CA","Oracle +Corp., Redwood Shores, CA#TAB#"],"affiliations":[{"raw_affiliation_string":"Oracle Corporation, 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/A5002546424","display_name":"Sankar Subramanian","orcid":"https://orcid.org/0000-0002-2375-3254"},"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":"Sankar Subramanian","raw_affiliation_strings":["Oracle Corporation, Redwood Shores, CA","Oracle +Corp., Redwood Shores, CA#TAB#"],"affiliations":[{"raw_affiliation_string":"Oracle Corporation, 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":8,"corresponding_author_ids":["https://openalex.org/A5088270000"],"corresponding_institution_ids":["https://openalex.org/I1342911587"],"apc_list":null,"apc_paid":null,"fwci":1.5573,"has_fulltext":false,"cited_by_count":15,"citation_normalized_percentile":{"value":0.86025536,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":96},"biblio":{"volume":"30","issue":"1","first_page":"83","last_page":"121"},"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.9998999834060669,"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/T12205","display_name":"Time Series Analysis and Forecasting","score":0.9763000011444092,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8871656656265259},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.8152226209640503},{"id":"https://openalex.org/keywords/joins","display_name":"Joins","score":0.6782695055007935},{"id":"https://openalex.org/keywords/relational-database-management-system","display_name":"Relational database management system","score":0.6420422196388245},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.5679349899291992},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5449146628379822},{"id":"https://openalex.org/keywords/scalability","display_name":"Scalability","score":0.4919159412384033},{"id":"https://openalex.org/keywords/online-analytical-processing","display_name":"Online analytical processing","score":0.48232337832450867},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.4735538065433502},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.4080447852611542},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.32770657539367676},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.1690211296081543},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.14484664797782898}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8871656656265259},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.8152226209640503},{"id":"https://openalex.org/C2778692605","wikidata":"https://www.wikidata.org/wiki/Q4041866","display_name":"Joins","level":2,"score":0.6782695055007935},{"id":"https://openalex.org/C24394798","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database management system","level":3,"score":0.6420422196388245},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.5679349899291992},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5449146628379822},{"id":"https://openalex.org/C48044578","wikidata":"https://www.wikidata.org/wiki/Q727490","display_name":"Scalability","level":2,"score":0.4919159412384033},{"id":"https://openalex.org/C201932085","wikidata":"https://www.wikidata.org/wiki/Q642514","display_name":"Online analytical processing","level":3,"score":0.48232337832450867},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.4735538065433502},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.4080447852611542},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.32770657539367676},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.1690211296081543},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.14484664797782898},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"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}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/1061318.1061321","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1061318.1061321","pdf_url":null,"source":{"id":"https://openalex.org/S90119964","display_name":"ACM Transactions on Database Systems","issn_l":"0362-5915","issn":["0362-5915","1557-4644"],"is_oa":false,"is_in_doaj":false,"is_core":true,"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":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"ACM Transactions on Database Systems","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":26,"referenced_works":["https://openalex.org/W3225910","https://openalex.org/W29150487","https://openalex.org/W136602510","https://openalex.org/W176528069","https://openalex.org/W1531041457","https://openalex.org/W1534906344","https://openalex.org/W2012670464","https://openalex.org/W2039491213","https://openalex.org/W2049859567","https://openalex.org/W2102387332","https://openalex.org/W2102951036","https://openalex.org/W2103201239","https://openalex.org/W2106181436","https://openalex.org/W2116476518","https://openalex.org/W2118269922","https://openalex.org/W2118382442","https://openalex.org/W2132582487","https://openalex.org/W2144829796","https://openalex.org/W2151135734","https://openalex.org/W2252034896","https://openalex.org/W2915063781","https://openalex.org/W4205167958","https://openalex.org/W6601222474","https://openalex.org/W6605585436","https://openalex.org/W6607266271","https://openalex.org/W6679865122"],"related_works":["https://openalex.org/W411760269","https://openalex.org/W1982455124","https://openalex.org/W2098812463","https://openalex.org/W4247095193","https://openalex.org/W1497653608","https://openalex.org/W2015932315","https://openalex.org/W9978827","https://openalex.org/W151494989","https://openalex.org/W45850614","https://openalex.org/W2476511644"],"abstract_inverted_index":{"Commercial":[0],"relational":[1,167],"database":[2],"systems":[3],"lack":[4,162],"support":[5,250],"for":[6,29,63,133,159,206,217,229,252,261],"complex":[7,46,85,207],"business":[8,30],"modeling.":[9,31,208],"ANSI":[10,235,265],"SQL":[11,43,62,88,194,197,236,253,266,277,285,292,302],"cannot":[12,249],"treat":[13],"relations":[14,205],"as":[15],"multidimensional":[16],"arrays":[17],"and":[18,49,73,84,98,103,125,148,180,188,214,245,247,270],"define":[19],"multiple,":[20,108],"interrelated":[21,109],"formulas":[22,158],"over":[23,204],"them,":[24],"operations":[25,231],"which":[26,69,152,272],"are":[27,91,153,169,297],"needed":[28],"Relational":[32],"OLAP":[33],"(ROLAP)":[34],"applications":[35],"have":[36],"to":[37,77,171,200,225,276,300],"perform":[38],"such":[39],"tasks":[40],"using":[41,268],"joins,":[42],"Window":[44],"Functions,":[45],"CASE":[47],"expressions,":[48],"the":[50,55,66,75,163,166,186,284,301],"GROUP":[51],"BY":[52],"operator":[53],"simulating":[54],"pivot":[56],"operation.":[57],"The":[58],"designated":[59],"place":[60],"in":[61],"calculations":[64,203],"is":[65,70,223],"SELECT":[67],"clause,":[68],"extremely":[71],"limiting":[72],"forces":[74],"user":[76,175],"generate":[78],"queries":[79],"with":[80,93],"nested":[81],"views,":[82],"subqueries":[83,269],"joins.":[86],"Furthermore,":[87,234],"query":[89],"optimizers":[90],"preoccupied":[92],"determining":[94],"efficient":[95,120],"join":[96],"orders":[97],"choosing":[99],"optimal":[100],"access":[101,131,212],"methods":[102,114,260],"largely":[104],"disregard":[105],"optimization":[106,228],"of":[107,122,157,165,183,283],"formulas.":[110,287],"Research":[111],"into":[112],"execution":[113,215],"has":[115,138,143],"thus":[116],"far":[117],"concentrated":[118],"on":[119,130],"computation":[121,246],"data":[123,184,244,275],"cubes":[124],"cube":[126],"compression":[127],"rather":[128],"than":[129],"structures":[132],"random,":[134],"interrow":[135],"calculations.":[136],"This":[137,190,288],"created":[139],"a":[140,240],"gap":[141],"that":[142],"been":[144],"filled":[145],"by":[146],"spreadsheets":[147],"specialized":[149],"MOLAP":[150],"engines,":[151],"good":[154,241],"at":[155],"specification":[156],"modeling":[160],"but":[161],"formalism":[164],"model,":[168],"difficult":[170],"coordinate":[172],"across":[173],"large":[174],"groups,":[176],"exhibit":[177],"scalability":[178],"problems,":[179],"require":[181],"replication":[182],"between":[185,243],"tool":[187],"RDBMS.":[189],"article":[191],"presents":[192,281],"an":[193],"extension":[195],"called":[196],"Spreadsheet":[198,286,293,303],",":[199],"provide":[201,239],"array":[202],"We":[209,256],"present":[210],"optimizations,":[211],"structures,":[213],"models":[216,296],"processing":[218],"them":[219],"efficiently.":[220],"Special":[221],"attention":[222],"paid":[224],"compile":[226],"time":[227],"expensive":[230],"like":[232],"aggregation.":[233],"does":[237],"not":[238],"separation":[242],"hence":[248],"parameterization":[251,259,282],"Spreadsheets":[254],"models.":[255],"propose":[257],"two":[258],"SQL.":[262],"One":[263],"parameterizes":[264],"view":[267],"scalars,":[271],"allows":[273],"passing":[274],"Spreadsheet.":[278],"Another":[279],"method":[280],"supports":[289],"building":[290],"stand-alone":[291],"libraries.":[294],"These":[295],"then":[298],"subject":[299],"optimizations":[304],"during":[305],"model":[306],"invocation":[307],"time.":[308]},"counts_by_year":[{"year":2023,"cited_by_count":1},{"year":2020,"cited_by_count":1},{"year":2019,"cited_by_count":1},{"year":2018,"cited_by_count":2}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}