Chapter 1
Database Fundamentals
Course: Comptia Datasys Ds0 001
Subject: Comptia Datasys Plus Ds0 001
Chapter: Database Deployment
1. Requirements Gathering
Requirements gathering is the foundational step in database planning. It involves analyzing business goals, user needs, data characteristics, and technical constraints to inform decisions about design, scalability, performance, and long-term maintainability. The accuracy and depth of this phase directly impact the effectiveness of the final system.
a. Number of users
The number of expected users influences concurrency control, server capacity, connection pooling, and licensing models. It’s important to consider both total and peak concurrent users.
- Small-scale systems (up to 50 users) can often be supported by a single database instance using lightweight RDBMS solutions like SQLite or MySQL, particularly in internal or departmental use cases.
- Medium-scale systems (100–500 users) may require optimized indexing, dedicated servers, and performance tuning.
- Enterprise-scale systems (thousands of concurrent users) need advanced architecture with multi-node clusters, load balancing, replication strategies, and optimized transaction handling.