{"id":"https://openalex.org/W2295459385","doi":"https://doi.org/10.5220/0005350802590270","title":"Context-sensitive Indexes in RDBMS for Performance Optimization of SQL Queries in Multi-tenant/Multi-application Environments","display_name":"Context-sensitive Indexes in RDBMS for Performance Optimization of SQL Queries in Multi-tenant/Multi-application Environments","publication_year":2015,"publication_date":"2015-01-01","ids":{"openalex":"https://openalex.org/W2295459385","doi":"https://doi.org/10.5220/0005350802590270","mag":"2295459385"},"language":"en","primary_location":{"id":"doi:10.5220/0005350802590270","is_oa":true,"landing_page_url":"https://doi.org/10.5220/0005350802590270","pdf_url":null,"source":null,"license":"cc-by-nc-nd","license_id":"https://openalex.org/licenses/cc-by-nc-nd","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 17th International Conference on Enterprise Information Systems","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://doi.org/10.5220/0005350802590270","any_repository_has_fulltext":null},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5080614524","display_name":"Arjun K. Sirohi","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":"Arjun K. Sirohi","raw_affiliation_strings":["Oracle U.S.A. Inc, United States"],"affiliations":[{"raw_affiliation_string":"Oracle U.S.A. Inc, United States","institution_ids":["https://openalex.org/I1342911587"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5101472687","display_name":"Vidushi Sharma","orcid":"https://orcid.org/0000-0002-0094-5202"},"institutions":[{"id":"https://openalex.org/I72769676","display_name":"Gautam Buddha University","ror":"https://ror.org/026cfwd52","country_code":"IN","type":"education","lineage":["https://openalex.org/I72769676"]}],"countries":["IN"],"is_corresponding":false,"raw_author_name":"Vidushi Sharma","raw_affiliation_strings":["Gautam Buddha University, India"],"affiliations":[{"raw_affiliation_string":"Gautam Buddha University, India","institution_ids":["https://openalex.org/I72769676"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5080614524"],"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.17779254,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"259","last_page":"270"},"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.9980000257492065,"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.9980000257492065,"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.9952999949455261,"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/T10101","display_name":"Cloud Computing and Resource Management","score":0.9861000180244446,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.9006509780883789},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.7609774470329285},{"id":"https://openalex.org/keywords/relational-database-management-system","display_name":"Relational database management system","score":0.6502155065536499},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.5956271290779114},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5885229110717773},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.574711799621582},{"id":"https://openalex.org/keywords/table","display_name":"Table (database)","score":0.5497390627861023},{"id":"https://openalex.org/keywords/context","display_name":"Context (archaeology)","score":0.5068259835243225},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.4844975173473358},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.46261531114578247},{"id":"https://openalex.org/keywords/sargable","display_name":"Sargable","score":0.4293120801448822},{"id":"https://openalex.org/keywords/stored-procedure","display_name":"Stored procedure","score":0.4155949354171753},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.41541406512260437},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.3134356141090393},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.2173798680305481},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.18633165955543518},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.14187729358673096},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.11202901601791382}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.9006509780883789},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.7609774470329285},{"id":"https://openalex.org/C24394798","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database management system","level":3,"score":0.6502155065536499},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.5956271290779114},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5885229110717773},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.574711799621582},{"id":"https://openalex.org/C45235069","wikidata":"https://www.wikidata.org/wiki/Q278425","display_name":"Table (database)","level":2,"score":0.5497390627861023},{"id":"https://openalex.org/C2779343474","wikidata":"https://www.wikidata.org/wiki/Q3109175","display_name":"Context (archaeology)","level":2,"score":0.5068259835243225},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.4844975173473358},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.46261531114578247},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.4293120801448822},{"id":"https://openalex.org/C154420247","wikidata":"https://www.wikidata.org/wiki/Q846619","display_name":"Stored procedure","level":5,"score":0.4155949354171753},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.41541406512260437},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.3134356141090393},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.2173798680305481},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.18633165955543518},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.14187729358673096},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.11202901601791382},{"id":"https://openalex.org/C151730666","wikidata":"https://www.wikidata.org/wiki/Q7205","display_name":"Paleontology","level":1,"score":0.0},{"id":"https://openalex.org/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.5220/0005350802590270","is_oa":true,"landing_page_url":"https://doi.org/10.5220/0005350802590270","pdf_url":null,"source":null,"license":"cc-by-nc-nd","license_id":"https://openalex.org/licenses/cc-by-nc-nd","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 17th International Conference on Enterprise Information Systems","raw_type":"proceedings-article"}],"best_oa_location":{"id":"doi:10.5220/0005350802590270","is_oa":true,"landing_page_url":"https://doi.org/10.5220/0005350802590270","pdf_url":null,"source":null,"license":"cc-by-nc-nd","license_id":"https://openalex.org/licenses/cc-by-nc-nd","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 17th International Conference on Enterprise Information Systems","raw_type":"proceedings-article"},"sustainable_development_goals":[{"display_name":"Industry, innovation and infrastructure","score":0.4300000071525574,"id":"https://metadata.un.org/sdg/9"}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":["https://openalex.org/W2374912898","https://openalex.org/W2955368753","https://openalex.org/W2978539281","https://openalex.org/W2554271401","https://openalex.org/W2375340541","https://openalex.org/W2406556739","https://openalex.org/W2150741898","https://openalex.org/W2889903446","https://openalex.org/W2385089576","https://openalex.org/W2588167896"],"abstract_inverted_index":{"With":[0],"the":[1,23,52,60,90,96,102,115,126,141,148,156,160,172],"recent":[2],"shift":[3],"towards":[4],"cloud-based":[5],"applications":[6,132,168],"and":[7,18,43,87,109,133,169],"Software":[8],"as":[9,104,106,114],"a":[10,73],"Service":[11],"(SaaS)":[12],"environments,":[13],"relational":[14],"databases":[15],"support":[16],"multi-tenant":[17],"multi-application":[19],"workloads":[20],"that":[21,62],"query":[22,41,175],"same":[24,157],"set":[25],"of":[26,79,117,150,174],"data":[27,61],"stored":[28],"in":[29,58],"common":[30],"tables,":[31],"using":[32],"SQL":[33,36,152],"queries.":[34],"These":[35],"queries":[37],"have":[38],"very":[39],"different":[40,48],"constructs":[42],"data-access":[44],"requirements":[45],"leading":[46],"to":[47,72,146],"optimization":[49],"needs.":[50],"However,":[51],"business-users'":[53],"expect":[54],"sub-second":[55],"response":[56],"times":[57],"getting":[59],"they":[63],"requested.":[64],"The":[65],"current":[66],"RDBMS":[67],"architectures":[68],"where":[69],"indexes":[70,119,139,164],"\u00e2\u0080\u009cbelong\u00e2\u0080\u009d":[71],"table":[74],"without":[75],"any":[76],"object":[77],"privileges":[78],"their":[80,137,151],"own,":[81],"and,":[82],"therefore,":[83],"must":[84],"be":[85],"considered":[86],"used":[88],"by":[89],"optimizer":[91,103,161],"for":[92,101,128,171],"all":[93],"SQLs":[94],"referencing":[95],"table(s),":[97],"pose":[98],"multiple":[99],"challenges":[100],"well":[105],"application":[107],"architects":[108],"performance":[110],"tuning":[111],"experts,":[112],"especially":[113],"number":[116],"such":[118,163],"grows.":[120],"In":[121],"this":[122],"paper,":[123],"we":[124],"make":[125],"case":[127],"\u00e2\u0080\u009cContext-Sensitive":[129],"Indexes\u00e2\u0080\u009d,":[130],"whereby":[131],"tenants":[134],"could":[135],"define":[136],"own":[138],"on":[140],"shared,":[142],"transactional":[143],"database":[144],"tables":[145],"optimize":[147],"execution":[149],"queries,":[153],"while":[154],"at":[155],"time":[158],"having":[159],"keep":[162],"isolated":[165],"from":[166],"other":[167],"tenants/users":[170],"purposes":[173],"optimization.":[176]},"counts_by_year":[],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}