The Database MarketMajor PlayersOracle – IBM – MicrosoftIndustry StrengthsIndustry Strengths: ScalabilityIndustry Strengths: SpeedIndustry Strengths: Backup & RecoveryIndustry Strengths: SecurityWhat’s Wrong with Access?Open Source DB SystemsTrendsMySQL and SAPQuestions?SourcesThe Database Market The Database MarketPresented to the class of BA 471May, 2006Dr. Rene ReitsmaAmy Miller ● Elaina Reinhard ● Shannon WegnerAmy Miller ● Elaina Reinhard ● Shannon WegnerMajor PlayersMajor PlayersOracle41.3%IBM30.6%Microsoft13.4%Database Market Share Source: IDC 2004Oracle – IBM – MicrosoftOracle – IBM – Microsoft•Oracle–Among the worlds largest enterprise software companies–Oracle Database 10g Release 2•IBM–Well diversified product portfolio–DB2•Microsoft–Microsoft SQL Server–Competes on PriceIndustry StrengthsIndustry Strengths•What makes a DB industry strong?–Scalability–Speed–Backup & Recovery–SecurityIndustry Strengths: Scalability Industry Strengths: Scalability •Ability to process and handle large volumes of transactions•Is it scalable?–Scale up or scale out •Consider performance, number of users, location of usersIndustry Strengths: SpeedIndustry Strengths: Speed•High number of transactions per unit of time–Product or server itself–DB design quality–Drive speed–Query OptimizerIndustry Strengths: Backup & RecoveryIndustry Strengths: Backup & Recovery•Challenges–Cold vs. Hot Backup •24 hours per day•DB Administrators–Why are they needed?–OutsourcingIndustry Strengths: SecurityIndustry Strengths: Security•An obvious concern•Security features:–Authentication–AuthorizationWhat’s Wrong with Access?What’s Wrong with Access?•‘Not scalable’•Slow•Inferior security•However:–Likely to be available and supported for years to come–Most widely used desktop database system globallyOpen Source DB SystemsOpen Source DB Systems•Postgre SQL (standard query language)•My SQL–Used by travel agencies, manufacturing agencies, Google, SAP, etc.–Many traditional database systems are becoming, or are already available on open source OS (e.g. Oracle, DB2, Sybase IQ)TrendsTrends•Why is there a trend toward open source systems?–Expired patents–Cost savings•Why are some businesses sticking with IBM, Oracle, and Microsoft–Brand equity–High switching costsMySQL and SAPMySQL and SAP•What is SAP?•SAP + MySQL = MAX DB–Benefits for MySQL–Implementations to MySQL 5.1Questions?Questions?SourcesSources•http://www.sql-server-performance.com/dk_massive_scalability.asp
View Full Document