Quote:
Originally Posted by mbovenka
Weird, then, that in the corporate world they have doing pretty much nothing else for those 30 years. It doesn't seem to bother them much.
|
Those tend to use SERVER engines running on the host. The clients make requests and get sent a 'results'. The client does not get the full DB.
A Client - Server DBMS has all sorts of 'locking' protocol
I used to do Paradox DOS (RDBMS) this was a shared file DB system.
You ask the server 'can I do this kind of Lock right now' (typ Record or Full) or
Place a Block (to others) when you needed to do a process (eg PREVENT FULL LOCK)
did your thing and removed your locks
Fun things
happened when screen savers or auto logout happened while full locks were in use.
Thank goodness they had tools to see which user placed locks, so all you had to do was find the user.