大数据智能分析解决方案介绍IBM64.pptVIP

统一考核数据平台当前痛点 痛点 痛点：各分行考核流程负责从分行的数据集市生成各分行考核数据集市。这个过程主要包含多表的关联操作。随着数据量大增大，流程处理的时间也越来越大。 执行时间过长，对业务考核产生影响，业务人员经常无法及时查询到自己的考核绩效。 流程由分行自行开发，总行DBA无法过多介入来保证性能。 针对目前平台痛点的2种可能优化方法： 优化现有的分行的行存储数据集市。 利用DB2 BLU来管理分行数据集市 分行考核流程 ? 2013 IBM Corporation 第六十二页，共六十五页。 优化方案结果对比 建立额外的索引 使用range partition分区表 采用页压缩技术 收集统计信息 调优内存配置 方案1 充分优化的行数据库 方案2 DB2 BLU DB2_WORKLOAD=ANALYTICS 建库，加载数据 运行 VS DB2 BLU无需繁杂的调优过程取得了19倍的性能提升 19 X ? 2013 IBM Corporation 第六十三页，共六十五页。 谢谢！ 第六十四页，共六十五页。 内容总结 Analytics and Big Data on Power方案及案例分享。“数据是新型石油”未开采的石油，没有什么价值。从渠道交互到社交媒体，通过分析所有数据来源帮助您了解您的每位客户。通过成本效益技术降低IT成本。我们不具备相应的需求、预算或者技能，因此我们不必为此担心。数据加载场景每核加载速度为x86核的11.18倍。从硬件、文件系统和分布式计算框架所有层面采用高可靠设计架构，杜绝基于开源产品的不可靠问题。GPFS-FPO替换HDFS，更可靠、更高效。DB2 BLU为DB2数据库添加列式存储功能。不同于常见的内存数据库，数据不必完全在内存中。银行风险管理系统-案例总结3/3。谢谢 第六十五页，共六十五页。 * Big data has become a business issue, or at least an issue that business people are aware of. Look at the coverage its getting in the business press. From the Wall Street Journal “Companies are being inundated with data” to the Financial Times “Increasingly businesses are applying analytics to social media such as Facebook and Twitter” to Forbes “Big Data has arrived at Seton Health Care Family”. Why is it getting this type of coverage? Because it has the potential to profoundly affect the way we do business. The quote on CNBC really exemplifies this “Data is the new Oil”. Data is a natural resource that is growing bigger. Like any resource, it is difficult to extract. It comes in many types – or a huge variety. It is also difficult to refine, or analyze. Many organizations do not even tap into this natural resource – they ignore data, or they use it for one purpose. This is largely because it is difficult to structure and restructure for different purposes. But some organizations have cracked the code, and they have figured out how to process and analyze the data available to them, and they are utilizing it to achieve breakthrough outcomes. If data is a natural resource, what is your