IS&B: 12 Decision Support

Question 1

What are the Big data 3 V’s ?

Answer 1

1)Volume (size datasets)
2)Variety (data types)
3)Velocity (processing speed)

Question 2

What is a data warehouse?

Answer 2

Set of databases designed to support decision making in organization, structured for fast online queries/explorations, may extract and aggregate enormous amounts of data from many different operational systems

Question 3

What is the concept of data warehouse?

Answer 3

Extract data from org database and load it into data warehouse for storage/analysis

Question 4

What are the 3 criterias for data warehouses?

Answer 4

1)Uses non-operational data (copy of active databases)
2)Data is time-variant (time stamp when loaded)
3)Data is standardized (standard format)

Question 5

What is data mart?

Answer 5

Database focused on addressing concerns of specific problems or business unit (ex: marketing)

Question 6

What is the top-down approach?

Answer 6

Create an enterprise-wide data warehouse and then, as specific needs emerge, create smaller data marts from data warehouse

Question 7

What are the 5 benefits of data warehouses?

Answer 7

1)Forces to better understand data
2)Provides centralized view of data
3)¨One version of the truth¨
4)Snapshots of data can be taken over time
5)Tools to combine data