Enterprise Information Mashups: Integrating Information, Simply Anant Jhingran CTO, Information Management IBM IBM Confidential
Outline � Web 2.0 and Info 2.0 � Example and the research problems we see � IBM efforts in this area � Creativity v. Control
Information Technology Spend “had” been growing nicely 2000: Dot- 1964: 1971: First 1981: IBM 1994: com S/360 Intel Micro PC Netscape collapse debuts Navigator
Over time, complexity got built into the IT systems Mainframe PC/NT apps Depository Banks Unix apps Vendor Setup Vendor 3rd Party Interface Process Servers I17 Customer Perceived Maintenance UAR - Universal Account Budget (Imaging) NEW Soundscan In-Stock Sterling VAN Analysis Tool NPD Group Roadshow Reconciliation Printer Mesa Data Mailbox (Value) AIG Warranty Guard S20-Sales Maintenance Polling I13- Auto I15 Hand Scan I06 - Customer Replenishment Apps Printer PO Insertions Order S01 - Sales AIS Reports Orders Corrections AIS Calendar I06 Warehouse Due Dates Print Costing Management General Invoice App Broadcast E13 Stores & Mrkts Maintenance E3 Interface Fringe PO Filter Smart Plus Smart Plus M03 - Millennium 3.0 S04 - Sales Posting Launcher S07 - Cell I03 Return to P16 - Tally Sheet Phones D01 Post Load Vendor M02 - Millennium S06 - Credit App Billing Equifax Stock Options I12 Entertainment S09 - Digital P15 EES Employee Software Satellite Change Notice L02-Resource A04 - Cust System L01-Promo Scheduling Refund Chks E01-EDI 1 (Campbell) Analysis P14 On-line New Hire Entry AAS V02-Price Resumix P01- Marketing Employee Washington, Support RGIS, Masterfile Ntl Bus Systems P09 - P17 Cobra Cyborg Frick S11 - ISP CTO2.Bestbuy. CTS Co I10 Cycle Physical Tracking com I04 Home Inventory ACH Deliveries V04-Sign Prodigy System U18 - CTO Banks - ACH and Pos to I02 - POS X92-X96 Transfers Pay Host to AS400 Communication Plan Administrators (401K, PCS, Life, Spec Source B01 - Stock SKU Tracking Status Unicare, Solomon I11 Price Smith Barney) I09 Cycle Counts Testing Supplier S08 - Vertex NPD, S02 - Compliance Intercept Sales E02-Employee Layaways SoundScan Tax Purchase Spec I01 PO Source SKU Scorecard - HR Receiving Performance V03- Mkt Reactions L60 MDF Coop P09 S03-Polling I05 V01-Price Management SKU Selection Bonus/HR System Inventory Info Tool I35 - CEI K02 Customer Repair ASIS Arthur Planning I35 Early Warning Tracking System I18 Rebate SKU Rep Transfer I55 SKU I07 Purchase Store Information Order Ad Expense Monitor ELT PowerSuite G02 - General Ledger Store Scorecard Texlon 3.5 Sign System NARM I14 Count Corrections Store Budget Reporting Valley Media B02 Merchandise U16-Texlon CopyWriter's Analysis BMP - Bus Workspace performance Mngt EDI Coordinator Merch Mngr Approval Batch Forcasting AIMS Journal Entry Tool Kit A05 - AP Ad Measurement AIMS Admin INVENTORY CONTROL APPS - PC INVENTORY CONTROL APPS - PC ACCTS REC APPS - PC Cellular Code Alarm DPI/CPI 990COR Rollover AIMS OTHER APPS - PC Debit Receivings IC Batching Bad Debt Ad S05 - House Reporting AP - Collections/Credit Devo Sales Inventory Adj/Count Correct Beneficial Fees Charges TM - Credit Card DB Display Inventory Inventory Control Reports Beneficial Reconcile Launcher In Home Inventory Levels JEAXF Junkouts Inventory Roll JEBFA US Bank Recon Merchandise Withdrawal Optika Merchandise Withdrawal JEBKA PSP File Promo Credits Open Receivings JEDVA C02 - Capital RTV Accrual PI Count Results JESOA Projects Shrink PI Time Results from Inv JEVSA Connect 3 ICMS Credit AP Research - Inv Cntrl Price Protection JEVSF SiteSeer AP Research-Addl Rpts Sales Flash Reporting NSF In-Home Book to Perpetual Inventory Shrink Reporting TeleCredit Fees Data Warehouse Repair Close Out Reporting SKU Gross Margin Connect 3 Connect 3 Computer Intelligence Data SKU Shrink Level Detail (Interfaces to and from the Cash Receipts/Credit PDF Transfe Reports Count Corrections Data Warehouse are not F06 - Fixed USM Cross Ref for VCB Dnlds VCB Downloads displayed on this diagram) Assets Misc Accounting/Finance Apps - PC/NT Warranty Damage Write Off COBA (Corp office Budget Assistant) Billing Debit Receivings Star Repair Cash Over/ PCBS(Profit Center Budget System) DFI Vendor Database System Short Merchandising Budget Display Inventory Reconcile Prepared by Michelle Mills Display Inventory Reporting Actual Application Architecture for Consumer Electronics Company
And using Information as a Strategic Asset to build better Architectures Presentation Services Legacy Portals, Browsers, and or Devices Legacy Transaction Discovery Analytic Application Services Services Application Services Business Process Management Master Discovery App Tactical Tx Strategic Business Data APPL Process Business Server APPL APPL APPL APPL Monitoring Services Rules Enterprise Service Bus Master data Hubs Federation Product Customer Metadata EDW ECW Email OLTP Supplier Location OLTP1 Metadata Event OLTP2 Notes Master Data Services Processing Services Streaming Batch Collaboration Transaction Analytic Services Content Services Information Integration Services Services Services
Open Innovation is Here to Stay, Exemplified by Web 2.0 But…
Web 2.0 outside, and inside an enterprise will succeed only with a Info 2.0 Mashup Fabric Web 2.0 Info 2.0 Enables the same separation of “data” and “logic” that revolutionized the use of databases in the ’80’s. Enables the same separation of “information” and “process” that is now happening in Web 1.5
Within enterprises, it will… � Enable connections to Presentation Services Legacy Portals, Browsers, and or Devices Legacy information that does not make it into the enterprise IT Architectures: Transaction Discovery Application Services Services Analytic Application Services – Email Business Process Management Master Discovery App Tactical Tx Strategic – Presentations and Documents Data APPL Server APPL APPL APPL Business APPL Process Business Monitoring Services Rules – External Data (Web) – Spreadsheets Enterprise Service Bus – Decision Support Datasets… Master data Hubs � And Enable it to be done Federation “quickly”, as “assembly” as Metadata Cu Pr sto od me uct r EDW ECW Email opposed to as “programming” OLTP Sup L OLTP1 plier oc Event Metadata ati OLTP2 Processing Services Notes o Master Data Services n Streaming Batch Collaboration Transaction Services Services Analytic Services Content Services Information Integration Services
How the Architecture could play out… External Web LOB Focus IT Focus Situational Apps Process Server/ESB Situational Apps Process Server/ESB Web 2.0 Info 2.0 Information Integration Information Integration Info 2.0 Fabric Info 2.0 Fabric ppt email doc doc DB CM Files SaaS Model Software Model
Example (Zipcode) Meet Pete, an insurance agent in Florida. He sees a news report of a severe storm. What is the company’s risk? He needs to forward a risk summary to executives. (HUC = Hydrological Unit Code) (Geocode = Latitude/Longitude) (Geocode = Latitude/Longitude) http://florida.maps.anant/ http://water.usgs.gov/waterwatch/ edc. usgs.gov/ http://www.dotd.louisiana.gov/
Flood Risk Assessment Mashup Report Report Mashup Search Mashup Search Standardization Standardization Screen Scraping Screen Scraping Standardize www.floodlevels.com Standardize www.floodlevels.com Lineage Lineage standardize policy XLS water.usgs.gov edc.usgs.gov dotd.florida.gov policy XLS water.usgs.gov edc.usgs.gov dotd.florida.gov
So how can Pete write his mashup simply? Simplicity Accuracy
So how can Pete write his mashup simply? Procedural Code <?php // Get policy holders in a Policy object array $url = "file://policies/myclients.xsl"; $content = file_get_contents($url); $policyArr = getPolicy($content); // Find high risk zones $url = "http://www.floodlevels.com"; $content = file_get_contents($url); // Do screen scraping to extract high risk zones Procedural $zoneArr = findRiskyZones($content); // Initialize the return array Code Accuracy $riskArr = array(); // Find corresponding policy holders for each city foreach ($policyArr as $policy) { if ($policy->amount < 250000) { continue; } // Standardize the address $policyZone = findZone($policy->address); // Check whether this policy affected foreach ($zoneArr as $zone) { if ($zone == $policyZone) { // This policy carries a high risk. // Insert into high risk array $riskArr [] = $policy; } } } // Send email to manager for high risk policies sendEmail("suzan@trustinsurance.com", "High risk policies", $riskArr); ?> Simplicity
So how can Pete write his mashup simply? Declarative Queries sendMail("suzan@trustinsurance.com", <highRiskPolicies> { for $i in url(“file://policies/myclients.xsl”) for $j in url("http://www.floodlevels.com”) Accuracy where $i//amount > 250000 and $i//address in $j/zone return <policy> {$i} </policy> } </highRiskPolicies>); Simplicity
So how can Pete write his mashup simply? GUIs, Spreadsheets, Wikis Accuracy Simplicity
Recommend
More recommend
