Let's wrap up by discussing the content database architecture. There is exactly one content database per SharePoint Web application installed by default. You might recall from Chapter 1 that portions of the setup and installation screen referred to this database. The role of the content database is to store site content for customized pages, including site documents or files in document libraries, list data, and Web Part properties, as well as user names and rights.
In addition, Windows SharePoint Services 3.0 stores all end user data in the content database. The approach provides the following advantages:
Storage of list data, documents, and metadata in normalized tables
Transactional updates of documents and ...