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

When is update_statistics command used, When is UPDATE_STATISTICS command u...

When is UPDATE_STATISTICS command used? - When processing of large data is done, this command is used. - Whenever large number of modification, deletions or copy takes place

What is authorization graph, What is authorization graph? Passing of au...

What is authorization graph? Passing of authorization from single user to another can be shown by an authorization graph.

What is a primary index, What is a primary index? A primary index is an...

What is a primary index? A primary index is an index whose search key also explains the sequential order of the file.

State in brief about object design, Give the Introduction of OBJECT DESIGN ...

Give the Introduction of OBJECT DESIGN Strategies which are selected during system design are carried out in object-oriented design. In this procedure, objects which are identi

Draw an er diagram for organization of a student database, Draw an ER diagr...

Draw an ER diagram that shows the organization of a simple student database. The database captures the information about letter grades obtained by university students who enrolled

Benefits abd drawback of hashed file organisation, Benefits of Hashed file ...

Benefits of Hashed file Organisation 1. Insertion or search on hash-key is quick. 2. Best if equality search is required on hash-key. Drawbacks of Hashed file

Visio diagram - database, The database depicted in the Visio diagram descri...

The database depicted in the Visio diagram describes Proceeding , Article , Researcher , article PublishedIn a proceeding, article WrittenBy researchers and proceedings Edi

Logical design part 1, create an e-r diagram usuing graphical dipicted soft...

create an e-r diagram usuing graphical dipicted software that could theoritically be used in resturant application

List the armstrong axioms for functional dependencies, List the Armstrong's...

List the Armstrong's axioms for functional dependencies. What do you understand by soundness and completeness of these axioms? Ans: The Armstrong's axioms are: F1:

Linked list, what is difference between circular inked lust and grunded lin...

what is difference between circular inked lust and grunded linked list

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages