¬d¬Ý§¹¾ãª©¥»: ORACLE¤½¥q¶Ç©_

chris 12-7-2005 10:59

ORACLE¤½¥q¶Ç©_

ORACLE¤½¥q¶Ç©_
ORACLE¤½¥q¤§°_·½

«ÜÃø·Q¹³¡AORACLE¤½¥qªº³o¤@¬q¶Ç©_©~µM­n±qIBM¶}©l¡C

1970¦~ªº6¤ë¡AIBM¤½¥qªº¬ã¨s­û·R¼w®æ•¦Ò¯S(Edgar Frank Codd)¦bCommunications of ACM ¤Wµoªí¤F¨º½gµÛ¦Wªº¡m¤j«¬¦@¥Î¸ê®Æ®w¸ê®ÆªºÃö«Y¼Ò«¬¡n¡]A Relational Model of Data for Large Shared Data Banks¡^ªº½×¤å¡C³o¬O¸ê®Æ®wµo®i¥v¤Wªº¤@­ÓÂà§é¡C­nª¾¹D¡A·í®ÉÁÙ¬O¼h¦¸¼Ò«¬©Mºôª¬¼Ò«¬ªº¸ê®Æ®w²£«~¦b¥«³õ¤W¥e¥D­n¦ì¸m¡C±q³o½g½×¤å¶}©l¡A©Ô¶}¤FÃö«Y«¬¼Æ¾Ú®w³nÅé­²©Rªº§Ç¹õ¡C

ÁöµM¦­¦b1970¦~´N½Ï¥Í¤FÃö«Y¼Ò«¬²z½×¡A¦ý¬O¥«³õ¤W¿ð¿ð¤£¨£Ãö«Y«¬¼Æ¾Ú®wºÞ²z³nÅ骺±À¥X¡C¥D­n­ì¦]¬O«Ü¦h¤Ï¹ïªÌ»{¬°Ãö«Y«¬¼Æ¾Ú®w³t«×¤ÓºC¡A¤ñ¤£¤W·í®Éªº¼h¦¸¦¡¸ê®Æ®w¡C­È±o¦n¯ºªº¬O¡AIBMÁöµM1973¦~´N±Ò°Ê¤FSystem Rªº¶µ¥Ø¨Ó¬ã¨sÃö«Y«¬¼Æ¾Ú®wªº¹ê»Ú¥i¦æ©Ê¡A¤]¨S¦³¤Î®É±À¥X³o¼Ëªº²£«~¡A¦]¬°·í®ÉIBMªºªºIMS¡]µÛ¦Wªº¼h¦¸«¬¸ê®Æ®w¡^¥«³õ¤£¿ù¡A¦pªG±À¥XÃö«Y«¬¼Æ¾Ú®w¡A²o¯A¨ìIBM«Ü¦h¤Hªº¦Û¨­§Q¯q¡C¦AªÌ¡AIBMÃe¤j½ÆÂøªº©x¹±¾÷ºc³B¦b¨Mµ¦¤W»·¤£¨º»òÆF¬¡¡C

1977¦~6¤ë¡ALarry Ellison»PBob Miner©MEd Oates¦bª¿½\¦@¦P³Ð¿ì¤F¤@®a¦W¬°³nÅéµo®i¹êÅç«Ç¡]Software Development Laboratories¡ASDL¡^ªº¹q¸£¤½¥q¡]ORACLE¤½¥qªº«e¨­¡^¡C¨º­Ó®É­Ô¡A32·³ªºLarry Ellison¡A³o­ÓŪ¤F¤T®a¤j¾Ç³£¨S¯à²¦·~ªº½ù¾Ç¾Ç¥Í¡AÁÙ¥u¬O¤@­Ó´¶³qªº³nÅé¤uµ{®v¡C¤½¥q³Ð¥ß¤§ªì¡AMiner¬OÁ`µô¡AOates¬°°ÆÁ`µô¡A¦ÓEllison¡A¦]¬°¤@­Ó¦X¦Pªº¨Æ±¡¡AÁÙ¦b¥t¤@®a¤½¥q¤W¯Z¡C¨S¦h¤[¡A²Ä¤@¦ì­û¤uBruce Scott¡]¥Î¹LORACLE¸ê®Æ®w³nÅ骺¤H³£ª¾¹D¦³­ÓScott¥Î¤áªº§a¡H¨S¿ù¡A´N¬O³o­ÓScott¡A¦Ü©óScott¥Î¤áªº±K½XTiger¡A¨º¬OScott¾iªº¿ßªº¦W¦r¡^¥[·ù¶i¨Ó¡A¦bMiner©MOates¦³¨Ç¹½­Â¤F¨ººØ¦X¦P¦¡ªº¶}µo¤u§@«á¡A¥L­Ì¨M©w¶}µo³q¥Î³nÅé¡A¤£¹L¥L­ÌÁÙ¤£ª¾¹D¦Û¤v¯à¶}µo¥X¨Ó¤°»ò¼Ëªº²£«~¡COates³Ì¥ý¬Ý¨ì¤F·R¼w®æ•¦Ò¯Sªº¨º½gµÛ¦Wªº½×¤å³s¦P¨ä¥L´X½g¬ÛÃöªº¤å³¹¨Ã±ÀÂËEllison©MMiner¤]¾\Ū¤@¤U¡CEllison©MMiner¹w¨£¨ì¸ê®Æ®w³nÅ骺¥¨¤j¼ç¤O¡]¸òµÛIBM¨«¡A¨S¿ù¡^¡A©ó¬O¡ASDL¶}©lµ¦¹ººc«Ø¥i°Ó¥ÎªºÃö«Y«¬¼Æ¾Ú®wºÞ²z¨t²Î¡]RDBMS¡^¡C

«Ü§Ö¥L­Ì´N§Ë¥X¨Ó¤@­Ó¤£¤Ó¹³¼Ëªº²£«~¡A©ÎªÌ¨ãÅ骺»¡¡A§ó¹³¤@­ÓDemo¡C®Ú¾ÚEllison©MMiner¦b«e¤@®a¤½¥q±q¨Æªº¤@­Ó¥Ñ¤¤¥¡±¡³ø§½§ë¸êªº¶µ¥Ø¥N½X,¥L­Ì§â³o­Ó²£«~©R¦W¬°ORACLE¡C¦]¬°¥L­Ì¬Û«H¡AORACLE¡]¦r¨åùتº¸ÑÄÀ¦³¡§¯«¿Ù, ¹w¨¥¡¨¤§·N¡^¬O¤@¤Á´¼¼zªº·½¬u¡C1979¦~¡ASDL§ó¦W¬°Ãö«Y³nÅ馳­­¤½¥q¡]Relational Software¡AInc.¡ARSI¡^¡A²¦³º¡§³nÅéµo®i¹êÅç«Ç¡¨¤£¤Ó¹³¤@­Ó¤j¤½¥qªº¦W¦r¡C1983¦~¡A¬°¤F¬ð¥X¤½¥qªº®Ö¤ß²£«~¡ARSI¦A¦¸§ó¦W¬°ORACLE¡C


µo®i»P§§¤j

RSI¦b1979¦~ªº®L©uµo§G¤F¥i¥Î©óDEC¤½¥qªºPDP-11¹q¸£¤Wªº°Ó¥ÎORACLE²£«~¡A³o­Ó¸ê®Æ®w²£«~¾ã¦X¤F¤ñ¸û§¹¾ãªºSQL¹ê²{¡A¨ä¤¤¥]¬A¤l¬d¸ß¡B³s±µ¤Î¨ä¥L¯S©Ê¡C¦ý¤£±o¤£»¡¡A³nÅ餣¬O«Üí©w¡A¨Ã¯Ê¤Ö¨Æ°È³B²z³o¼Ëªº­«­n¥\¯à¡C¥X©ó¥«³õµ¦²¤¡A¤½¥q«ÅºÙ³o¬O¸Ó²£«~ªº²Ä2ª©¡A¦ý«o¬O¹ê»Ú¤Wªº²Ä1ª©¡C¤§©Ò¥H³Q©R¦W¬°²Ä2ª©¦Ó¤£¬O²Ä1ª©¡A¬O¦]¬°Ellison»{¬°¼ç¦bªº«È¤á§óÄ@·NÁʶR²Ä2­Óª©¥»¡A¦Ó¤£¬Oªì©lª©¥»¡C¡]ÁöµM³o¼Ë°µ¦³¨Ç¤£¤Ó¸Û¹ê¡AÁÙ¬O­n©Ó»{³o¬O­Ó¤Q¤À°ª©úªº§Þ¥©¡C¨ì²{¦bÁÙ¦³¤@¨Ç¤½¥q§â¦Û¤v½æµ¹«È¤áªºª©¥»¥s°µ1.0¡A¾Ç¾Ç1979¦~ªºORACLE§a¡I¡^¦h¦~¥H«áªº¤µ¤Ñ¡AORACLE¤½¥qÁnºÙ¬O¥L­Ì²Ä¤@­Ó´£¨Ñ¤F²Ä¤@­ÓSQLÃö«Y«¬¼Æ¾Ú®wºÞ²z¨t²Î¡C

ÁöµM³nÅ餣¬O«Ü¦n¡A¦ý¬O«È¤áÁÙ¬O¦³ªº¡C¬ü°ê¤¤¥¡±¡³ø§½­¢¤£¤Î«Ý¦a·Q¶R¤@®M³o¼Ëªº³nÅé¨Óº¡¨¬¥L­Ìªº»Ý¨D¡C¦ý¦b¿Ô¸ß¤FIBM¤½¥q¤§«áµo²{IBM¨S¦³¥i¥H°Ó¥Îªº²£«~¡A¥L­ÌÁpô¤FRSI¡C©ó¬ORSI¦³¤F²Ä¤@­Ó«È¤á¡C¦b·í®É¡A¬F©²©M­x¤èªº¾÷ºc©¹©¹¦P®É¦³´XºØ¹q¸£¡A¦Ó¨º®ÉÁÙ¨S¦³¤°»ò¡§³nÅé¥i²¾´Ó¡¨³o¼Ëªº»¡ªk¡A·íµM¡A¤]´X¥G¨S¦³¨ã¦³³o¼Ëªº¯à¤OªºÀ³¥Î³nÅé¡C¤]´N¬O»¡¡Aµ¹PDP-11¶}µoªºORACLE¸ê®Æ®w¤£¯à¥Î¦bIBM¥D¾÷©MDECªºVAX¤W¡C«Ü§Ö¥Î¤á´Nªí²{¥X¨Ó³o¼Ëªº»Ý¨D¡GORACLE¯à§_¦P®É¦b¤£¦Pªº§@·~¨t²Î¤W¹B¦æ¡H³oµ¹RSI±a¨Ó¤F·sªº¬D¾Ô¡]¥D­n¬OMiner©MScott¡^¡C70¦~¥N¥½´Á©M80¦~¥N¦­´Áªº³nÅé¤@¯ë³£³]­p¦¨¦b³æ¤@§@·~¨t²Î¤W¹B¦æ¡A¨ã¦³¥i²¾´Ó¯à¤Oªº³nÅé«Ü¤Ö¡C

1983¦~3¤ë¡ARSIµo§G¤FORACLE²Ä3ª©¡CMiner©MScott¾úºÉÁ}¨¯¥ÎC»y¨¥­«·s¼g´N³o¤@ª©¥»¡C­nª¾¹D¡AC»y¨¥·í®É±À¥X¤£¤[¡A¥Î¥¦¨Ó¼gORACLE³nÅé¤]¬O¨ã¦³¤@©wªº­·ÀIªº¡A¦ý°£¦¹¤§¥~¡A§OµL¥Lªk¡C«Ü§Ö´NÃÒ©úÁA³o¼Ë°µ¬O¦h»òªº¥¿½T¡AC½s;¹«K©y¦Ó¤S¦³®Ä¡C±q²{¦b°_¡AORACLE²£«~¦³¤F¤@­ÓÃöÁ䪺¯S©Ê¡G¥iÄâ©Ê¡CORACLE²Ä3ª©ÁÙ±À¥X¤FSQL»y¥y©M¨Æ°È³B²zªº¡§­ì¤l©Ê¡¨――SQL»y¥y­n»ò¥þ³¡¦¨¥\¡A­n»ò¥þ³¡¥¢±Ñ¡A¨Æ°È³B²z­n»ò¥þ³¡´£¥æ¡A­n»ò¥þ³¡¦^ºu¡CORACLE²Ä3ª©ÁÙ¤Þ¤J¤F«Dªý¶ë¬d¸ß¡A¨Ï¥Î¦sÀx¦b¡§before image file¡¨¤¤ªº¸ê®Æ¨Ó¬d¸ß©M¦^ºu¨Æ°È¡A±q¦ÓÁ×§K¤FŪÂê©w¡]read lock¡^ªº¨Ï¥Î¡]ÁöµM³q¹L¨Ï¥Îªí¯ÅÂê©w­­¨î¤F¥¦ªº§]¦R¶q¡^¡C¦P¼Ë¬O1983¦~¡AIBMµo§G¤F©k©k¨Ó¿ðªºDatabase 2¡]DB2¡^¡A¦ý¥u¥i¦bMVS¤W¨Ï¥Î¡C¤£ºÞ«ç»ò»¡¡AORACLE¤w¸g¥e¨ú¤F¥ý¾÷¡C

¦b¶}µo²Ä¤Tª©ÁÙ¨S¦³µ²§ôªº®É­Ô¡AScottÂ÷¶}¤FORACLE¡C·í®É¥ÎC§ï¼gORACLEªºÀ£¤O«Ü¤j¡AµL¥ð¤îªº³nÅé½Õ¸Õ²×©óÅýScott¤£³ô­«­t¡A¿ï¾Ü¤F¤@¨«¤F¤§¡C§â³Ñ¤Uªº­«¾á¥æµ¹¤FMiner¤@­Ó¤H¡C¦b¥X°â¤F¦Û¤v4¢HªºªÑ²¼¤§«á¡AScott «á¨Ó³Ð«Ø¤FGupta¤½¥q¡]²{§ó¦W¬°Centura Software¡^©MPointBase¤½¥q¡]´£¨Ñ100%¯ÂJava´O¤J¦¡¸ê®Æ®w¡^¡A³£¬O¶}µo©M¸ê®Æ®w¬ÛÃöªº²£«~¡C¦h¦~«á¦³¤H°Ý¨ì¥Lªº4¢HªºORACLEªÑ²¼ªº®É­Ô¡AScott¡A³o­Ó´¿¸gµ¹ORACLE¼g¥X²Ä¤@¦æ¥N½Xªº§Þ³N°ª¤â¡A¤]¥u¯à³ø¥H¤@¯º¤F¡C¦pªG¯à°í«ù¤U¨Ó¡A¨º¬O¤@µ§´X»õ¬üª÷ªº°]´I¡C¤£¹L·í®ÉªºScott¨S¦³¨º»ò¦hªº·Qªk¡A¥L¥u¬O¤Ó²Ö¤F¡C

ORACLE³Ì¥ý±N¨ä³nÅé²¾´Ó¨ìDEC VAX¹q¸£¤WªºVMS§@·~¨t²Î¤W¡C¦­¦b1979¦~¤½¥q´N¤w¸g¶±¤F¤@¦ìDEC¤½¥qªº§Þ³N°ª¤âRobot Brandt¶i¦æVAX¤WORACLEªº¶}µo¡C¶}©lªº®É­Ô¸êª÷¦³­­¡A¥u¯à¨ì¥[¦{¤j¾Ç§B§J§Q¤À®Õ¥hóO¾÷¾¹¶i¦æ¶}µo¡A«á¨Ó¦n¤@¨Ç¡A¦ý¾÷¾¹¤]¬O­É¨Óªº¡C¾¨ºÞ§xÃø­«­«¡ABrandtÁÙ¬O¤ñ¸û¦¨¥\ªº§¹¦¨¤F²¾´Ó¤u§@¡CÀHµÛVAX¤p«¬¾÷ªº¤j¶q¾P°â¤D¦Ü¨Ñ¤£À³¨D¡AORACLE³nÅé¤]¦¨¬°VAX¤W³Ì¨üÅwªïªºµ{¦¡¡C³o¤@ÂI­nÂk¥\©óLarry¹ï¥«³õªº¥ýª¾¥ýı¡C¦pªG»¡¡A¬OIBM¤Þ»âµÛORACLE¤½¥q¨«¤W¸ê®Æ®wªº¤j²î¡A¨º»òDEC¤½¥qªºVAX´N¬O±aµÛ¥L­Ì´­¦|¥X®ü¤F¡Cµuµuªº´X¦~¤§«á¡AORACLE¸ê®Æ®w³Q²¾´Ó¨ì¦UºØ¥D­n¥­»O¤§¤W¡CORACLE²£«~¤]¤@ª½¦]¬°¦³¥iÄâ©Ê³o­ÓÃöÁä¯S©Ê¦Ó³Q¨º¨Ç¼ç¦bªº«È¤áÃöª`¡C

Oates³o­Ó®É­Ô¦]¬°±B«ÃÁÍ©ó¯}µõ¦Ó±¡ºüªq³à¡A¤w¸g¤£¯à§âºë¤O¥þ³¡©ñ¨ì¤½¥q¤W¡A¤£±o¤£Â÷¶}¤½¥q¡C´X¦~«á¡A¥L¤S­«ªð¤½¥q¡A­«·s¬°ORACLE±a¨Ó¥¨¤jªº°^Äm¡A¥L³\¤U¿Õ¨¥¡A¦b¤½¥q­û¤u¶W¹L1¸U¤Hªº®É­Ô·|¦A«×Â÷¶}¡C1999¦~¡A¥L§¹¦¨¤F¤ßÄ@¡C²{¦b¥L¥¿¦bÁa±¡©ó­µ¼Ö¡A¦Û±o¨ä¼Ö¡C

«Üªø¤@¬q®É¶¡ùØ¡A¤½¥q¬ãµo¥ÑMiner¿W¤O©Ó¾á¡CMinerµøª÷¿ú¦pµLª«¡A¬°¤H§C½Õ¡A©MEllisonªº¾W¨~¥²ÅS§Î¦¨ÂA©úªº¹ï¤ñ¡C¦b¤½¥qùØ¡A¤j®a¤@­P»{¬°¥L¬O¦Ñ¦n¤H¡A¥L¤]²`¨ü­û¤u·RÀ¹¡CEllison¬O¤½¥qªº¤j¸£¡AMiner«h·í¤§µL·\ªº¦¨¬°¤½¥qªº¤ßŦ¡C¥L¬O­Ó¨IÀqªº­^¶¯¡A¥¿¦pSteve Jobs­I«áªºSteve Wozniak¤@¼Ë¡C

1984¦~10¤ë¡AORACLEµo§G¤F²Ä4ª©²£«~¡C²£«~ªºÃ­©w©ÊÁ`ºâ±o¨ì¤F±o¨ì¤F¤@©wªº¼W±j¡A¥ÎMinerªº¸Ü»¡¡A¹F¨ì¤F¡§¤u·~±j«×¡¨¡C¦ý¬OÁÙ¤£°÷¥O¤Hº¡·N¡A¥Î¤á¹ï²£«~ªº©ê«è¦ü¥G¥ÃµL¥ð¤î¡C³o¤@ª©¼W¥[¤FŪ¤@­P©Ê¡]read consistency¡^¡A³o¬O¸ê®Æ®wªº¤@­ÓÃöÁä¯S©Ê¡A¥i¥H½T«O¥Î¤á¦b¬d¸ß´Á¶¡¬Ý¨ì¤@­Pªº¸ê®Æ¡C¤]´N¬O»¡¡A·í¤@­Ó·|¸Ü¥¿¦b­×§ï¸ê®Æ®É¡A¨ä¥Lªº·|¸Ü±N¬Ý¤£¨ì¸Ó·|¸Ü¥¼´£¥æªº­×§ï¡C¥i¥H¬Ý¨ì¡A¦bORACLE²Ä4ª©¤§«e¡A²£«~©l²×¬O¤£Ã­©wªº¡A¦ý¬OORACLEªº³o¸s¾P°â¤H­û¡A¥D­n¬OEllison¡A¥L¦b«Å¶ÇORACLEªº®É­ÔÁ`¬O­n¸Ø¤j¨äµü¡A¦ý¥L´N¬O¦³¯à¤O§â³nÅ齿¥X¥h¡A¦Ó¥B¡AÁÙ½æ±o«Ü¦n¡A¤£±o¤£©Ó»{¡A³oªº½T¦³¨Ç¯«©_¡CÅý§Ú­Ì¬Ý¬Ý1984¦~³nÅ饫³õªº±¡§Î¡A¦b¸ê®Æ®w¥«³õ¤WªºÅQ¥D¬OAsnton-Tale¤½¥q¡A¥L­Ìªº®±ÀY²£«~¬O­è±À¥X¤£¤[ªºdBase III¡]½T¤Áªº»¡dBase¬OPC¤Wªº¸ê®Æ®w³nÅéÅQ¥D¡^¡A­è­è¦¨¬°¥þ²y²Ä¤T¤jªº¿W¥ß³nÅ餽¥q¡]²Ä¤@©M²Ä¤G¤À§O¬O·L³n¡BLotus¡AORACLE¦b·í®ÉÁٱƤ£¤W¸¹¡^¡A³o¤@¦~¡A¤]¬OÄ«ªG¤½¥qMacintosh½Ï¥Íªº¦~«×¡ASteven Jobs¥Î³o­Ó®±ÀY²£«~¬D¾Ô¦Ñ¤j­ôIBM¡C¦P¼Ë¦b³o¤@¦~¤¤¡AORACLE¤½¥qªº¶}µo¤H­û­è­è§â²£«~²¾´Ó¨ìPC¤W¡C³o¬O³Ì¦nªº¦~¥N¡A¤]¬O³ÌÃaªº¦~¥N¡C¼Æ¥H¤d­pªº¤p¤½¥q¦b³nÅé»â°ìùت§°«¤£¥ð¡A·s¤½¥q¦p«B«á¬Kµ«¯ë¦¨¥ß¡AORACLE¦p¦ó¤~¯à©ó¤£±Ñ¤§¦a¡H

¦b1985¦~¡AORACLEµo§G¤F5.0ª©¡C¦³¥Î¤á»¡¡A³o­Óª©¥»ºâ±o¤W¬OORACLE¸ê®Æ®wªºÃ­©wª©¥»¡C³o¤]¬O­º§å¥i¥H¦bClient/Server¼Ò¦¡¤U¹B¦æªºªºRDBMS²£«~¡A¦b§Þ³NÁͶդW¡AORACLE¸ê®Æ®w©l²×¨S¦³¸¨«á¡C³o·N¨ýµÛ¹B¦æ¦b®à­±PC¾÷¡]«È¤á¾÷¡^¤Wªº°Ó°ÈÀ³¥Îµ{¦¡¯à°÷³q¹Lºô¸ô³X°Ý¸ê®Æ®w¦øªA¾¹¡C1986¦~µo§Gªº5.1ª©Á٤䴩¤À´²¦¡¬d¸ß¡A¤¹³\³q¹L¤@¦¸©Ê¬d¸ß³X°Ý¦sÀx¦b¦h­Ó¦ì¸mªº¸ê®Æ¡C

¨º¬O¦b1985¦~¡A·í®É´¿¸gªº³Ì¤jªº¿W¥ß³nÅ餽¥qCullinet(¥D­n¾P°âºôª¬¸ê®Æ®w)¤w¸g¦p¬y¬P¯ë¹k¸¨¡CORACLEªº¥D­nÄvª§¹ï¤â¬OIngres¸ê®Æ®w¡CIngres¦b¥[¦{¤j¾Ç§B§J§Q¤À®Õ½Ï¥Í¡A¥D­nªº³]­pªÌ¬O·í®É¹©¹©¤j¦WªºMichael Stonebraker±Ð±Â¡C¥i¥H»¡Ingres¸ê®Æ®w³nÅé¬O¤W­Ó¥@¬ö80¦~¥N§Þ³N¤W³Ì¦nªº¸ê®Æ®w¡AIngres¥«³õ¤ÀÃBªº§Ö³t¼Wªø¤w¸gµ¹ORACLE¦­¦¨¤F«Ü¤jªºÀ£¤O¡C¥©ªº¬O¡A³o­Ó®É­Ô¡AIBM¤½¥q¦A¤@¦¸¦ù¥X¡§¤W«Ò¤§¤â¡¨¡C

Ingres¨Ï¥Îªº¬OStonebraker µo©úªºQUEL¡]Query Language¡^¡^ªº¬d¸ß§Þ³N¡A³o©MIBMªºSQL¤j¤£¬Û¦P¡C¦b¬Y¨Ç¦a¤èQUEL¬Æ¦Ü­nÀu©óSQL¡CIBM·í®É¾á¤ßIngres§âQUELÅܦ¨¼Ð·Ç·|¹ï¦Û¤v¤£§Q¡C¸g¹L¤@µf¿Å¶q¡A¨M©w§â¦Û¤vªºSQL´£¥æµ¹¸ê®Æ®w¼Ð·Ç©e­û·|¡C¦ÓStonebraker±Ð±Â¥i¤£¥´ºâ§âQUEL´£¥æµ¹¸ê®Æ®w¼Ð·Ç©e­û·|¡A¾Ç°|¬£ªº¥L»{¬°³o麽°µ¹ê»Ú¤W¬O§ã±þ¤F³Ð·sºë¯«¡Cøf°F¬Ûª§¡Aº®¯Î±o§Q¡CORACLE¬Ý¨ì¨Ã§ì¦í¤F³o­Óµ´¨Îªº¾÷·|¡A¤j¸v«Å§GORACLE¥þ­±»PSQL¬Û®e¡A¥[¤WORACLE·í®É¹ïIngres PC¤Wªºª©¥»ªº§ðÀ»¡]®z¤Æ¹ï¤âÀu¶Õ¡A¤Æ¸Ñ¦Û¤v®z¶Õ¬O¥L­Ì³Ì®³¤âªº¥»»â¡^¡A¦A¥[¤WORACLE¤½¥q¾P°â¤Wªº±j¶Õ¡AIngres¤£Â_¥á«°¥¢¦a¡Aµ¥¨ì«á¨Ó±À¥X¤ä´©SQLªº¸ê®Æ®wªº®É­Ô¬°®É¤w±ß¡Cºò¸òIBMÅýORACLE±o¥H¦¨ªø¡B§§¤j¡A¾Ö©ê¼Ð·Ç¡A¾Ö©ê¶}©ñ¡A¾Ö©êÅܤơAÅýORACLE¥ß©ó¤£±Ñ¤§¦a¡C

1986¦~3¤ë12¤é¡AORACLE¤½¥q¥H¨CªÑ15¬ü¤¸¤½¶}¤W¥«¡A·í¤é¥H20.75¬ü¤¸¦¬½L¡A¤½¥q¥«­È2.7»õ¬ü¤¸¡C3¤ë13¤é¡A·L³n¥H¨CªÑ21¬ü¤¸ªºµo¦æ»ù¤W¥«¡A¥H28¬ü¤¸¦¬¥«¡A¤½¥q¥«­È¹F¨ì7»õ¬ü¤¸¡C»·»·¶W¹L¤FORACLE¡C¦¨¥\ªº¥úÀôªº·L³n©M»\¯ý¾B»\¦í¤FORACLE©MEllisonªº¥ú¨~¡A¥i¯à³o¤]¬OEllison¼Äµø·L³nªº¶}©l¡C
¸g¨ü®À§é

ORACLE²Ä6ª©©ó1988¦~µo§G¡C¥Ñ©ó¹L¥hªºª©¥»¦b©Ê¯à¤W¹ð¨ü¸á¯f¡AMiner±a»âµÛ¤uµ{®v¹ï¸ê®Æ®w®Ö¤ß¶i¦æ¤F­«·sªº§ï¼g¡C¤Þ¤J¤F¦æ¯ÅÂê¡]row-level locking¡^³o­Ó­«­nªº¯S©Ê¡A¤]´N¬O»¡¡A°õ¦æ¼g¤Jªº¨Æ°È³B²z¥uÂê©w¨ü¼vÅTªº¦æ¡A¦Ó¤£¬O¾ã­Óªí¡C³o­Óª©¥»¤Þ¤J¤FÁٺ⤣¤W§¹µ½ªºPL/SQL¡]Procedural Language extension to SQL¡^»y¨¥¡C²Ä6ª©ÁÙ¤Þ¤J¤FÁp¾÷¼ö³Æ¥÷¥\¯à¡A¨Ï¸ê®Æ®w¯à°÷¦b¨Ï¥Î¹Lµ{¤¤³Ð«ØÁp¾÷ªº³Æ¥÷¡A³o·¥¤j¦a¼W±j¤F¥i¥Î©Ê¡C¦P®É¦b³o¤@¦~¡AORACLE¶}©l¬ãµoERP³nÅé¡C

¤½¥qµo®i¬Ý¤W¥h¤ñ¸û¶¶§Q¡A¤£¹L¡A¾µ¹Ú¤~­è­è¶}©l¡C

¥Ñ©ó¹L¥h¹ï³nÅé´ú¸Õ­«µøªºµ{«×¤£°÷――¨º­Ó®É­Ô¤½¥q³W¼Ò¤p¡A°ò¥»¤W³£¬O«È¤áÀ°§U§K¶O´ú¸Õªº¡C¦b²Ä6ª©­èµo§G¤§«á¡A«Ü¦h­¢¤£¤Î«Ý¶}©l¨Ï¥Îªº¥Î¤á´N«èÁn¸ü¹D¡C³o¬O­Ó®Ú¥»´N¨S¦³´ú¸Õ¦n´N¶i¦æµo§Gªº²£«~¡]¤]©ÇEllison¡A¤j¸ÜÁ`­n»¡¦b«eÀY¡A¥u¦n¦Û¹Á­WªG¡^¡C¥Î¤á¶}©l¹ïORACLE¤j¸v©áÀ»¡AORACLEªº¤@¨Ç¹ï¤â¡A¤]¶}©l¸¨¤«¤U¥Û¡A°w¹ïORACLE²£«~ªº¤@¨Ç®zÂI¶i¦æ§ðÀ»¡C¶}µo¤H­û¤@­±À³¥I¼««ãªº¥Î¤á¡A¤@­±¥[¯Z¥[ÂI¦a¹ïµ{¦¡¶i¦æ±µ³s¤£Â_ªº­×¥¿¡A³Ì«á¡AÁ`ºâ±o¨ì¤F¤@­Ó¤ñ¸ûí©wªºª©¥»¡A¼È®É¥­®§¤F¥Î¤áªº¼««ã¡C

¦ý¬O¡A¹ê»Úªº°ÝÃD¨Ã¤£¦b³oùØ¡A´X¦~¨Ó°ª³t¼Wªøªº¦P®É¤]µ¹¤½¥q±a¨Ó¤F¥¨¤jªºÁô±w¡A1990°]¦~²Ä¤T©u«×³øªíªº¤½§G¤ÞÃz¤F¤@¤Á¡C°]°È¤H­ûµo²{¤F1500¸U¬ü¤¸ªºÃa±b¡A¨Ã¥B¤½¥q§Q¼í¶ZÂ÷¹w´Á¬Û®t¬Æ»·¡C±µ¤U¨Óªº®É¶¡ùØ¡A¤j¤½¥q¯fªº½Ñ¯ë¯gª¬±µ¿æ¦Ó¨Ó¡A­±¹ïªÑªFªº«ü±±¡AªÑ²¼¤@¸¨¤d¤V¡A¤½¥q«e´º·t²H¡A¬Æ¦Ü­±Á{¯}²£¡C¤@«×¾a¶U´Ú¨Óºû«ù¦Û¤vªº°øµØ¥Í¬¡¤]¤£ÅܽæªÑ²¼ªºEllison¤]§Ö¼µ¤£¦í¤F¡C¤½¥q¤U¤j¤O®ð¾ã¹y°]°È¡]°]°È¥DºÞ³Ç¤Ò•¨U§J±q¬YºØµ{«×¤W¸Ñ±Ï¤F¤½¥q¡^¡C¤½¥q«Å§G«d´î¶}¤ä¡Aµô°h¤j¶q¾P°â¤H­û¡A¦P®É¸u¥Î¤F±MªùªººÞ²z¤H¤~¡C

¾µ¹Ú©µÄò¨ìORACLE²Ä7ª©ªº±À¥X¦Óµ²§ô¡C³o­Ó¤½¥q¤w¸gªÅ½Í¤F¦n´X¦~ªº·sª©¥»¡]¤@«×³QÃտج°¤£¹L¬OEllisonªº¬G­p­«¬I¦Ó¤w¡^¡Aª½¨ì1992¦~6¤ë¤~²×©ó°{«Gµn³õ¡A³o¤@¦¸¤½¥q§l¨ú¤F²Ä6ª©¥^¦£¤W¥«ªº±Ð°V¡AÅ¥¨ú¤F¥Î¤áªº¦h¤è­±ªº«ØÄ³¡A¨Ã¶°¤¤¤O¶q¹ï·sª©¥»¶i¦æ¤F¤j¶q¦Ó²Ó½oªº´ú¸Õ¡C¸Óª©¥»¼W¥[¤F³\¦h·sªº©Ê¯à¯S©Ê¡G¤À´²¦¡¨Æ°È³B²z¥\¯à¡B¼W±jªººÞ²z¥\¯à¡B¥Î©óÀ³¥Îµ{¦¡¶}µoªº·s¤u¨ã¥H¤Î¦w¥þ©Ê¤èªk¡CORACLE 7ÁÙ¥]§t¤F¤@¨Ç·s¥\¯à¡A¦p¦sÀx¹Lµ{¡BIJµo¹Lµ{©M»¡©ú©Ê¤Þ¥Î§¹¾ã©Êµ¥¡A¨Ã¨Ï±o¸ê®Æ®w¯u¥¿ªº¨ã¦³¥i½sµ{¯à¤O¡CÁÙ¦³¤@ÂI¥²»Ý­n»¡©úªº¬O¡A³o­Óª©¥»¦b­ì¦³ªº°ò©ó³W«hªºÀu¤Æ¾¹¡]RBO¡^¤§¥~¤Þ¤J¤@ºØ·sªºÀu¤Æ¾¹¡G°ò©ó¶}¾PªºÀu¤Æ¾¹¡]Cost-Based Optimizer , CBO¡^¡CCBO®Ú¾Ú¸ê®Æ®w¦Û¨­¹ïª«¥óªº²Î­p¨Ó­pºâ»y¥yªº°õ¦æ¶}¾P¡A±q¦Ó±o¥X¨ãÅ骺»y¥y°õ¦æ­pµe¡C¦b¥H«áªº´X­Ó­«¤jª©¥»¤¤¡AORACLEªº¤uµ{®v­Ì³v¨B¹ï³o­ÓÀu¤Æ¾¹¶i¦æ§ï¶i¡ACBO³vº¥¨ú¥N¤FRBO¡C

ORACLE²Ä7ª©¬OORACLE¯u¥¿¥X¦âªº²£«~,¨ú±o¤F¥¨¤jªº¦¨¥\¡C³o­Óª©¥»ªº¥X²{¯u¬O¦n®É¾÷¡A·í®ÉSybase¤½¥qªº¸ê®Æ®w¤w¸g¦û¾Ú¤F¤£¤Ö¥÷ÃB¡AORACLE­É§U³o¤@ª©¥»ªº¦¨¥\¡A¤@¨ãÀ»°h¤F©F©F¹G¤HªºSybase¡C¤½¥qªº¾P°â¤H­û³o¦¸ºâ¨ì¤Fµ¹¥Î¤á§I²{ªÅÀY³\¿Õªº®É­Ô¡C¤½¥q¸g¹L¨â¤T¦~ªºªv²z¡A²×©óÂ\²æ¤FºØºØ³Â·Ð¡A­«·s¶}©l°·±dµo®i¡A¾P°âÃB¤]±q92¦~ªº15»õ¬ü¤¸Åܬ°¥|¦~«áªº42»õ¬ü¤¸¡C

¸ó¤WÅq®p

¡§ÅÍ´ý¤ô¡¨¬OEllisonªº¤@¶µµ´§Þ¡C¦b1995¦~¤Ú¾¤Á|¦æªº¼Ú¬w¸ê°T§Þ³N½×¾Â·|ij¤W¡AEllison¦b§Y¿³ºtÁ¿¤¤¤¶²Ð¤Fºô¸ô¹q¸£¡]Network Computer¡ANC¡^ªº·§©À¡A©Ò¿×NC«üªº¬O°t¸m²³æ«o¯à¥R¤À§Q¥Îºô¸ô¸ê·½ªº§C»ù¹q¸£¡A³Ì¬°­«­nªº¬O¡A¥¦¤£»Ý­n§@·~¨t²Î¡A©ÎªÌ§ó·Ç½Tªº»¡¡A¤£»Ý­n·L³nªº§@·~¨t²Î¡CEllison§Æ±æ­É¦¹¨Ó©è¨î·L³nªº±j¶Õ¡C«Ü§Ö¡AORACLEÁp¦XIBM¡BSun¡BApple©MNetscape¦b1996¦~¨î©w¤Fºô¸ô¹q¸£ªº¼Ð·Ç¡A¦ý¨Æ¹ê¤W¤H­Ì±qÀY¨ì§À¨S¦³¬Ý¨ì¤@¥x¯u¥¿ªºNC¥Í²£¥X¨Ó¡C³o¦¸ªººtÁ¿¦b·~¬É¤Þ°_¤F°aµM¤jªi¡A³q¹L³o­Ó¨Æ¥ó¡AORACLE¤½¥q§l¤Þ¤F¨¬°÷¦hªºª`·N¤O¡A¦P®É¤]Åý¤H­Ì¬Ý¨ìORACLE¤½¥q¹ï©óºô¸ôªº¥¨¤j«H¤ß¡C

1997¦~6¤ë¡AORACLE²Ä8ª©µo§G¡CORACLE 8¤ä´©­±¦Vª«¥óªº¶}µo¤Î·sªº¦h´CÅéÀ³¥Î¡A³o­Óª©¥»¤]¬°¤ä´©Internet¡Bºô¸ô­pºâµ¥³þ©w¤F°ò¦¡C¦P®É³o¤@ª©¥»¶}©l¨ã¦³¦P®É³B²z¤j¶q¥Î¤á©M®ü¶q¸ê®Æªº¯S©Ê¡C³o­Óª©¥»¤]ºâ¥i°é¥iÂI¤F¡C

1998¦~9¤ë¡AORACLE¤½¥q¥¿¦¡µo§GORACLE 8i¡C¡§i¡¨¥NªíInternet¡A³o¤@ª©¥»¤¤²K¥[¤F¤j¶q¬°¤ä´©Internet¦Ó³]­pªº¯S©Ê¡C³o¤@ª©¥»¬°¸ê®Æ®w¥Î¤á´£¨Ñ¤F¥þ¤è¦ìªºJava¤ä´©¡CORACLE 8i¦¨¬°²Ä¤@­Ó§¹¥þ¾ã¦X¤F¥»¦aJava¹B¦æ®ÉÀô¹Òªº¸ê®Æ®w¡A¥ÎJava´N¥i¥H½s¼gORACLEªº¦sÀx¹Lµ{¡C¹ï¡AJava¡A¥u­n¬O¯à°÷¥´À»·L³nªºªZ¾¹¡AORACLE³£­n¬£¤W¥Î³õ¡CORACLE 8i ²K¥[¤FSQLJ¡]¤@ºØ¶}©ñ¦¡¼Ð·Ç¡A¥Î©ó±NSQL¸ê®Æ®w»y¥y´O¤J«È¤á¾÷©Î¦øªA¾¹Java¥N½X¡^©MORACLE interMedia¡]¥Î©óºÞ²z¦h´CÅ餺®e¡^¥H¤ÎXMLµ¥¯S©Ê¡C¦P®É¡AORACLE 8i ·¥¤jµ{«×¤W´£°ª¤F¦ùÁY©Ê¡BÂX®i©Ê©M¥i¥Î©Ê¥Hº¡¨¬ºô¸ôÀ³¥Î»Ý­n¡C±µ¤U¨Óªº´X¦~¤¤¡AORACLE³°Äòµo§G¤F8iªº´X­Óª©¥»¡A¨Ã³vº¥²K¥[¤F¤@¨Ç­±¦Vºô¸ôÀ³¥Îªº·s¯S©Ê¡C­±¹ï¶}·½¹B°Êªº½´«kµo®i¡AORACLE¦ÛµM¤£¥Ì¸¨«á¡A1998¦~10¤ëORACLEµo§G¤F¥i¥Î©óLinux¥­»OªºORACLE 8 ¥H¤ÎORACLE Application Server 4.0¡AÀH«á¤£¤[¡AORACLE¤Sµo§G¤FORACLE 8i for Linux¡C¦b .com¤j¼é¤¤¡AORACLE¬O¯¸¦b­·¤f®ö¦yªº§Ë¼é¨à¡C

¦b2001¦~6¤ëªºORACLE OpenWorld¤j·|¤¤¡AORACLEµo§G¤FORACLE 9i¡C¦bORACLE 9iªº½Ñ¦h·s¯S©Ê¤¤¡A³Ì­«­nªº´N¬OReal Application Clusters¡]RAC¡^¤F¡C»¡°_ORACLE¶°¸s¦øªA¾¹¡A¦­¦b²Ä¤­ª©ªº®É­Ô¡AORACLE´N¶}©l¶}µoORACLE¨Ã¦æ¦øªA¾¹¡]ORACLE Parallel Server ¡AOPS¡^¡A¨Ã¦b¥H«áªºª©¥»¤¤³vº¥ªº§¹µ½¤F¨ä¥\¯à¡A¤£¹L¡AÄY®æ¨Ó»¡¡A¾¨ºÞOPSºâ±o¤W¬O­Ó¶°¸sÀô¹Ò¡A¦ý¬O¨Ã¨S¦³Åé²{¥X¶°¸s§Þ³NÀ³¦³ªºÀuÂI¡C¦b§¹¥þ§l¦¬¤FRdb¡]ORACLE¦b1994¦~¦¬ÁʤFCompaqªºRdb¸ê®Æ®w¡A¦¹«eRdbÄÝ©óDEC¤½¥q¡ADEC¤½¥q¦bVAX¤W¹ê²{¤F²Ä¤@­Ó¥i¥H°Ó¥ÎªºRdb¶°¸s¸ê®Æ®w¡^ªº¤@¨Ç§Þ³NÀu¶Õ¤§«á¡AORACLE²×©ó±À¥X¤F¯u¥¿ªºÀ³¥Î¶°¸s³nÅé¡CRAC¨Ï±o¦h­Ó¶°¸s¹q¸£¯à°÷¦@¥Î¹ï¬Y­Ó³æ¤@¸ê®Æ®wªº³X°Ý¡A¥HÀò±o§ó°ªªº¥i¦ùÁY©Ê¡B¥i¥Î©Ê©M¸gÀÙ©Ê¡CORACLE 9iªºRAC¦bTPC-Cªº°ò·Ç´ú¸Õ¤¤¥´¯}¤F¼Æ¶µ°O¿ý¡A¤@®É¶¡·~¤ºÆf¥Ø¡C³o­Ó·sªº¸ê®Æ®wÁÙ¥]§t¶°¦¨ªº°Ó°È´¼¼z¡]BI¡^¥\¯à¡CORACLE 9i²Ä2ª©ÁÙ°µ¥X¤F«Ü¦h­«­nªº§ï¶i¡A¨ÏORACLE¸ê®Æ®w¦¨¬°¤@­Ó¥»¦aªºXML¸ê®Æ®w¡F¦¹¥~ÁÙ¥]¬A¦Û°ÊºÞ²z¡BData Guardµ¥°ª¥i¥Î¤è­±ªº¯S©Ê¡C

¾ú¥vÁÙ¦bÄ~Äò

2003¦~9¤ë8¤é¡A¤Tÿ¥«Á|¿ìªºORACLE World¤j·|¤W¡AEllison«Å§G¤U¤@¥N¸ê®Æ®w²£«~¬°¡§ORACLE 10g¡¨¡CORACLEÀ³¥Î¦øªA¾¹10g¡]ORACLE Application Server 10g¡^¤]±N§@¬°¥Ò°©¤å¤½¥q¤U¤@¥NÀ³¥Î°ò¦¬[ºc³nÅé¶°¦¨®M¥ó¡C¡§g¡¨¥Nªí¡§grid ,ºô®æ¡¨¡C³o¤@ª©ªº³Ì¤jªº¯S©Ê´N¬O¥[¤J¤Fºô®æ­pºâªº¥\¯à¡C¦ó¿×ºô®æ­pºâ¡Hºô®æ­pºâ¥i¥H§â¤À§G¦b¥@¬É¦U¦aªº¹q¸£³s±µ¦b¤@°_¡A¨Ã¥B±N¦U¦aªº¹q¸£¸ê·½³q¹L°ª³tªº¤¬Ápºô²Õ¦¨¥R¤À¦@¥Îªº¸ê·½¶°¦¨¡C³q¹L¦X²z½Õ«×¡A¤£¦Pªº­pºâÀô¹Ò³Qºî¦X§Q¥Î¨Ã¦@¥Î¡CORACLE«ÅºÙ10g¥i¥H§@¬°ºô®æ­pºâªº°ò¦¡A¥ÙÀYª½«ü³Ì¤jªº¼Ä¤HIBMªº¡§ÀH»ÝÀ³ÅÜ¡¨¡I¬Ý¨Ó¡AORACLE¤½¥q¤w¸g§â³o¤@¦¸ªº¡§½äª`¡¨©ã¦b¤Fºô®æ­pºâªº¤j¥«³õ¤W¡C¦ý«e´º¦p¦ó¡HÅý§Ú­Ì«ø¥Ø¥H«Ý¡C

¦pªG»¡¡AIBM¬OIT²£·~¤¤ªº¤@ÀY¥¨ÄH¡A¨º»òORACLE¤@©w´N¬O¤@±ø¤jÃT³½¡G©F©F¹G¤H¡Aµ½©ó¶i§ð¡C´N¦b2003¦~6¤ëªì¡AORACLE¬ðµM«Å§G51»õ¬üª÷¦¬Áʤ¯¬ì¡]PeopleSoft¡^¡A·~¤º¦A¦¸¾_°Ê¡C¦¸Á|¤S¤@¦¸ÅS¥XORACLE ¤@³eµ½©ó¶i§ðªº¥»©Ê¡C­nª¾¹D¡AORACLE¦bµo®i¹Lµ{¤¤«Ü¤Ö¹ï¥ø·~¶i¦æ¦¬Áʪº¡A¨º»ò¦¬Áʤ¯¬ì¥Øªº¦ó¦b¡H­º¥ý¡AORACLEÁ»¿Ì¥ø·~À³¥Î³nÅ饫³õ¤w¤[¡A¦ý­W©ó¤£¯à¶i¤@¨BÂX¤j¥«³õ¤ÀÃB¡A¤×¬°­«­nªº¬O¡A¤@¥¹¦¨¥\¡A¥i¥Hª½±µ¹ï³Ì¤jªº¼Ä¤HIBM¶i¦æ¥´À»¡AÁÙ¥i¥HªýÀ»SAPµ¥¥¨ÀYªº±j¶Õ¡A³o¤@ÂI¤×¬°­«­n¡C®É¦Ü¤µ¤é¡AORACLE¨ÌµM¥H¤£¹F¥Øªº¤£¥Ì¥ðªººA¶Õ©M¤¯¬ìÄñ°«¡Aµ²ªG¦p¦ó¡AÅý§Ú­Ì«ø¥Ø¥H«Ý¡C

¡§¤H¥Í³Ì¤jªº§Ö¼Ö¬OÀ»±Ñ¼Ä¤H¡¨¡AEllison¤@©w«Ü³ßÅw³o¥y¬¡¡C
­¶: [1]
¬d¬Ý§¹¾ãª©¥»: ORACLE¤½¥q¶Ç©_