What are the implications of database system architecture choices, such as shared-nothing, shared-disk, and shared-everything architectures, on system scalability, fault tolerance, and performance characteristics, and how do they influence database deployment and configuration decisions?