支付宝全局架构师曹刚:为 12 亿用户设计架构是什么体验?| 程序员有话说

从一线研发到全局架构师,支付宝的曹刚分享了公司技术架构的演进历程,包括从SOA架构到金融网络平台的建设,以及如何应对双十一大促带来的技术挑战。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

从2005年成立以来,支付宝逐渐成长为拥有12亿用户的数字生活开放平台,在它背后,是不断演进的技术架构在做支撑。

在过去,我们已经分享过了支付宝伴随着双十一大促一路走来的技术演进,今天,我们邀请到了支付宝全局架构师曹刚,请他给大家分享一下,给12亿用户设计架构是什么体验。

所谓全局架构师,就是为整个公司的架构治理和架构演进提供服务的人。不过曹刚也并不是一开始就成为全局架构师,而是从一线研发开始做起,和支付宝共同成长。

支付宝全局架构师 曹刚

一线研发:和公司一同成长,掌握架构理念

 

曹刚2008年9月加入支付宝,是公司的早期员工之一。加入公司后,他负责快捷支付业务和网银业务的开发,也参加了公司三代架构的建设。

“三代架构是一个非常有里程碑意义的架构体系,鲁肃老苗在公司内提出了SOA这套架构模式,奠基了今天整个支付宝的技术基础。”曹刚回忆道。

当时,支付宝和银行对接,是通过一个专门的银行网关系统对接的,人们通过支付宝付款,就是通过这套网关跳转到银行的网银系统进行支付。但是,这套系统各项功能糅杂在一起,发生问题难以维护和处理,更别提进行扩展了。曹刚和同事们一起,将这套银行网关系统演进成金融网络平台,通过SOA理念按照职责和领域进行分层和剥离包含支付指令向银行指令转换的金融交换层、报文拆分解析的网关层、与银行间的查错服务处理层,形成了今天支付宝金融网络的基础雏形。在这个过程中,曹刚对架构的理解逐步深入。

在一线研发的这段日子里,他认为自己收获最大的地方是,很快掌握了SOA的架构理念,包括架构设计方式以及整个运维体系、从零开始完成SOA架构的搭建,从底层到前端的架构细节等等。这些为他之后承担更大的职责奠定了基础。

 

成为架构师:从最下游到最上游

 

曹刚在成为全局架构师之前,分别担任过金融网络平台和财富领域的架构师。

和一线研发相比,架构师的工作不再局限于某一个系统的程序开发,更关注整个平台的体系化是否足够完善,哪些地方有短板,哪些地方需要优化,哪些老的系统是需要治理等。

担任金融网络架构师期间,曹刚重新设计了银行卡资金的流入流出体系,它里面涉及到的支付、退款、对账、查询等能力,和之前相比是更高层次的抽象,通过这种抽象形成了两套系统,分别是以实时交易为主的流入体系和异步处理、批量处理的流出体系。

在这段时间里,曹刚也参与了公司四代架构的改造。在阿里ALL IN无线之后,支付的业务量激增,表现在双十一大促上,则是支付峰值每年都会翻上好几倍。因此对金融网络的高可用和高并发的设计也成为曹刚关注的重点。

在应对高峰流量的挑战时,除了支付宝所做的分布式架构和单元化之外,每年双十一曹刚还会和银行方一起做扩容和压测,形成了一整套应对大促的容量规划和全链路压测的体系。“双十一大促,从一定程度上改变了整个国内的银行业IT基础能力。”对于这句话,作为这些年在一线和银行并肩作战的人,他的感受是最深刻的。

2016年,应公司的的需要,曹刚加入了成立不久的财富事业群,成为财富领域的架构师。

虽然同是架构师,但和之前相比,金融网络偏业务底层,是金融基础设施的一部分,并不直接面对最终用户;财富则类似于支付业务的收银台,更贴近一线业务,属于业务的最上游,他的职业转变相当于从业务最下游转到最上游,改变还是很大的。

在这段时间里,曹刚最大的收获是对业务的理解更加深入,视野更加开阔,对架构的整体结构理解更加清晰。做金融网络架构的时候是从底层往上看,看的不是特别全面,在财富领域看业务可以更加完整,可以深刻的理解支付宝的这套架构体系。包括理解每一个领域的内容在整个业务过程中充当什么角色和位置,以理财产品为例,今天我们为什么要上这个理财产品,这个理财产品需要从哪个金融机构引进来,引进的过程中涉及哪些领域的合作才能让产品成功上架面对用户等等问题,都是他在做财富领域架构师之后学习到的。

担任财富领域架构师期间,曹刚推动金融资产交易这一层的架构从烟囱型变成平台型,打造了一个金融资产中台。在过去,理财产品分为很多业务线,包括余额宝、基金、定期、黄金等,都是烟囱化建设,曹刚将其中各类资产公共的、通用的部分抽象出来,沉淀为平台统一为各类业务提供服务,包括理财资产统一登记、计量,资金清算流程统一等,同时又保持每个业务各自的灵活性,这非常考验架构师对架构分与合的判断能力和权衡能力。

 

全局架构师:推动全公司架构演进与治理

进入2019年,曹刚已经在架构领域工作了6年时间,这6年里他对金融领域的业务和技术都进行了深入的了解和实践,希望到更大的平台去看一看,这一年他加入了架构部,成为了一名全局架构师。

全局架构师最核心的工作目标,就是推动整个支付宝技术架构的演进,同时拉动整个技术组织的升级和发展,协助CTO落地全公司的顶层技术战略。他们需要在CTO战略和各条事业线之间形成良好衔接,推动顶层战略在各条事业线落地,同时挖掘各条线的共性问题,形成拉动全局技术架构演进的课题。

和局部领域架构师不一样的是,全局架构师需要关注整个公司全局性的课题。大部分时间,全局架构师要思考怎么让整个架构体系更灵动,一方面要让业务具备灵活性和自主性,但同时需要将共通的能力沉淀下来。结合公司业务和技术战略方向,全局架构师要定义整体架构升级的大方向,以及当前要做的横向技术课题有哪些。比如支付宝今年的横向课题包括云原生、安全生产、研发效能、数据智能等,然后深度参与或负责其中一些课题的具体落地过程。

全局架构师另一个工作就是关注现有的架构中不合理的的地方。比如研发效能、低水平的重复建设、边界不清晰、分工不合理等,需要推进解决这些问题。过去,我们往往依赖架构师的专家经验来解决这些问题,随着数字化转型的趋势,全局架构工作也在转型,我们要把技术研发过程和技术管理过程数字化、平台化,助推蚂蚁技术架构优化与演进、技术组织升级与发展,通过数据挖掘和分析,建立相关的数据分析产品,直接提供给CTO和各条线的技术负责人,让他们更好的发现技术领域的一些问题,并提供专家经验和解决方案,辅助技术管理层决策,从而更加高效的推动问题改进。

 

全局架构师需要什么能力?

 

当前,支付宝正从金融支付平台向数字生活开放平台升级,我们要搭建全球最大的数字生活开放平台、数字普惠金融平台,我们要建设新一代的技术架构体系去更好的支撑业务战略提升,业务在高速发展,要在整个公司层面进行这样的架构升级,相当于给飞行中的飞机换引擎,需要全局统筹,善于取舍和决断,对全局架构师提出了非常大的挑战。

从上面可以知道,全局架构师的工作极端重要,同时对能力和经验都有很高要求,为了更广泛的吸纳人才,支付宝决定向全社会招募全局架构师。

至于全局架构师需要什么的人才,曹刚本身就是一个很好的模板:在垂直领域取得成绩,具备一定的技术影响力,可以认为是这个领域的权威;能力已经被证实过,有带领中型以上团队的经验,同时又追求更大领域的发展和格局,希望到更大的平台来发展。这就是支付宝对全局架构师候选人的画像。

另外,支付宝内部还有一个架构文化,从最开始的鲁肃老苗,通过传帮带而传承下来,其中也包括全局架构师需要具备的四种能力或特质:

首先,需要有业务洞察能力,全局架构师更多的偏业务架构和应用架构,因此对于自己所负责的领域要有独到的理解。就拿支付宝来说,你要理解它做的支付本质是什么?解决什么问题?底层是什么?包括支付、账务、清算、结算、交易平台等等,都需要有自己的理解。

其次要保持心态开放,有些问题一线的同学可能感受没那么强烈,比如两个团队之间的一些合作效率上的问题,但架构师要来解决的话可能伤害到同学们,那么到底要不要解决呢?这里就涉及到具体的权衡,而在这个过程中,要保持开放的心态,要能够容忍各种矛盾。

第三个是架构师需要具有全局视野,做架构本质是权衡和取舍,如果决策的时候只能看到一部分,那么结果就是盲人摸象,决策肯定会出问题。要解决局部领域的问题,需要从全局视野出发,否则最后的方向可能与整个公司的方向背道而驰。而这条对于全局架构师更加是必备的素质。

最后是紧盯结果,需要很强的推动力,架构师不是画几张图就完了,还必须把它落实到架构的原则、架构的元素、系分方案的评审中。因为全局架构师独立于业务线之外,在这样一个环境里推动一个事情往前走是非常困难的,涉及很多的团队协作和沟通。需要有鲜明的观点,并且要能说服很多人,才能得到想要的结果。

更多精彩推荐

☞从Spring Cloud到Service Mesh,微服务架构治理体系如何演进?

“生命游戏之父”因新冠肺炎逝世,回顾数学顽童的一生

AI 时代,为什么程序员很贵?

“手把手撕LeetCode题目,扒各种算法套路的裤子”

区块链十年一梦:有人辞官归故里,有人星夜来赶考

面试造飞机系列:看架构师如何设计微服务接口

你点的每个“在看”,我都认真当成了喜欢

MySQL中这样一张长表:INSERT INTO zhijian.rmo_performance_anti_fraud_long (person_name,metric,current_value,original_value,performance_month,is_consistent,is_agreed,create_time,updated_time) VALUES ('张俊','detected_amount',5335261.10,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('曹刚','detected_amount',10510019.10,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('陈俊晖','detected_amount',5370685.40,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('居安','detected_amount',9413603.60,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('陆诗崑','detected_amount',6322137.80,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('徐佳明','detected_amount',9632521.90,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('姚俊','detected_amount',5054490.20,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('张俊','detection_coefficient',1.00,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('曹刚','detection_coefficient',1.10,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('陈俊晖','detection_coefficient',1.00,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'); INSERT INTO zhijian.rmo_performance_anti_fraud_long (person_name,metric,current_value,original_value,performance_month,is_consistent,is_agreed,create_time,updated_time) VALUES ('居安','detection_coefficient',1.00,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('陆诗崑','detection_coefficient',1.00,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('徐佳明','detection_coefficient',1.10,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('姚俊','detection_coefficient',1.00,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('张俊','operation_performance',3032.00,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('曹刚','operation_performance',3335.20,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('陈俊晖','operation_performance',3032.00,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('居安','operation_performance',3032.00,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('陆诗崑','operation_performance',3032.00,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('徐佳明','operation_performance',3335.20,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'); INSERT INTO zhijian.rmo_performance_anti_fraud_long (person_name,metric,current_value,original_value,performance_month,is_consistent,is_agreed,create_time,updated_time) VALUES ('姚俊','operation_performance',3032.00,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('张俊','detection_batch',19.00,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('曹刚','detection_batch',22.00,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('陈俊晖','detection_batch',18.00,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('居安','detection_batch',26.00,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('陆诗崑','detection_batch',19.00,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('徐佳明','detection_batch',20.00,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('姚俊','detection_batch',18.00,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('张俊','total_recovery_amount',441292.04,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('曹刚','total_recovery_amount',633283.76,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'); INSERT INTO zhijian.rmo_performance_anti_fraud_long (person_name,metric,current_value,original_value,performance_month,is_consistent,is_agreed,create_time,updated_time) VALUES ('陈俊晖','total_recovery_amount',400572.45,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('居安','total_recovery_amount',677921.00,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('陆诗崑','total_recovery_amount',649130.34,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('徐佳明','total_recovery_amount',439785.06,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('姚俊','total_recovery_amount',603742.60,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('张俊','fraud_recovery_rate',0.08,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('曹刚','fraud_recovery_rate',0.06,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('陈俊晖','fraud_recovery_rate',0.08,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('居安','fraud_recovery_rate',0.07,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('陆诗崑','fraud_recovery_rate',0.10,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'); INSERT INTO zhijian.rmo_performance_anti_fraud_long (person_name,metric,current_value,original_value,performance_month,is_consistent,is_agreed,create_time,updated_time) VALUES ('徐佳明','fraud_recovery_rate',0.05,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('姚俊','fraud_recovery_rate',0.12,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('张俊','key_scenario_participation',0.00,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('曹刚','key_scenario_participation',0.00,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('陈俊晖','key_scenario_participation',0.00,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('居安','key_scenario_participation',0.00,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('陆诗崑','key_scenario_participation',0.00,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('徐佳明','key_scenario_participation',0.00,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('姚俊','key_scenario_participation',0.00,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('张俊','personal_score',69.39,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'); INSERT INTO zhijian.rmo_performance_anti_fraud_long (person_name,metric,current_value,original_value,performance_month,is_consistent,is_agreed,create_time,updated_time) VALUES ('曹刚','personal_score',84.89,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('陈俊晖','personal_score',64.20,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('居安','personal_score',95.73,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('陆诗崑','personal_score',85.24,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('徐佳明','personal_score',67.25,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('姚俊','personal_score',82.15,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('张俊','personal_contribution_coefficient',0.00,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('曹刚','personal_contribution_coefficient',0.70,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('陈俊晖','personal_contribution_coefficient',0.00,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('居安','personal_contribution_coefficient',0.70,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'); INSERT INTO zhijian.rmo_performance_anti_fraud_long (person_name,metric,current_value,original_value,performance_month,is_consistent,is_agreed,create_time,updated_time) VALUES ('陆诗崑','personal_contribution_coefficient',0.70,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('徐佳明','personal_contribution_coefficient',0.00,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('姚俊','personal_contribution_coefficient',0.70,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('张俊','team_contribution_reward',0.00,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('曹刚','team_contribution_reward',891.30,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('陈俊晖','team_contribution_reward',0.00,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('居安','team_contribution_reward',1005.14,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('陆诗崑','team_contribution_reward',895.04,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('徐佳明','team_contribution_reward',0.00,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('姚俊','team_contribution_reward',862.57,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'); INSERT INTO zhijian.rmo_performance_anti_fraud_long (person_name,metric,current_value,original_value,performance_month,is_consistent,is_agreed,create_time,updated_time) VALUES ('张俊','recovery_amount',119915.00,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('曹刚','recovery_amount',47551.00,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('陈俊晖','recovery_amount',155772.00,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('居安','recovery_amount',61457.00,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('陆诗崑','recovery_amount',110648.00,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('徐佳明','recovery_amount',92175.00,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('姚俊','recovery_amount',69106.00,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('张俊','resolved_recovery_reward',3998.30,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('曹刚','resolved_recovery_reward',2002.04,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('陈俊晖','resolved_recovery_reward',4715.44,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'); INSERT INTO zhijian.rmo_performance_anti_fraud_long (person_name,metric,current_value,original_value,performance_month,is_consistent,is_agreed,create_time,updated_time) VALUES ('居安','resolved_recovery_reward',2443.71,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('陆诗崑','resolved_recovery_reward',3812.96,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('徐佳明','resolved_recovery_reward',3365.25,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('姚俊','resolved_recovery_reward',2673.18,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('张俊','pending_loss_amount',NULL,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('曹刚','pending_loss_amount',NULL,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('陈俊晖','pending_loss_amount',NULL,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('居安','pending_loss_amount',NULL,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('陆诗崑','pending_loss_amount',NULL,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('徐佳明','pending_loss_amount',NULL,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'); INSERT INTO zhijian.rmo_performance_anti_fraud_long (person_name,metric,current_value,original_value,performance_month,is_consistent,is_agreed,create_time,updated_time) VALUES ('姚俊','pending_loss_amount',NULL,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('张俊','pending_loss_reward',NULL,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('曹刚','pending_loss_reward',NULL,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('陈俊晖','pending_loss_reward',NULL,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('居安','pending_loss_reward',NULL,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('陆诗崑','pending_loss_reward',NULL,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('徐佳明','pending_loss_reward',NULL,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('姚俊','pending_loss_reward',NULL,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('张俊','anti_fraud_report_reward',NULL,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('曹刚','anti_fraud_report_reward',NULL,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'); INSERT INTO zhijian.rmo_performance_anti_fraud_long (person_name,metric,current_value,original_value,performance_month,is_consistent,is_agreed,create_time,updated_time) VALUES ('陈俊晖','anti_fraud_report_reward',NULL,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('居安','anti_fraud_report_reward',NULL,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('陆诗崑','anti_fraud_report_reward',NULL,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('徐佳明','anti_fraud_report_reward',NULL,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('姚俊','anti_fraud_report_reward',NULL,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('张俊','personnel_disposal_reward',NULL,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('曹刚','personnel_disposal_reward',NULL,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('陈俊晖','personnel_disposal_reward',NULL,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('居安','personnel_disposal_reward',NULL,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('陆诗崑','personnel_disposal_reward',NULL,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'); INSERT INTO zhijian.rmo_performance_anti_fraud_long (person_name,metric,current_value,original_value,performance_month,is_consistent,is_agreed,create_time,updated_time) VALUES ('徐佳明','personnel_disposal_reward',NULL,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('姚俊','personnel_disposal_reward',NULL,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('张俊','anti_fraud_reward',NULL,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('曹刚','anti_fraud_reward',NULL,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('陈俊晖','anti_fraud_reward',NULL,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('居安','anti_fraud_reward',NULL,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('陆诗崑','anti_fraud_reward',NULL,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('徐佳明','anti_fraud_reward',NULL,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('姚俊','anti_fraud_reward',NULL,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('张俊','other_rewards',NULL,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'); INSERT INTO zhijian.rmo_performance_anti_fraud_long (person_name,metric,current_value,original_value,performance_month,is_consistent,is_agreed,create_time,updated_time) VALUES ('曹刚','other_rewards',NULL,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('陈俊晖','other_rewards',NULL,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('居安','other_rewards',NULL,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('陆诗崑','other_rewards',NULL,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('徐佳明','other_rewards',2468.00,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('姚俊','other_rewards',NULL,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('张俊','monthly_performance',7030.30,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('曹刚','monthly_performance',6228.54,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('陈俊晖','monthly_performance',7747.44,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('居安','monthly_performance',6480.85,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'); INSERT INTO zhijian.rmo_performance_anti_fraud_long (person_name,metric,current_value,original_value,performance_month,is_consistent,is_agreed,create_time,updated_time) VALUES ('陆诗崑','monthly_performance',7740.00,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('徐佳明','monthly_performance',9168.45,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'), ('姚俊','monthly_performance',6567.75,NULL,'2025-06',NULL,NULL,'2025-07-22 11:09:00','2025-07-22 11:09:00'); 怎么写MySQL查询语句转换成宽表:INSERT INTO zhijian.rmo_performance_anti_fraud (person_name,detected_amount,detection_coefficient,operation_performance,detection_batch,total_recovery_amount,fraud_recovery_rate,key_scenario_participation,personal_score,personal_contribution_coefficient,team_contribution_reward,recovery_amount,resolved_recovery_reward,pending_loss_amount,pending_loss_reward,anti_fraud_report_reward,personnel_disposal_reward,anti_fraud_reward,other_rewards,monthly_performance,create_time,updated_time,performance_month,is_approval,leader_cff) VALUES ('张俊',5335261.10,1.00,3032.00,'19',441292.04,0.08,'0.00',69.39,0.00,0.00,119915.00,3998.30,NULL,NULL,NULL,NULL,NULL,NULL,7030.30,'2025-07-22 11:09:39','2025-07-22 11:09:39','2025-06',NULL,NULL), ('曹刚',10510019.10,1.10,3335.20,'22',633283.76,0.06,'0.00',84.89,0.70,891.30,47551.00,2002.04,NULL,NULL,NULL,NULL,NULL,NULL,6228.54,'2025-07-22 11:09:39','2025-07-22 11:09:39','2025-06',NULL,NULL), ('陈俊晖',5370685.40,1.00,3032.00,'18',400572.45,0.08,'0.00',64.20,0.00,0.00,155772.00,4715.44,NULL,NULL,NULL,NULL,NULL,NULL,7747.44,'2025-07-22 11:09:39','2025-07-22 11:09:39','2025-06',NULL,NULL), ('居安',9413603.60,1.00,3032.00,'26',677921.00,0.07,'0.00',95.73,0.70,1005.14,61457.00,2443.71,NULL,NULL,NULL,NULL,NULL,NULL,6480.85,'2025-07-22 11:09:39','2025-07-22 11:09:39','2025-06',NULL,NULL), ('陆诗崑',6322137.80,1.00,3032.00,'19',649130.34,0.10,'0.00',85.24,0.70,895.04,110648.00,3812.96,NULL,NULL,NULL,NULL,NULL,NULL,7740.00,'2025-07-22 11:09:39','2025-07-22 11:09:39','2025-06',NULL,NULL), ('徐佳明',9632521.90,1.10,3335.20,'20',439785.06,0.05,'0.00',67.25,0.00,0.00,92175.00,3365.25,NULL,NULL,NULL,NULL,NULL,2468.00,9168.45,'2025-07-22 11:09:39','2025-07-22 11:09:39','2025-06',NULL,NULL), ('姚俊',5054490.20,1.00,3032.00,'18',603742.60,0.12,'0.00',82.15,0.70,862.57,69106.00,2673.18,NULL,NULL,NULL,NULL,NULL,NULL,6567.75,'2025-07-22 11:09:39','2025-07-22 11:09:39','2025-06',NULL,NULL);
最新发布
08-04
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值