Multi-Location System Structure

Question 1

How do you consolidate from multiple locations?

Answer 1

1) Centralized cycle (Data and processing at central location)
2) Decentralized System- Individual location processing and data- Individual location processing data
3) Distributed (hybrid) database system- Distribute to locations according to need

Question 2

What are advantages/disadvantages of centralized system?

Answer 2

ADVANTAGES:

• Enables better data security
• Consistency in processing

DISADVANTAGE:

• High transmission costs
• Input/Output bottlenecks at high traffic times
• Slow response to information requests

Question 3

What are decentralized system advantages/disadvantages?

Answer 3

ADVANTAGES:

• Low transmission costs
• Lower power and storage
• Lower input/output bottlenecks

DISADVANTAGES

• Data redundancy
• Security issues
• Higher hardware costs

Question 4

What are distributed database system characteristics?

Answer 4

ADVANTAGES

• Better communication between locations
• More current and complete information
• Reduce or eliminate need for expensive central processing system

DISADVANTAGE:

• Cost of communication
• Access and update conflicts