Global ETD Search
Search theses and dissertations gathered from participating repositories worldwide. Every result links back to the library that holds it. No account is needed.
Results
Showing 1 to 12 of 12 for “"TPC-DS"”.
-
BCD Deduplication: Effective Memory Compression Using Partial Cache-Line Deduplication
… average compression ratio of 1.98x for SPEC2006, TPC-DS, and TPC-H, which is 39.4% higher than a straightforward combination of the state-of-the-art cache-line-granularity compression and memory deduplication. This work also presents an efficient implementation in modern memory hierarchy along …
-
Automatic knobs-tuning for DB2 using deep reinforcement learning
Modern database management systems have hundreds of different configuration parameters (knobs) that control various aspects of how they behave and perform. These knobs must be properly tuned in order to maximize the performance of the database for a given query workload. Traditionally, database …
-
Guiding Expert Database Tuning with Explainable AI
… to interpret. Tuning them for specific workloads remains challenging due to their complexity, numerous configuration options, and interaction with unique workload characteristics. Additionally, database systems increasingly rely on black-box machine learning models within the optimizer and …
-
Query-Aware Data Systems Tuning via Machine Learning
Modern data systems have hundreds of system configuration parameters which heavily influence the performance of business queries. Manual configuration by experts is painstaking and time consuming. We propose a query-informed tuning system called BLUTune which uses deep reinforcement learning based …
-
DistGALO: Distributed system for query problem determination
… over our previous system using the synthetic TPC-DS benchmark and the effectiveness of the various pruning strategies.
-
A Design Framework for Efficient Distributed Analytics on Structured Big Data
… improvement in mean query time by 3-6x on the TPC-H and TPC-DS benchmarks, and more than an order of magnitude improvement in many cases.
-
Query Generation for Database Testing Via Machine Learning
… plans contain the user-defined patterns. On TPC-H, QueryMorpher achieves a target-pattern rate of 0.6 vs 0.4 for the best baseline, while maintaining 10% higher plan diversity under the same budget. On TPC-DS, QueryMorpher achieves similar improvements, indicating that QueryMorpher is stable …
-
DQN-Guided Rule-Class Selection for Search-Based Query Rewriting
… at each state with a Deep Q-Network and forwards only the top k to the unchanged rewriter routine. On an in-domain workload derived from the TPC-H benchmark at k = 1, average rewrite latency falls from 15.3 ms to 4.0 ms and average policy-tree size from 9.9 to 2.4 nodes, reductions of about 74% …
-
Fundamentals and applications of order dependencies
… when the optimizer can also reason over known ODs to infer new ones. Order dependencies can be declared as integrity constraints, and they can be detected automatically for many types of SQL functions and algebraic expressions. We present optimization techniques using ODs for queries that …
-
Uma metodologia baseada em grafos para detecção de redundância estrutural em Arquiteturas Data Mesh
… ou baseadas em benchmarks consolidados, como o TPC-DS, além de oferecer recursos para a execução controlada de experimentos, a compara ção entre algoritmos e a análise de métricas como tempo de execução (ET), acurácia (ACC) e frequência de sucesso (SF). Dois estudos de caso ilustraram a …
-
Robust Query Optimization in Relational Databases Based on Approximate Probabilistic Machine Learning
… evaluation across multiple benchmarks (JOB, CEB, DSB, and TPC-DS+) demonstrates that Roq consistently outperforms state-of-the-art approaches. The risk-aware plan selection strategies improve the 99th percentile of suboptimality by up to 44.4% compared to existing learned optimizers while …
-
A Comparison of Leading Database Storage Engines in Support of Online Analytical Processing in an Open Source Environment
Online Analytical Processing (OLAP) has become the de facto data analysis technology used in modern decision support systems. It has experienced tremendous growth, and is among the top priorities for enterprises. Open source systems have become an effective alternative to proprietary systems in …