What is metadata? What metadata is stored in the system catalog? Describe the information stored per relation, and per index. (Section 12.1)

The catalog is itself stored as a collection of relations. Explain why. (Section 12.1)

What three techniques are commonly used in algorithms to evaluate relational operators? (Section 12.2)

What is an access path? When does an index match a search condition? (Section 12.2.2)

What are the main approaches to evaluating selections? Discuss the use of indexes, in particular. (Section 12.3.1)

What are the main approaches to evaluating projections? What makes projections potentially expensive? (Section 12.3.2)

What are the main approaches to evaluating joins? Why are joins expensive? (Section 12.3.3)

What is the goal of query optimization? Is it to find the best plan? (Section 12.4)

How does a DBMS represent a relational query evaluation plan? (Section 12.4.1)

What is pipelined evaluation? What is its benefit? (Section 12.4.2)

1. Describe three techniques commonly used when developing algorithms for relational operators. Explain how these techniques can be used to design algorithms for the selection, projection, and join operators.

2. What is an access path? When does an index match an access path? What is a primary conjunct, and why is it important?

3. What information is stored in the system catalogs?

4. What are the benefits of making the system catalogs be relations?

5. What is the goal of query optimization? Why is optimization important?

 

 

What is metadata? What metadata is stored in the system catalog? Describe the information stored per relation, and per index. (Section 12.1)   The catalog is itself stored as a collection of relations. Explain why. (Section 12.1)   What three techniques are commonly used in algorithms to evaluate relational operators? (Section 12.2)   What is an access path? When does an index match a search condition? (Section 12.2.2)   What are the main approaches to evaluating selections? Discuss the use of indexes, in particular. (Section 12.3.1)   What are the main approaches to evaluating projections? What makes projections potentially expensive? (Section 12.3.2)   What are the main approaches to evaluating joins? Why are joins expensive? (Section 12.3.3)   What is the goal of query optimization? Is it to find the best plan? (Section 12.4)   How does a DBMS represent a relational query evaluation plan? (Section 12.4.1)   What is pipelined evaluation? What is its benefit? (Section 12.4.2)1.  Describe three techniques commonly used when developing algorithms for relational operators. Explain howthese techniques can be used to design algorithms for the selection, projection, and join operators.

• 1495279481-Assigment.docx

ComputerScienceExpert

(11)

Status NEW Posted 20 May 2017 11:05 AM My Price 9.00

-----------

Attachments

file 1495279484-Solutions file 2.docx preview (51 words )

H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------. ----------- Th-----------ank----------- yo-----------u -----------

Not Rated(0)

• Buy Answer