DOC PREVIEW
OSU BA 471 - D B M S

This preview shows page 1-2-3-4 out of 13 pages.

Save
View full document
View full document
Premium Document
Do you want full access? Go Premium and unlock all 13 pages.
Access to all documents
Download any document
Ad free experience
View full document
Premium Document
Do you want full access? Go Premium and unlock all 13 pages.
Access to all documents
Download any document
Ad free experience
View full document
Premium Document
Do you want full access? Go Premium and unlock all 13 pages.
Access to all documents
Download any document
Ad free experience
View full document
Premium Document
Do you want full access? Go Premium and unlock all 13 pages.
Access to all documents
Download any document
Ad free experience
Premium Document
Do you want full access? Go Premium and unlock all 13 pages.
Access to all documents
Download any document
Ad free experience

Unformatted text preview:

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, 2007IntroductionIntroductionDBMS = Database Management DBMS = Database Management SystemSystemSoftware programs designed for Software programs designed for running databases… running databases… Topics:Topics:Companies/products availableCompanies/products availableIndustry-strength systemsIndustry-strength systemsPersonnel requiredPersonnel requiredAccessAccessGood design, but rarely usedGood design, but rarely usedLearning tool to discover the basics Learning tool to discover the basics of databasesof databasesUsed only in small operations Used only in small operations Not industry strengthNot industry strengthIndustry Industry DemandsDemandsThese things are needed to make a database These things are needed to make a database industry strengthindustry strengthSpeedSpeedCapacityCapacitySecuritySecurityBack-up and RecoveryBack-up and RecoveryProgramming CapabilityProgramming CapabilityCompanies need training facilities, GREAT Companies need training facilities, GREAT PersonnelPersonnelNeeds to run on multiple hardwareNeeds to run on multiple hardwareIBM DB2IBM DB2Owns 30% of market and claims to Owns 30% of market and claims to be #1be #1Bought Informix (2001)Bought Informix (2001)Self-managing computing solutionsSelf-managing computing solutionsAlliance with SAPAlliance with SAPCost = It depends…Cost = It depends…Microsoft SQLMicrosoft SQL ServerServerLess than 20% of market share but up Less than 20% of market share but up & coming& comingClaims:Claims:Faster resultsFaster resultsBetter decisionsBetter decisionsTrusted PlatformTrusted PlatformLess 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.OracleOracleHas 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 industryBetter results/Industry leading securityBetter results/Industry leading securityOnline redo logsOnline redo logsWorks on Linux, Windows, and Unix Works on Linux, Windows, and Unix serversserversMySQLMySQLOpen Source dbmsOpen Source dbmsRuns on Windows, Linux and UnixRuns on Windows, Linux and UnixMission: 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 worldAvailable and affordable for allAvailable and affordable for allEasy to useEasy to useContinuously improvedContinuously improvedFree of BugsFree of BugsFun to use and improveFun to use and improveTop Reasons to Use Top Reasons to Use MySQLMySQLScalability & FlexibilityScalability & FlexibilityHigh PerformanceHigh PerformanceHigh AvailabilityHigh AvailabilityWeb & Data Warehouse StrengthsWeb & Data Warehouse StrengthsStrong Data ProtectionStrong Data ProtectionOpen Source Freedom & 24/7 Open Source Freedom & 24/7 SupportSupportProprietary Reactions to Proprietary Reactions to MySQLMySQLMySQL is open source MySQL is open source  mostly mostly free of chargefree of chargeThreatens 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 dbmsPersonnelPersonnelDB 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 shouldIf they are certified they make 6 If they are certified they make 6 figure salariesfigure salariesIndustry-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

OSU BA 471 - D B M S

Documents in this Course
D B M S

D B M S

13 pages

RFID

RFID

12 pages

XML

XML

8 pages

W3C- Web

W3C- Web

23 pages

Linux

Linux

21 pages

Telecoms

Telecoms

11 pages

Linux

Linux

11 pages

Load more
Download D B M S
Our administrator received your request to download this document. We will send you the file to your email shortly.
Loading Unlocking...
Login

Join to view D B M S and access 3M+ class-specific study document.

or
We will never post anything without your permission.
Don't have an account?
Sign Up

Join to view D B M S 2 2 and access 3M+ class-specific study document.

or

By creating an account you agree to our Privacy Policy and Terms Of Use

Already a member?