NDLI: A Framework for Predicting Query Response Time

Content Provider	IEEE Xplore Digital Library
Author	Singhal, R.
Copyright Year	2012
Abstract	In a typical OLTP environment, emphasis has been given on promising Service level Agreements (SLAs) for perceived query elapsed response time; the SQL queries are tested on the small size of database which may be a fraction of the production database. As time progresses the database grows and the earlier optimized queries may not hold SLA anymore. Once the application is deployed, it becomes difficult to modify the application or alter the production system. In this paper, we have discussed a framework for predicting the SQL query response time with growth of the database while being transparent to the production hardware, storage subsystem and DB Server. We have discussed various factors which can impact query response time and are also affected by the increase in the data size. We have presented a theoretical model for predicting the elapsed response time of SQL queries and also discussed a case study of Oracle 10g for implementing the proposed frame work
Starting Page	1137
Ending Page	1141
File Size	369005
Page Count	5
File Format	PDF
ISBN	9781467321648
DOI	10.1109/HPCC.2012.167
Language	English
Publisher	Institute of Electrical and Electronics Engineers, Inc. (IEEE)
Publisher Date	2012-06-25
Publisher Place	United Kingdom
Access Restriction	Subscribed
Rights Holder	Institute of Electrical and Electronics Engineers, Inc. (IEEE)
Subject Keyword	Execution Conferences High performance computing Query Parsing Fetching Response Time Large Size Database SQL Data Acess
Content Type	Text
Resource Type	Article

Sl.	Authority	Responsibilities	Communication Details
1	Ministry of Education (GoI), Department of Higher Education	Sanctioning Authority	https://www.education.gov.in/ict-initiatives
2	Indian Institute of Technology Kharagpur	Host Institute of the Project: The host institute of the project is responsible for providing infrastructure support and hosting the project	https://www.iitkgp.ac.in
3	National Digital Library of India Office, Indian Institute of Technology Kharagpur	The administrative and infrastructural headquarters of the project	Dr. B. Sutradhar bsutra@ndl.gov.in
4	Project PI / Joint PI	Principal Investigator and Joint Principal Investigators of the project	Dr. B. Sutradhar bsutra@ndl.gov.in Prof. Saswat Chakrabarti will be added soon
5	Website/Portal (Helpdesk)	Queries regarding NDLI and its services	support@ndl.gov.in
6	Contents and Copyright Issues	Queries related to content curation and copyright issues	content@ndl.gov.in
7	National Digital Library of India Club (NDLI Club)	Queries related to NDLI Club formation, support, user awareness program, seminar/symposium, collaboration, social media, promotion, and outreach	clubsupport@ndl.gov.in
8	Digital Preservation Centre (DPC)	Assistance with digitizing and archiving copyright-free printed books	dpc@ndl.gov.in
9	IDR Setup or Support	Queries related to establishment and support of Institutional Digital Repository (IDR) and IDR workshops	idr@ndl.gov.in