integrating data

Question 1

choice of storage depends on…

Answer 1

performance requirements, scalability, cost, security

Question 2

data integration

Answer 2

combining data into single, unified view of an organization’s data for analysis

Question 3

schema integration

Answer 3

• combines data from multiple sources using database schemas
  
  • maps the data, combining + analyzing it
• • can merge two data sets into single view using SQL

Question 4

data consolidation

Answer 4

combines data from multiple sources into a single location

Question 5

data propagation

Answer 5

• updating data in one system based on changes made in another system
• for consistency across apps

Question 6

application integration

Answer 6

• integrating data between different applications
• allows everyone in organization to access same info, regardless of app used

Question 7

the problems w/ integrating data

Answer 7

• quality: accuracy, consistency, completeness
• format incompatibilities: different file formats or database structures
• security: potential security risks when gathering from multiple sources

Question 8

how to overcome integration issues

Answer 8

• establish goals, everyone knows desired outcomes
• stakeholders(people who have something to lose if it doesn’t work out) involved in planning + execution
• standardized data formats + protocols for integration