what is meant by distributed environment related to DBMS?

Question

i know the general and the dictionary meaning of it,

what does it mean when it said with respect to website and database designing?

like let say

make this and that for distributed environment,

what events, what criteria should be used, coding method

guidelines

please

thank you

if this question is not in accordance to the rules of post please redirect it thank you

Answer 1

Usually when a 'distributed environment' is mentioned in the context of a web application, it means a web farm: multiple servers running the same code where requests are load-balanced across available servers.

In the context of a database it can be an actual distributed database, but most of the time it refers to multiple copies of the same database(s), which are synchronized using what is known as replication.

The advantages are mostly redundancy and performance; there are more servers available to handle incoming requests, and if a single server fails, there are other servers available to transparently take over for that server.

You can learn about SQL Server replication here, and about IIS Web Farms here, but as to the things you need to take into account in code, I'm not able to help you.