main books n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
MAIN BOOKS PowerPoint Presentation
Download Presentation
MAIN BOOKS

Loading in 2 Seconds...

play fullscreen
1 / 9

MAIN BOOKS - PowerPoint PPT Presentation


  • 74 Views
  • Uploaded on

MAIN BOOKS. DATA WAREHOUSING IN THE REAL WORLD : Sam Anshory & Dennis Murray, Pearson DATA MINING CONCEPTS AND TECHNIQUES : Jiawei Han & Micheline Kamber, Morgan Kaufmann BUILDING THE DATA WAREHOUSE, W.H. Inmon, John Wiley & Sons DATA MINING TECHNIQUES : Arun Pujari, Universities-Press.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'MAIN BOOKS' - dewei


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
main books

MAIN BOOKS

DATA WAREHOUSING IN THE REAL WORLD : Sam Anshory & Dennis Murray, Pearson

DATA MINING CONCEPTS AND TECHNIQUES : Jiawei Han & Micheline Kamber, Morgan Kaufmann

BUILDING THE DATA WAREHOUSE, W.H. Inmon, John Wiley & Sons

DATA MINING TECHNIQUES : Arun Pujari, Universities-Press

additional readings
ADDITIONAL READINGS
  • INTRODUCTION TO DATA MINING WITH CASE STUDIES, G. K. Gupta (PHI)
  • DATA MINING Introductory & Advanced Topics, Margaret Dunham, Prentice Hall
oltp olap
OLTP & OLAP
  • OLTP covers day-to-day operations of an organization such as purchasing, inventory, payroll etc.
  • OLAP caters to knowledge workers and aid in decision making
oltp olap1
OLTP & OLAP
  • OLTP is customer oriented & used by clerks, clients & IT professional
  • OLAP is market oriented used for data analysis by knowledge workers including managers, executives and analysts
oltp olap2
OLTP & OLAP
  • OLTP uses current data, usually very detailed
  • OLAP uses large amounts of historical data with facilities for summarization, aggregation. Information is maintained at different levels of granularity
oltp olap3
OLTP & OLAP
  • OLTP uses E-R model
  • OLAP uses STAR or SNOWFLAKE model & a subject oriented database design
oltp olap4
OLTP & OLAP
  • OLTP consist of small, atomic transactions. No of records usually in terms of tens
  • OLAP consist mainly of read-only operations. No of records accessed usually in terms of millions
oltp olap5
OLTP & OLAP
  • In OLTP number of users in terms of thousands, DB size is 100 MB to GB, high performance, high availability

Metric for measurement is transaction throughput

  • In OLAP number of users in terms of hundreds, 100 GB to TB, high flexibility & end-user autonomy

Metric for measurement is query throughput

oltp olap6
OLTP & OLAP
  • OLTP - unit of work is short simple transaction, detailed flat relational view, index/hashing on primary key for operation
  • OLAP – unit of work is complex query, summarized multi-dimensional view, lots of scan involved in operation