Speed Up Vs Scale Up

Speed up	Scale up
It improves Response Time	It improves throughput.
As you multiply resources by a certain factor, the time taken to execute a transaction should be reduced by the same factor:	As you multiply resources the size of a task that can be executed in a given time should be increased by the same factor.
10 seconds to scan a DB of 10,000 records using 1 CPU 1 second to scan a DB of 10,000 records using 10 CPUs	1 second to scan a DB of 1,000 records using 1 CPU 1 second to scan a DB of 10,000 records using 10 CPUs
It concentrates on time, means improving response time i.e. Speed up.	It concentrates on data, means improving scale up.

Assignment - 5 Introduction to Other Databases

Assignment – 5  Introduction to Other Databases  

Submission Date : 25-04-2011   

Q.1	Explain the Following Questions in detail.
	1) What is Parallel Database System? Why we need it? 2) Explain Key element of Parallel Database system? 3) Explain Architecture of parallel Database with advantage and disadvantage? 4) Explain inter query parallelism and intra query parallelism? 5) Explain Advantage, disadvantage of Distributed Database System? 6) Explain Types and Property of Distributed Databases? 7) Explain Architecture of Distributed Database System? 8) Explain Two Phase commit? 9) Explain features, Advantage and Disadvantage of OODBMS?
Q.2	Differentiate the following :
	Parallel Database System Vs Distributed Database Interquery parallelism Vs Intraquery parallelism Homogeneous DDBS Vs Heterogenous DDBS Shared Memory multiple CPU Vs Shared Disk multiple CPU Speed Up Vs Scale Up

Mid Term Exam Feedback

Assignment - 4 Database Security

Assignment – 4     Database Security   Submission Date : 13-Apr-2011  

Q.1	Explain the Following Questions in detail.
	1.    What is database security? Explain the goal of database security? 2.    Describe the Granting & Revoking privileges using SQL with syntax and example. Explain account level, table level and column level privileges. 3.    Explain concept of audit train in detail 4.    Explain the Mandatory Access Control with Bell-Lapadulla model. 5.    What is statistics database security? 6.    What do you mean by firewall? What are firewall techniques that are used in database Security? 7.    Explain data encryption with different schemes. 8.   Using Polyalphabetic substitution method and encryption key, “SECURITY”, encrypt the plaintext message “SELL ALL STOCKS”
Q.2	Differentiate the following :
	1.    Security Vs integrity 2.    Discretionary Access Control Vs Mandatory Access Control 3.    Authorization Vs Authentication. 4.    Simple Property Vs Star Property 5.    Audit Trail Vs Transaction Log 6.    Simple Substitution Method Vs Polyalphabetic Substitution Method