18 ms·
+1 for the idea of tuning query optimization based on ML. I don't know of any DBMSs that take this advice, and that's remarkable in this day and age.
by quizotic 9y ago
+1 for the idea of tuning query optimization based on ML. I don't know of any DBMSs that take this advice, and that's remarkable in this day and age.
- vthriller 9y agoOracle already promised to bring something similar back in september: https://www.oracle.com/database/autonomous-database/index.html https://www.oracle.com/database/autonomous-database/index.ht...
- jve 9y agoSQL Server 2017 has introduced 2 Automatic database tuning features: Automatic plan correction and Automatic index management (Latter for Azure SQL Only) https://docs.microsoft.com/en-us/sql/relational-databases/automatic-tuning/automatic-tuning https://docs.microsoft.com/en-us/sql/relational-databases/au...
- rev112 9y agoThis looks quite relevant: https://aws.amazon.com/blogs/ai/tuning-your-dbms-automatically-with-machine-learning/ https://aws.amazon.com/blogs/ai/tuning-your-dbms-automatical... ("Tuning Your DBMS Automatically with Machine Learning") The authors propose a way to do some automatic tuning for MySQL and Postgres. Link to the paper itself: http://db.cs.cmu.edu/papers/2017/tuning-sigmod2017.pdf http://db.cs.cmu.edu/papers/2017/tuning-sigmod2017.pdf
- power 9y agoPostgres has a query optimizer that uses Genetic Algorithms: https://www.postgresql.org/docs/current/static/geqo.html https://www.postgresql.org/docs/current/static/geqo.html Clarification: this is for planning how to execute a query, not for tuning the db settings
- agnivade 9y agoWow, did not know that. TIL!