System Types by Data Structure

Question 1

What is a flat file system?

Answer 1

BAD!!

• Usually in (pre-ERP system)
• Data redundancy, poor analytics
• Hard to extract data

Question 2

What is a database system?

Answer 2

Pool data into logically related files (the database)

MIS always implement in a database environment

Question 3

What is a knowledge management system?

Answer 3

• Means to collect, organize, and develop relations among information

Question 4

What is data warehouse?

Answer 4

System to collect, organize, and store entity-wide data

Easy to access to large quantities of varied data from across the organization

Often incorporated in data-driven (DDS) system

May include external data (economic indicators, stock prices, exchange rates, etc)

Drill down: Move from summary to detailed information (click into a number and get more information)

Slicing and dicing- view data in multiple ways

Question 5

What is data mining?

Answer 5

exploration, aggregation, and analysis of data in the data warehousing using analytical tools and exploratory techniques