Histogram Techniques for Cost Estimation in Query Optimization: A Study in Relational Database Systems - Image 1

£52.00

It has never been this cheap. We have no record of a lower price.

£52 today · cheaper than every other day in the last 3 months

VDM Verlag Histogram Techniques for Cost Estimation in Query Optimization: A Study in Relational Database Systems

Name: Histogram Techniques for Cost Estimation in Query Optimization: A Study in Relational Database Systems
Brand: VDM Verlag
Price: 52.0 GBP
Availability: InStock

Computing & Internet

Price Distribution

Price distribution over 59 days • 1 price levels

Days at Price

Price Analysis

Most common price: £52 (59 days, 100.0%)

Price range: £52 - £52

Price levels: 1 different prices over 59 days

Description

Query optimization is an important task of Relational Database Management Systems. A typical query optimizer estimates the cost of various execution plans for a given query, and selects the one with the lowest cost. The accuracy of cost estimation is crucial in that it directly affects the quality of the decisions made by query optimizers. Seletivity estimation is an important part of cost estimation. Many commercial DBMSs maintain histograms to summarize the contents of relations in order to perform efficient selectivity estimations. In this book, we review the various existing histogram techniques, and propose two new types of histograms: the piecewise linear histogram and the A- Optimal histogram. Experiements show that they perform better than existing histogram in many cases. We also consider the problem of building global histograms. By adaptively allocate the given storage space to individual histograms according to their skewness, we can reduce the overall estimation error. Finally, we address the dynamic maintenance of histograms, and propose an efficient maintenance method for the piecewise linear histogram based on the probabilistic counting technique.

Product Specifications

Brand: VDM Verlag
Format: paperback
ASIN: 3639379063
Category: Books > Subjects > Computing & Internet
Domain: Amazon UK
Release Date: 26 August 2011
Listed Since: 01 September 2011

Barcode

No barcode data available

It has never been this cheap. We have no record of a lower price.

VDM Verlag Histogram Techniques for Cost Estimation in Query Optimization: A Study in Relational Database Systems

Price Distribution

Price Analysis

Description

Product Specifications

Barcode

Similar Products You Might Like

Query Processing Concepts and Techniques for Set Containment Tests: Algorithms, algebra, and applications involving the relational division operator

Extending Database Query Models for Data Retrieval and Analysis: Addressing emerging data challenges in user-facing applications with novel database querying capabilities

Classification and Analysis of Management and Marketing Data: Statistical Applications for Strategic Planning

Achieving Information Integrity in Databases for Open Systems: An analytical approach

Rough Set and Statistical Approach to Knowledge Discovery: Dimension Reduction, Clustering and Classification Techniques

The Institutionalisation of Data Quality in the Health Sector: The Development of a Data Quality Strategy and Framework for the Health Sector

Storing and Querying XML: An Efficient Approach Using Relational Databases

Erkennung von Laständerungen in Datenbanksystemen: Ein Baustein zur Entwicklung vollständig autonomer Datenbanksysteme

Staging for Creative Collaboration in Design Teams

State Dependence in Work-Related Training: Modelling and Estimation

Operational Behaviors and Continuous Improvement: in National Communications Systems

Nomadic Data Entry: Empirically Derived Performance Models for Data Entry Tasks in Mobile Situations

SOFTWARE REUSE AND INDUSTRIALIZATION: MODEL-DRIVEN INTEGRATION OF SOFTWARE AND SERVICE COMPONENTS

Interactive Multimedia Systems for Science and Rheology: Interactive Interrogation of Complex Rheological Data Using Media-Rich Adaptive Multimedia Technologies

Virtuelle Zusammenarbeit in Unternehmen: Analyse kooperativer Szenarien

Release Planning of Software Systems: A Decision Support Approach

Improvisation, Computers and Interaction

Learning and Probabilistic Methods for Visual Servoing and Tracking: An Optimization Approach

A COMMUNITY RELATIONS MODEL: FOR THE TOURISM INDUSTRY

The Performance of Diversified Hospitals in California: Gaining Competitive Edge by Diversifying Successfully

Deterministic and Stochastic Signal Processing: Continuous and Discrete Time Signals

Work?ow Patterns in Practice: A Case Study on Facility Management

COLLABORATION IN MASS CUSTOMISATION: Exploring the impacts of suppliers and lead users

Taylor Kriging for Simulation Metamodeling: Taylor Kriging for Simulation Interpolation, Sensitivity Analysis and Optimization

It has never been this cheap. We have no record of a lower price.

VDM Verlag Histogram Techniques for Cost Estimation in Query Optimization: A Study in Relational Database Systems

Price History & Forecast

Price Distribution

Price Analysis

Description

Product Specifications

Barcode

Similar Products You Might Like

Query Processing Concepts and Techniques for Set Containment Tests: Algorithms, algebra, and applications involving the relational division operator

Extending Database Query Models for Data Retrieval and Analysis: Addressing emerging data challenges in user-facing applications with novel database querying capabilities

Classification and Analysis of Management and Marketing Data: Statistical Applications for Strategic Planning

Achieving Information Integrity in Databases for Open Systems: An analytical approach

Rough Set and Statistical Approach to Knowledge Discovery: Dimension Reduction, Clustering and Classification Techniques

The Institutionalisation of Data Quality in the Health Sector: The Development of a Data Quality Strategy and Framework for the Health Sector

Storing and Querying XML: An Efficient Approach Using Relational Databases

Erkennung von Laständerungen in Datenbanksystemen: Ein Baustein zur Entwicklung vollständig autonomer Datenbanksysteme

Staging for Creative Collaboration in Design Teams

State Dependence in Work-Related Training: Modelling and Estimation

Operational Behaviors and Continuous Improvement: in National Communications Systems

Nomadic Data Entry: Empirically Derived Performance Models for Data Entry Tasks in Mobile Situations

SOFTWARE REUSE AND INDUSTRIALIZATION: MODEL-DRIVEN INTEGRATION OF SOFTWARE AND SERVICE COMPONENTS

Interactive Multimedia Systems for Science and Rheology: Interactive Interrogation of Complex Rheological Data Using Media-Rich Adaptive Multimedia Technologies

Virtuelle Zusammenarbeit in Unternehmen: Analyse kooperativer Szenarien

Release Planning of Software Systems: A Decision Support Approach

Improvisation, Computers and Interaction

Learning and Probabilistic Methods for Visual Servoing and Tracking: An Optimization Approach

A COMMUNITY RELATIONS MODEL: FOR THE TOURISM INDUSTRY

The Performance of Diversified Hospitals in California: Gaining Competitive Edge by Diversifying Successfully

Deterministic and Stochastic Signal Processing: Continuous and Discrete Time Signals

Work?ow Patterns in Practice: A Case Study on Facility Management

COLLABORATION IN MASS CUSTOMISATION: Exploring the impacts of suppliers and lead users

Taylor Kriging for Simulation Metamodeling: Taylor Kriging for Simulation Interpolation, Sensitivity Analysis and Optimization