Surajit Chaudhuri and Vivek R. Narasayya, AutoAdmin "What-If" Index Analysis Utility. Proceedings of ACM SIGMOD, Seattle, 1998.  Home/Search   Document Not in Database   Summary   Related Articles   Check

.... hotspot analysis, and swapping file blocks between hot and cold disks. Ergastulum can select the appropriate number of devices to use, supports RAID systems, and uses far more sophisticated performance models to predict the effect of system modifications. The AutoAdmin index selection tool [10] can automatically design a suitable set of indexes, given an input workload of SQL queries. It has a component that intelligently searches the space of possible indexes, similar to Ergastulum, and an evaluation component (model, in Ergastulum terms) to determine the effectiveness of a ....

S. Chaudhuri and V. Narasayya. AutoAdmin "What- if" index analysis utility. In SIGMOD International Conference on Management of Data, pages 367-- 378, June 1998.

....decisions, and does not handle long term changes in the workload. Conversely, Hippodrome makes long term decisions and does not require application modification. A few other, automated tools exist that are useful to administrators of enterprise class systems. The AutoAdmin index selection tool [12] can automatically design a suitable set of indexes, given an input workload of SQL queries. It has a component that intelligently searches the space of possible indexes, similar to Hippodrome s design component, and an evaluation component (model, in Hippodrome terms) to determine the ....

.... research questions include the following: # How well does Hippodrome interact with optimizations at the application level, which may result in changes to the I O workload For instance, how would the automated storage loop interact with database systems that automatically create indices as needed [12] or tune query plans based on observed performance [29] # How does Hippodrome fit into an overall endto end optimization scheme For instance, how should Hippodrome cooperate with other solutions for storage area network design [32] or quality of service preserving online migration [26] # ....

S. Chaudhuri and V. Narasayya. AutoAdmin "What-if" index analysis utility. In SIGMOD International Conference on Management of Data, pages 367--378, June 1998.

....and performs its validity checks at commit time. In contrast to similar systems, our merge predicates should decrease the number of transactions aborted due to out of date caches. Many previous projects have explored feedback driven adaptation in extensible operating systems [45] databases [11], file systems [34] global operating systems [9] and storage devices [51] Although these projects employ differing techniques and terminology, each could be analyzed with respect to the introspective model. The Seer project formulated the concept of semantic distance [28] and collects clusters ....

S. Chaudhuri and V. Narasayya. AutoAdmin "what-if" index analysis utility. In Proc. of ACM SIGMOD Conf., pages 367-- 378, June 1998.

....and performs its validity checks at commit time. In contrast to such systems, our merge predicates decrease the number of transactions aborted due to out of date caches. Many previous projects have explored feedback driven adaptation in extensible operating systems [52] databases [13, 14], file systems [39] global operating systems [9] and storage devices [10, 60] Although these projects employ differing techniques and terminology, each could be analyzed with respect to the introspective model. The Seer project formulated the concept of semantic distance [33] and collects ....

S. Chaudhuri and V. Narasayya. AutoAdmin "what-if" index analysis utility. In Proc. of ACM SIGMOD Conf., pages 367--378, June 1998.

....been done in the field of index selection, especially in the context of decision support systems OLAP [GHR 97, Sar97] Another driving factor are database vendors who support their commercial systems with easy to use tools for database administration, like the AutoAdmin Tool of MS SQL Server 7. 0 [CN97, CN98]. An important result of [CN99] is the observation that cost based index selection yields significantly better results than selection based only on structural analysis . To our knowledge all this work covers only one dimensional index structures, and does not address the special issues of MDAMs. ....

S. Chaudhuri and V. Narasayya. AutoAdmin "What-If" Index Analysis Utility. Proc. of SIGMOD, 1998.

No context found.

Chaudhuri S., Narasayya V., AutoAdmin "What-If" Index Analysis Utility. ACM SIGMOD 1998.

No context found.

Surajit Chaudhuri and Vivek R. Narasayya, AutoAdmin "What-If" Index Analysis Utility. Proceedings of ACM SIGMOD, Seattle, 1998.

No context found.

S. Chaudhuri and V. Narasayya. AutoAdmin "what-if" index analysis utility. In Proceedings of ACM SIGMOD, 1998.

Online articles have much greater impact   More about CiteSeer.IST   Add search form to your site   Submit documents   Feedback  

CiteSeer.IST - Copyright Penn State and NEC