1 / 23

AGILE DATA ARCHITECTURE

AGILE DATA ARCHITECTURE . Agile Data Architecture. Fit-for-purpose solution Enables self-service data management . Software Virtual Appliance: Flexibility, Simplicity. Deploys in minutes For any team in any location Installs on private, public clouds. Any HW. Any Storage. Cloud Ready.

amity
Download Presentation

AGILE DATA ARCHITECTURE

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. AGILE DATA ARCHITECTURE

  2. Agile Data Architecture • Fit-for-purpose solution • Enables self-service data management

  3. Software Virtual Appliance: Flexibility, Simplicity • Deploys in minutes • For any team in any location • Installs on private, public clouds Any HW Any Storage Cloud Ready Project team A DR Site Primary Data Center Remote DC Project team B Remote DC • 3 Continents, 22 Application Teams

  4. Data Virtualization: Performance, Consolidation

  5. BLOCK MAPPING COMPRESSION FILTERING 90%+ Common, Repeated Data Oracle EBS Production Dev: R12 Data Mapping QA: R12 Data Mapping Dev: Customization Testing QA: Customization Testing 1 TB 1 TB 1 TB 1 TB 1 TB • Unique block mapping • Block aware filtering • Efficient compression .5 TB 90% reduction in EBS storage costs

  6. CACHING Built for VDB Performance: 20 VDBs on Average 5 sources and 35 virtual databases consolidated per Delphix server • Global “hot” read cache • Global write log • SSD flash cache • On-the-fly compression, de-compression

  7. Data Orchestration: Right Data, Time, Place

  8. SYNC Auto Sync for 10+ Heterogeneous Sources on Windows Hitachi storage Cluster on Windows IBM storage RAC on Solaris NetAppstorage on RHEL NetAppstorage on HP-UX EMC storage EXADATA Appliance Any HW Any Storage on AIX EMC storage on AIX NetAppstorage Cloud Ready Remote Remote 10+ sources synchronize with one Delphix virtual appliance

  9. SYNC Near Real Time Log Shipping Local 12:36:38 12:36:41 12:36:38 • Maintain sync within seconds of last transactions • Ensure access to fresh data • Enable use of VDBs for HA Remote 12:36:38 Intra-daily refreshes of virtual copies tied to trading systems

  10. SYNC Sync (Reduced Load) 1x Process I/O 1x Transfer I/O 1x Read I/O 1x Write I/O 1xRead I/O 1x Dump I/O 5% Process I/O 5% Network Transfer Load 5% Read I/O 5% Write I/O 90% load reduction with automated DB aware, change data only sync

  11. RECORD 50:1 TimeFlow (Store 50 Days in the Space of 1) TimeFlow 1 month retention, logs for 1 week 2 week retention, logs for 1 week 90 day full retentionof logs and snapshots • Store 50 days in the space of 1 • Superior SLAs (RPO and RTO) • Reduce impact on systems, networks Quarter ending snapshots retained for 1 year Instant recovery protects against $3000 per minute ERP downtime costs

  12. PLAY Refresh, Rollback on HP-UX EMC storage Jul 25, 6:42:18 Rollback / Recover Aug 1, 3:36:51 Provision Current Time Refresh • On-demand access to source data • Superior data management SLA’s • Higher application quality Weekly scheduled refreshes, daily rollback for patch and upgrade test environments

  13. PLAY Data Integration Integrated Rollback Integrated Refresh Aug 1, 11:50:33 Aug 5, 7:28:29 Aug 6, 3:17:51 Integrated Provisioning • Decouple reliance on multiple production teams • Synchronize data delivery across sources • Maximize test time and improve data quality 6 sources integrated for MDM initiative (50% acceleration)

  14. MOVE Promote, Demote, V2P QA Dev Test V2P V2P Prod UAT • Create VDBs from VDBs • V2P to restore data to physical • V2P to automate UAT refresh

  15. MOVE Consolidate, Load Balance X X Test 1 Test 2 Test 3 30% consolidation (license reduction)of Oracle workloads

  16. REPLICATE High Availability, DR, Backup for Delphix X Local or Remote Delphix as primary backup and DR solution (20+ apps)

  17. REPLICATE Active-Active Multicast Production Source • Scale out to large numbers of VDBs • Enable VDB development at remote sites DR Site 100+ VDBs for risk application

  18. Self Service Enterprise Management • 1500 developers using VDBs for ERP projects

  19. Next Steps • Identify candidate applications and projects for data virtualization • Complete ROI workshop with Delphix Business Solutions team • For initial target applications and full environment • Access to project team and plan needed for project impact analysis • Delphix trial options • Cloud based • Single Delphix virtual appliance scope • Standard onsite POC • Multiple Delphix virtual appliance scope • Guaranteed deployment • Production grade deployment, 90 day guarantee • Application Assessment Service • Production grade deployment, services led adoption • POTENTIAL OPPORTUNITIES • ERP rollouts or projects • Agile development • Application DB upgrades • Platform / DC migrations • Data warehousing / MDM • Exadata rollout • Private cloud build-out • Secure test data

  20. Thank You

  21. Performance Optimization Measures w.o. Delphix w. Delphix I/O processing time Provisioning and refreshes – actual labor Provisioning and refreshes - scheduling and process overhead Virtualization overhead offset by: Overall labor and process gains Global “Hot” Read Cache On-the-fly Compression, De-compression

  22. Connectivity Protocols Source Server Target Servers SSH JDBC SSH JDBC NFS SSH HTTP FC, iSCSI Compressed Data

  23. System Requirements Delphix Server • Virtualization Platform: VMware (ESX Server 3.x, vSphere 4.x, vSphere 5.x) • VM Guest Container Profile: Solaris 10 64-bit • Virtual CPUs: 8 vCPUs • Memory: 16 GB (minimum), add more if indicated Source and Target Servers • Oracle 9.2.0.8, Oracle 10g R2, Oracle 11g R1, or Oracle 11g R2 • Solaris, RedHat, OEL, SUSE, AIX, HPUX

More Related