《Oracle大数据解决方案》学习笔记9-2——数据库库内分析-快速交付彰显时间价值（In-Database Analytics: Delivering Faster Time to Value）

 

1. Oracle文本挖掘模型

Oracle Text Mining Models
Model Type	Typical Functions
Rule-based classification	Efficiently classify a stream of documents according to a set of queries. For example, each time an e-mail arrives at a call center, send it to all interested agents. Or each time a news item arrives, post it to the relevant Web sites or pages.
Supervised training	Use a training set of documents to define a classifier for large data sets. Decision trees and support vector machines (SVMs) are examples of such techniques.
Clustering	Group similar documents together according to their content. The package supports flat and hierarchical clustering.

2. 业务问题对应的函数

Typical Examples of Business Questions and the Functions That Can Be Used to Answer Them
Type of Query	Function
List the brands that make up 20% of sales	Banding
Which region’s sales growth for 2012 as compared to 2011 was greater than 20%?	Lag/Lead
List the top ten and bottom ten salespeople per region	Ranking
What are each product’s sales as a percentage of sales for its product group?	Reporting Aggregate
What is the 13-week moving average for sales?	Windowing

 

3. 大数据与多维数据模型的集成，并展示在BI仪表盘