Wir verwenden Cookies und Analyse-Tools, um die Nutzerfreundlichkeit der Internet-Seite zu verbessern und für Marketingzwecke. Wenn Sie fortfahren, diese Seite zu verwenden, nehmen wir an, dass Sie damit einverstanden sind. Zur Datenschutzerklärung.
Performance Evaluation and Optimization of Queries in Multi Databases
Details
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.
Autorentext
Sambit Kumar Mishra is presently working as a Professor (Computer Sc.&Engg.) & Head (R&D) in Gandhi Institute for Education & Technology, Bhubaneswar, Odisha. He is member of Editorial Board of several Journals like, IJDATS ( Inderscience Publishing House), IJAERS, JCSA, AJIS, JECET and member of Professional bodies ,ISTE,CSTA,IAENG,IACSIT,CSI
Weitere Informationen
- Allgemeine Informationen
- GTIN 09783330079267
- Anzahl Seiten 52
- Genre Self Help & Development
- Herausgeber LAP LAMBERT Academic Publishing
- Größe H220mm x B150mm
- Jahr 2017
- EAN 9783330079267
- Format Kartonierter Einband
- ISBN 978-3-330-07926-7
- Titel Performance Evaluation and Optimization of Queries in Multi Databases
- Autor Sambit Kumar Mishra
- Sprache Englisch