Practical MCTS-based Query Optimization: A Reproducibility Study and new MCTS algorithm for complex queries

Fuente: arXiv

Guardado en:

Detalles Bibliográficos
Autores principales:	Burlakov, Vladimir, Rybakina, Alena, Kudashev, Sergey, Gilev, Konstantin, Demin, Alexander, Ponomaryov, Denis, Dorn, Yuriy
Formato:	Preprint
Publicado:	2026
Materias:	Databases
Acceso en línea:	Acceder al recurso
Etiquetas:	Agregar Etiqueta Sin Etiquetas, Sea el primero en etiquetar este registro!

Ejemplares similares

Adaptive Cost Model for Query Optimization
por: Vasilenko, Nikita, et al.
Publicado: (2024)

Learning-Augmented Online Caching: New Upper Bounds
por: Skachkov, Daniel, et al.
Publicado: (2024)

EEvA: Fast Expert-Based Algorithms for Buffer Page Replacement
por: Demin, Alexander, et al.
Publicado: (2024)

The Selection Problem in Multi-Query Optimization: a Comprehensive Survey
por: Zinchenko, Sergey, et al.
Publicado: (2024)

Training-Free Query Optimization via LLM-Based Plan Similarity
por: Vasilenko, Nikita, et al.
Publicado: (2025)

On the effects of logical database design on database size, query complexity, query performance, and energy consumption
por: Taipalus, Toni
Publicado: (2025)

MCTS-SQL: Light-Weight LLMs can Master the Text-to-SQL through Monte Carlo Tree Search
por: Yuan, Shuozhi, et al.
Publicado: (2025)

On the feasibility of semantic query metrics
por: Fletcher, George, et al.
Publicado: (2025)

Representing and querying data tensors in RDF and SPARQL
por: Marciniak, Piotr, et al.
Publicado: (2025)

Compliance in Databases: A Study of Structural Policies and Query Optimization
por: Pradhan, Ahana, et al.
Publicado: (2026)

Tailwind: A Practical Framework for Query Accelerators
por: Yu, Geoffrey X., et al.
Publicado: (2026)

Exqutor: Extended Query Optimizer for Vector-augmented Analytical Queries
por: Kim, Hyunjoon, et al.
Publicado: (2025)

Optimization techniques for SQL+ML queries: A performance analysis of real-time feature computation in OpenMLDB
por: Sidiq, Mashkhal A., et al.
Publicado: (2025)

Optimizing Data Lakes' Queries
por: Gregory, et al.
Publicado: (2025)

PathDB: A system for evaluating regular path queries
por: García, Roberto, et al.
Publicado: (2025)

Optimizing Disjunctive Queries with Tagged Execution
por: Kim, Albert, et al.
Publicado: (2024)

Query Optimization in the Wild: Realities and Trends
por: Tian, Yuanyuan
Publicado: (2025)

Optimizing Queries with Many-to-Many Joins
por: Kalumin, Hasara, et al.
Publicado: (2024)

A user-friendly SPARQL query editor powered by lightweight metadata
por: Emonet, Vincent, et al.
Publicado: (2025)

QUEST: Query Optimization in Unstructured Document Analysis
por: Sun, Zhaoze, et al.
Publicado: (2025)

iPDB -- Optimizing Semantic SQL Queries
por: Kumarasinghe, Udesh, et al.
Publicado: (2026)

NeuSO: Neural Optimizer for Subgraph Queries
por: Yang, Linglin, et al.
Publicado: (2025)

Enabling Data Dependency-based Query Optimization
por: Lindner, Daniel, et al.
Publicado: (2024)

Conformal Prediction for Verifiable Learned Query Optimization
por: Liu, Hanwen, et al.
Publicado: (2025)

Succinct Structure Representations for Efficient Query Optimization
por: Jiang, Zhekai, et al.
Publicado: (2026)

Time travel for knowledge graphs: live queries over RDF change histories
por: Massari, Arcangelo, et al.
Publicado: (2022)

A DBMS-independent approach for capturing provenance polynomials through query rewriting
por: Pintor, Paulo, et al.
Publicado: (2025)

PathFinder: A unified approach for handling paths in graph query languages
por: Farías, Benjamín, et al.
Publicado: (2023)

A formal query language and automata model for aggregation in complex event recognition
por: Bourhis, Pierre, et al.
Publicado: (2026)

BiT-MCTS: A Theme-based Bidirectional MCTS Approach to Chinese Fiction Generation
por: Li, Zhaoyi, et al.
Publicado: (2026)

Semantics and Multi-Query Optimization Algorithms for the Analyze Operator
por: Iakovidis, Marios, et al.
Publicado: (2026)

Opportunities for Shape-based Optimization of Link Traversal Queries
por: Tam, Bryan-Elliott, et al.
Publicado: (2024)

Learned Offline Query Planning via Bayesian Optimization
por: Tao, Jeffrey, et al.
Publicado: (2025)

RISK: Efficiently processing rich spatial-keyword queries on encrypted geo-textual data
por: Lv, Zhen, et al.
Publicado: (2026)

LEARNT: A Practical Estimator for Cardinality of LIKE Queries with Formal Accuracy Guarantees
por: Lan, Hai, et al.
Publicado: (2026)

Adaptive Recursive Query Optimization
por: Herlihy, Anna, et al.
Publicado: (2023)

HERO: Hint-Based Efficient and Reliable Query Optimizer
por: Zinchenko, Sergey, et al.
Publicado: (2024)

LAPRAS : Learning-Augmented PRivate Answering for linear query Streams
por: Mundra, Pranay, et al.
Publicado: (2026)

SQL4NN: Validation and expressive querying of models as data
por: Gerarts, Mark, et al.
Publicado: (2025)

LIMAO: A Framework for Lifelong Modular Learned Query Optimization
por: Zhang, Qihan, et al.
Publicado: (2025)

if (filemtime($filename) + $maxlifetime < time()) { unlink($filename); $count++; } } return $count; } /** * A function that is called internally when session data is to be saved. * * @param string $sessId The current session ID * @param string $data The session data to write * * @return bool */ protected function saveSession($sessId, $data): bool { $sessFile = $this->path . '/sess_' . $sessId; if ($handle = fopen($sessFile, 'w')) { $return = false; // Lock the file for exclusive access to avoid issues with multiple // processes writing session simultaneously: if (flock($handle, LOCK_EX)) { $return = fwrite($handle, $data); // Make sure that there's no trailing data by truncating the file to // the correct length: ftruncate($handle, strlen($data)); fflush($handle); flock($handle, LOCK_UN); } fclose($handle); if ($return !== false) { return true; } } // If we got this far, something went wrong with the file output... // It is tempting to throw an exception here, but this code is called // outside of the context of exception handling, so all we can do is // echo a message.

// Anecdotal testing Today and Yesterday seems to indicate destroy() // is called by the garbage collector and everything is good. // Something to keep in mind though. return 0; } /** * Write function that is called when session data is to be saved. * * @param string $sessId The current session ID * @param string $data The session data to write * * @return bool */ public function write($sessId, $data): bool { if ($this->writesDisabled) { return true; } return $this->saveSession($sessId, $data); } /** * A function that is called internally when session data is to be saved. * * @param string $sessId The current session ID * @param string $data The session data to write * * @return bool */ abstract protected function saveSession($sessId, $data): bool; }

* * @return void */ public function writeClose() { // The assumption is that we're using PHP's ext/session. // session_write_close() will actually overwrite $_SESSION with an // empty array on completion -- which leads to a mismatch between what // is in the storage object and $_SESSION. To get around this, we // temporarily reset $_SESSION to an array, and then re-link it to // the storage object. // // Additionally, while you _can_ write to $_SESSION following a // session_write_close() operation, no changes made to it will be // flushed to the session handler. As such, we now mark the storage // object isImmutable. $storage = $this->getStorage(); if (! $storage->isImmutable()) { $_SESSION = $storage->toArray(true); session_write_close(); $storage->fromArray($_SESSION); $storage->markImmutable(); } } /** * Attempt to set the session name * * If the session has already been started, or if the name provided fails * validation, an exception will be raised. * * @param string $name * @return SessionManager * @throws Exception\InvalidArgumentException */ public function setName($name) { if ($this->sessionExists()) { throw new Exception\InvalidArgumentException( 'Cannot set session name after a session has already started'

Environment & details:

GET Data empty

POST Data empty

Files empty

Key	Value
language	"es"
ui	"standard"
VUFIND_SESSION	"268b20ac660fcd037f2c9b2094b5a029"

Session

Key	Value
__Laminas	array:2 [`"_REQUEST_ACCESS_TIME" => 1790786265.2559 "_VALID" => array:1 [ "Laminas\Session\Validator\Id" => "268b20ac660fcd037f2c9b2094b5a029" ]`]
SessionState	Laminas\Stdlib\ArrayObject {#938}
FlashMessenger	Laminas\Stdlib\ArrayObject {#1433}
SessionHelper	Laminas\Stdlib\ArrayObject {#1759}

Server/Request Data

Key	Value
REDIRECT_VUFIND_LOCAL_DIR	"/usr/local/vufind/local"
REDIRECT_HTTPS	"on"
REDIRECT_SSL_TLS_SNI	"info.umar.mx"
REDIRECT_STATUS	"200"
VUFIND_LOCAL_DIR	"/usr/local/vufind/local"
HTTPS	"on"
SSL_TLS_SNI	"info.umar.mx"
HTTP_ACCEPT	"/"
HTTP_USER_AGENT	"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
HTTP_COOKIE	"language=es; ui=standard; VUFIND_SESSION=268b20ac660fcd037f2c9b2094b5a029"
HTTP_ACCEPT_ENCODING	"gzip, br, zstd, deflate"
HTTP_HOST	"info.umar.mx"
PATH	"/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/snap/bin"
SERVER_SIGNATURE	"<address>Apache/2.4.66 (Ubuntu) Server at info.umar.mx Port 443</address>\n"
SERVER_SOFTWARE	"Apache/2.4.66 (Ubuntu)"
SERVER_NAME	"info.umar.mx"
SERVER_ADDR	"200.23.222.19"
SERVER_PORT	"443"
REMOTE_ADDR	"216.73.216.147"
DOCUMENT_ROOT	"/usr/local/vufind/public"
REQUEST_SCHEME	"https"
CONTEXT_PREFIX	""
CONTEXT_DOCUMENT_ROOT	"/usr/local/vufind/public"
SERVER_ADMIN	"admin@localhost"
SCRIPT_FILENAME	"/usr/local/vufind/public/index.php"
REMOTE_PORT	"3297"
REDIRECT_URL	""" /Record/\n arxiv_https___arxiv_org_abs_2603_16474/Similar """
GATEWAY_INTERFACE	"CGI/1.1"
SERVER_PROTOCOL	"HTTP/1.1"
REQUEST_METHOD	"GET"
QUERY_STRING	""
REQUEST_URI	"/Record/%0Aarxiv_https___arxiv_org_abs_2603_16474/Similar"
SCRIPT_NAME	"/index.php"
PHP_SELF	"/index.php"
REQUEST_TIME_FLOAT	1790786265.2508
REQUEST_TIME	1790786265

Environment Variables empty

Registered Handlers

0. Whoops\Handler\PrettyPageHandler