Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

You are employed as a DBA in a manufacturing company. Currently, you manage two databases for two production systems in your company. There are many

You are employed as a DBA in a manufacturing company. Currently, you manage two databases for two production systems in your company. There are many problems with the backup procedure, backup type and cluster between these two systems, you should propose a backup procedure, backup type and cluster solution between these two systems. The following about each system.

  1. a. You manage a database in a data warehouse system. There is a huge amount of data in this database. The situation with this system: • Only executives and managers could access this database
    • • This database is not critical in the business process in your company.
    • • It takes 4 days for a full backup of this database and 2 days for differential backup.
    • • It is not necessary to always back up this database.
    • b. You manage a database for a machinery system. The situation with this system: • This system is very critical and must always be available.
    • • This system does not store a huge amount of data.
    • • It is necessary to always take backup because this system is critical for your company.
    • • It takes 6 hours to fully backup and 1 hour for a differential backup.
    • Based on 2 cases above you should make :
  • Make an architecture diagram for clustering between 2 systems and explain it!

Step by Step Solution

3.39 Rating (152 Votes )

There are 3 Steps involved in it

Step: 1

To manage the backup process backup type and integration of two systems in the manufacturing company data warehouse system and technology you must con... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Management Accounting Information for Decision-Making and Strategy Execution

Authors: Anthony A. Atkinson, Robert S. Kaplan, Ella Mae Matsumura, S. Mark Young

6th Edition

137024975, 978-0137024971

More Books

Students also viewed these Databases questions

Question

Do any of my ideas contradict one another?

Answered: 1 week ago

Question

How is residual income computed?

Answered: 1 week ago