We apologize for a recent technical issue with our email system, which temporarily affected account activations. Accounts have now been activated. Authors may proceed with paper submissions. PhDFocusTM
CFP last date
20 November 2024
Call for Paper
December Edition
IJCA solicits high quality original research papers for the upcoming December edition of the journal. The last date of research paper submission is 20 November 2024

Submit your paper
Know more
The week's pick
Responsive image
An Efficient Restoration Method for the Faint Dot Matrix Images

Ao Zhu Peng Cao
Random Articles
Reseach Article

Evolution of Database Emerging to Sybase Adaptive Server Enterprise and Ensuring better Server Performance Tuning and Query Optimization

by Mohammad Ghulam Ali
journal cover thumbnail

International Journal of Computer Applications
Foundation of Computer Science (FCS), NY, USA
Volume 35 - Number 1
Year of Publication: 2011
Authors: Mohammad Ghulam Ali
10.5120/4368-6027

Mohammad Ghulam Ali . Evolution of Database Emerging to Sybase Adaptive Server Enterprise and Ensuring better Server Performance Tuning and Query Optimization. International Journal of Computer Applications. 35, 1 ( December 2011), 37-62. DOI=10.5120/4368-6027

@article{ 10.5120/4368-6027,
author = { Mohammad Ghulam Ali },
title = { Evolution of Database Emerging to Sybase Adaptive Server Enterprise and Ensuring better Server Performance Tuning and Query Optimization },
journal = { International Journal of Computer Applications },
issue_date = { December 2011 },
volume = { 35 },
number = { 1 },
month = { December },
year = { 2011 },
issn = { 0975-8887 },
pages = { 37-62 },
numpages = {9},
url = { https://ijcaonline.org/archives/volume35/number1/4368-6027/ },
doi = { 10.5120/4368-6027 },
publisher = {Foundation of Computer Science (FCS), NY, USA},
address = {New York, USA}
}
%0 Journal Article
%1 2024-02-06T20:20:55.558908+05:30
%A Mohammad Ghulam Ali
%T Evolution of Database Emerging to Sybase Adaptive Server Enterprise and Ensuring better Server Performance Tuning and Query Optimization
%J International Journal of Computer Applications
%@ 0975-8887
%V 35
%N 1
%P 37-62
%D 2011
%I Foundation of Computer Science (FCS), NY, USA
Abstract

Evolution of the database is emerging to a robust Sybase Adaptive Server Enterprise Database System. Key issue in the Sybase Database System is to obtain better server performance by tuning the server and optimizing the query processing. The server performance tuning and query optimization are two main issues to gain high throughput and less or fast response time. In this paper we have considered well two issues and explained how to gain better server performance by tuning the server and optimizing the query processing. We are also illustrating solutions to some situations normally occurs related to this two issues in this paper. This paper will introduce the reader to the most basic concepts of server performance tuning, query processing and optimization of query processing. We hope this paper will provide an adequate support to Database Administrator(s) (DBAs) who are working on Sybase and researchers who are working on Database Server performance tuning and query optimization. We have discussed in brief in the introduction section of this paper about the evolution of the database emerging to SYBASE ASE version under different operating system environments.

References
  1. Craig S. Mullins, “An introduction to the Architecture of Sybase SQL Server”, Winter 1994.
  2. “Sybase® Adaptive Server™ Enterprise Performance and Tuning Guide: Query Tuning”, Adaptive Server Enterprise Version 12, Last Revised: October 1999, Document ID: 32614-01-1200-02.
  3. Gene Leganza, “Sybase SQL server performance Considerations”, Bachman Information systems.
  4. Jeffrey Garbus, Alvin Chang, Gary Tyrrel and Penny Garbus “Administrator's Guide to Sybase ASE 12.5”, Wordware Publishing, Inc.
  5. http://www.rocket99.com/techref/8681.html, “Sybase ASE Overview, Architecture”.
  6. Mich Talebzadeh “Oracle and Sybase, Concepts and Contrasts”, January 2006.
  7. Eric Miner, “ASE 15 and the Optimizer Statistics – More Influential Than Ever“, December 11, 2008
  8. http://www.isug.com/ Sybase_FAQ/ ASE/ section1.5. html, “Sybase Performance Tuning”.
  9. http://www.sybase.in/detail?id=47625, “Server Enterprise”.
  10. Chapter 15, "Memory Use and Performance, “Sybase® SQL Server(TM) Performance and Tuning Guide“.
  11. Eric Miner, Sr. Engineer, Sybase, Inc. DST Engineering Optimizer Group , “An Introduction to Sybase Adaptive server Enterprise’s Modern Optimizer”.
  12. “Sybase ASE 15 Best Practice Query Processing and Optimization”, Technical White Paper, Sybase Inc.
  13. Eric Miner, “ASE 15 and the Optimizer Statistics – More Influential Than Ever”.
  14. “Optimizing Transaction Performance in Adaptive Server® Enterprise 12.5”, A Technical White Paper.
  15. “Performance and Tuning: Basics”, Adaptive Server® Enterprise 12.5.1.
  16. “Performance and Tuning: Locking”, Adaptive Server® Enterprise 12.5.1.
  17. “Performance and Tuning: Monitoring and Analyzing”, Adaptive Server® Enterprise 12.5.1
  18. “Performance and Tuning Guide: Volume 2 - Query Optimization, Query Tuning and Abstract Plans”, Adaptive Server Enterprise 12.5.
  19. Sybase® Adaptive Server™ Enterprise Performance and Tuning Guide: Query Tuning, Adaptive Server Enterprise Version 12, Last Revised: October 1999.
  20. Eric Miner, Director of Enhancements, Sybase International User Group, “Sybase Adaptive Server Enterprise 15’s Query Processing Engine (QPE) Delivers High Performance for Applications in Mixed-Workload Environments”.
  21. Scott Waiz, Sr. Director of Product Management at Embarcadero Technologies, “The High Performance Sybase ASE DBA”, Managing Multiple Database Platforms for Performance & Availibility, August 2010.
  22. John Ngubiri, “On Query Optimization in Relational Databases, May, 2004.
  23. Mihnea Andrei, Patrik Valduriez, “User-Optimizer communication Using Abstract Plans in Sybase ASE”, Proceedings of the 27th VLDB Conference, Roma, Italy, 2001.
  24. Vorgelegt Von, “Algebraic Query Optimization in database systems”, 1999.
  25. Elmsari, “Algorithms for Query Processing and Optimization”, 2007.
  26. Johann Christoph Freytag, “The Basic Principles of Query Optimization in Relational Database Management Systems”, 1989.
  27. Adaptive Server Enterprise 15.0, Performance and Tuning: Basics.
  28. Adaptive Server Enterprise 15.5, Performance and Tuning Series: Query Processing and Abstract Plans, Understanding Query Processing.
  29. Adaptive Server Enterprise on Egenera BladeFrame platform, A technical white paper, SYBASE Information Anywhere, January 2003.
  30. Sybase 15 Optimization Goals and Impacts on the Joins, malaikannan.wordpress.com, 2009.
  31. Jeffery Garbus, Eric Miner, Joel Duplessis, Alvin Chang, Yuval Malache, “Sybase ASE 12.5 Performance and Tuning.
  32. Performance & Tuning for In-Memory Databases in Adaptive Server Enterprise 15.5, white paper.
  33. SolidData, Best Practice Guide, Best Practice Guide, Sybase: Maximizing Performance through Solid State File-Caching, May 2000.
  34. Sybase Adaptive Server Enterprise (ASE) 15, Product Datasheet.
  35. Adaptive Server Enterprise 15.0, Performance and Tuning: Query Processing and Abstract Plans
  36. Michael L., Rupley Jr., “Introduction to Query Processing and Optimization”.
  37. Nurazzah Abd Rahman, Tareq Salahi Saad, “Hash Algorithms Used in Text-Based Information Retrieval: Guidelines for Users”
  38. Sybase 15 Optimization Goals and Impacts on the Joins, Malai’s Tech Space.
  39. Sachin Arora, Nested loops, Hash Join and Sort Merge Joins – differences, March 2, 2007.
  40. http://sybasefaqs.blogspot.com/2008/07 /sybase-query-optimization. html, “Sybase Database Interview Questions and Answers”
  41. Adaptive Server Enterprise 15.0, Migration Guide, Ensuring Stability and Performance, Determining query processing changes
  42. http://www.rocket99.com/techref/sybase8714.html “ASE 15 Hints: Query Plan Optimization”.
Index Terms

Computer Science
Information Sciences

Keywords

Database Database Management System Relational Database Management System Performance Tuning Query Processing Query Optimization

Powered by PhDFocusTM