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.