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"”.

  1. 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 …

    cornell Repository record for BCD Deduplication: Effective Memory Compression Using Partial Cache-Line Deduplication (opens in a new tab)

  2. 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 …

    uoit Repository record for Automatic knobs-tuning for DB2 using deep reinforcement learning (opens in a new tab)

  3. 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 …

    york Repository record for Guiding Expert Database Tuning with Explainable AI (opens in a new tab)

  4. 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 …

    york Repository record for Query-Aware Data Systems Tuning via Machine Learning (opens in a new tab)

  5. 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.

    uoit Repository record for DistGALO: Distributed system for query problem determination (opens in a new tab)

  6. 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.

    sask Repository record for A Design Framework for Efficient Distributed Analytics on Structured Big Data (opens in a new tab)

  7. 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 …

    york Repository record for Query Generation for Database Testing Via Machine Learning (opens in a new tab)

  8. 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% …

    ottawa-retro Repository record for DQN-Guided Rule-Class Selection for Search-Based Query Rewriting (opens in a new tab)

  9. 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 …

    york Repository record for Fundamentals and applications of order dependencies (opens in a new tab)

  10. 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 …

    brazil-ufpe Repository record for Uma metodologia baseada em grafos para detecção de redundância estrutural em Arquiteturas Data Mesh (opens in a new tab)

  11. 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 …

    ottawa-retro Repository record for Robust Query Optimization in Relational Databases Based on Approximate Probabilistic Machine Learning (opens in a new tab)

  12. 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 …

    etsu Repository record for A Comparison of Leading Database Storage Engines in Support of Online Analytical Processing in an Open Source Environment (opens in a new tab) Download PDF for A Comparison of Leading Database Storage Engines in Support of Online Analytical Processing in an Open Source Environment (opens in a new tab)