تنقيب البيانات (Data Mining)

  • Published on
    13-May-2015

  • View
    7.693

  • Download
    1

Embed Size (px)

Transcript

  • 1. Data Warehousing : * : (OLAP (On-line Analytical Processing . :(DSS (Decision Support Systems (EIS (Executive Information Systems . ) :(Data Mining ) (. :(OLTP (On-line Transaction Processing . . . . :)1( ).(Multidimensional Model)2( ) (Time Series ) (Trends Analysis ) (Transactional Databases . )3( ) (Periodic . )4( . )5( ) (Aggregation ) (Dimensions . )6( Client/server . )7( )1 . (TB = 1024 GB :

2. 1- ) :(Enterprise-wide Data Warehouses . 2- ) :(Virtual Data Warehouses .3- ) :(Data Marts ) (. : : ) (Data Cubes ) (Hyper Cubes . . : : . ) ( . 3. . ) (Pivoting ) (Rotation . . : 1- ) :(Dimension Table attributes. 2- ) :(Fact Table )Business Key (Performance Indicators . : / :Star Schema . . / :Snowflake Schema Star Schema ) (Normalization. ).(Joining : 4. poduct_key Time_dim product_dimquarter_keyregion_key qarter_keypod_key revenueregion_dimyearprod_name . begin_dateprod_desc Region_keyend_dateprod_styleSales_fact subregionprod_lineStar Schema Time_dim pnames_dim product_dimSales_factqarter_key prod_namepod_key poduct_keyyear prod_descprod_name quarter_key begin_dateprod_styleregion_key prod_line revenueregion_dimbegin_date. end_date region_key prod_line_nosubregion prod_line_nam FQ_Dates e P_lines_dimSnowflake Schema: : metadataOLAP Cubes DSS, EIS Data Mining / poduct_keyquarter_keyqarter_keyregion_key yearrevenuebegin_date end_date Time_dimRegion_key .Sales_fact subregion region_dim 5. : 1- . 2- ) (Consistency .3- ) (Validity .4- .5- 6- 7- ) (Distributed )(Centralized : 1- :Roll-up ) (. 2- :Drill-Down -Roll.up 3- :(Pivot (Rotation . 4- :Slice and Dice . 5- ) :(Sorting . 6- ) :(Selection . 7- : . : : - . - . - .- . - . : (ROLAP (Relational OLAP (MOLAP ( Multidimensional OLAP SQL ) (Advanced Join Methods ) (Intelligent Scanning . :/ . / ).(Data quality 6. / . / .