MYSQL教程之Oracle已过期？

客户还是可以使用DBaaS系统所能提供的所有能力。数据库云服务消除了组织对专职人员、本地数据库存储设备的需要。他们不必安装、配置和维护任何软硬件。oracle转自MarkRittman的BLOG
http://www.rittman.net/archives/001130.html

IsOracleALegacyTechnology?
OneofthenicethingsaboutworkingwiththeOracleRDBMS,comparedtosayworkingwithtechnologiessuchasAS/400,COBOLormainframesisthatitsgenerallyperceivedasa"hot"technology.SalarysurveysshowOracleskillsasbeingoneofthemostin-demandskillsets,theOracledatabaseiswayaheadofthecompetitionintermsoffeaturesanduseofnewtechnology,andmostoftheworldstopcompaniesuseOracleastheirdatabaseofchoice.ButwhatifinfactwevegonepastthepeakofOraclesascendancy,anditsnowalegacyproduct,withallworkinfuturebeingmainlyaboutmaintainingsystemsinplace,andmigratingthemtonewer,morefashionablesystems?AcoupleofexcellentrecentarticlesbyMogensNørgaardraisedthisasapossibility,andcertainlygiveyouafewthingstothinkoverwhenyouconsidertheOracledatabasetechnologystack.

ThefirstarticlewasattheendofMogenschapterinOracleInsights:TalesOfTheOaktable,wherehelooksatthekeyfactorthatmakesOracleparticularlysuitedtoeffectivetuning-thefactthatthedatabasekernelisheavilyinstrumented(thefamous"waitinterface"),andbecauseofthis,youcanobtainprecisedetailsaboutexactlywhatisslowingdownyourapplication.Otherdatabases,suchasDB2andMicrosoftSQLServer,donthavethisinstrumentation(oratleastitsnotpubliclyaccessible)andthereforeitsmuchmore"hitandmiss"withthoseplatforms.

ApointthatMogensmakesmid-waythroughthearticlethoughisthat,whilstitsallwellandgoodinstrumentingthedatabase,inmostcasesanapplicationconsistsofaSAN,operatingsystem,anapplicationserver,applicationcodeandsoon,andifyouveonlygotfeedbackonhowthedatabaseisperforming,youveonlygotpartofthestory.Mogensmakesthegoodpointthat,whilstMicrosofthaventexposedSQLServersinternalsinthesamewaythatOraclehave,infacttheyvegotahistoricalchancetoinstrumenttheentireapplicationplatform,astheyownthetechnologybehindWindowsServer,IIS,.NETandsoon,apointmadeagainbyNiallLitchfieldinathreadoncomp.databases.oracle.server.

Wherethisgoesontothoughisthat,whilstitsfantasticwhatOraclesdonewithinstrumentingthedatabasekernel,whatMogensisactuallyfindinginreallifeisthat,likediskstorageandoperatingsystemsbeforeit,thedatabaseitselfisnowbecomingacommodity,withno-onethesedaysgettingfiredforbuyingMicrosoftSQLServer,andmanyorganisationslookingtoopensourcedatabasessuchasmySQLtohandletheirday-to-daydatabaseneeds.Whilstthisismovingdatabasesasawholeintothelegacycategory,itparticularlyhurtsOraclebadlyasfirstly,theOracleRBDMSisexpensiveandstilltothisdayrequiresalevelofadministrativeskillwellaboveSQLServerandmySQL,andsecondly,forOracle,databaserevenuesarestillthemajorityoftheirtotallicenserevenues.Accordingtothearticle,

"OracleandDB2arenowlegacydatabases:veryfewtrulynewsalescomparedtolicenserenewalsandadd-onsalestoexistingcustomers,veryfewyoungpeoplecomingoutofschoolswantingbadlytolearnaboutthem.SQLServeristhesafechoicethatwontgetyoufired,andtheopensourcedatabasessuchasmySQLwillprevailwhentheycandelivertheneccessary(ratherfew,basic)functionalitiesthatthedevelopersoftomorrowwillrequire(suchashandlingtransactionscorrectly,havegoodbackupmethods,andsoon)."

TheironyasfarasMogensisconcerned,isthat"wheneverasystemortechnologyreachesalevelofperfection(inotherwords,scienceisusedasarule)itwillbereplacedbysomethingmorechaoticthatlooks(andperhapsevenis)cheaper",somethingthathappenedtomainframesbeforeand,justatthepointwhereitreachesthelevelof"technicalperfection",couldpossiblybethefateoftheOracleRDBMSitself.

MogensmadethesamepointsagaininhiscolumnintheAutumn2004editionofOracleScene,and,thinkingabouttheearlierpointaboutdatabasesingeneralbeingmadeintoacommodity,saysthatthiswillhavethefollowingeffectondatabaseprofessionals:

"SotheDBAsareslowlybeingreplaced,outsourced,divertedtoothertasks,orbeingaskedtofocusonotherthings,too.Thatmeansthreethingsforourdatabaseworld:

1.Thedatabaseswillusuallyrun,becausenobodyisfiddlingwithparametersandotherstuff.

2.Nonewfeatureswillbetestedandimplemented(afterall,7.3isstillplentyofdatabasetechnologyformostuses).

3.Whenthingsfinallygowrong,alotofothercomplications,duetothelackofdailynursing,fiddling,andcaring,willbediscovered,makingthetroubleshootingandrestore/recoveryprocessevenharderinanevenmorecriticalsituation.

Itmeanssomethingelse,too:Forcompaniesspecialisinginthissortofscenario,withabunchoftechiesstillaroundwhocanstaycurrentwiththelatestwithoutforgettingthe(basicsofthe)past,therewillbelotsofworkforthenext10years."

whilstforOracleinparticular,theeffectsarelikelytoinvolveachangeinbusinessplan

"...Ithinkit’sfairlysafetosaythistoday:
OracleandDB2arelegacydatabases,youdon’tgetfiredcurrentlyfromchoosingSQLServer,andtheopensourcedatabaseswillbecomethedefaultassoonasthey’regoodenough,whichwillhappenrealsoonnow,sincemoreandmoreworktakesplaceoutsidethedatabase,turningthedatabaseintoadatadump.TheopensourcedatabaseswilldotothedatabasemarketwhatLinuxiscurrentlybusydoingintheO/Smarket.Oraclegetsmostofitslicenseprofitsfromthedatabase.Iftheydon’tfindadditionalsourcesofincome(andprofit),suchasPeopleSoft,theywillfailbecauseoftheconstantattackontheirprofitsanctuaries(thedatabaselicencesandSupport).OraclewillbeboughtbyIBMorHPiftheydon’tmanagetogrowtoacomparablesize."
Sowhatdoesthismeanforusthen,whosecareers(presumably)arebasedaroundourknowledgeofOracle?WellIthinkitssafetosaythat,whilstImintotalagreementwithMogensonhisassessmentofthemarket(whichunfortunatelyalwayspickscheapestandsimplestabovecomplexityandcostly)ImsureeveryonewouldagreethattheOracleRDBMSisntgoinganywhereinthenearfuture.IfyouspoketoTomKyte(orindeedMogens)youcouldpointtoanynumberofnewfeaturesthatmakeOraclemorepowerful,easiertoadministerandlesscostlytorun,andnodoubtwhendatabasessuchasSQLServerandmySQLgetthefeaturesthatOraclecurrentlyhas,theyllbejustascomplextoadminister.

However,timeandtimeagainnowIcomeacrosssituationswherethedatabaseisconsideredjustpartoftheunderlyingplatformandalltherealactivitytakesplaceonthemid-tierandintheapplication,andifyouvegoingtodothat,youmightaswellusemySQLorAccess.Also(andthisisparticularlypronouncedintheBIandOLAPworld,andwillbemoresowhenYukoncomesout)rivaldatabasesarecatchingupwithOracleintermsoffeatures,andinmostcaseshaveabetter"outofthebox"experiencethatdoesntscareoffcuriousfirst-timeusersofthedatabase.

Ithinklikeinanywalkoflife,itpaystohedgeyourbets,andifyouspeaktomostadvocatesofOracletechnology(includingmanyoftheOaktablemembers)theyalsohaveagoodunderstandingofrivalRDBMSs,andinsomecasesrecommendtheminpreferencetoOracle.Also,itdependswhereyouareinyourcareer-Im36nowandworkingwithOraclemoreorlessforallofmyITcareer,andinallprobabilitywillcontinuetoworkwithdatabasesfortherestofmytimeintheindustry.If,however,Iwasjuststartingout,IdprobablyfocusmoreonJavaor.NETapplicationcoding,lookmoreat"mid-tier"issuesandspendlesstimeonthedatabase,storageandtheoperatingsystem.Still,havingsaidthat,IstillcomeacrossAS/400-basedapplications,andconsultantswhostillmakeapacketlookingafterthesesupposed"legacy"systems,anddonthavetospendalltheirtimerecertifyingandgettingtheirheadsaroundconceptssuchas"gridcomputing"and"service-orientatedarchitectures",soitcouldjustpaytosititoutandleteveryoneelsefightitoutoverthenextnewgreatthing.
正如前文所提到的，MySQL易学、易部署、易管理和易维护。