²½ÈëÖÇÄÜÐÂʱÆÚ ±¦ÔËÀ³¹Ù·½ÍøÕ¾´òÔìÍøÂ簲ȫ´¹Ö±ÁìÓò´óÄ£ÐÍ

°ä²¼¹¦·ò 2023-09-13

ChatGPTÒý·¢ÁËÈËÃǶÔÌìÉúʽÈËΪÖÇÄÜ¡¢´óÄ£Ð͵ĸ߶ȹØ×¢¡£¸÷Ðи÷ÒµÔÚ²»ÐÝʹÓôóÄ£ÐͽøÐÐÒµÎñÈںϴ´Ðº͸³ÄÜ´¹Ö±ÁìÓòµÄͬʱ £¬Æä×ÔÉí°²È«ÎÊÌâÒÔ¼°ÓÉ´Ë´øÀ´µÄ°²È«·çÏÕÎÊÌâҲͬÑù±ØÒªÆ÷³Á £¬ÒÔÇ÷Àû±Üº¦ £¬ÊµÏÖÈËÓëAIµÄ¹²Éú¡£


ÕýÈ籦ÔËÀ³¹Ù·½ÍøÕ¾¼¯ÍÅCEOÑÏÍû¼ÑÔÚ2023ÄêÊý²©»áÉÏËùÌᳫµÄ £¬¡°Í¨¹ý¼ÓÇ¿ÀíÂۺͼ¼Êõ×êÑÐ £¬ÎªÖÇÄÜ»¯¸ßËÙÒýÇæ×°Öá®·½ÏòÅÌ¡¯ºÍ¡®Ô춯Æ÷¡¯ £¬¹¹½¨ÒÔ±¨´ð±¾µÄÊý×ÖÉÆÖÎÉú̬ϵͳ £¬ÊµÏÖÈËÓëÈËΪÖÇÄÜЭͬ¹²ÉúÑÝ»¯¡£¡±


±¦ÔËÀ³¡¤(ÖйúÇø)×îйٷ½ÍøÕ¾

±¦ÔËÀ³¹Ù·½ÍøÕ¾¼¯ÍÅCEOÑÏÍû¼Ñ³öϯ2023Öйú¹ú¼Ê´óÊý¾Ý²úÒµÕ¹ÀÀ»á


³Ö¾ÃÒÔÀ´ £¬ÍøÂ簲ȫÐÐÒµÃæ¶Ô×ÅÒµÎñ³¡¾°¸´ÔÓ¡¢°²È«É豸¶à¶à¡¢¸æ¾¯Êý¾ÝÁ¿´ó¡¢ÊÂÎñ·ÖÎö´ëÖÃÑϳÁÒÀÀµ×¨Òµ°²È«ÈËÔ±¾­ÑéµÈÌôÕ½ £¬¶ø´óÄ£ÐÍÌåÏÖ³öµÄͨÓÃÈËΪÖÇÄÜ £¬ÕýÊÇÓ¦¶ÔÉÏÊöÌôÕ½µÄÃÎÏë½â¾ö¹æ»®¡£Ä¿Ç°¹úÄÚ±íһЩ»¥ÁªÍøÆóÒµºÍרҵ°²È«¹«Ë¾ £¬ÒÑÆðÍ·³¢ÊÔ½«´óÄ£ÐÍÀûÓÃÔÚ°²È«²úÆ·»ò·þÎñÖÐ £¬ÌáÉý²úÆ·ÄÜÁ¦ºÍ·þÎñЧÄÜ¡£


±¦ÔËÀ³¹Ù·½ÍøÕ¾»ùÓÚ×ÔÉíÔÚÍøÂ簲ȫÁìÓòµÄ¶àÄê¶Ñ¼¯ £¬ÝÓÈÆÈËΪÖÇÄܸ³Äܰ²È«ÒÔ¼°°²È«µÄÈËΪÖÇÄܵȽǶÈ £¬´òÔìÁËÍøÂ簲ȫ´¹Ö±ÁìÓò´óÄ£ÐÍ £¬²¢ÀûÓÃÓÚÍøÂ簲ȫҵÎñÖÐ £¬ÖØÒªÀûÓÃÁË´óÄ£ÐÍËù¾ß±¸µÄÊÀ½ç֪ʶºÍ˼ÏëÁ´ÄÜÁ¦£º


1¡¢·á˶µÄÊÀ½ç֪ʶ£º´óÄ£ÐÍÔÚѵÁ·¹ý³ÌÖжÁÈ¡Á˸÷¸öÁìÓòµÄº£Á¿ÓïÁϿ⠣¬ÔÚÆä²ÎÊýÖд洢ÁË´óÁ¿¿Í¹ÛÊÀ½çµÄÊÂʵÐÔ֪ʶ¡£ÍøÂ簲ȫҵÎñÊÇ֪ʼûܼ¯ÐÍÒµÎñ £¬¶Ô°²È«É豸²úÉúµÄ¸æ¾¯×öÑÐÅÓ×¢ÏìÓ¦ºÍȡ֤ £¬ÒÀÀµÓë¸æ¾¯Óйصݲȫ֪ʶ £¬ÕâÒ²ÊÇ´Óǰ¼«¶ÈÒÀÀµ°²È«ÈËÔ±Ó×ÎÒ¾­ÑéµÄ»·½Ú¡£½«´óÄ£ÐÍÀûÓõ½°²È«ÒµÎñÖÐ £¬Äܹ»ÔÚÒµÎñ¹ý³ÌÖÐ×¢ÈëÓйصݲȫ֪ʶ £¬ÌáÉý°²È«ÈËÔ±µÄÈÏÖª¡£


2¡¢×³´óµÄ˼ÏëÁ´ÄÜÁ¦£ºË¼ÏëÁ´ÊÇÖ¸½«¸´ÔÓ¹¤×÷·Ö»¯Îª¶à¸ö½Ïµ¥Ò»µÄÖÐÑ빤×÷ £¬ÔÙ±ðÀëÖ´ÐеÄÄÜÁ¦¡£´óÁ¿°²È«¹¤×÷¶¼±ØÒª·Ö»¯Îª¶à¸ö²½ÖèÖ´ÐÐ £¬ÀýÈç¸æ¾¯¹ØÁª·ÖÎö¡¢°²È«ÊÂÎñ´ëÖõÈ¡£´óÄ£ÐÍÀûÓõ½°²È«ÒµÎñ £¬¿ÉÒÔΪ°²È«¹¤×÷ÌìÉúÕýÈ·µÄ´ëÖÃÁ÷³Ì £¬ÌáÉý°²È«ÈËÔ±µÄЧÄÜ¡£


±¦ÔËÀ³¹Ù·½ÍøÕ¾ÔÚ½«´óÄ£ÐÍÈÚÈëÍøÂ簲ȫҵÎñ¹ý³ÌÖÐ £¬½â¾öÁË´óÄ£ÐÍÀûÓÃÂ䵨µÄһϵÁÐÎÊÌâ £¬º­¸Ç´óÄ£ÐÍ΢µ÷ÓÅ»¯¡¢ÍÆËã×ÊÔ´»ñÈ¡ºÍÄ£ÐÍÉý¼¶µü´úµÈ·½Ã棺


1¡¢´óÄ£ÐÍ΢µ÷ÓÅ»¯£ºÓÉÓÚ°²È«ÐÐÒµµÄÌØÊâÐÔºÍרҵÐÔ £¬»¥ÁªÍøÉϿɹ«¿ª»ñÈ¡µÄ°²È«×ÊÁϲ»¹»È«Ãæ £¬¶ÔÓÚÌØ¶¨ÎÊÌâ²»×ãÓÐÕë¶ÔÐԵĽâ¾ö¹æ»®¡£Õâ¾Íµ¼Ö»ùÓÚ¿ªÔ´ÓïÁÏ¿âѵÁ·²úÉúµÄ´óÄ£ÐÍ £¬¶ÔÓÚ°²È«ÎÊÌâµÄ½â´ð²»×ãʵ²ÙÐÔ¡£


ÔÚѵÁ·ÓÅ»¯½×¶Î £¬±¦ÔËÀ³¹Ù·½ÍøÕ¾¶Ô¹úÄÚ±í¿ªÔ´´óÄ£ÐͽøÐÐÁË¿í·º²âÊÔ £¬·¢ÏÖ¿ªÔ´´óÄ£Ð;ù´æÔÚ·ÖÆçˮƽµÄÎÞЧ»Ø¸²£¨ÄÚÈݹÌÈ»ÕýÈ· £¬µ«¹ýÓÚ¿í·ºÎÞ·¨Ö´ÐУ©¡¢»Ã¾õ£¨ÄÚÈݲ»Çкϰ²È«Ñ§ÎÊ£©µÈ¾°Ïó¡£»ùÓÚ´Ë £¬ÀûÓù«Ë¾ÔÚ°²È«¼ì²âºÍÔËÓªÁìÓòµÄ¶àÄê¶Ñ¼¯ÐγɵĸßÖÊÁ¿°²È«°¸Àý¿â £¬»ùÓÚLoRA²½Öè΢µ÷»ù×ù´óÄ£ÐÍ £¬²¢Éè¼ÆÁË´óÁ¿ÓÅ»¯ºóµÄPromptÄ£°å £¬Ê¹µÃÓÅ»¯ºó´óÄ£ÐÍÌìÉúÄÚÈݵÄÖÊÁ¿ÓÐÁËÏÔÖøÌáÉý¡£´Ë±í £¬ÀûÓù«Ë¾¶Ñ¼¯µÄ°²È«ÖªÊ¶¿â´òÔì±¾µØÏòÁ¿Êý¾Ý¿â £¬»ùÓÚLangchain¿ò¼ÜʵÏÖ»ùÓÚ±¾µØÖªÊ¶µÄÎÊ´ðϵͳ £¬½øÒ»²½ÌáÉýÁËÌìÉúÄÚÈݵĿ¿µÃסÐÔ¡£


2¡¢ÍÆËã×ÊÔ´ÅäÖ㺴óÄ£Ð͵ÄѵÁ·ºÍÍÆÀí¶¼±ØÒª´óÁ¿µÄÍÆËã×ÊÔ´ £¬ÓÈÆäÊÇGPU×ÊÔ´ £¬¶ø´«Í³ÆóÒµÍùÍù²»¾ß±¸¡£±¦ÔËÀ³¹Ù·½ÍøÕ¾Í¨¹ý½èÖúÒÆ¶¯ÔƵÄËãÍøÓÅÊÆ £¬½«´óÄ£Ð͵ÄѵÁ·ÓÅ»¯ºÍÍÆÀí¶¼²¿ÊðÔÚÁËÔÆ¶Ë £¬ÕâÑù²»½ö½â¾öÁË×ÔÉíµÄ×ÊÔ´ÐèÒªÎÊÌâ £¬Ò²ÓÐÖúÓÚ½«À´½èÖúÒÆ¶¯ÔÆ £¬¶ÔÔÆÉÏ×â»§Ìṩ»ùÓÚ´óÄ£Ð͵ݲȫ·þÎñ¡£


3¡¢Ä£ÐÍÉý¼¶µü´ú£ºÍøÂç¹¥»÷·½Ê½ÔÚ²»Ðݱ䶯 £¬´óÄ£Ð͵ݲȫÄÜÁ¦Ò²±ØÒª³ÖÐøµü´ú £¬ÄÜÁ¦ÔÚÕæÊµ³¡¾°ÖÐÂú×ãÒµÎñÒªÇó¡£Ö»ÓлùÓÚÕæÊµ·´À¡¶ÔÄ£ÐͽøÐв»ÐÝÓÅ»¯ £¬ÐγÉÄÜÁ¦ÌáÉýµÄ¹Ø»· £¬ÄÜÁ¦´òÔì¿ÉÓõݲȫ´¹Ö±ÁìÓò´óÄ£ÐÍ¡£ÓÉ´Ë £¬±¦ÔËÀ³¹Ù·½ÍøÕ¾½«°²È«´óÄ£ÐÍ×÷ÎªÌ¬ÊÆ¸Ð֪ƽ̨µÄ¡°ÖÇÄܰ²È«¸±ÊÖ¡± £¬Í¨¹ý°²È«ÔËÓªÈËÔ±ÔÚʹÓùý³ÌÖеķ´À¡Á˾Ö £¬³ÖÐø¶Ô´óÄ£ÐͽøÐÐÓÅ»¯Éý¼¶ £¬Õâ¾Í±£ÕÏÁË´óÄ£Ð͵ÄÄÜÁ¦¿ÉÄܲ»ÐÝ¶ÔÆë°²È«ÈËÔ±µÄÔ¤ÆÚ¡£

Æäʵ £¬ÔçÔÚ2022Äê £¬±¦ÔËÀ³¹Ù·½ÍøÕ¾¾Í°ä²¼ÁËÃæÏò°²È«Ô˽»Ò×ÎñµÄ°²È«ÖÇ»ÛÐÔÃüÌå¡°PanguBot(ÅÌÓ×¹Å)¡± £¬³õ²½ÊµÏÖÁ˶԰²È«ÔËÓªÈËÔ±Ö¸ÁîµÄÓïÒåÀí½â¡¢°²È«Õ½ÊõÔì¶©¡¢Ö´ÐÐÁ˾ַ´À¡µÈÄÜÁ¦¡£


±¦ÔËÀ³¡¤(ÖйúÇø)×îйٷ½ÍøÕ¾


µ±Ç° £¬Óɱ¦ÔËÀ³¹Ù·½ÍøÕ¾´òÔìµÄÍøÂ簲ȫ´¹Ö±ÁìÓò´óÄ£ÐÍ £¬ÒѾ­×÷Ϊ¡°PanguBot(ÅÌÓ×¹Å)¡±Éý¼¶°æµÄ´óÄÔ £¬¸³ÓèÁË¡°ÅÌÓ׹š±¸ü׳´óµÄ°²È«ÖÇÄÜ¡£


ÔÚ°²È«Ô˽»Ò×ÎñÖÐ £¬¡°ÅÌÓ׹š±¿É×÷Ϊ°²È«·ÖÎöÈËÔ±µÄÖÇÄܸ±ÊÖ £¬ÒÔÌìȻ˵»°µÄ·½Ê½½Ó¹Ü°²È«¹¤×÷²¢·´À¡Á˾Ö £¬´Ó¶øÀ©´ó°²È«ÔËӪƽְ̨ÄÜ¡¢ÌáÉýÒ»Ïß°²È«ÈËÔ±¹¤×÷ЧÄÜ¡£


ÔÚ½«°²È«Êý¾Ý´ÓÈÕÖ¾µ½¸æ¾¯¡¢ÔÙµ½ÊÂÎñµÄÖð²ãÌáÁ¶¹ý³ÌÖÐ £¬»ùÓÚ´óÄ£Ð͵ÄÖÇÄܸ±ÊÖ¶¼Äܹ»Æðµ½¹Ø¼ü×÷Óãº


1¡¢ÈÕÖ¾·ÖÎöÄÜÁ¦£ºÈÕÖ¾·ÖÎöÊǰ²È«ÔËÓªÖеĻù´¡¹¤×÷ £¬ÒÔÍù±ØÒª°²È«ÈËÔ±½«·ÖÎöÐèҪʵÏÖΪ¿ÉÔËÐеÄSQLÓï¾ä £¬ÔÙÌá½»µ½ÈÕÖ¾Êý¾Ý¿âÖÐÔËÐÐ £¬·ÖÎöÔËÐÐÁ˾Ö £¬Õû¸ö¹ý³Ì·Ñʱ·Ñ¾¢¡£


½èÖú´óÄ£Ð͵Ä˼ÏëÁ´ÄÜÁ¦ £¬°²È«ÈËÔ±Äܹ»ÓÃÌìȻ˵»°µÄ·½Ê½Ìá½»ÈκεķÖÎöÐèÒª £¬´óÄ£ÐÍÔÚÀí½â¹¤×÷ÄÚÈÝºó½«Æä²ð½âΪһϵÁÐ×÷Ϊ£º°ÎÈ¡ÏàÒ˵ÄÊý¾Ý±í£»ÀûÓÃText-to-SQLÄÜÁ¦Æ¾¾ÝÐèÒªÌìÉúSQL¾ç±¾£»½«¾ç±¾Ìá½»µ½ÈÕÖ¾¿â»ñÈ¡·µ»ØÁ˾Ö£»Æ¾¾Ý·µ»ØÄÚÈÝ×éÖ¯ÏàÒ˵ÄͼÎÄ·½Ê½µÈ £¬Õû¸öÁ÷³Ì¶¼ÓÉ´óÄ£ÐÍ×Ô¶¯ÊµÏÖ¡£ÓÐÁË´óÄ£Ð͵ļӳÖ £¬°²È«ÈËÔ±ÈÕÖ¾·ÖÎöµÄЧÄÜÓÐÁËÏÔÖøÌáÉý¡£


2¡¢¸æ¾¯½â¶ÁÄÜÁ¦£ºÔÚ´ÓÈÕÖ¾ÖзÖÎö³ö¿ÉÒɸ澯ºó £¬ÏÂÒ»²½¾Í±ØÒª¶Ô¸æ¾¯ÓÐЧÐÔ×öÑÐÅС£´«Í³×ö·¨Êǰ²È«ÈËԱƾ¾Ý×Ô¼ºµÄ¾­Ñé £¬½áºÏ¸æ¾¯µÄ¸ßµÍÎĺÍÓйØ×ʲúÐÅÏ¢ £¬×ö³ö¸æ¾¯ÊÇ·ñÓÐЧµÄÅжÏ £¬ÕâÓÖÊÇÒ»¸ö¼È·Ñʱ¡¢ÓÖÑϳÁÒÀÀµ°²È«ÈËÔ±¾­ÑéµÄ¹ý³Ì¡£

½èÖú´óÄ£ÐÍËù´æ´¢µÄ°²È«ÖªÊ¶ £¬ÖÇÄܸ±ÊÖ¿ÉÄܶԸ澯ÄÚÈÝ¡¢¸ßµÍÎÄÐÅÏ¢¡¢¹¥»÷ÊÖ·¨¡¢×ʲúÊôÐÔµÈÉí·Ö½øÐÐרҵ·ÖÎöºÍ½â¶Á¡£ÓÐÁËÕâЩ·á˶µÄ½â¶ÁÄÚÈÝ £¬°²È«ÈËÔ±ÑÐÅеÄÕýÈ·ÂʺÍЧÄÜ»áÓÐÏÔÖøÌáÉý¡£


3¡¢ÊÂÎñ´ëÖÃÄÜÁ¦£º¶ÔÓÚÈ·¶¨ÎªÕæÊµµÄ°²È«ÊÂÎñ £¬±ØÒª¾¡¿ìÖ´Ðо«×¼µÄÏìÓ¦Õ½Êõ £¬¼ÈÒª¿ÉÄÜÓÐЧ×è¶Ï¹¥»÷ÐÐΪ½øÒ»²½·¢Õ¹ £¬ÓÖÒª½«×è¶ÏµÄÓ°ÏìÁìÓò½µµ½×îÓס£´«Í³×ö·¨Êǰ²È«ÈËԱƾ¾ÝÏÖÊµÍøÂç»·¾³ºÍ°²È«É豸²¿ÊðÇé¿ö £¬Ï·¢ÏàÓ¦µÄ×è¶ÏÕ½Êõ £¬Õû¸ö¹ý³ÌʱЧÐԵ͡¢¶Ô°²È«ÈËÔ±µÄÒÀÀµ¶È¸ß¡£


½èÖú´óÄ£Ð͵Ä˼ÏëÁ´ÄÜÁ¦ £¬ÖÇÄܸ±ÊÖ¿ÉÄÜÆ¾¾Ý¸æ¾¯ÐÅÏ¢ºÍ°²È«É豸ÐÅÏ¢ £¬×Ô¶¯ÌìÉú´ëÖÃÕ½Êõ £¬²¢Å²Óð²È«É豸µÄAPI½Ó»°±úÏÖÕ½Êõ×Ô¶¯Ö´ÐÐ £¬Õû¸ö¹ý³Ì²»±ØÒª°²È«ÈËÔ±²Î¼Ó £¬´ó´óÌáÉýÁËÊÂÎñ´ëÖõÄЧÄÜ¡£


Ŀǰ»ùÓÚ´óÄ£Ð͵ÄÖÇÄܰ²È«¸±ÊÖ £¬ÒѾ­ÔÚÓû§µÄ°²È«Ô˽»Ò×ÎñÖнøÐÐÁ˳¢ÊÔ £¬ÔÚ¸³Äܰ²È«ÔËÓª¡¢ÌáÉý·ÖÎöЧÄÜ¡¢ÌáÉý´ëÖÃʱЧÐԵȷ½ÃæÕ¹Ê¾³öÓÅÁ¼µÄÀûÓÃÔ¶¾°¡£½«À´Ëæ×Å´óÄ£Ð͵ĽøÒ»²½ÓÅ»¯ £¬°²È«ÖÇÄܸ±ÊÖ½«»á×÷ÎªÒÆ¶¯ÔÆÉϵÄÒ»Ïî³ß¶È°²È«²úÆ· £¬¶ÔÒÆ¶¯ÔÆÉϵÄÓû§ÌṩÖÇÄÜ»¯°²È«·þÎñÄÜÁ¦¡£