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: 710 CZK
Availability: InStock

Autor: Sambit Kumar Mishra

Jazyk:

Vazba: Brožovaná

Vydavatel: LAP Lambert Academic Publishing

Dostupnost: Skladem u dodavatele

Odesíláme za 8-11 dnů

710 Kč

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

Informace o knize

Autor

Sambit Kumar Mishra

Jazyk

Angličtina

Vazba

Kniha - Brožovaná

Vydáno

2017

Stránek

EAN

9783330079267

ISBN

3330079266

Enbook ID

16367521

Vydavatel

LAP Lambert Academic Publishing

Hmotnost

Rozměry

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 zajímat

Zákaznicí kteří koupili tuto knihu koupili také

Nejčastěji hledané

Categories

Authors

Publishers

Produkty

Produkty

Nejčastěji hledané

Categories

Authors

Publishers

Produkty

Produkty

Performance Evaluation and Optimization of Queries in Multi Databases

Informace o knize

Kompletní popis

Mohlo by vás zajímat

Zákaznicí kteří koupili tuto knihu koupili také