A review of different cost-based distributed query optimizers

M Sharma, G Singh, R Singh - Progress in Artificial Intelligence, 2019 - Springer
The paper narrates the review of cost-based query optimizers designed using database
strategies, deterministic, stochastic, hybrid and energy efficiency-based techniques. It was …

Autonomic workload performance tuning in large-scale data repositories

B Raza, A Sher, S Afzal, AK Malik, A Anjum… - … and Information Systems, 2019 - Springer
The workload in large-scale data repositories involves concurrent users and contains
homogenous and heterogeneous data. The large volume of data, dynamic behavior and …

[PDF][PDF] Analysis of DSS queries using entropy based restricted genetic algorithm

M Sharma, G Singh, R Singh… - Applied Mathematics & …, 2015 - researchgate.net
Optimization is one of the dominant research areas in the field of different subjects viz.
Mathematics, Computer Science, Business and Economics. In this paper, an effort has been …

[图书][B] Benchmarks for Transaction and Analytical Processing Systems

A Bog, A Bog - 2014 - Springer
As presented in Chap. 1, the goal of this thesis is to analyze and compare the behavior of
databases in mixed workload scenarios as a basis to evaluate logical database design …

Feedback control loop design for workload change detection in self-tuning NoSQL wide column stores

M Mozaffari, E Nazemi… - Expert Systems with …, 2020 - Elsevier
Database management systems are the main part of information systems that the size and
complexity of these systems are increased in recent years. Due to the growing complexity of …

[PDF][PDF] Benchmarking with TPC-H on off-the-shelf hardware

A Thanopoulou, P Carreira, H Galhardas - AN Experiments Report, 2012 - scitepress.org
Most medium-sized enterprises run their databases on inexpensive off-the-shelf hardware;
still, they need quick answers to complex queries, like ad-hoc Decision Support System …

The Psychic–Skeptic Prediction framework for effective monitoring of DBMS workloads

S Elnaffar, P Martin - Data & Knowledge Engineering, 2009 - Elsevier
Self-optimization is one of the defining characteristics of an autonomic computing system.
For a complex system, such as the database management system (DBMS), to be self …

SQL scorecard for improved stability and performance of data warehouses

N Rahman - International Journal of Software Innovation (IJSI), 2016 - igi-global.com
Scorecard-based measurement techniques are used by organizations to measure the
performance of their business operations. A scorecard approach could be applied to a …

Self-management concepts for relational database systems

M Holze - 2012 - ediss.sub.uni-hamburg.de
Selbstverwaltende (oder autonome) Datenbanken sollen die Betriebskosten für
Datenbanksysteme (DBS) reduzieren, indem sie sich automatisch an veränderliche …

[PDF][PDF] Autonomic workload management for database management systems

M Zhang - 2014 - qspace.library.queensu.ca
In today‟ s database server environments, multiple types of workloads, such as on-line
transaction processing, business intelligence and administrative utilities, can be present in a …