SQL Anywhere: A Holistic Approach to Database Self-management
Authors:
- 1 April 2007
- conference paper
- Published by Institute of Electrical and Electronics Engineers (IEEE)
- p. 414-423
Abstract
In this paper we present an overview of the self-management features of SQL anywhere, a full-function relational database system designed for frontline business environments with minimal administration. SQL Anywhere can serve as a high-performance workgroup server, an embedded database that is installed along with an application, or as a mobile database installed on a handheld device that provides full database services, including two-way synchronization, to applications when the device is disconnected from the corporate intranet. We illustrate how the various self-management features work in concert to provide a robust data management solution in zero-administration environments.Keywords
This publication has 15 references indexed in Scilit:
- The History of Histograms (abridged)2003
- SQL Memory Management in Oracle9i2002
- Memory allocation strategies for complex decision support queries1998
- Load balanced query evaluation in shared-everything environments1997
- Practical algorithms for self scaling histograms or better than average data collectionPerformance Evaluation, 1996
- Goal-oriented buffer management revisitedACM SIGMOD Record, 1996
- Estimating page fetches for index scans with finite LRU buffersThe VLDB Journal, 1995
- A new approach to I/O performance evaluationACM Transactions on Computer Systems, 1994
- Index scans using a finite LRU buffer: a validated I/O modelACM Transactions on Database Systems, 1989
- Sequentiality and prefetching in database systemsACM Transactions on Database Systems, 1978