Advertisement

Intelligent Statistics Management in Sybase ASE 15.0

  • Satya Sreenivasan
  • Xiao Ming Zhou
  • Tat Keong Loh
Part of the Lecture Notes in Computer Science book series (LNCS, volume 3882)

Abstract

Sybase ASE (Adaptive Server Enterprise) is a cost based database system. Statistics information plays a key role in the costing model of ASE optimizer. Typically, up-to-date statistics is critical in selecting an optimal query plan with good performance. However, updating statistics is a resource intensive maintenance operation. A common user concern is the lack of input on when statistics needs to be updated and also the time taken to maintain the statistics. In this paper, we introduce a new solution for automating statistics maintenance in Sybase ASE 15.0. Our solution includes a new metric for evaluating data changes due to DMLs (Data Management Language), the use of a scheduler to generate rules to gather statistics based on feedback from the metric and random sampling of data when gathering statistics. This approach will make statistics maintenance more intelligent and efficient, and reduce the TCO (Total Cost of Ownership) significantly.

Keywords

Database Administrator Statistic Maintenance Update Statistics Accurate Statistic Query Processor 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. 1.
    2005 Winter TopTen Award Winners, Winter Corporation (2005)Google Scholar
  2. 2.
    Ault, M., Tumma, M., Liu, D., Burleson, D.: Oracle Database 10g New Features: Oracle 10g Reference for Advanced Tuning and Administration. Rampant TechPress (2003)Google Scholar
  3. 3.
    Chaudhuri, S., Motwani, R., Narasayya, V.: Random Sampling for Histogram Construction: How much is enough? In: Proc. ACM SIGMOD Conference (1998)Google Scholar
  4. 4.
    DB2 Universal Database for iSeries – Database Performance and Query Optimization, IBM Corp. (2002)Google Scholar
  5. 5.
    Ling, Y., Sun, W.: An Evaluation of Sampling-Based Size Estimation Methods for Selections in Database Systems. In: Proc. IEEE Conference on Data Engineering (1995)Google Scholar
  6. 6.
    Lipton, R.J., Naughton, J.F.: Query Size Estimation by Adaptive Sampling. In: Proc. ACM PODS (1990)Google Scholar
  7. 7.
    Piatesky-Shapiro, G., Connell, C.: Accurate estimation of the number of tuples satisfying a condition. In: Proc. ACM SIGMOD Conference (1984)Google Scholar
  8. 8.
    SQL Server 2000 Books Online v8.00.02. Microsoft Corp. (2004)Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2006

Authors and Affiliations

  • Satya Sreenivasan
    • 1
  • Xiao Ming Zhou
    • 1
  • Tat Keong Loh
    • 1
  1. 1.Sybase Asia Development CenterSingapore

Personalised recommendations