ISM 50 - Business Information SystemsLecture 15Instructors: Mary Doyle, Geoff RyderUC Santa CruzMay 20, 2009Class announcementsReading for next Wednesday (May 27):Messerschmitt Chapter 8 p. 233-258 (reading instead of Ch 10)Reading for Monday (June 1)Akamai CaseStudent Presentations Wednesday (May 27)Any one looking for extra credit? You can make a presentation about your paper or a news story for X points….Student presentation for June 1Tracie KemmerleToday’s Class Student presentationsAlma Y. Montes John Kuan• Wrap up mySQL• Oracle/Sun discussion• Protocols and Algorithms• NetworksmySQLHow does OSS work?Two Types of License: GPL (General Public License)FreeNo SupportAny software that uses MySQL as a module must itself be made GPL Commercial LicenseSupportCould be distributed with non-open source software Not Free: MySQL: Classic $250, Pro $495 (for ~ 50 users)Compare to:MSFT $3150 single proc for 50 usersIBM $33000 single proc for 50 usersOracle $40000 single proc for 50 usersAside: DB’s in different software stacksOperating SystemMiddlewareApplicationMS Windows or other OSOracleor MySQL, IBM, etcSAPOr Oracle, Axtapa, etc.ERPSoftwareStackLinux or other OSMySQLor other DBApache Web ServerWebApplicationSoftwareStackProprietary Business LogicBankingSoftwareStackIBM z/OSor other OSGeneralSoftwareStackOracleor other DB ProprietaryBanking App.Which companies are competitors?Which are complimenters?Which are both!?mySQL Which segments of market is mySQLstrong in?Large Companies or Small Companies?Web applications or Critical Enterprise data? Why would a major enterprise want to pay so much more for an Oracle or IBM DB?My SQL: marketSmall 20% Medium 30% Large 50%Enterprise wide data90%Web Sites10%MicrosoftOracle IBMMy SQLReliabilityScalabilitySupportLongevityCostFigure Adapted from “Teaching Note for MySQL Open Source Database,” 6/1/04, Stanford GSB.How should mySQL grow in order to meet it’s stated goal of getting to $100 million In revenue?My SQL: Growth Strategy- Lack of Brand identity in this segement- MySQL lacks the organization to offer support- Large enterprises have high switching costsSmall 20% Medium 30% Large 50%Enterprise wide data90%Web Sites10%MicrosoftOracle IBMMy SQLReliabilityScalabilitySupportLongevityCostFigure Adapted from “Teaching Note for MySQL Open Source Database,” 6/1/04, Stanford GSB.My SQL: Growth Strategy- Not a big enough market to reach stated $100 million goal.Small 20% Medium 30% Large 50%Enterprise wide data90%Web Sites10%MicrosoftOracle IBMMy SQLReliabilityScalabilitySupportLongevityCostFigure Adapted from “Teaching Note for MySQL Open Source Database,” 6/1/04, Stanford GSB.Stay Put?My SQL: Growth Strategy+ Many of these customers already using MySQL with websites+ Less emphasis on global organization+ Leverage SAP alliance- Up against Microsoft.Small 20% Medium 30% Large 50%Enterprise wide data90%Web Sites10%MicrosoftOracle IBMMy SQLReliabilityScalabilitySupportLongevityCostFigure Adapted from “Teaching Note for MySQL Open Source Database,” 6/1/04, Stanford GSB.Maybe?My SQL: Growth Strategy+ builds on existing brand and strengths- Market not so bigSmall 20% Medium 30% Large 50%Enterprise wide data90%Web Sites10%MicrosoftOracle IBMMy SQLReliabilityScalabilitySupportLongevityCostFigure Adapted from “Teaching Note for MySQL Open Source Database,” 6/1/04, Stanford GSB.Maybe?Oracle Buys Sun! (Announced 4/20) Oracle announced it would buy Sun Microsystems for $7.4 B cashEarlier, IBM made a cheaper offer for Sun, but talks fell throughOracle in 2009: strong proprietary DBMS business; gradually gaining market share with its ERP productsRecall: by buying Sun, Oracle gets?Sun HW (workstations, servers)Solaris OS (UNIX)Java language leadership, OpenOffice suiteMySQL open source DBMS (ISM 50: case study 5/18!)Oracle/Sun Discussion “More Oracle databases run on the Solaris Sparc than any other system,” said Oracle CEO Larry Ellison, noting Linux was second. “We’ll engineer the Oracle database and Solaris operating system together. With Sun we can make all components of the IT stack integrated and work well.”Oracle buys Sun Microsystems; tries to become the Apple of the enterprise... http://blogs.techrepublic.com.com/hiner/?p=1506 Oracle’s stack of IT stuff now includes:Java;Solaris;Enterprise applications ranging from CRM to ERP to business intelligence;The database (Oracle and MySQL);The middleware;The storage hardware;Cloud computing services;And servers.Oracle/Sun Discussion “It’s clear that Oracle is targeting the next generation data center—as is the rest of the industry. The list of tech titans looking to remake the data center:“IBM;HP;Cisco;Dell;Oracle;JuniperEMCVMwareothers...Break into groups of 3 or 4Discuss A) Is the acquisition of Sun a basic change in strategy for Oracle - why or why not?B) What made Sun an attractive acquisition target for Oracle?C) Has Sun been an Oracle rival, a substitute, or supplier?D) What’s your best guess at the long term role of Sun in the industry? (What’s the industry?)Write your ideas down.Oracle/Sun DiscussionA) Is the acquisition of Sun a basic change in strategy for Oracle - why or why not? The new Apple of Business Information Systems? What’s Oracle’s decision on OSS going forward?B) What made Sun an attractive acquisition target for Oracle? ...see prior slides: Java, Solaris, etc. Also, Sun shareholders wanted to sell...C) Has Sun been an Oracle rival, a substitute, or supplier?...make a case for each oneD) What’s your best guess at the long term role of Sun in the industry? ...let’s hear your ideasWhat is Microsoft’s fate? Have we arrived in the post-Windows era? | Between the Lines | ZDNet.com http://blogs.zdnet.com/BTL/?p=16590Preparation for networking topics:Algorithms and protocolsMarkup languagesAdapted from David G. MesserschmittChapter 11, Chapter 15AlgorithmSpecified sequence of steps thataccomplish a designated taskin a finite number of stepsRepresentation:simple algorithm: flowchartcomplicated algorithm: programStartturnThrowdiceMove token numberof squares indicatedon diceLand on “goto jail”?Move to“jail” squareDo not move;follow policiesfor square(like “pay