µ±Ç°Î»ÖãºLinux½Ì³Ì - LinuxÎÄ»¯ - ΢Èí: Oracle ¸Ï²»ÉÏ SQL Server

΢Èí: Oracle ¸Ï²»ÉÏ SQL Server


ÃÀ¹ú΢ÈíÒѾ­¿ªÊ¼Ìṩ¸Ã¹«Ë¾ÍƳö¡°.NETÕ½ÂÔ¡±ÒÔÀ´µÄµÚÒ»¸ö·þÎñÆ÷²úÆ· SQL Server 2000¡£SQL Server ÔÚ.NET Õ½ÂÔÖеĴ¦ÓÚʲôÑùµÄλÖÃÄØ¡£¸Ã¹«Ë¾½«ÈçºÎÓ뾺Õù¶ÔÊÖÃÀ¹ú Oracle ¹«Ë¾¿¹ºâÄØ¡£´ø×ÅÕâЩÎÊÌâ±¾¿¯¼ÇÕ߲ɷÃÁË΢ÈíµÄ SQL Server Group ²úÆ·Ö÷¹Ü Steve Murchie£¬ÇëËû̸һϹØÓÚ SQL Server µÄ²úÆ·Õ½ÂÔ¡£

ÎÊ SQL Server ½«Îª.NET Õ½ÂÔÌṩÄÄЩ¹¦ÄÜÄØ¡£

´ð .NET µÄÄ¿µÄÊÇÓÐÀûÓÚÒòÌØÍøÉÌÎñ¡£SQL Server 2000 ³ýÁ˾ßÓÐÀ©Õ¹ÐÔ£¬¿É¿¿ÐÔÒÔÍ⣬»¹¾ßÓпÉÒÔѸËÙ¿ª·¢ÐµÄÒòÌØÍøϵͳµÄ¹¦ÄÜ¡£ÓÈÆäÊÇ¿ÉÒÔÖ±½Ó´æÖü XML Êý¾Ý£¬¿ÉÒÔ½«ËÑË÷½á¹ûÒÔ XML ¸ñʽÊä³öµÈÌص㣬ÕâЩÌصãÔÚ.NET Õ½ÂÔÖз¢»Ó×ÅÖØÒªµÄ×÷Óá£ÕâÊÇÒòΪ.NET µÄÄ¿±ê¾ÍÊÇÒªÒÔ XML ¸ñʽ½»»»Êý¾Ý¡£

½«À´»¹Òª½øÒ»²½¼ÓÇ¿ÃæÏò.NET µÄ¹¦ÄÜ¡£Ê×ÏÈÐèÒªÖ§³ÖÔÚÒòÌØÍøÉÏÌṩµÄÊý¾Ý·¢ËÍʱËù±ØÐèµÄЭÒé¡°SOAP£¨Simple Object Access Protocol£©¡±¡£Ä¿Ç°ÔÚ²ÉÓÃÁË SOAP µÄÊý¾Ý¿â·ÃÎÊÖУ¬ÐèҪʹÓÃÔÚÊý¾Ý¿âºÍÓ¦ÓÃÈí¼þÖ®¼ä½øÐнâÊÍ SOAP ЭÒéµÄÖмäÈí¼þ¡£ÕâÒ»²¿·Ö½«°²×°µ½ SQL Server ÉÏ£¬ÕâÑù¾Í¿ÉÒÔÖ±½Ó½âÊÍ SOAP¡£

ÁíÍâÒ»¸öÊÇ¿ÉÒÔÀûÓÃÊʺÏÓÚ¶àÖÖ¿ª·¢ÓïÑ﵀ Common Language Runtime£¨CLR£©¡£ÔÚ SQL Server Öн«°²×° CLR£¬´Ó¶ø¿ÉÒÔÓà Perl ÒÔ¼° COBOL µÈ¶àÖÖ¿ª·¢ÓïÑÔÃèÊö´æÖü¹ý³Ì£¨Stored Procedure£©¡£

ÎÊ ÔÚÒòÌØÍøÁìÓòÖУ¬´ó¶¼²ÉÓÃÃÀ¹ú Sun Microsystems ºÍ Oracle Á½¹«Ë¾µÄ²úÆ·¡£Î¢ÈíµÄ²úÆ·ÄܸúÉÏÊö¹«Ë¾¿¹ºâÂð¡£

´ð Sun ºÍ Oracle µÄ²úÆ·ÔÚ¿É¿¿ÐÔºÍÀ©Õ¹ÐÔ·½Ãæȷʵ±íÏÖ׿Խ¡£²»¹ýÔÚÄ¿Ç°£¬ Windows 2000 ºÍ SQL Server 2000 µÄ×éºÏÒ²²¢²»Ñ·É«¡£ÓбØҪʹÓû§Á˽⵽Çé¿öÓ뼸ÄêÇ°Ïà±È·¢ÉúÁ˺ܴóµÄ±ä»¯¡£Õâ¿ÉÄÜ»¹ÐèҪһЩʱ¼ä£¬ÔÚÍÆÏú·½ÃæÎÒÃÇ»¹ÐèÒªÔټӰѾ¢¡£ Èç¹ûÓû§ÈÏʶµ½ÎÒÃǵIJúÆ·¾ßÓÐ×ã¹»µÄ¿É¿¿ÐԺͿÉÀ©Õ¹ÐÔÄÜ£¬ÄÇôÏÂÒ»²½ÈËÃǹØ×¢µÄ½¹µã±ØÈ»»áתÒƵ½ÈçºÎ¾¡¿ì½¨Á¢ÏµÍ³ÉÏÀ´¡£ÔÚÕâÒ»·½Ã棬SQL Server 2000 ¸ü¾ßÓÅÊÆ¡£

ÎÊ ÔÚÓйع¤×÷ÒªÇó´¦ÀíÐÔÄÜµÄ TPC-C Bench Mark ²âÊÔÖУ¬SQL Server 2000 µÄ Cluster ϵͳÅÅÃûµÚÒ»¡£¶Ô´Ë£¬Oracle µÄ Ellison »á³¤Ôø¾­¿äϺ£¿Ú£¬¡°Èç¹û΢ÈíÄܹ»°´ÕÕÔÚ TPC-C ²âÊÔÖÐʹÓÃµÄ Cluster Êý¾Ý¿âµÄ±ê×¼ÓÃÓÚʵ¼ÊµÄ»°£¬ÎÒÃÇÔ¸ÒâÖ§¸¶ 1000 ÍòÃÀÔª¡±¡£ÇëÎÊÈçºÎ¿´´ýÕâһ˵·¨¡£

´ð ÖØÒªµÄÊdzýÁË TPC-C ²âÊÔÒÔÍ⣬»¹ÓÐÆäËü»ù×¼²âÊÔҲ֤ʵÁË SQL Server 2000 µÄ׿ԽÐÔÄÜ¡£ÀýÈ磬ÔÚʹÓà SAPR/3 ºÍ People Soft µÈERPÈí¼þ½øÐÐµÄ Bench Mark ²âÊÔÖУ¬SQL Server ҲͬÑùλ¾Ó°ñÊס£

µ±³õÔÚ Oracle µÄ Cluster ϵͳÖвÉÓÃÁ˶à¸ö·þÎñÆ÷¹²ÏíÒ»¸öÓ²ÅÌ×°Öõġ°¹²ÏíÓ²ÅÌ¡±½á¹¹¡£ÕâÑù¼´Ê¹ÔÙ×·¼Ó·þÎñÆ÷£¬ÆäÐÔÄܳÙÔç»á´ïµ½¼«ÏÞ¡£

¶ø SQL Server 2000 Ôòδ²ÉÓù²ÏíÓ²ÅÌ×°Öõġ°Shared Nothing¡±½á¹¹¡£ÕâÊÇÒ»ÖÖ½«Ò»¸ö±í£¨Table£©Ö«½âµ½¶à¸ö·þÎñÆ÷ÖУ¬½øÐв¢ÐÐËÑË÷¼°¸üеķ½·¨¡£ÕâÖÖ·½Ê½ËäÈ»²»ÄÜ˵ÊÇÊÊÓÃÓÚËùÓÐʵ¼ÊÓÃ;£¬²»¹ý´óÖÂÉϵ±×·¼Ó·þÎñÆ÷ʱ£¬ÆäÐÔÄÜҲͬʱµÃµ½Ìá¸ß¡£

δÀ´µÄ SQL Server ½«»á·¢Õ¹³ÉÐ嵀 Shared Nothing ÐÍ¡£ÕâÊÇÒ»ÖÖÔÚ Cluster ϵͳµÄËùÓзþÎñÆ÷ÖУ¬·ÅÖÃÍêÕûµÄÊý¾Ý¿âµÄ¸´ÖÆÆ·µÄ·½Ê½¡£Ö»Òª Oracle ¼á³Ö²ÉÓù²ÏíÓ²ÅÌÐÍ£¬¾Í²»¿ÉÄܸÏÉÏ SQL Server¡£


Õª×Ô£ºhttp://linux.tcpip.com.cn