oracle Data Mining
Executive Overview
The Oracle Data Mining Option provides powerful data mining functionality within the Oracle Database. It enables you to discover new insights hidden in your data and to leverage your investment in Oracle Database technology. With Oracle Data Mining, you can build and apply predictive models that help you target your best customers, develop detailed customer profiles, and find and prevent fraud. Oracle Data Mining helps your company better compete on analytics.
In-Database Data Mining
With Oracle Data Mining, everything occurs in the Oracle Database—in a single, secure, scalable platform for advanced business intelligence. Oracle Data Mining represents a breakthrough in business intelligence. In contrast to traditional statistical software that requires data extraction to separate servers, which may be insecure and costly to maintain, Oracle Data Mining embeds a wide-range of mining functions inside the database—where the data is stored. Coupled with the power of SQL, Oracle Data Mining eliminates data movement and duplication, maintains security and minimizes latency time from raw data to valuable information.
Oracle Data Mining enables you to:
• Leverage your data to discover patterns and valuable new insights
• Build and apply predictive models and embed them into dashboards and applications
• Save money. Oracle Data Mining costs significantly less than traditional statistical software. As an integrated component of your Oracle IT platform, Oracle Data Mining significantly reduces your total cost of ownership.
相关文档:
查询及删除重复记录的SQL语句
1、查找表中多余的重复记录,重复记录是根据单个字段(peopleId)来判断
select * from people
where peopleId in (select peopleId from people group by peopleId having count(peopleId) > 1)
2、删除表中多余的重复记录,重复记录是根据 ......
DML(Manipulation):数据操作语言
CRUD
DDL(Definition): 数据定义语言,与表,索引,同义词有关
create,alter,drop,rename,truncate(清空)
DCL(Control): 数据控制语言,与权限有关
grant,revoke
TCL(Transaction Control): 事务控制语言,与事务有关
commit,rollback,savepoint
==========================
存储 ......
1. flashback table table_test to timestamp to_timestamp('20091103000000','yyyymmddhh24miss');
2.如果報錯ORA-08189: cannot flashback the table because row movement is not enabled
3.alter table table_test enable row movement;
4.OK ......
游标(CURSOR),很重要
游标:用于处理多行记录的事务
游标是一个指向上下文的句柄(handle)或指针,简单说,游标就是一个指针
1 处理显式游标
显式游标处理需 4个 PL/SQL 步骤,显示游标主要用于处理查询语句
(1) 定义游标
格式: CURSOR cursor_name [(partment[,parameter]...)] IS s ......