Transcript Mindset for Performance Operating Models

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
IBM
41.3%
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
• 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)
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
Questions?
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