What are the issues are formed while selecting a database, Database Management System

Assignment Help:

What are the Issues when Selecting a Database

Issues when Selecting a Database

Storage space requirement: A database requires about triple storage space of the actual data.
Response time: The response time of database for input/output or communication bound (in case of the distributed databases) request.
Locking modes pessimistic locking: Lock before accessing an object
Optimistic locking: Read and writes can freely occur (high degree of concurrency).
Administration: Modern DBMS requires specially trained staff to set up security policies, prepare backups, manage the disk space, monitor performance and fine-tune the performance.

Related Discussions:- What are the issues are formed while selecting a database

Foreign keys , Foreign Keys and NULL Let us take the relation: ...

Foreign Keys and NULL Let us take the relation: DEPT DEPT ID DNAME BUDGET D1 M

What do you understand by raid, What do you understand by RAID? Explain RA...

What do you understand by RAID? Explain RAID Level 4 and Level5? RAID - It is stands for Redundant Array of Inexpensive Disks (as named by the inventor), or alternatively Re

Differentiate between static hashing and dynamic hashing, Differentiate bet...

Differentiate between static hashing and dynamic hashing. Ans: Static Hashing comprises the number of primary pages in the directory fixed. So, while a bucket is full, we requ

What is a homogeneous distributed database, What is a homogeneous distribut...

What is a homogeneous distributed database? In homogeneous distributed databases, all sites have the same database management system software, are aware of one another, and agr

Define the method of recursion, What is recursion? Is it possible for a sto...

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of SP nesting is possible? Recursion is method of proble

Describe domain constraints, Describe domain constraints. Domain constr...

Describe domain constraints. Domain constraints contain entity integrity and referential integrity. The domain is a set of values that might be assigned to an attribute. The en

What are the two integrity rules, What are the two integrity rules? An...

What are the two integrity rules? Ans: The two integrity rules are: Entity Integrity Rule & Referential Integrity Rule. Entity Integrity Rule - If the attribute A of rel

Explain nested relations, Explain nested relations? Nested relations ...

Explain nested relations? Nested relations The assumption of INF is a natural one in the bank examples we have considered. However, not all applications are best modelled

What is the concept of knowledge discovery in database, Data Warehousing & ...

Data Warehousing & Mining 1. What is the concept of knowledge discovery in database? 2. Describe the following types of Multidimensional Data Models. • Stars, Snowflakes and

The basic 2pl-two phase locking (2pl), Normal 0 false false ...

Normal 0 false false false EN-US X-NONE X-NONE

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages