Skip to content
Free planNo credit card requiredStart writing
AI for Research home
AI for Research home
Dashboard
Sign inGet started

Search 250 million research papers

Read the abstract, see who wrote it and who cites it, and get the citation in APA, MLA, Chicago or Harvard.

About 4,134 papers for “Database tuning”

Database tuning

Dennis Shasha, Philippe Bonnet · 2002

No abstract available.

Cited by 1

Database Tuning

Ignatius Fernandez · Apress eBooks · 2015

Database tuning can be a complex exercise, but it can be facilitated by a systematic approach. This chapter describes a systematic five-step approach to performance tuning. It also presents the most important tools provided by Oracle to help with performance tuning; Statspack is given equal time because tools such as Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM) require licenses and are not available at most sites. In particular, you learn a powerful method of mining the Statspack and AWR repositories for data on performance trends. This data can be graphed by using tools such as Microsoft Excel.

Cited by 1

Database Fine-Tuning

Nils B. Weidmann · Cambridge University Press eBooks · 2023

A summary is not available for this content so a preview has been provided. As you have access to this content, a full PDF is available via the ‘Save PDF’ action button.

Cited by 0Open access

Database Performance Tuning

Paulíček, Martin · Brno University of Technology Digital Library (Brno University of Technology) · 2011

The objective of this thesis was to study problems of an insufficient database processing performance and possibilities how to improve the performance with database configuration file optimizations, more powerful hardware and parallel processing. The master thesis contains a description of relational databases, storage media and different forms of parallelism with its use in database systems. There is a description of the developed software for testing database performance. The program was used for testing several database configuration files, various hardware, different database systems (PostgreSQL, Oracle) and advantages of parallel method "partitioning". Test reports and evaluation results are described at the end of the thesis.

Cited by 0

Online database tuning

Karl Schnaitter, Serge Abiteboul, Tova Milo et al. · 2006

This paper introduces Colt (Continuous On-Line Tuning), a novel self-tuning framework that continuously monitors the incoming queries and adjusts the system configuration in order to maximize query performance. The key idea behind Colt is to gather performance statistics at different levels of detail and to carefully allocate profiling resources to the most promising candidate configurations. Moreover, Colt uses effective heuristics to self-regulate its own performance, lowering its overhead when the system is well tuned and being more aggressive when the workload shifts and it becomes necessary to re-tune the system. We detail the design of the generic Colt system, and present its specialization to the important problem of selecting an effective set of indices for a relational query load. We describe an implementation of the proposed framework in the PostgreSQL database system and evaluate its performance experimentally. Our results validate the effectiveness of Colt in self-tuning a relational database, demonstrating its ability to modify the system configuration in response to changes in the query load. Moreover, Colt achieves performance improvements that are comparable to more expensive off-line techniques, thus verifying the potential of the on-line approach in the design of self-tuning systems. 1

Cited by 0

Schallehn (FIN/ITI) Database Tuning and Self-Tuning 2010 2 / 130Literature: Database Tuning

Dr. -ing Eike Schallehn, Ovg Universität Magdeburg, Dennis Shasha et al. · 2006

What are issues, basic principles, and common techniques for optimizing the performance of a database system? Database Self-Tuning: What are current approaches to automate the database tuning process and what techniques can be used for a possible full automization in the future?

Cited by 0

Schallehn (FIN/ITI) Database Tuning and Self-Tuning 2012 2 / 130Literature: Database Tuning Dennis Shasha: Database Tuning- A Principled Approach,

Dr. -ing Eike Schallehn, Michael J. Corey, Michael Abbey et al. · 2006

What are issues, basic principles, and common techniques for optimizing the performance of a database system? Database Self-Tuning: What are current approaches to automate the database tuning process and what techniques can be used for a possible full automization in the future?

Cited by 0

Database Engine Tuning Advisor

Grant Fritchey · Apress eBooks · 2014

SQL Server’s performance frequently depends upon having the proper indexes on the database tables. However, as the workload and data change over time, the existing indexes may not be entirely appropriate, and new indexes may be required. The task of deciding upon the correct indexes is complicated by the fact that an index change that benefits one set of queries may be detrimental to another set of queries.

Cited by 2

Database Engine Tuning Advisor

Grant Fritchey · Apress eBooks · 2018

SQL Server’s performance frequently depends upon having the proper indexes on the database tables. However, as the workload and data change over time, the existing indexes may not be entirely appropriate, and new indexes may be required. The task of deciding upon the correct indexes is complicated by the fact that an index change that benefits one set of queries may be detrimental to another set of queries.

Cited by 0

From Conceptual Database Schemas to Logical Database Tuning

Jean-Marc Petit, Mohand-Saïd Hacid · IGI Global eBooks · 2011

This chapter revisits conceptual database design and focuses on the so-called “logical database tuning”. We first recall fundamental differences between constructor-oriented models (like extended Entity-Relationship models) and attribute-oriented models (like the relational model). Then, we introduce an integrated algorithm for translating ER-like conceptual database schemas to relational database schemas. To consider the tuning of such logical databases, we highlight two extreme cases: null-free databases and efficient — though non redundant — databases. Finally, we point out how SQL workloads could be used a posteriori as a help for the designers and/or the database administrators to reach a compromise between these extreme cases. While a lot of papers and books have been devoted for many years to database design, we hope that this chapter will clarify the understanding of database designers when implementing their databases and database administrators when maintaining their databases.

Cited by 0

Database Tuning from Relational Database to Big Data

Bery Leouro Mbaiossoum, Ladjel Bellatreche, Narkoy Batouma et al. · International Journal of Engineering Trends and Technology · 2023

The objective of this work is to present the database tuning from relational databases to Big Data. It revisits the tools of the physical design. It examines their applicability to the main types of databases, in particular legacy (hierarchical or network), relational, object-oriented and NoSQL databases and Big Data. A literary review is done on database tuning tools to examine how to bring them closer to the DB lifecycle. It is noted that modern physical design techniques consider all phases of the DB lifecycle. Database tuning has evolved as new database types emerge. There is a vertical evolution of database tuning with the addition of new phases when a new database type appears and a horizontal evolution resulting in the enrichment of each phase of the DB lifecycle by considering new tools. This phenomenon with the Bigata data results vertically with multiple types of Big Data schemas and horizontally with the advent of the map-reduce technique. The database administrator has to consider these evolutions in the database tuning work.

Cited by 1Open access

FRAMEWORK TO SUPPORT DATABASE TUNING

ANA CAROLINA BRITO DE ALMEIDA · Portuguese National Funding Agency for Science, Research and Technology (RCAAP Project by FCT) · 2013

Há uma crescente demanda por ferramentas que automatizem tarefas complexas relacionadas ao SGBD, tais como aquelas relacionadas às atividades de sintonia fina. Nestas ferramentas, existe uma falta de clareza sobre as decisões e as ações que são tomadas de forma automática. Essa tese propõe um framework para execução das heurísticas de sintonia fina para apoiar o DBA (e possivelmente outros usuários) nas escolhas envolvidas na atividade de sintonia fina. Esse trabalho de pesquisa inclui uma proposta de ontologia para a sintonia fina (automática ou não) que proporciona uma abordagem formal para decisões e inferências. A contribuição inovadora dessa abordagem é oferecer transparência e\nconfiabilidade acerca das alternativas disponíveis para possíveis cenários no SGBD, por meio de justificativas concretas para as decisões que foram tomadas. Além disso, através do uso de uma ontologia específica, proporcionar a geração automática de novas práticas de sintonia fina, que podem ser obtidas a partir das práticas existentes (uso de inferências) ou de novas regras e conceitos que venham a surgir no futuro. Esta abordagem permite também a realização de combinações de heurísticas de sintonia fina em alto nível.

Cited by 0Open access

DB2 Universal Database Performance Tuning

Berni Schiefer, Gary Valentin · 1999

DB2 Universal Database is the flagship Relational Database from IBM. By building on decades of ground-breaking IBM Database Research projects, DB2 Universal Database benefits from a pervasive and con-tinuous infusion of advanced technology ranging from first-class optimizer and compiler technology to advanced locking, logging and recovery mechanisms, all designed with a common thread of high perfor-mance in both OLTP and complex query environments. This article will take the reader on a whirlwind tour of DB2 Universal Database, with a focus on the new auto-configuration tools. Find out how its open platform support exploits a rich repertoire of data storage techniques and how the latest Java-based ad-ministration tools can be used to quickly build and configure a DB2 Universal Database- for maximum performance. 1

Cited by 0