A company plans to deploy a credit-sales system that will provide service to ten
ID: 3741555 • Letter: A
Question
A company plans to deploy a credit-sales system that will provide service to ten large population centers. A database will be used to store user information and record credit transactions. The IT department is considering two choices:
(1) A centralized database, where a single copy of the data is stored in one datacenter and used from all population centers.
(2) A replicated database, where one copy of the data is stored at multiple data centers (one in each population center) and all copies of the data are synchronized.
Be sure to watch the short youtube video about replicated databases as part of your research: http://www.youtube.com/watch?v=R-WceyM7BD0
Create a presentation for the next IT staff meeting that summarizes the pros and cons of each approach and recommends the one that should be deployed.
Explanation / Answer
Centralized database:
>Centralized databases are the type of database where the whole database resides at a single location such as a mainframe computer or a database server
>The main advantages of centralized databases are the following
>The disadvantages of a centralized database are
Replicated database :
>Replicated databases are the type of distributed database where the copy of data resides in more than one sites
>The advantages of a replicated database are:
>The disadvantages are
In the above scenario, it will be a redundant database that would be suggested because of the following reasons.
> Since the database stores the credit information from each major population center, the redundant database can reduce the access time if the data are stored in the corresponding server at that center.
>If the credit information is lost, then the company will be in trouble. so it is very important data to the company so recovery is a primary concern than the initial cost of implementation so Redundant database is more suitable than centralized.
>The redundant databases can overcome the bottleneck condition arises from a large number of requests so, the system can work without bottleneck issue
Therefore by considering all the facts, the redundant database is more suitable to this system.
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.