本文主要是介绍《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仪表盘
这篇关于《Oracle大数据解决方案》学习笔记9-2——数据库库内分析-快速交付彰显时间价值(In-Database Analytics: Delivering Faster Time to Value)的文章就介绍到这儿,希望我们推荐的文章对编程师们有所帮助!