000161481 001__ 161481
000161481 005__ 20190316235007.0
000161481 037__ $$aCONF
000161481 245__ $$aAn Automated, yet Interactive and Portable DB designer
000161481 269__ $$a2010
000161481 260__ $$c2010
000161481 336__ $$aConference Papers
000161481 500__ $$aDEMO EURYI
000161481 520__ $$aTuning tools attempt to configure a database to achieve optimal performance for a given workload. Selecting an optimal set of physical structures is computationally hard since it involves searching a vast space of possible configurations. Commercial DBMSs offer tools that can address this problem. The usefulness of such tools, however, is limited by their dependence on greedy heuristics, the need for a-priori (offline) knowledge of the workload, and lack of an optimal materialization schedule to get the best out of suggested design features. Moreover, the open source DBMSs do not provide any automated tuning tools. This demonstration introduces a comprehensive physical designer for the PostgreSQL open source DBMS. The tool suggests design features for both offline and online workloads. It provides close to optimal suggestions for indexes for a given workload by modeling the problem as a combinatorial optimization problem and solving it by sophisticated and mature solvers. It also determines the interaction between indexes to suggest an effective materialization strategy for the selected indexes. The tool is interactive as it allows the database administrator (DBA) to suggest a set of candidate features and shows their benefits and interactions visually. For the demonstration we use large realworld scientific datasets and query workloads.
000161481 6531_ $$aPhysical Design Tuning
000161481 6531_ $$aContinuous Tuning
000161481 6531_ $$aIndex Interaction
000161481 700__ $$0243534$$g191574$$aAlagiannis, Ioannis
000161481 700__ $$aDash, Debabrata
000161481 700__ $$aSchnaitter, Karl
000161481 700__ $$g177957$$aAilamaki, Anastasia$$0243527
000161481 700__ $$aPolyzotis, Neoklis
000161481 7112_ $$dJune 6–10, 2010$$cIndianapolis, Indiana, USA$$aACM SIGMOD International Conference on Management of Data
000161481 773__ $$tProceedings of the ACM SIGMOD International Conference on Management of Data
000161481 8564_ $$uhttps://infoscience.epfl.ch/record/161481/files/alagiannis-sigmod2010.pdf$$zPublisher's version$$s197101$$yPublisher's version
000161481 909C0 $$xU11836$$0252224$$pDIAS
000161481 909CO $$qGLOBAL_SET$$pconf$$ooai:infoscience.tind.io:161481$$pIC
000161481 917Z8 $$x188175
000161481 917Z8 $$x188175
000161481 917Z8 $$x188175
000161481 917Z8 $$x194694
000161481 937__ $$aEPFL-CONF-161481
000161481 973__ $$rNON-REVIEWED$$sPUBLISHED$$aEPFL
000161481 980__ $$aCONF