IBM Software Group IBM Information Server Understand

® IBM Software Group IBM Information Server Understand - Information Analyzer © IBM Corporation

IBM Software Group IBM Information Server Delivering information you can trust Support for Service-Oriented Architectures Understand Cleanse Transform Deliver Discover, model, and govern information structure and content Standardize, merge, and correct information Combine and restructure information for new uses Synchronize, virtualize and move information for in-line delivery Platform Services Parallel Processing Connectivity Metadata Administration Deployment 2

IBM Software Group The IBM Solution: IBM Information Server Delivering information you can trust IBM Information Server Unified Deployment Understand Cleanse Transform Deliver Unified Metadata Management Information Analyzer Data profiling for understanding what data you Paralldata have and how it relates to other data, plus el Processing analysis for measuring and. Rich Connectivitongoingations, Data, and Content monitoring y to Applic data quality. 3

IBM Software Group Data Profiling Data Sources ERP from acquisition Mainframe manufacturing system Parts BOM External Lists Distribution Demographic Contact Billing / Accounts Critical Problems: § You don’t know what data is really in your legacy systems § Sources have changed or are new and unknown Why? § Data values and relationships are inconsistent and divergent from documented rules § Incomplete and missing documentation § Data sources are never static and frequently change without warning Alternative Approach § Labor intensive, resource devouring process § Never review 100% of data elements § No infrastructure to support maintenance § No standardized approach across projects § 1 st generation tools document but don’t address the problem resolution 4

IBM Software Group About Information Analyzer Data Sources ERP from acquisition Mainframe manufacturing system Parts BOM External Lists Distribution Demographic Contact § Automates your data discovery process § Enables you to understand your data before starting development § Eliminates the risk and uncertainty of using bad data § Useful in any type of data migration project § Analyzes every data attribute and reverse engineers the true meta data of your source § Reduces time to analyze data Billing / Accounts 5

IBM Software Group IBM Information Analyzer Data Profiling: the process of analyzing a data sources to determine its content, quality and structure § Reduce Time to Value of Data Projects § Increase the Productivity of Data Personnel § Assess Data Quality & Consistency across the Enterprise § Results sharable across IBM Information Server 6

IBM Software Group What does Information Analyzer provide? § Source System Analysis 4 Provides the key understanding of the source data § Column & Domain analysis Primary Key Analysis § Table/Primary Key analysis § Cross-Domain analysis Column Analysis § Foreign Key analysis Source 1 Source 2 Foreign Key & Cross-Domain Analysis § Iterative Analysis 4 Leverages the analysis to facilitate iterative tests § Baseline analysis 7

IBM Software Group Source System Analysis § Column & Domain analysis 4 Infers from content a column’s classification, physical properties, and frequency distribution § Table/Primary Key analysis 4 Validates the uniqueness of the identified key column, which allows us to ensure that a given row of data can be clearly identified and related to other data § Cross-Domain & Foreign Key analysis 4 Syncronizes the structure, relationships and integrity of data environments by finding and validating otherwise unknown relationships and identifying critical integrity violations that need to be rectified. 8

IBM Software Group Column Analysis: Tabular View 9

IBM Software Group Column Analysis: Chart View § Frequency Distribution 4 View Frequency Distribution either in Tabular or in Graph 4 Add user defined value to Frequency Distribution 4 Generate Reference Tables 4 Sort and Filter Frequency Data 10

IBM Software Group Column Analysis: Properties § Properties 4 Six property values are inferred for each column: Data Type, Length, Precision, Scale, Nullability and Cardinality Type. 4 Distribution of data types, lengths, precisions and scales is displayed graphical. 11

IBM Software Group Primary Key Analysis Results § Reviewing Duplicates 4 View Summary of Distinct and Duplicated Values 4 Display list of all Primary Key values and #/% Duplicated. 12

IBM Software Group Cross Domain Analysis Results 13

IBM Software Group Baseline Analysis § Baseline Differences 4 Detailed results for the column level. 4 Results include the column level summaries of distinctions for both Structure (Defined and Inferred) and Content. 14

IBM Software Group Sharing Analysis across Information Server 15

IBM Software Group ROI: Food Distribution. Company Facts : • Largest distributor in North America • Four major acquisitions in last two years • 12, 000 branded products • 30, 000 clients • 11 operating centers Project Goals Challenges Results Integration of supply chain management systems Staff changes and limited documentation related to acquired systems 80% productivity gain for analyzing data sources Profit margin analysis systems Only 7% of data being analyzed, but bad data causing 20% of cost overruns $504, 000 annual savings in lower development and maintenance costs Estimate 10 k hours and $650 k in costs to support first four projects Repeatable process for all future projects that ensures good, actionable data Field expansion, and take along project 16

IBM Software Group ROI: Top US Life Insurance Company Facts : • #1 Largest Life Insurance Company in USA • 138 US$ billion in assets under management • Offer complete like of life insurance, investment, retirement and related products Project Goals Competitive pressures requires the company to further enhance an existing competitive advantage – 360 degree customer view and 247 data availability. . Challenges Detailed customer data resided in ten disparate legacy systems with little to no documentation. Presenting raw detailed data 247 was impossible. Leveraging IBM allows for consistent data formats, validate data domains, define business rules linking policy data. Results Better customer visibility. Reduced costs by eliminating expensive and time-consuming investigations of detailed data. Redeploying an investigator saves $130 k annually. 17