Centralized Database

1
Centralized Database

• FAG 12
• Hongran
  Liang
• Jacqueline
  Beddaoui
• Mallory
  Boucher
• Saleh
  Rahman
• Shomaia
  Reza

2
Agenda

• Synopsis of the case
• Advantages and Disadvantages
• Impact on petPro

3
Synopsis of the case

• Major Drilling International Inc. is a contractor
  to mining companies all around the world for
  drilling work and core sampling.
• The old client-server system they were using was
  not efficient enough to continue daily
  operations.
• Under old system each division had to retrieve a
  copy of the company database and update it
  independently

4
Synopsis of the case

• Since Major Drilling deals with companies all
  around the world, a better system had to be
  employed.
• This is where centralized global database comes
  in.

5
Advantages of centralized database

• Minimal data redundancy
• Improved data consistency
• Improved data sharing
• Improved data accessibility
• Reduced program maintenance

6
Disadvantages

• New specialized personnel
• Installation and management cost and complexity
• Conversion Costs
• Need for explicit backup and recovery
• Organizational conflict

7
Impact on petPro

• Centralized Databases are vital for petPro
  because of the way it runs its operations.

8
Impact on petPro

• Theyre necessary for JIT Systems

9
Impact on petPro

• Online ordering
• -centralized databases ensure that
  
• orders are made ACCURATELY
• and ON TIME

10
Impact on petPro

• Centralizing databases allows for a lot of
  flexibility for the company, which greatens its
  ability to capture new opportunities as they
  arise, and reap the profits.

11
Impact on petPro

• If petPro decides to GO GLOBAL in the future, the
  potential for error and the need for time
  management is greater.

12

• Thank you!