What are the other types of database architectures?
Most databases are client/server, although some embedded databases can be used purely like libraries, and share the application's address-space.

The server architecture can vary between databases, and differ from what you described too.  MySQL runs entirely as a single process (with multiple threads).  It does not require any OS shared memory segments or inter-process communication.