Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Oracle, for example has a typical client server architecture, and a memory cache (SGA) with some background processes.

This is one way of designing a database. Are there databases out there which have been designed fundamentally in different ways than this?

share|improve this question

closed as not a real question by gbn, Jack Douglas Oct 17 '11 at 15:57

It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center.If this question can be reworded to fit the rules in the help center, please edit the question.

    
Why do you say Oracle is "client server"? –  gbn Oct 15 '11 at 14:26
    
@gbn: I did not understand your question. Oracle is a client server model, where a user process (client) connects to a server process (server) to do work. –  Lazer Oct 15 '11 at 14:42
    
In that case, aren't all RBDMS (which includes LDAP systems, mail servers etc) are client-server. How can you have otherwise? –  gbn Oct 15 '11 at 14:44
1  
FWIW sqlite is not client-server in the way most RDBMSs are, and neither are other file-based dbs like Jet. –  Jack Douglas Oct 15 '11 at 20:16
1  
@Lazer - I'm just closing this until you get back to me - we're very happy to open it up again if you edit... or can give us some direction via the comments to help you edit it. –  Jack Douglas Oct 17 '11 at 16:01

1 Answer 1

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.

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.