loading
Papers

Research.Publish.Connect.

Paper

Paper Unlock

Authors: Arjun K. Sirohi 1 and Vidushi Sharma 2

Affiliations: 1 Oracle U.S.A. Inc, United States ; 2 Gautam Buddha University, India

ISBN: 978-989-758-096-3

Keyword(s): Indexes, Mixed-load Queries, Multi-tenant Queries, Multi-application Queries, SQL Performance Optimization.

Related Ontology Subjects/Areas/Topics: Data Engineering ; Databases and Data Security ; Databases and Information Systems Integration ; Distributed Database Systems ; Enterprise Information Systems ; Large Scale Databases ; Query Languages and Query Processing

Abstract: With the recent shift towards cloud-based applications and Software as a Service (SaaS) environments, relational databases support multi-tenant and multi-application workloads that query the same set of data stored in common tables, using SQL queries. These SQL queries have very different query constructs and data-access requirements leading to different optimization needs. However, the business-users' expect sub-second response times in getting the data that they requested. The current RDBMS architectures where indexes “belong” to a table without any object privileges of their own, and, therefore, must be considered and used by the optimizer for all SQLs referencing the table(s), pose multiple challenges for the optimizer as well as application architects and performance tuning experts, especially as the number of such indexes grows. In this paper, we make the case for “Context-Sensitive Indexes”, whereby applications and tenants could define their own indexes on the shared, transact ional database tables to optimize the execution of their SQL queries, while at the same time having the optimizer keep such indexes isolated from other applications and tenants/users for the purposes of query optimization. (More)

PDF ImageFull Text

Download
CC BY-NC-ND 4.0

Sign In Guest: Register as new SciTePress user now for free.

Sign In SciTePress user: please login.

PDF ImageMy Papers

You are not signed in, therefore limits apply to your IP address 34.239.160.113

In the current month:
Recent papers: 100 available of 100 total
2+ years older papers: 200 available of 200 total

Paper citation in several formats:
K. Sirohi, A. and Sharma, V. (2015). Context-sensitive Indexes in RDBMS for Performance Optimization of SQL Queries in Multi-tenant/Multi-application Environments.In Proceedings of the 17th International Conference on Enterprise Information Systems - Volume 1: ICEIS, ISBN 978-989-758-096-3, pages 259-270. DOI: 10.5220/0005350802590270

@conference{iceis15,
author={Arjun K. Sirohi. and Vidushi Sharma.},
title={Context-sensitive Indexes in RDBMS for Performance Optimization of SQL Queries in Multi-tenant/Multi-application Environments},
booktitle={Proceedings of the 17th International Conference on Enterprise Information Systems - Volume 1: ICEIS,},
year={2015},
pages={259-270},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0005350802590270},
isbn={978-989-758-096-3},
}

TY - CONF

JO - Proceedings of the 17th International Conference on Enterprise Information Systems - Volume 1: ICEIS,
TI - Context-sensitive Indexes in RDBMS for Performance Optimization of SQL Queries in Multi-tenant/Multi-application Environments
SN - 978-989-758-096-3
AU - K. Sirohi, A.
AU - Sharma, V.
PY - 2015
SP - 259
EP - 270
DO - 10.5220/0005350802590270

Login or register to post comments.

Comments on this Paper: Be the first to review this paper.