1 / 18

Lab2

CPIT 440 Data Mining and Warehouse. Lab2. CPIT 440 Data Mining and Warehouse. Lab2: Outlines . Installation Steps of Oracle 10g Introduction to Oracle Data Mining What is data mining ? What is data mining in the database ? What is Oracle data mining ? Data mining functions and models

margaretscott
Download Presentation

Lab2

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. CPIT 440 Data Mining and Warehouse Lab2

  2. CPIT 440 Data Mining and Warehouse Lab2: Outlines • Installation Steps of Oracle 10g • Introduction to Oracle Data Mining • What is data mining ? • What is data mining in the database ? • What is Oracle data mining ? • Data mining functions and models • Installation Oracle Data Mining tool with Oracle 10g

  3. CPIT 440 Data Mining and Warehouse Installation Steps of Oracle 10g • Oracle Universal Installer opens and displays the Select Installation Method page.

  4. CPIT 440 Data Mining and Warehouse Installation Steps of Oracle 10g 2. On the Product-Specific Prerequisite Checks page, verify that all checks succeeded. If any checks failed, then you must correct the problem before proceeding

  5. CPIT 440 Data Mining and Warehouse Installation Steps of Oracle 10g 3. The Summary page displays the settings and components for the installation. Click the Install button to proceed.

  6. CPIT 440 Data Mining and Warehouse Installation Steps of Oracle 10g 4. The Installer proceeds with the installation.

  7. CPIT 440 Data Mining and Warehouse Installation Steps of Oracle 10g 5. After installing the software, the Installer invokes the Configuration Assistants to create the starter database.

  8. CPIT 440 Data Mining and Warehouse Installation Steps of Oracle 10g 6. The Database Configuration Assistant copies the files for the starter database

  9. CPIT 440 Data Mining and Warehouse Installation Steps of Oracle 10g 7. In the Password Management dialog, you can specify new passwords for the system accounts.

  10. CPIT 440 Data Mining and Warehouse What is Data Mining? • Too much data and not enough information — this is a problem facing many businesses and industries. • Most businesses have an enormous amount of data, with a great information hiding within it. • Data mining provides a way to get the information buried in the data. • Data mining creates models to find hidden patterns in large, complex collections of data.

  11. CPIT 440 Data Mining and Warehouse What is Data Mining in the database? • Data mining projects usually require a significant amount of data collection and data processing. • Real-world data is often dirty, which is, includes wrong or missing values, • So, data must often be cleaned before it can be used. • Data is filtered, normalized, sampled, transformed in various ways, and eventually used as input to data mining algorithms. • Up to 80% of the effort in a data mining project is often devoted to data preparation.

  12. CPIT 440 Data Mining and Warehouse What Is Oracle Data Mining? • Oracle Data Mining (ODM) embeds data mining within the Oracledatabase. • ODM algorithms operate natively on relational tables or views, thus eliminating the need to extract and transfer data into standalone tools or specialized analytic servers. • ODM's integrated architecture results in a simpler, more reliable, and more efficient data management and analysis environment. 

  13. CPIT 440 Data Mining and Warehouse Data Mining Functions • Data mining functions can be divided into following categories:  • Supervised, Directed, Predictive functions • Unsupervised, Undirected, Descriptive functions

  14. CPIT 440 Data Mining and Warehouse Data Mining Functions • Supervised data mining: • Classification: Assign items to predefined classes (categories). • Regression: Approximating and forecasting continuous values • Attribute Importance: Identifying the attributes that are most important in predicting results • Anomaly Detection: Identifying items that do not satisfy the characteristics of "normal" data (outliers) • Unsupervised data mining: • Clustering: no predefined classes is required. The task is to find the grouping of the data based on the some relationships. • Association models: Analyzing "market baskets“, used to discover relationships or correlations in a set of items. • Feature extraction: Creating new attributes (features) as a combination of the original attributes.

  15. CPIT 440 Data Mining and Warehouse Installation Oracle Data Mining Step 1: Edit DMSYS user by using Oracle Enterprise Manager(EM) or SQL Plus. • Alter user DMSYS account unlock; • Alter user DMSYS identified by aaa; Step 2: Create Table-Space for working in ODM by using EM or SQL Plus. • CREATE SMALLFILE TABLESPACE "DM_TB" DATAFILE 'C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\dm_tbf' SIZE 100M • AUTOEXTEND ON NEXT 1M MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO; • BEGIN DBMS_SERVER_ALERT.SET_THRESHOLD(9000,NULL,NULL,NULL,NULL,1,1,NULL,5,'DM_TB'); END;

  16. CPIT 440 Data Mining and Warehouse Installation Oracle Data Mining Step 3: Create ODM User by using SQL Plus • @C:\oracle\product\10.1.0\db_1\dm\admin\odmuser Step 4: Open Oracle Data Miner • Unzip ODMINER and keep the folder in C Drive. e.g. C:/odminer • Open odminer bin  odminerw.exe

  17. CPIT 440 Data Mining and Warehouse Installation Oracle Data Mining Step 5: Enter all parameters required for making connection

  18. CPIT 440 Data Mining and Warehouse Installation Oracle Data Mining Step 6: Go to the Tools  Preference from Menu Bar Step 7: Browse and select SQL Loader.exe and working Directory • C:\oracle\product\10.1.0\db_2\BIN\SQLLDR.EXE

More Related