Transcription of 8. Query Processing - Computer Science- UC Davis
{{id}} {{{paragraph}}}
Example: tourism industry
8. Query Processing - Computer Science- UC Davis
ECS-165A WQ'11 136. 8. Query Processing Goals: Understand the basic concepts underlying the steps in Query Processing and optimization and estimating Query Processing cost; apply Query optimization techniques;. Contents: Overview catalog Information for Cost Estimation Measures of Query Cost Selection Join Operations Other Operations Evaluation and Transformation of Expressions Query Processing & Optimization Task: Find an efficient physical Query plan (aka execution plan). for an SQL Query Goal: Minimize the evaluation time for the Query , , compute Query result as fast as possible Cost Factors: Disk accesses, read/write operations, [I/O, page transfer] (CPU time is typically ignored). Dept. of Computer Science UC Davis 8. Query Processing and Optimization ECS-165A WQ'11 137. Basic Steps in Processing an SQL Query Parser & Relational Algebra SQL Query Translator Expression Statistics Optimizer (System Catalogs).
Dept. of Computer Science UC Davis 8. Query Processing and Optimization. ECS-165A WQ’11 137 Basic Steps in Processing an SQL Query ... Representation as logical query plan (a tree): o o CName Price > 5000 CName Price > 5000 ORDERS CUSTOMERS ORDERS OFFERS ... ECS-165A WQ’11 139 Catalog Information for Cost Estimation Information about ...
Loading..
Tags:
Information
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document:
Related search queries
Catalog, Price, Motor Accessories, Motor Accessories Motor Accessories, This Issue: SPINACH DOWNY MILDEW: NEW, And Hello Direct Corded Headsets How, And Hello Direct Corded Headsets, Gross national income per capita, MANAGEMENT APPROACH FOR DRAINAGE, APPROACH FOR DRAINAGE INFRASTRUCTURE AND, University of Cincinnati, Management Approach for Drainage Infrastructure and