权威的BI-pentaho指南

BI-pentaho-权威指南 数据加工王者Kettle?...................................................................................................?21?3.1?ETL及Kettle概述?............................................................................................................?21? III 3.1.1?基于“流”架构的Kettle .......................................... 21?3.1.2?下载及安装Kettle ............................................... 22?3.2?Spoon设计转换及作业的集成开发环境?.................................................................?23?3.2.1?启动Spoon ...................................................... 23?3.2.2?从Kettle内置的ETL转换和作业示例谈起 ............................ 24?3.2.3?监控ETL转换的执行性能 .......................................... 29?3.2.4?调整宿主Spoon IDE的JVM内存 ..................................... 30?3.3?将转换和作业进行外在化管理?...................................................................................?30?3.3.1?存储到数据库中以Oracle为例 ................................... 30?3.4?Kettle内置的ETL相关辅助工具?....................................................................................?32?3.4.1?Pan执行转换 .................................................. 32?3.4.2?Kitchen执行作业 .............................................. 32?3.4.3?Carte添加新的ETL执行引擎 ..................................... 33?3.4.4?Encr加密工具 ................................................... 35?3.5?基于集群并发加工大批量数据?...................................................................................?35?3.5.1?静态集群模式 ................................................... 36?3.5.2?动态集群模式 ................................................... 36?3.6?与Pentaho?BI服务器的集成?..........................................................................................?36?3.7?自定义及扩展Kettle?......................................................................................................?36?3.8?Kettle最佳实践?..............................................................................................................?36?3.8.1?善待Kettle内置的变量集合 ....................................... 36?3.9?其他ETL解决方案..........................................................................................................?36?3.9.1?同IBM DataStage的对比 .......................................... 36?3.9.2?Spring Batch另一种风格的ETL解决方案 .......................... 37?3.10?小结?...............................................................................................................................?37?4?Action?Sequence集大成者?.........................................................................................?39?4.1?Action?Sequence概述?....................................................................................................?39?4.1.1?Pentaho Design Studio开发工具 .................................. 40?4.2?深入到Action?Sequence中?............................................................................................?42? IV 4.2.1?Action Sequence定义 ............................................ 42?4.2.2?测试Action Sequence ............................................ 43?4.2.3?组件集合 ....................................................... 44?4.3?于复杂BI场景中进行Action?Sequence实战?.................................................................?48?4.3.1?银行ETL调度场景概述 ............................................ 48?4.3.2?Action Sequence的创建过程 ...................................... 48?4.3.3?运行并验证Action Sequence的执行 ................................ 49?4.4?小结?...............................................................................................................................?49?5?Pentaho报表工具数据展现解决方案?.........................................................................?50?5.1?Pentaho数据展现解决方案概述?..................................................................................?50?5.1.1?Pentaho元数据编辑器概述 ........................................ 50?5.2?Pentaho?Report?Designer?...............................................................................................?51?5.2.1?PRD的下载及安装 ................................................ 51?5.2.2?借助PRD完成报表的制作 .......................................... 52?5.3?借助PME梳理报表模型?................................................................................................?52?5.3.1?PME的下载及安装 ................................................ 52?5.3.2?使用PME ........................................................ 52?5.3.3?PRD中报表模型的使用 ............................................ 52?5.4?Pentaho即席报表?..........................................................................................................?52?5.4.1?揭秘metadata.xmi ............................................... 53?5.4.2?即席报表的制作 ................................................. 53?5.5?嵌入式Pentaho报表引擎?..............................................................................................?53?5.5.1?操作型BI报表 ................................................... 53?5.5.2?嵌入式报表的研发过程 ........................................... 53?5.6?Pentaho数据展现最佳实践?..........................................................................................?53?5.6.1?中文问题 ....................................................... 53?5.7?小结?...............................................................................................................................?54?6?Mondrian?OLAP引擎多维数据分析利器?....................................................................?55? V 6.1?OLAP概述?......................................................................................................................?55?6.1.1?多维建模及数据仓库设计 ......................................... 55?6.1.2?Mondrian OLAP引擎 .............................................. 55?6.2?使用Mondrian?...............................................................................................................?55?6.2.1?下载Mondrian OLAP引擎 .......................................... 55?6.2.2?初探Mondrian OLAP .............................................. 56?6.2.3?Mondrian OLAP使用案例研究 ...................................... 56?6.3?借助PSW设计OLAP?Cube?..............................................................................................?56?6.3.1?下载Pentaho Schema Workbench ................................... 56?6.3.2?初探PSW ........................................................ 57?6.3.3?PSW使用案例研究 ................................................ 57?6.4?Mondrian技术架构探讨?...............................................................................................?57?6.5?与Pentaho?BI服务器的集成?..........................................................................................?57?6.6?借助Pentaho?Aggregation?Designer提升数据分析性能?..............................................?58?6.6.1?数据聚合概述 ................................................... 58?6.6.2?PAD的下载和安装 ................................................ 58?6.6.3?PAD使用案例研究 ................................................ 59?6.7?小结?...............................................................................................................................?59?7?基于Weka的数据挖掘解决方案?....................................................................................?60?7.1?数据挖掘概述?...............................................................................................................?60?7.1.1?Weka介绍 ....................................................... 60?7.2?采纳Weka进行数据挖掘?..............................................................................................?60?7.2.1?下载Weka ....................................................... 61?7.2.2?Weka使用案例研究 ............................................... 61?7.3?小结?...............................................................................................................................?61?8?Pentaho仪表盘工具?......................................................................................................?63?8.1?Pentaho?Dashboard工具概述?.......................................................................................?63?8.1.1?Community Dashboard Framework介绍 .............................. 63? VI 8.1.2?借助Flash展现 .................................................. 64?8.2?小结?...............................................................................................................................?64?9?Pentaho?BI套件高级特性讨论?.......................................................................................?65?9.1?配置新的解决方案库?...................................................................................................?65?9.1.1?Solution概述 ................................................... 65?9.1.2?实践Solution ................................................... 65?9.2?基于元数据的架构思路?...............................................................................................?65?9.3?基于领域模型的安全性管理?.......................................................................................?65?9.4?小结?...............................................................................................................................?65?10?附录AKettle组件权威指南?.....................................................................................?66?10.1?专注转换的组件集合?...................................................................................................?66?10.1.1?输入组件 ....................................................... 66?10.1.2?输出组件 ....................................................... 66?10.1.3?转换组件 ....................................................... 66?10.1.4?实用Utility组件 ............................................ 66?10.1.5?流程控制Flow组件 ........................................... 66?10.1.6?脚本组件 ....................................................... 67?10.1.7?查询组件 ....................................................... 67?10.1.8?连接组件 ....................................................... 67?10.1.9?数据仓库组件 ................................................... 67?10.1.10?校验Validation组件 ........................................ 67?10.1.11?统计Statistics组件 ........................................ 67?10.1.12?作业组件 ...................................................... 67?10.1.13?映射组件 ...................................................... 68?10.1.14?内联组件 ...................................................... 68?10.1.15?批量装载Bulk Loading组件 .................................. 68?10.2?专注作业的组件集合?...................................................................................................?68?10.2.1?通用组件 ....................................................... 68? VII 10.2.2?邮件组件 ....................................................... 68?10.2.3?文件管理组件 ................................................... 68?10.2.4?条件组件 ....................................................... 68?10.2.5?脚本组件 ....................................................... 69?10.2.6?批量加载组件 ................................................... 69?10.2.7?XML组件 ........................................................ 69?10.2.8?文件传输组件 ................................................... 69?10.2.9?资源库组件 ..................................................... 69?11?附录BSpring?Batch?.................................................................................................?70?11.1?为ETL而战?.....................................................................................................................?70?11.2?Spring?Batch概述?...........................................................................................................?70?11.3?实践Spring?Batch?...........................................................................................................?70?12?附录C相关资料?......