ch18 - Chapter18:DataAnalysisandMining...

Info iconThis preview shows pages 1–6. Sign up to view the full content.

View Full Document Right Arrow Icon
Database System Concepts ©Silberschatz, Korth and Sudarshan See  www.db-book.com  for conditions on re-use  Chapter 18: Data Analysis and Mining  Chapter 18: Data Analysis and Mining 
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
©Silberschatz, Korth and Sudarshan 18.<number> Database System Concepts - 5 th  Edition, Aug 26, 2005 Chapter 18: Data Analysis and Mining  Chapter 18: Data Analysis and Mining  Decision  Support Systems Data Analysis and OLAP Data Warehousing  Data Mining 
Background image of page 2
©Silberschatz, Korth and Sudarshan 18.<number> Database System Concepts - 5 th  Edition, Aug 26, 2005 Decision Support Systems Decision Support Systems Decision-support systems  are used to make business decisions, often  based on data collected by on-line transaction-processing systems. Examples of business decisions: What items to stock? What insurance premium to change? To whom to send advertisements? Examples of data used for making decisions Retail sales transaction details Customer profiles (income, age, gender, etc.)
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
©Silberschatz, Korth and Sudarshan 18.<number> Database System Concepts - 5 th  Edition, Aug 26, 2005 Decision-Support Systems: Overview Decision-Support Systems: Overview Data analysis  tasks are simplified by specialized tools and SQL  extensions Example tasks For each product category and each region, what were the total  sales in the last quarter and how do they compare with the same  quarter last year As above, for each product category and each customer category Statistical analysis  packages (e.g., : S++) can be interfaced with  databases Statistical analysis is a large field, but not covered here Data mining   seeks to discover knowledge automatically in the form of  statistical rules and patterns from large databases. data warehouse  archives information gathered from multiple sources,  and stores it under a unified schema,  at a single site. Important for large businesses that generate data from multiple  divisions, possibly at multiple sites Data may also be purchased externally
Background image of page 4
©Silberschatz, Korth and Sudarshan 18.<number> Database System Concepts - 5 th  Edition, Aug 26, 2005 Data Analysis and OLAP Data Analysis and OLAP Online Analytical Processing (OLAP) Interactive analysis of data, allowing data to be summarized and  viewed in different ways in an online fashion (with negligible delay) Data that can be modeled as dimension attributes and measure  attributes are called  multidimensional data .
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 6
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 52

ch18 - Chapter18:DataAnalysisandMining...

This preview shows document pages 1 - 6. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online