W006-信息整解决方案与应用实践.ppt

议程 企业IT资源整合面临的挑战 IBM信息整合解决方案 IBM信息整合应用案例 企业面临的挑战—整合IT资源 整合:关键能力需求 传统的企业信息交互方式 高效信息集成技术 Federation-联邦数据库技术提供整合信息基础平台 联邦数据源 数据联邦提供单点数据访问 简化了数据访问的层次 例：实现多个数据源的联邦操作-大量的人工编码 信息整合技术简化应用 信息集成提供统一的客户视图 异构数据复制(SQL Q Replication) 基于事件的数据发布 信息集成提供全局负载管理 基于成本的全局优化技术 信息集成的数据安全 跨企业间信息集成 满足纵向系统间信息整合的需求 IBM Ascential—提供全面的数据处理方法学 WebSphere ProfileStage WebSphere QualityStage WebSphere DataStage 从上到下的GUI方法 性能: 并行执行 WebSphere MetaStage--元数据管理 Ascential Products now IBM WebSphere IBM信息整合成功案例 山东地税信息整合前架构 山东地税信息集成架构 泰康信息架构挑战 泰康信息整合 招商银行信息集成架构 谢谢! ProfileStage can analyze any source system that it can connect to via ODBC. The minimum information it needs is Table and Column Names. ProfileStage analyzes every data attribute in the source data and reverse engineers it to establish the true meta data of that source system ProfileStage determines what the distinct values are for each column and calculates the frequency distribution for all values. ProfileStage establishes the primary and foreign key candidates by finding the data relationships between columns in the same table and by comparing data values across multiple tables. This includes tables across multiple sources. ProfileStage can generate a normalized target database definition using the information chosen by the analyst after reviewing the analysis results. ProfileStage has a transformation mapping function which allows a user to establish or modify source to target mapping information. This information can be used to print a specification, generate DDL, or to create a DataStage ETL job. Search engine is sometimes called search runtime. In the web-based admin “Main index” is called “Index Reorganization” and delta index is called “Content Refresh” Spend some time on this slide to define all the components, their role (what’s the input, what’s the output) Notice that all components are independent. They can be started and stopped independently. If the crawler was to fail, or the parser or the indexer, the search runtime