There are numerous considerations when implementing either a centralized database or multiple replicated databases. These considerations include the question of whether the return-on-investment outweighs the upfront and future cost of the solution, what risks are associated with each solution and whether those risks are acceptable to the business, and what impact either solution would have on performance and productivity. By addressing these questions and weighing which solution most aligns with the overall business strategy while introducing more positive than negative consequences, the company can make the appropriate decision and move forward with the planning, design, and implementation of the solution.
The Pros and Cons of a Centralized Database In an effort to deploy a credit-sales system, the company must determine the optimal solution for storing user information and recording credit transactions. The first solution under consideration is whether to deploy a centralized database server at …show more content…
The availability of a service is a primary concern of information security and may even have legal ramifications due to the contractual obligations of a Service Level Agreement (SLA). Service unavailability, particularly for a credit-sales system, has an immediate impact on revenue, which will continue until that service is restored. The restoral process is much more difficult when there is a single site hosting the affected service, and even more so if the site is affected by a natural disaster that cause damage to the facility itself. In short, the decision to deploy a single, centralized database server has serious implications for business continuity, as well as the reliability and availability of the