I am thinking of designing a very large database that can handle close to a million people. What best policies do I need to consider when designing such a system? Which potential bottlenecks does such a large systems present to designers and coders? How do I resolve the common bottlenecks associated with this kind of project?
The factors that define the large databases are software, hardware, data volume and throughput. The goal of every database should be efficient and scalable. When you design a large database, database architectures should be chosen in such a way that it does fast operations. An expert DataBase Administrator(DBA) will have experience in scaling the databases.  This  can determine the bottlenecks of a large database. The DBA should address the performance bottlenecks, cloud computing related issues and the availability issues while designing a large database. There must be multiple servers to handle the complexity of the backups. Ensure to include some business plans in your database design such that it helps in backups and prevention from data loss.
Â
