140 likes | 307 Views
The Database Market. Amy Miller ● Elaina Reinhard ● Shannon Wegner. Presented to the class of BA 471. May, 2006. Dr. Rene Reitsma. Major Players. Microsoft 13.4%. Oracle 41.3%. IBM 30.6%. Database Market Share Source: IDC 2004. Oracle – IBM – Microsoft. Oracle
E N D
TheDatabase Market Amy Miller ● Elaina Reinhard ● Shannon Wegner Presented to the class of BA 471 May, 2006 Dr. Rene Reitsma
Major Players Microsoft 13.4% Oracle 41.3% IBM 30.6% Database Market Share Source: IDC 2004
Oracle – 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 Price
Industry Strengths • What makes a DB industry strong? • Scalability • Speed • Backup & Recovery • Security
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 users
Industry Strengths: Speed • High number of transactions per unit of time • Product or server itself • DB design quality • Drive speed • Query Optimizer
Industry Strengths: Backup & Recovery • Challenges • Cold vs. Hot Backup • 24 hours per day • DB Administrators • Why are they needed? • Outsourcing
Industry Strengths: Security • An obvious concern • Security features: • Authentication • Authorization
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 globally
Open Source DB Systems • PostgreSQL (standard query language) • MySQL • 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)
Trends • 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 costs
MySQL and SAP • What is SAP? • SAP + MySQL = MAX DB • Benefits for MySQL • Implementations to MySQL 5.1
Sources • http://www.sql-server-performance.com/dk_massive_scalability.asp • http://support.microsoft.com • http://www.oracle.com/database/index.html • http://www.eweek.com/article2/0,1895,1773515,00.asp • http://www.oracle.com/corporate/index.html • http://www.oracle.com/corporate/press/2005_mar/database_leader_idc.html • http://www.governmentsecurity.org/articles/Thedatabasesecurityblanket.php • http://www.theparticle.com/cs/bc/dbsys/speed.pdf • http://www.oreillynet.com/cs/user/view/wlg/4715#mysql_sap • http://help.sap.com/saphelp_erp2005/helpdata/en/indes_srmaddon.htm • http://www.idc.com/getdoc.jsp?containerId=prUS00089505 • http://www.bls.gov/oco/ocos042.htm#outlook • http://www.blueclaw-db.com/microsoft_access.htm • http://searchoracle.techtarget.com/originalContent/0,289142,sid41_gci938717,00.html