为生成式BI描述数据表和业务语义,提高大模型生成准确SQL的效率
明确告知大模型字段类型、字段属于维度还是度量、关联键信息、维度枚举值的业务含义以及枚举值是否可穷举;使用数据库中的真实值替代问题中的条件,并正确应用指标过滤条件。例如,将“上海地区”映射为 shanghai,将“男装”映射为 IN ('boy shirt', 'boy shoes', 'boy pants', 'boy coat'),且销售金额仅统计 status = 'finished' 的已完成订单。
MOSS: A Production Framework for Monitoring and Diagnosing Semantic Failures in Search and Recommendation Systems
Alina Nesen · Prathyusha Kanmanth Reddy · David Relyea · Rohit Avinash Mujumdar · Samaneh Karimi · Bo Shen · et al.
生产环境中推荐与搜索系统的语义故障检测困难,行为指标滞后且人工审查难以扩展。MOSS 框架将基于 LLM 的相关性评分嵌入持续监控循环,结合定向采样、策略感知提示及结构化告警,将故障归类为可操作的根因。该框架在美国大型零售商的生产环境中运行超过六个月,覆盖推荐、搜索及优惠界面,并发现两个已确认的服务缺陷。针对其中一项回填混合缺陷,MOSS 离线量化修复方案使告警率相对降低 76.4%。在 498 对人工标注的推荐基准上,前沿 LLM 评判器在 F1 和 AUC 上优于非 LLM 基线(内部生产嵌入和 SBERT),在需要意图级关系推理的任务上增益最大。同一评判器、评分尺度及阈值仅需表面特定提示适配即可迁移至涵盖 21 个查询的 466 对搜索基准,无需重新调参即实现强 F1 和 AUC 表现。
尚无解读。
arXiv:2610.26902v1 Announce Type: cross Abstract: Detecting semantic failures in production recommendation and search systems is hard: behavioral metrics lag by days, manual review does not scale, and most LLM evaluation frameworks are designed for offline, fixed datasets rather than continuous operational monitoring. We present Model Sanity Service (MOSS), a production framework that addresses this operational gap by embedding LLM-based relevance scoring into a recurring monitoring loop with targeted sampling, strategy-aware prompting, structured alerting, and diagnostic follow-up prompting that categorizes failures into actionable root causes. MOSS has been running in production at a large U.S. retailer for over six months across recommendation, search, and offer surfaces, and has surfaced two confirmed serving defects. For one of these, a backfill blending defect, MOSS quantified the impact of the proposed fix offline as a 76.4\% relative reduction in alert rate. On a 498-pair human-annotated recommendation benchmark, frontier LLM judges achieve higher F1 and AUC point estimates than non-LLM baselines (internal production embeddings and SBERT), with the largest gains on strategy-dependent tasks requiring intent-level relational reasoning. The same judge, score scale, and threshold transfer to a 466-pair search benchmark spanning 21 queries with only a surface-specific prompt adaptation, achieving strong F1 and AUC without retuning. These results show that a single LLM monitoring framework can provide useful, actionable quality signals across multiple product discovery surfaces in a large-scale e-commerce setting.
明确告知大模型字段类型、字段属于维度还是度量、关联键信息、维度枚举值的业务含义以及枚举值是否可穷举;使用数据库中的真实值替代问题中的条件,并正确应用指标过滤条件。例如,将“上海地区”映射为 shanghai,将“男装”映射为 IN ('boy shirt', 'boy shoes', 'boy pants', 'boy coat'),且销售金额仅统计 status = 'finished' 的已完成订单。
LLM 角色和任务描述 Freewheel 广告业务介绍 术语黑话映射表: 包括了常见的黑话和通过 RAG 方式召回的部分 数据目录与仓库概述 候选表和列:也就是上一步召回的表和列,包括每个表的描述和选表逻辑 通用选表规则:应该遵守的规则,例如什么时候应该选择事实表或者维度表,什么时候应该选择多张表 选表样例:我们收集了多样化的问题并标注了最优选择的表,存储到选表样例向量数据库中,通过 RAG 的方式找到和用户提问相似的例子。
我将在[目标国家]推出[产品/服务],希望深入了解我的潜在客户。根据当地市场,创建 2-3 个关键买家角色(包括人口统计、目标、痛点和购买行为)。针对每个角色,列出他们使用的最相关的沟通渠道(如社交平台、消息应用程序、论坛)。还包括文化细微差别、偏好以及任何可能影响其购买决策的行为洞察。
Rank the following features for our [TYPE OF PRODUCT/SERVICE] based on customer preferences: [PRODUCT FEATURES]. Provide insights into which feature should be prioritized in our marketing efforts.
Role: Act as a senior market research analyst specializing in digital advertising and cross-border e-commerce. Task: Create a detailed country entry report for ${insert_country_name}to help me sell products using Meta Ads (Facebook/Instagr…