A reorganization model based on the database entropy concept.
The Computer Journal
Index scans using a finite LRU buffer: a validated I/O model
ACM Transactions on Database Systems (TODS)
On-line reorganization of sparsely-populated B+-trees
SIGMOD '96 Proceedings of the 1996 ACM SIGMOD international conference on Management of data
A method for on-line reorganization of a database
IBM Systems Journal
SAC '95 Proceedings of the 1995 ACM symposium on Applied computing
Efficient locking for concurrent operations on B-trees
ACM Transactions on Database Systems (TODS)
Optimal file designs and reorganization points
ACM Transactions on Database Systems (TODS)
Optimum reorganization points for linearly growing files
ACM Transactions on Database Systems (TODS)
A dynamic database reorganization algorithm
ACM Transactions on Database Systems (TODS)
Optimal policy for batch operations: backup, checkpointing, reorganization, and updating
ACM Transactions on Database Systems (TODS)
Performance and Stability Analysis of Multilevel Data Structures with Deferred Reorganization
IEEE Transactions on Software Engineering
ACM Computing Surveys (CSUR)
Database Reorganization—Principles and Practice
ACM Computing Surveys (CSUR)
Optimal reorganization of distributed space disk files
Communications of the ACM
Optimum data base reorganization points
Communications of the ACM
Proceedings of the 2002 ACM symposium on Applied computing
Toward autonomic computing with DB2 universal database
ACM SIGMOD Record
Estimating page fetches for index scans with finite LRU buffers
The VLDB Journal — The International Journal on Very Large Data Bases
Performance Analysis of a Concurrent File Reorganization Algorithm for Record Clustering
IEEE Transactions on Knowledge and Data Engineering
Probabilistic Model and Optimal Reorganization of B+-Tree with Physical Clustering
IEEE Transactions on Knowledge and Data Engineering
The Vision of Autonomic Computing
Computer
Heuristic Reorganization of Clustered Files
FOFO '89 Proceedings of the 3rd International Conference on Foundations of Data Organization and Algorithms
Improving I/O response times via prefetching and storage system reorganization
COMPSAC '97 Proceedings of the 21st International Computer Software and Applications Conference
On-line Reorganization of Data in Scalable Continuous Media Servers
DEXA '96 Proceedings of the 7th International Conference on Database and Expert Systems Applications
Dynamic Reorganization of Object Databases
IDEAS '99 Proceedings of the 1999 International Symposium on Database Engineering & Applications
SQLCM: A Continuous Monitoring Framework for Relational Database Engines
ICDE '04 Proceedings of the 20th International Conference on Data Engineering
Opportunities for data base reorganization
ACM SIGMOD Record
Storage device performance prediction with CART models
Proceedings of the joint international conference on Measurement and modeling of computer systems
Effective use of block-level sampling in statistics estimation
SIGMOD '04 Proceedings of the 2004 ACM SIGMOD international conference on Management of data
LEO: An autonomic query optimizer for DB2
IBM Systems Journal
Parameter Estimation Using B-Trees
IDEAS '04 Proceedings of the International Database Engineering and Applications Symposium
Research issues in automatic database clustering
ACM SIGMOD Record
Polus: Growing Storage QoS Management Beyond a "4-Year Old Kid"
FAST '04 Proceedings of the 3rd USENIX Conference on File and Storage Technologies
Continuous resource monitoring for self-predicting DBMS
MASCOTS '05 Proceedings of the 13th IEEE International Symposium on Modeling, Analysis, and Simulation of Computer and Telecommunication Systems
Reorganization points for file designs with nonlinear processing costs
VLDB '75 Proceedings of the 1st International Conference on Very Large Data Bases
Incremental file reorganization schemes
VLDB '85 Proceedings of the 11th international conference on Very Large Data Bases - Volume 11
DB2 design advisor: integrated automatic physical database design
VLDB '04 Proceedings of the Thirtieth international conference on Very large data bases - Volume 30
Automated statistics collection in DB2 UDB
VLDB '04 Proceedings of the Thirtieth international conference on Very large data bases - Volume 30
An on-line reorganization framework for SAN file systems
ADBIS'06 Proceedings of the 10th East European conference on Advances in Databases and Information Systems
Concurrency control for adaptive indexing
Proceedings of the VLDB Endowment
Hi-index | 0.00 |
Structural deterioration of database is caused by updates of the database and can degrade performance seriously. Database reorganisation, which removes structural deterioration by relocating data in the secondary storage, is an administrator's headache; it is difficult to schedule reorganisation efficiently to keep acceptable performance because conventional database systems lack crucial monitoring facility of structural deterioration, with high resolution, high accuracy and low overhead. In order to make database reorganisation be easy for administrators and be autonomic in the future, the paper proposes an online database structure deterioration monitor, which can visualise structural deterioration distribution, with a novel structural deterioration model, a storage performance model and an incremental update technique. The experimental results with our prototype show that our scheme can monitor structural deterioration with an error of within 12% and with an overhead of 3% at most.