1 / 13

Understanding Database Management Systems (DBMS) in Today's Industry

Explore the world of Database Management Systems (DBMS) - essential software for running databases in modern organizations. Learn about key industry players, system requirements, and personnel needs. Discover the functionalities and strengths of popular systems like IBM DB2, Microsoft SQL Server, Oracle, and MySQL, as well as the roles and responsibilities of certified DB administrators. Gain insights into the industry demands for speed, capacity, security, and more.

shelby-pearson
Télécharger la présentation

Understanding Database Management Systems (DBMS) in Today's Industry

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. D B M S Andy Cannon Hannah Eggert Aharon LaGrander May 2nd, 2007

  2. Introduction • DBMS = Database Management System • Software programs designed for running databases… • Topics: • Companies/products available • Industry-strength systems • Personnel required

  3. Access Good design, but rarely used Learning tool to discover the basics of databases Used only in small operations Not industry strength

  4. Industry Demands • These things are needed to make a database industry strength • Speed • Capacity • Security • Back-up and Recovery • Programming Capability • Companies need training facilities, GREAT Personnel • Needs to run on multiple hardware

  5. IBM DB2 Owns 30% of market and claims to be #1 Bought Informix (2001) Self-managing computing solutions Alliance with SAP Cost = It depends…

  6. Microsoft SQLServer • Less than 20% of market share but up & coming • Claims: • Faster results • Better decisions • Trusted Platform • Less expensive than Oracle and IBM--Price

  7. SQL 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.

  8. Oracle Has 30% of market share (targets mid-range market) Claims to be #1 in Database industry Better results/Industry leading security Online redo logs Works on Linux, Windows, and Unix servers

  9. MySQL • Open Source dbms • Runs on Windows, Linux and Unix • Mission: to make superior data management available and affordable for all. • Values—MySQL strives to be: • The best and most used database in the world • Available and affordable for all • Easy to use • Continuously improved • Free of Bugs • Fun to use and improve

  10. Top Reasons to Use MySQL • Scalability & Flexibility • High Performance • High Availability • Web & Data Warehouse Strengths • Strong Data Protection • Open Source Freedom & 24/7 Support

  11. Proprietary Reactions to MySQL • MySQL is open source  mostly free of charge • Threatens proprietary vendors. • Oracle & Microsoft make available free and low cost light-weight versions of their dbms

  12. Personnel DB Administrators store, organize, manage data, as well as ensure that systems perform as they should If they are certified they make 6 figure salaries Industry-strength dbms are complex tools; they need trained people to run and manage them.

More Related