Question

Consider an XYZ Hypermarket in the Sultanate of Oman. The hypermarket has got a lot of branches spread across different Wilayats in the country. As a database administrator, which client server architecture will you be preferring for this hypermarket and why. Support you answer with valid in-text citations and references.

Answer 1

For the communication of the users with online business organisations disseminated over the internet, client server based application are playing a significant role this where the importance of client server architecture receives its importance.

basically client server architecture is a shared architecture system where loads of client server are divided the client server architecture is a centralized resources systems where server holds all the resources. the server receives numerous performance at its edge for sharing resources to its clients when requested. client and server may be on the same network or different network it can be use in both the network.

Client server architecture are three types

1. 1-tier architecture

2. 2-tier architecture

3. 3-tier architecture

XYZ hypermarket is spreading all over in sultanate of oman so simply it is being big in market

so according to types of client server and features i will prefer 3-tier architecture

because it is easy to use in this client server an extra middleware is sued that means client request goes to the server through that middle layer and the responses of server is received by middlewre first and then to the client. this architecture protesct 2-tier architecture and gives the best performance this system comes expensive but it is simple to use the middleware stores all the buisness logic and data passage logic the idea of middleware is to be database staging, queuing, application execution, scheduling and also middleware improves flexibility and gives the best performance.

so this architecture will be perfect for this buisness.