Choosing a database
Databases come in many forms depending upon the amount
and the complexity of the data they must store. When choosing a
database, you should consider several factors, including your budget
and the number of users you anticipate will access the database.
- Budget
- Some vendors produce high‑end application database servers
that are expensive to buy and administer. Others vendors provide
easier, more cost-effective solutions, such as Microsoft Access
or the open-source database MySQL.
- Users
- If you anticipate a large user community accessing the site,
select a database designed to support your site’s intended user
base. For websites requiring greater flexibility in their data modeling,
and the ability to support large, concurrent user communities, consider
server-based relational databases (typically referred to as RDBMS)
like Microsoft SQL Server and Oracle.