Konfigurasi Oracle Data Mining


Step Instalasi Oracle Data Mining

1. Install Database Oracle

2. Pastikan Option Data Mining sudah Enabled

SQL> SELECT VALUE FROM V$OPTION WHERE PARAMETER = ‘Data Mining’;
VALUE
—————————————————————-
TRUE

3. Create User untuk mengolah data mining

SQL> create user dmuser identified by dmuser13
2 default tablespace users
3 temporary tablespace temp
4 quota unlimited on users;
User created

4. Memberikan Grant kepada user agar bisa menggunakan objek data mining di database

GRANT CREATE JOB TO dmuser;
GRANT CREATE MINING MODEL TO dmuser; — required for creating models
GRANT CREATE PROCEDURE TO dmuser;
GRANT CREATE SEQUENCE TO dmuser;
GRANT CREATE SESSION TO dmuser;
GRANT CREATE SYNONYM TO dmuser;
GRANT CREATE TABLE TO dmuser;

GRANT CREATE TYPE TO dmuser;
GRANT CREATE VIEW TO dmuser;
GRANT EXECUTE ON ctxsys.ctx_ddl TO dmuser; — required for text mining
GRANT SELECT ON data TO dmuser; — required for data that is not in your schema

5. Grant Previlliges ke user

System Privilege Allows you to ….
CREATE MINING MODEL : Create mining models in your own schema.
CREATE ANY MINING MODEL : Create mining models in any schema.
ALTER ANY MINING MODEL : Change the name or cost matrix of any mining model in anyschema.
DROP ANY MINING MODEL Drop any mining model in any schema.
SELECT ANY MINING MODEL Apply(score) a mining model in any schema, also view model details in any schema.
COMMENT ANY MINING MODEL Add a comment to any mining model in any schema. (See “Adding a comment to a Mining Model” on page 5-3.)
AUDIT ANY Generate an audit trail for any mining model (or any object) in any schema. (See “Auditing Mining Models” on page 5-4.)

SQL> grant create mining model to dmuser;
SQL> grant create any mining model to dmuser;
SQL> grant alter any mining model to dmuser;
SQL> grant drop any mining model to dmuser;
SQL> grant select any mining model to dmuser;
SQL> grant comment any mining model to dmuser;
SQL> grant audit any to dmuser;

Oracle Data Mining baru bisa digunakan, User interfacenya bisa pake Oracle Data Miner

Selamat Mencoba… !

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s