--- 格式版本: 2 标题: "Guided Star Schema Generation: Bringing AI-Assisted Design to Semantic Model Customization | analytics" 原文链接: "https://blogs.oracle.com/analytics/guided-star-schema-generation-bringing-ai-assisted-design-to-semantic-model-customization" 发布日期: "2026-08-18" 发布时间校准状态: "found" 发布时间需复核: "否" 发布时间来源: "rule:local:strict_original_body" 发布时间证据: "August 18, 2026 3 minute read" 发布时间校准原因: "规则确认唯一严格发布时间，来源 local:strict_original_body" 发布时间校准置信度: "high" 发布时间候选数量: 5 发布时间严格候选数量: 1 发布时间原页读取状态: "source template page reused from URL open" 发布时间未找到原因: "" 发布时间校准时间: "2026-08-21T10:06:06+08:00" 发布时间仲裁状态: "skipped" 发布时间仲裁尝试次数: 0 发布时间仲裁耗时毫秒: 0 发现时间: "2026-08-21T09:56:58+08:00" 入库时间: "2026-08-21T02:06:06.593Z" 来源平台: "固定入口" 搜索渠道: "fixed_url" 搜索词: "https://blogs.oracle.com/?page=news" 匹配关键词: - "AI" 相关厂家: - "Oracle" 相关专家: [] 内容类型: "网页" 抓取工具: "CDP Render" 清洗工具: "CDP Text + Defuddle/Readability 正文提取" 原始附件: [] AI优质: "否" AI打分: 12 AI分档: "非优质" AI质检状态: "不通过" AI打分理由: "内容为Oracle Fusion Data Intelligence的星型模式AI辅助设计功能，属于数据分析/语义模型定制，与超节点、AI Rack、机柜级AI基础设施、供电散热互连等主题完全无关。虽来源权威且正文完整，但无关主题，判为非…" AI质检模型: "ali-deepseek-v4-flash" AI质检时间: "2026-08-21T10:06:30+08:00" AI主题相关性: 0 AI来源权威性: 8 AI新颖性: 0 AI技术细节: 0 AI商业部署信号: 0 AI完整性: 4 AI摘要: "Oracle Fusion Data Intelligence推出向导式星型模式生成功能，用户可在语义模型扩展中通过AI辅助六步创建逻辑星型模型，每一步先预览建议、确认后再生成。" AI摘要模型: "ali-deepseek-v4-flash" AI摘要时间: "2026-09-07T02:13:06.325Z" 采集批次: "2026年8月21日9点50分40秒" 采集批次ID: "20260821-095040-035" 去重键: "https://blogs.oracle.com/analytics/guided-star-schema-generation-bringing-ai-assisted-design-to-semantic-model-customization" --- **Requirements for Generating a Star Schema** If you want to build a well-designed star schema, apart from technical skills, you need to have a good understanding of dimensional modeling principles, have patience for a detailed setup process, and have sufficient experience to avoid the pitfalls that arise later in a slow query or a report that doesn’t quite reconcile. **Guided Star Schema Generation** Guided star schema generation is a new customization feature designed to help you easily customize your semantic model. An AI-assisted, guided experience helps you build the logical stars faster and more consistently, allowing you to make your decisions. Guided star schema generation acts as a knowledgeable collaborator: interpreting what you need, proposing a path forward, and working along with you to confirm or adjust every step along the way. The AI assistance offers: - **Alignment** – Translates your requirements into relevant schema suggestions. - **Streamlining** – Reduces low-level design effort so that you quickly customize. - **Accuracy** – Suggests recommendations for you to review and confirm before generating the final star. - **Consistency** – Ensures that the dimensional modeling principles are applied. **Steps in the Guided Flow** The guided flow breaks star creation into six clear steps: 1. **Identify Requirement** –You select the fact table and provide the context. 2. **Interpret Context** -The system proposes relevant entities and dimensions based on the context. 3. **Confirm Direction** – You confirm or modify the suggested entities. 4. **Preview Joins** – An LLM suggests the dimensional joins for your review. 5. **Adjust Joins** – You add, delete, or modify joins as required. 6. **Generate Star** – The system creates the final star once everything is confirmed. At every stage, you see what’s proposed before building. Nothing is generated behind the scenes without a checkpoint. **Design of the AI Assistance** The underlining design principle is simple; this is an assistive AI that supports better decisions and collaborates with user’s decisions. The experience is deliberately built to maintain a balance between control and delegation: - Candidate dimensions are previewed *before* joins are generated. - You can add, delete, or modify joins before you confirm the final star. - Every recommendation is a suggestion, and you decide what you need for the model. The result is a customization experience that moves at AI speed while still reflecting your decisions. A true partnership between guided intelligence and hands-on expertise. **Generating a Star Schema with AI assistance** 1. Open the Semantic Model Extensions page in Oracle Fusion Data Intelligence Console. 2. On the selected sandbox Details page, click **Perform Action**, select **Manage Logical Star**, and then select **Create Logical Star**. 3. On the Logical Star page, click **Auto Generate Logical Star**. 4. Use AI-assisted navigation. Follow the assisted navigation for specifications for the star schema. - Review the selected dimensions and their join columns, then click **Finish** to generate the star schema. You can edit and extend the generated star schema as required. **Generation Supports Adoption** This simple solution extends the semantic model shipped with Oracle Fusion Data Intelligence and enables you to use custom content. - Accelerates time to insight. - Promotes reuse of prebuilt and governed assets and extending assets. - Reduces dependency on administrators and experts **Roll Out Generation as Part of Enablement** To maximize impact, save time, and improve efficiency, introduce the guided star schema generation in semantic model extensions as a part of your Oracle Fusion Data Intelligence enablement plan rather than building individual dimensions and facts. **Summary** Oracle Fusion Data Intelligence provides organizations a strong foundation of prebuilt content along with a strong extensible platform. Natural language interaction with the platform leverages AI to do the modeling, making it robust and performant. **Call to Action** Try the AI-assisted guided star schema generation in semantic model extensions in your Oracle Fusion Data Intelligence environment and share feedback through the Oracle Analytics Community channels. We want your feedback. If you have suggestions or discover an issue while working with this experience, inform Oracle Support or your Center of Excellence counterpart so that the team can continue improving the experience for all Oracle Fusion Data Intelligence users. Related resources: [Explore Oracle Fusion Data Intelligence Content](https://docs.oracle.com/en/cloud/saas/analytics/26r2/fawug/explore-oracle-fusion-data-intelligence-content.html) [Oracle Fusion Data Intelligence](https://www.oracle.com/fusion-data-intelligence/) [Oracle Analytics Community](https://community.oracle.com/products/oracleanalytics/)