Performance Evaluation and Optimization of Queries in Multi Databases

Name: Performance Evaluation and Optimization of Queries in Multi Databases
Brand: LAP Lambert Academic Publishing
SKU: 9783330079267
Price: 31.02 EUR
Availability: InStock

Autor: Sambit Kumar Mishra

Jazyk:

Väzba: Brožovaná

Vydavateľ: LAP Lambert Academic Publishing

Dostupnosť: Skladom u dodávateľa

Odosielame za 8-11 dní

31.02 €

Modern database systems use a query optimizer to identify query plan to execute declarative SQL quer...

Informácie o knihe

Autor

Sambit Kumar Mishra

Jazyk

Angličtina

Väzba

Kniha - Brožovaná

Vydalo

2017

Stránok

EAN

9783330079267

ISBN

3330079266

Enbook ID

16367521

Vydavateľ

LAP Lambert Academic Publishing

Hmotnosť

Rozmery

150 x 220 x 3

Kompletný popis

Modern database systems use a query optimizer to identify query plan to execute declarative SQL queries. Optimization is a mandatory exercise since the difference between the cost of the best plan and a random choice could be in orders of magnitude. The role of query optimizers is especially critical for the decision-support queries featured in data warehousing and data mining applications. For a query on a given database and system configuration, the optimizer's plan choice is primarily a function of the selectivities of the base relations participating in the query. In this chapter, it has been projected towards the cost of sub-query operations on the various sites, as well as the benefits achieved in the range of thirty to forty percent for various sub-operations like selection, projection and join.

Mohlo by vás zaujímať

Zákazníci, ktorí si kúpili túto knihu, kúpili tiež

Najčastejšie vyhľadávané

Categories

Authors

Publishers

Produkty

Produkty

Najčastejšie vyhľadávané

Categories

Authors

Publishers

Produkty

Produkty

Performance Evaluation and Optimization of Queries in Multi Databases

Informácie o knihe

Kompletný popis

Mohlo by vás zaujímať

Zákazníci, ktorí si kúpili túto knihu, kúpili tiež