Page 237 - DCAP402_DCAO204_DATABASE MANAGEMENT SYSTEM_MANAGING DATABASE

Database Management Systems/Managing Database

Notes 5. In .......................... applications, each query is independent and takes a relatively short time
to execute.
6. Intra-query parallelism is very beneficial in ........................ applications, which often have
complex, long-running queries.
7. The basic problem with the shared-memory and shared-disk architectures is ................
8. The .......................... architecture requires more extensive reorganization of the DBMS code.

9. SMP stands for ......................................
10. .......................... is used to allow user to access tools to refer to the appropriate partition.

13.9 Review Questions

1. What do you mean by parallel database?
2. Distinguish between parallel database and distributed database.

3. Why parallel database more critical than object oriented databases? Explain
4. “Decision support system used in parallel database.” Explain
5. Explain horizontal partitioning.

6. Distinguish between horizontal and vertical partitioning.
7. Explain intra-query concept in detail.
8. Distinguish between intra-operation and inter-operation parallelism.
9. What do you mean by inter-query parallelism?
10. Write short note on “partition by size of table”.

Answers: Self Assessment

1. Three 2. massively parallel systems
3. Parallel execution 4. Inter-query
5. Online Transaction Processing (OLTP) 6. Decision Support System (DSS)
7. interference 8. shared-nothing

9. Symmetric multiprocessing 10. Meta data
13.10 Further Readings

Books C.J. Date, Introduction to Database Systems, Pearson Education.
Elmasri Navrate, Fundamentals of Database Systems, Pearson Education.
Martin Gruber, Understanding SQL, BPB Publication, New Delhi
Peter Rob & Carlos Coronel, Database Systems Design, Implementation and
Management, 7th Edition.

230 LOVELY PROFESSIONAL UNIVERSITY