Transcription
IBM Systems for Oracle Data WarehousingIncrease Performance and Flexibility of your Oracle DatabaseWarehouse with IBM SystemsRick A. KearnsSolutions ConsultantOracle on IBM Systems 2008 IBM CorporationMarty CarangeloManager IOCCAdvanced Technical SupportIBM Systems
Agenda Data Warehouse Requirement for IT Infrastructure IBM System p Solutions for Data Warehousing IBM System x Solutions for Data Warehousing IBM Optimized Warehouse Offerings 2008 IBM Corporation
IT Challenges Shared by IBM and Oracle CustomersIT flexible andresponsiveto businesschangesIT becomes abusiness enablerIT represents good value for money 2008 IBM Corporation
Oracle and IBMThe Technology Relationshipwww.Oracle.com/IBMDid You Know? Oracle and IBM have worked togetherfor over 30 years and collaboratedaily on development, marketingand sales activities. Long History working together Oracle: 20 years, PeopleSoft:17 years JD Edwards: 28 years Siebel: 9 years IBMmaintainsa teamof engineers20,000 joint applicationcustomersonsite at Oracle as well asof serversandhundreds hundredsOracle is #1 databasefor UNIXservers ofOracleis #1 databasefor Linux serversTerabytesof storagefor developmentStrong affinity forandOracleonIBMSystemssupport. IBM System p is #1 UNIX server for 11 IBMSystemsquartershold benchmarkconsecutiveleadershipfor all serverOracle IBM Systempositionsx is #1 x86 high-end(8-socket and above)applications including EBS,Peoplesoft, JDE and racle-ibm-relationship.pdf 2008 IBM CorporationOracle products “are all supported on AIX and aredeveloped concurrently with Oracle’s basedevelopment environment. Additionally, Oracledevelopment uses System p for stress testing ofcurrent and future releases of Oracle RealApplication Clusters (RAC)”
BI - DW Reference ArchitectureThird Party Tools (Cognos, Business Objects, SAS lysisMicrosoftOfficePlug-InOracle BI ServerOracle 10g DBMSETLOracle Automated Storage ManagementIBM AIX / Linux on Power / Linux or Windows on x86IBM System p / System xIBM TotalStorage DS3000 / DS4000 / DS8000 2008 IBM CorporationSystems Management & BackupTivoliCluster ManagementOracle Real Application ClusterOracle BI Enterprise Edition
rmsUnstructuredLoad / tionalData StoresCollaborationDataWarehousesQuery &ReportingData MiningDataMartsModelingTransport lyticsAccessBusiness BusinessObjectsIBM 2008 IBM CorporationOracleOracleSiebel AnalyticsHyperion / SASBusiness WebServices
Product to Node DesignInformaticaSASBusinessObjectsOracleSASSiebel AnalyticsHyperionBusiness 4000/8000System p/xETL BlockSystem p/xDW BlockSystem p/xApplicationBlock 2008 IBM Corporation
Typical Data 000DS4000/8000System pSystem xSystem pSystem xSANSystem pSystem xSystem pSystem xInterconnectSystem pSystem xSystem pSystem xSystem pSystem xSystem pSystem DW 2008 IBM Corporation
Agenda Data Warehouse Requirement for IT Infrastructure IBM System p Solutions for Data Warehousing IBM System x Solutions for Data Warehousing IBM Optimized Warehouse Offerings 2008 IBM Corporation
IBM leads the worldwide UNIX Server MarketIBM was the fastest growing UNIX vendor in 2007,growing 9 percent year-to-year and capturing 34.1%revenue share for Q407 according to Gartner.POWER6IDC Tracker 2008 IBM Corporation
IBM Power Product Linep595High-endp575LinuxMidrangePower 6p570p5-590Power 5p5-595p5-575p5-570 p5-520p5-520Qp5-510p5-510Qp520p5-505p5-505Q 2008 IBM CorporationEntryRackOracle Certifies for the O/S. Oncecertified all Power serversrunning the O/S are certified.
System p Technology Value To Oracle Customers More Performance per Core and per System Results in smaller hardware configurations that deliver the same performance –hardware and facility cost savingsSaves on software costs when software is licensed by the core Virtualization Technology Allows one physical server to run multiple logical/virtual serversAllows customer to chose when and how to use vertical and horizontal scalingWithout IBM Virtualization, the only choices were horizontal scaling or buying largesystems that were under utilized in order to allow growth or to absorb capacityspikes Increased Utilization Do more work with fewer processorsBetter return on investmentSaves on hardware and software costs Roadmap We own our entire chip and system roadmap, development, and productionOur chips and systems are designed synergistically – development of each isdone with the needs and requirements of the other taken into considerationWe deliver a vertically integrated solution that provides industry leading businessvalue to our customers. 2008 IBM Corporation
Agenda Data Warehouse Requirement for IT Infrastructure IBM System p Solutions for Data Warehousing IBM System x Solutions for Data Warehousing IBM Optimized Warehouse Offerings 2008 IBM Corporation
4 Socket System x Rack Servers for 2008x3755x3850 M2x3950 M2Cost Optimized,Entry/Mid-TierApplications and DBCompact Mid-tierApplications & Small DBScalable Database,Server Consolidation &Mission Critical Apps4U, 4 Socket4U, 4 Socket4U, 4 SocketSample ApplicationsSample ApplicationsSample Applications ERP CRM Small or RAC Database Graphics Rendering 2008 IBM Corporation ERP Application Logic CRM RAC Database SCON Collaboration Large SMP Database 2-Tier ERP CRM SCON
X3 Chipset evolves to the new Procx64Procx64Proc1066 MT/s667 MT/s2.5 GT/sIB: 2 x122.5 GT/sIB: 2 x12SP: 3 x85.2 GT/sSP: 3 x83.2 GT/sSouth Bridge 4x4x4x4x4x4x4SMIIISMIIISMIIISMIIIDDR2/3 MemoryDIMMS533 MT/sScalable Virtual L4 cache333 MT/s 2008 IBM Corporation
x3950 M2 Provides Unique Flexibility.TODAYTOMORROW*with RACx3950 M2Four Chassis 16-procUp to 1TB Memory.in a move to RAC.* Requires 3 additional operating system licenses and the purchase of Real Application Clusters (RAC) licenses from Oracle. 2008 IBM Corporation
Agenda Data Warehouse Requirement for IT Infrastructure IBM System p Solutions for Data Warehousing IBM System x Solutions for Data Warehousing IBM Optimized Warehouse Offerings 2008 IBM Corporation
IBM Technical Sales Support, Americas.OracleIBMIBMStorage ServersIBM Oracle InternationalCompetency CenterA presentation for the New York City Metro Oracle Users GroupMarty CarangeloManager IBM InternationalOracle Competency Centercmarty@us.ibm.com 2003 IBM Corporation
IBM Oracle International Competency CenterMission: IBM maintains on-site presence to further strategic planning, development,enablement, marketing and sales support activities with the ISV. Provide technical presales solution support for Oracle applications and technology with IBM platformsincluding: PeopleSoft, JD Edwards, Siebel, EBS, and others. provide worldwide solution technical mkt info & sizing meth to differentiate IBM/ISV solutions provide a visible on-site presence to the ISV, customers & prospects to provide technical deliverables for IBM/ISV go to market plans to help drive IBM/ISV revenue develop & deliver ISV specific technical sales education for IBM partners & IBM community provide 3rd level technical sales support to IBM personnel on IBM/ISV related questions On-Site Resources IBM Hardware andSoftware Brand Experts Technology Managers Solutions Sales Project Managers Labs Sizing Tools Creation and ownership ofworldwide sizing tools andprocessesSupport the Techline resources Technical Sales Support IBM Technical Sales Business Partners On-site briefings Located at Oracle and IBM Third level support when Benchmarking/Sizing testsnecessary Redbooks and WhitepapersIBM Oracle AllianceJune 2007 2007 IBM Corporation
IBM Technical Sales Support, AmericasHow to size Oracle Applications with IBM hardwareStep 1 - Download the SizingQuestionnaire from the Webwww.ibm.com/erp/sizingRefine if necessaryStep 3 - E-mail completedQuestionnaire to the IBM SizingCenterStep 2 – Certified Business Partners and IBMSpecialists assist in completingStep 4 – Sizing estimate isreturned from Sizing CenterDirect Questions of how to obtain IBM Hardware Sizing information for Oracle Applications to800-426-0222 or 888-426-5525 option 6 Or ibmoracl@us.ibm.com 2003 IBM Corporation
IBM Technical Sales Support, AmericasWhat is a Sizing? (Accuracy vs Precision)A sizing is an estimation that includes a workload from a provider other than IBM. IBM is not responsiblefor the accuracy of the data contained in such a workload. Any reliance by you on the third party workloadis at your sole risk and will not create any liability or obligation for IBM. If you have any questions or areunsatisfied with the third party workload information, you should contact the third party provider.The system resources quoted to you in any sizing related communications are sufficient only for theworkload(s) estimated. Other factors may require additional resources (e.g. additional non-estimatedworkloads, minimum configurations for RAID, allowance for growth, workspace, etc).The information provided to you in any sizing related communications are provided by InternationalBusiness Machines Corporation (IBM) as a service to you and may be used for informational purposesonly.Use of any sizing related communications is restricted to the purpose of helping you predict a possible IBMeServer model processor, memory and disk resources for a given workload. All representations ofprocessor utilization, throughput, response time, memory, disk, and other performance data in the sizingcommunications are estimates and averages based on certain assumptions and conditions. Norepresentation is made that these throughputs and their corresponding response times or otherperformance data will be accurate or achieved in any given IBM eServer installation environment. They arebased on specific configurations and run time environments. Customer results will vary. Any configurationrecommended by the sizing information communicated should be tested and verified.By accepting this information or using the sizing details you agree to the terms and conditions containedherein. If you do not agree with such terms and conditions, please do not review or use the providedmaterials and return the materials to IBM. 2003 IBM Corporation
IBM Technical Sales Support, AmericasPositioning of Pre-Sales curacy 2003 IBM Corporation
IBM Technical Sales Support, AmericasImportant considerations when Sizing Non-OLTP Databases 2003 IBM Corporation
IBM Technical Sales Support, AmericasImportant considerations when Sizing Non-OLTP Databases 2003 IBM Corporation
IBM Technical Sales Support, AmericasImportant considerations when Sizing Non-OLTP Databases 2003 IBM Corporation
IBM Technical Sales Support, AmericasImportant considerations when Sizing Non-OLTP Databases 2003 IBM Corporation
IBM Technical Sales Support, AmericasImportant considerations when Sizing Non-OLTP Databases 2003 IBM Corporation
IBM Technical Sales Support, AmericasReasons for Sizing Inaccuracies – (Marty’s Fab 5) Reporting / General Batch Processing Ad-Hoc Nature of Non-OLTP Workloads Queries, as in ad hoc queries, are especially difficult to size. The ultimate question is how do you sizesomething (Ad-hoc) defined as a process defined for specific or immediate purpose often improvised orimpromptu. Just the fact that you don’t know what will be asked, how often and what will be looked formakes this a difficult, no-win, scenario.Data Loads, Data Transformations, Aggregations. It is up to the users which batch jobs they submit, when they submit them and how many of all kindsthey run. It is very difficult for the customer or IBM, to predict these usage patterns. Non-OLTP usuallyhas a smaller number of users but the queries they generate are much more resource intensive. Theyaccess larger amounts of data and perform intensive function against this data.These types of processes are needed but all Non-OLTP systems but they largely depend on how manyof each you want to run, how much data each of them is processing, and how often you are going torun them. Interfaces are another type of process within this group of job however interfaces may bringdata into the system, as well as taking data out of the system.Security. Security setup and how many cycles it takes to authenticate can cause major performance implicationsfor the end user community. In my example a simple company birthdays report without department levelsecurity takes 30 seconds to complete for an average sized company. With security added to only allowthe submitter to see their departments and no others the time to run took 35 minutes. 2003 IBM Corporation
IBM Technical Sales Support, AmericasReasons for Sizing Inaccuracies – (Marty’s Fab 5) Customizations. Not just ad hoc queries fall into this category. Also queries submitted from query generation tools and fromdevelopers and designers. Good coders are hard to find and is usually not written with performance inmind the first time it is developed. This code can be written poorly in many formats, like SQL, java, HTML,C and all the others. Application Characterization - i.e. Budgeting. Purge Archive Frequency. An application that often is not in the Non-OLTP category that is bundled in as part of the non-oltp systembecause you have process the width of data in the non-oltp database. Very heavy at the app and web andalso heavy on the Intel side.Most customers only add data to their databases and never consider archiving older data or even purgingthe data. In a Non-OLTP implementation this is also something to consider. A customer who has 10 yearsof history data in tables and never queries more than 3 to 5 years is going to be paying a huge penalty forhaving to process the additional 7 to 10 years of data for their jobs. This is a huge factor in the overallperformance and sizing of the system.Database Maintenance tasks. These are tasks such as Backups, re-organizations, storage updates, and index creations. There can betimes when this maintenance has to be completed and can cause issues with the day to day operations ofthe system. 2003 IBM Corporation
IBM Technical Sales Support, AmericasLearning Points Sizing Recommendation – Is it Gospel? Accuracy vs. Precision Direction is a closed-loop process Recommended solution can handle defined workload– If your workload in reality is different may not be able to handle Changes in the ISV Application will impact solution Changes in technology will impact solution Setting the correct expectations is key! Testing is the KEY ! ! !– If you want accuracy, then test YOUR exact workload, volumesand configurations. It’s the only way. 2003 IBM Corporation
Oracle Optimized Warehouse InitiativeSMP Scale Up Capacity per SystemCustomer Data (Raw) Data SizeIBM Systems Reference Configurations SummaryReference ConfigurationsIBM System pServerStorageIBM System xp570x3850 M2x3755(Power6)(Intel x86)(AMD x86 )DS4800DS3400DS3400Optimized WarehouseReal Application Cluster Scale OutCustomer Data (Raw) Size 2008 IBM Corporation
IBM Systems Architecture for Oracle Optimized WarehouseSystem p 570 and System Storage DS4800Single rackbuilding blockRack sScale out buildingblocks: 5TB to 20 TB20TB15TB10TB1TB5TBDS4800ControllerSANSwitchp570 server4-core, 4.7GHzPOWER6HMC additional 2008 IBM CorporationOracle Components Oracle Database 10g EE Oracle RAC Oracle Partitioning
DS4800 Benefits for Data Warehousing Scalability to keep pace with warehouse data growthƒ To 67 TB FC, 168 TB SATA per DS4800 Performanceƒ Up to 575,000 IOPS burst from cache and1500 MB/sec sequential throughput from diskƒ 4Gbps Fibre Channel technology end-to-end from host server to disk for fastest access to data Data Protection and Continuous Availabilityƒ High availability architecture with redundant, hot-swap componentsƒ Multiple RAID levelsƒ Remote Support Manager for “call home” supportƒ FlashCopy , Volume Copy and Enhanced Remote Mirror Ease of Management, Ease of Useƒ SAN-ready, centralized storage simplifies managementƒ “Anytime Administration” and “Recovery guru” Low Total Cost of Ownershipƒ Investment protection throughout DS4000 Familyƒ 3-year Warranty*ƒ Open, non-proprietary solution 2008 IBM Corporation
IBM Systems Architecture for Oracle Optimized WarehouseSystem x3755 (or x3850M2) and System Storage DS3400Single rackbuilding blockRack rsDS3400ControllerScale out buildingblocks: 3TB to 12 r(8-core)HMC additional 2008 IBM CorporationOracle Components Oracle Database 10g EE Oracle RAC Oracle Partitioning
IBM System Storage DS3400 Overview Direct attach or SAN solutionExternal storage solution for System x & BladeCentersTwo auto-negotiating 4-Gbps host ports per controllerSuited for building new SANs or extending existing 1Gbps or 2-Gbps SANs 2U, 19” enclosure with 3.5” SAS drives Expandable up to 3 EXP3000s for a total of 48 drives 14.4TB max capacity 300GB SAS Managed by DS3000 Storage Manager 2008 IBM Corporation
Oracle Optimized DW Competitive ComparisonsIBM System x - Optimized Warehouse1/3TB9TB6TB12TBIBM System p - Optimized Warehouse10TB1/3/5TB15TBHP - Optimized Warehouse1-4TBDELL / EMC - Optimized Warehouse1TB2TB3TB4TBSUN - Optimized Warehouse10TB 2008 IBM Corporation20TB
IBM System p and System x & IBM System Storage the right systems for data warehousingLower your warehouseTCO by reducing:Increase the operationalefficiency of the warehouse through:9Maintenance costs9 Improvement of resource utilization9Software licensing costs9 Ability to quickly add new servicesto grow the warehouse on demand9Electrical and cooling costs9Downtime costs throughoutyour enterprise 2008 IBM Corporation9 Delivery of high levels of availability,response time and security to meetbusiness productivity requirements
Thank you. 2008 IBM Corporation
Notes to PresenterREQUIRED CHARTSThe presenter must display the Special Notices chart, the Notes onBenchmarks and Values charts (if the referenced values are given), and theNotes on Performance Estimates chart (if the referenced performanceestimates are given) during the course of the presentation. Any printed copiesof this presentation that are distributed must include legible copies of thesecharts. If printed copies are not distributed, the attendees must be offeredthe option to receive legible printed copies of these charts.TRADEMARKSPlease review the Special Notices page prior to updating this presentation toensure all trademarks used are given proper attribution.SPEAKER NOTESThis presentation may contain speaker notes available imbedded or as aseparate file. Please ensure these are utilized if available.Revised January 9, 2003 2008 IBM Corporation
Special NoticesThis document was developed for IBM offerings in the United States as of the date of publication. IBM may not make these offerings available inother countries, and the information is subject to change without notice. Consult your local IBM business contact for information on
Cognos Microstrategy Oracle Informatica SAS Business Objects IBM Data Repositories Data Integration Metadata Staging Areas Data Marts Data Warehouses Operational Data Stores Information Integrity Transport / Messaging Load / Apply Transforms Extraction Synchronize Em
