<Insert Picture Here> Application Change Management and Data Masking Strategies for DBAs Jagan Athreya Ravi Pattabhi Director of Product Mgmt Consulting Member of Tech Staff Oracle Oracle
The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle’s products remains at the sole discretion of Oracle.
Top Challenges for Enterprise IT Managers Consistent end-to-end application and 87% service performance guarantees Unplanned infrastructure changes 73% resulting in incidents and downtime Unanticipated infrastructure effects from 49% consolidation & new application projects 28% Misconfiguration of network objects 0% 50% 100% First-class application management is critical to IT and business effectiveness Source: Forrester Research, Top Five Challenges For Enterprise IT Infrastructure Managers — And How To Resolve Them, Thomas Mendel, March 2005
Oracle Vision – Managing the Business Value Stack Business Enter Notify Check Reserve Arrange Processes Order Customer Credit Stock Delivery (Examples) Mapping & Management Application Business Customer Product Inventory Order Shipping Billing Returns Cross-Layer Management Service Catalog Mgmt Fulfillment Services (Examples) Mapping & Management Application Custom & Composite Apps Oracle Packaged Apps Other Apps Software Based on Java/.Net, BPEL… Siebel, PeopleSoft, EBS… SAP, Exchange, Legacy Mapping & Management Middleware Databases Infrastructure Services Application Components Portals, AS, WS, ESB… Oracle, Other IMAP, LDAP, DNS… Mapping & Management Infrastructure Servers/OS Storage Devices Networking Devices Components Linux, Unix, Win, Virtual… NAS, SAN… Routers, Switches, VOIP…
Oracle Strategy – Top-Down Application Management LOB Business IT/Business Enterprise Managers Analysts Liaisons Architects • Discovery & mapping of application services, business services and business processes • End-user Experience Mgmt and App Diagnostics (Application Performance Management) • Business-centric Monitoring, Service Level Mgmt, Transaction Mgmt. and Reports Management of services offered to business users DB App Admin Manager Management of application Management of underlying operational lifecycle IT components (stack) System Cust. Admin Support • Testing, Provisioning, Patching • Middleware Management • Incident & Problem Management • Database Management Security Storage • Availability & Performance Mgmt • Server/OS Management Admin Admin • Change, Config & Release Mgmt • Storage Management • Access, Usage & Compliance • Network Management CAB & Network Auditors Admin Key Differentiator Integrated, end-to-end management of business services, applications and application infrastructure
Application Infrastructure Management Broad management for all application-dependent components Extended Infrastructure Management Extended Infrastructure Management Network Virtual Servers Network Virtual Servers Middleware Databases Databases Middleware • VMWare • Oracle VM • Check Point Firewall • Oracle • Oracle Operating Operating • Juniper Netscreen Firewall • IBM WebSphere • IBM DB2 • F5 BIG-IP Systems Systems • BEA WebLogic • MS SQL Server • Nortel Alteon Switch (2000 & 2005) • MS .NET • Linux (partner-built) • Sybase • MS BizTalk Server • All Unix • MS IIS • Microsoft Storage • MS Commerce Server Storage Applications Applications • MS ISA Server • MS Active Directory • JBoss AS Servers • IBM MQ Series Servers • NetApp Filer • Citrix Presentation Server • EMC Celerra, Clariion, (partner-built) Symmetrix • Oracle • Blue Lane PatchPoint • Pillar Axiom (partner-built) • Microsoft Exchange (partner-built) • Onaro SANScreen • SAP • Tomcat • Dell PowerEdge (partner-built)
Application Change Lifecycle Change Customization Package Install STAGING PRODUCTION DEV
Change is constant • Production Compliance : • How to avoid downtime due to out-of-band changes to production databases • Application Upgrades: • How to accelerate application upgrade cycles through faster upgrade and testing of application modules • Environment Synchronization: • How to keep application environments in sync to ensure consistent performance in test, development, staging & production • Custom Development: • How to improve application developer productivity by rapidly synchronizing changes in a distributed development environment.
Cost of Application Upgrades • AMR Research study on application upgrades • $1,839 per business user • 1 man-week of labor per business user • Company with 5000 business users will spend • $9.2 million • 20.7 man-years to perform an upgrade
Application Change Lifecycle Upgrade STAGING PRODUCTION DEV TEST Share Clone + Mask
Business Drivers for Data sharing Application Testing • California Database Security • Offshore or in-house application Breach Notification Act development • Sarbanes Oxley Act of 2002 • Offshore or in-house software QA • US HIPAA Act • US Graham-Leach-Bliley Data sharing Financial Services • Claims processing Modernization Act • Offline reporting • EU Data Protection Directive • Data archival and retrieval • Marketing analysis of customer data
<Insert Picture Here> Change Management
Change Management Concepts • Source • Database or Baseline from where change is captured or propagated • Target • Database to which change is to be Synchronized • Baseline • Captured snapshot of various object definitions in a database • Compare • Schemas can be compared between two sources. • Synchronize • Schemas changes can be propagated from source to target • Data Copy • Data can be propagated or preserved in source or target
Capture Application Baseline • Capture information on all schema objects for an HR OE IX application DEPT SALES EMP ORDERS PRODUCT PRICE • Tables, Views, Indexes • Procedures, Packages, Triggers • Users, init.ora • Capture scope • Database • Schema Base • Objects line Base • Version each baseline 3 Base line line 1 2
Capture Baseline Workflow HR OE IX • Figure out the list of objects in the capture scope • Use Meta Data API to EMP DEPT ORDERS SALES IXP IXQ capture XML MD representations. API • Store XML in EM repository and associate it to the captured baseline
Compare Baselines or Databases Baseline Baseline • Compare Modes • Baselines to Baselines • Baselines to Database • Database to Database • Compare Scope Prod Baseline • Schemas • Object types (Tables, Index etc) • Non Schema Objects (Users, Grants, Profiles etc) • Storage Parameters (Table Prod spaces, extent size etc) Prod
Comparison Workflow • Use existing baseline or capture a temporary baseline Aug MD API 2004 • For each object do an XML comparison to generate a XML difference document • Generate a comparison report XML Compare from XML difference document • On subsequent compares use Diff Doc last DDL time to limit comparisons to objects with changes
Synchronization • Synchronization modes Baseline Prod • Unattended Synchronize Dev Prod • Interactive Synchronize • Synchronize source can be CM Compare baseline or database Processor • Synchronize target is always a database Compare Results • Interactive Mode • Specify scope (schemas, object types to sync) Script generator • View Comparison results • Exclude objects from sync Script • Generate a script and impact report • Execute Synchronization script Execute Script
Change Manager Sync Processing DEV CM RDBMS MDAPI XML Capture Differ CM RDBMS MDAPI Capture PROD Diff Analysis Agent SQL DDL to Dependency Script recreate Analysis and or JOB Script modify System Generation
Use case 1: Production Compliance • Identify out-of-band changes to production database Normal performance • Best practice : weekly comparison report of current production against gold master baseline of production schema Loss of performance Index
Use case 2: Managing Application Upgrades Customization: Steps Invoice Check Printing Module 1. Create Baseline based on Dependencies: dependencies • PO_VENDORS table 2. Upgrade application • AP_CHECKS_PKG package & (EBusiness Suite 11.5.09 to 11.5.10) package body 3. Compare upgraded application schema with baseline 4. Identify changes 5. Upgrade customization modules accordingly
Development environments • Global teams of application developers • Developers make schema changes all the time • Changes to schema need to be promoted to all development teams rapidly
Recommend
More recommend
