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

What is a recursive relationship, Question: (a) Can a set of data requi...

Question: (a) Can a set of data requirements be correctly modelled by two or more different ER diagrams? Explain your answer. You may use a small example, if you think it will

Define rotational latency time, Define rotational latency time. The ti...

Define rotational latency time. The time spent waiting for the sector to be accessed to appear under the head is known as the rotational latency time.

Recovery management component, Ask question #Minim 100 words accepted#what ...

Ask question #Minim 100 words accepted#what is recovery management component in database management system and how it is useful

Attribute inheretence, a brief definition

a brief definition

Describe the capabilities offered via mysql client apis, Describe the capab...

Describe the capabilities offered via MySQL client APIs? . • Checking for errors. . • Connecting to the MySQL server, selecting a database, disconnecting from the server

State the process of inheritance adjustment, Inheritance Adjustment As...

Inheritance Adjustment As in object oriented analysis and design terms inheritance defines a relationship between classes, where as one class shares structure or behaviour def

Draw an e-r diagram and convert it to a relational schema, In an organisati...

In an organisation various projects are undertaken. Each projects can employ one or more employees. Every employee can work on one or more projects. Each project is undertaken on

Explain dml with some examples, Explain DML with some examples? DML - D...

Explain DML with some examples? DML - Data Manipulation Language: statements used for managing data within schema objects. Some examples: • SELECT - retrieve data from the a da

Determine that the checkpoints are a part of, 1. Determine that the Checkpo...

1. Determine that the Checkpoints are a part of Ans: Checkpoints are a part of Recovery measures

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