D B M SIntroductionAccessIndustry DemandsIBM DB2Microsoft SQL ServerSlide 7OracleMySQLTop Reasons to Use MySQLProprietary Reactions to MySQLPersonnelSlide 13D B M SD B M SAndy CannonAndy CannonHannah EggertHannah EggertAharon LaGranderAharon LaGranderMay 2May 2ndnd, 2007, 2007IntroductionIntroductionDBMS = Database Management DBMS = Database Management SystemSystemSoftware programs designed for Software programs designed for running databases… running databases… Topics:Topics:Companies/products availableCompanies/products availableIndustry-strength systemsIndustry-strength systemsPersonnel requiredPersonnel requiredAccessAccessGood design, but rarely usedGood design, but rarely usedLearning tool to discover the basics Learning tool to discover the basics of databasesof databasesUsed only in small operations Used only in small operations Not industry strengthNot industry strengthIndustry Industry DemandsDemandsThese things are needed to make a database These things are needed to make a database industry strengthindustry strengthSpeedSpeedCapacityCapacitySecuritySecurityBack-up and RecoveryBack-up and RecoveryProgramming CapabilityProgramming CapabilityCompanies need training facilities, GREAT Companies need training facilities, GREAT PersonnelPersonnelNeeds to run on multiple hardwareNeeds to run on multiple hardwareIBM DB2IBM DB2Owns 30% of market and claims to Owns 30% of market and claims to be #1be #1Bought Informix (2001)Bought Informix (2001)Self-managing computing solutionsSelf-managing computing solutionsAlliance with SAPAlliance with SAPCost = It depends…Cost = It depends…Microsoft SQLMicrosoft SQL ServerServerLess than 20% of market share but up Less than 20% of market share but up & coming& comingClaims:Claims:Faster resultsFaster resultsBetter decisionsBetter decisionsTrusted PlatformTrusted PlatformLess expensive than Less expensive than Oracle and IBM--PriceOracle and IBM--Price*Retail Pricing **Example PricingExpress EditionFREE FREECompact EditionFREE FREEWorkgroup Edition$3,899 $3,700Standard Edition$5,999 $5,737Enterprise Edition$24,999 $23,911SQL Server 2005 Pricing Comparison: Retail versus Example Pricing *All prices reflect pricing for purchases within the United States and are in U.S. dollars. The prices listed are estimated retail prices; reseller pricing may vary.** This is representative pricing for a company purchasing a small number of Processor or Server licenses through Microsoft Volume Licensing.OracleOracleHas 30% of market share (targets mid-Has 30% of market share (targets mid-range market)range market)Claims to be #1 in Database industryClaims to be #1 in Database industryBetter results/Industry leading securityBetter results/Industry leading securityOnline redo logsOnline redo logsWorks on Linux, Windows, and Unix Works on Linux, Windows, and Unix serversserversMySQLMySQLOpen Source dbmsOpen Source dbmsRuns on Windows, Linux and UnixRuns on Windows, Linux and UnixMission: to make superior data management Mission: to make superior data management available and affordable for all.available and affordable for all.Values—MySQL strives to be:Values—MySQL strives to be:The best and most used database in the worldThe best and most used database in the worldAvailable and affordable for allAvailable and affordable for allEasy to useEasy to useContinuously improvedContinuously improvedFree of BugsFree of BugsFun to use and improveFun to use and improveTop Reasons to Use Top Reasons to Use MySQLMySQLScalability & FlexibilityScalability & FlexibilityHigh PerformanceHigh PerformanceHigh AvailabilityHigh AvailabilityWeb & Data Warehouse StrengthsWeb & Data Warehouse StrengthsStrong Data ProtectionStrong Data ProtectionOpen Source Freedom & 24/7 Open Source Freedom & 24/7 SupportSupportProprietary Reactions to Proprietary Reactions to MySQLMySQLMySQL is open source MySQL is open source mostly mostly free of chargefree of chargeThreatens proprietary vendors.Threatens proprietary vendors.Oracle & Microsoft make Oracle & Microsoft make available free and low cost light-available free and low cost light-weight versions of their dbmsweight versions of their dbmsPersonnelPersonnelDB Administrators store, organize, DB Administrators store, organize, manage data, as well as ensure that manage data, as well as ensure that systems perform as they shouldsystems perform as they shouldIf they are certified they make 6 If they are certified they make 6 figure salariesfigure salariesIndustry-strength dbms are complex Industry-strength dbms are complex tools; they need trained people to tools; they need trained people to run and manage them.run and manage
View Full Document