および cancelled の受注は売上高に含めない。 orders テーブル(Glue Data Catalog) order_id customer_id product_id quantity total_amount order_date status 値: shipped / pending / cancelled status のどの値が売上高に入るかは、テーブルには書かれていない SELECT c.region, COALESCE(SUM(CAST(o.total_amount AS DOUBLE)), 0) AS total_sales FROM orders o JOIN customers c ON o.customer_id = c.customer_id GROUP BY c.region ORDER BY total_sales DESC -- WHERE status = 'shipped' がない AI が生成して実行された SQL(記事の Compiled artifacts より) 知識の地図を描く ─ オントロジーとは何か? | DevelopersIO 2026 6
Context Ontology Accelerator(COA)で日本語のオントロジーを構築してみ た」DevelopersIO, 2026-08-30 https://dev.classmethod.jp/articles/20260830-aws-context-v022/ T. Gruber, A Translation Approach to Portable Ontology Specifications, 1993 https://tomgruber.org/writing/ontolingua-kaj-1993/ A. Hogan et al., Knowledge Graphs, ACM Computing Surveys, 2021 https://arxiv.org/abs/2003.02320 L. Obrst, Ontologies for Semantically Interoperable Systems, CIKM 2003 http://jfsowa.com/ikl/Obrst03.pdf AWS What's New: Context Ontology Accelerator, 2026-07-31 W3C: OWL 2 Primer / SHACL / SKOS Reference https://aws.amazon.com/about-aws/whats-new/2026/07/aws-context--ontology-accelarator-generally-available/ https://www.w3.org/TR/owl2-primer/ / https://www.w3.org/TR/shacl/ / https://www.w3.org/TR/skos-reference/ Context Ontology Accelerator(GitHub / ドキュメント) J. Sequeda et al., A Benchmark to Understand the Role of Knowledge Graphs on LLM's Accuracy, 2023 https://github.com/aws/context-ontology-accelerator / https://aws.github.io/context-ontology-accelerator/ https://arxiv.org/abs/2311.07509 AWS ML Blog「Context intelligence for your data and AI agents at scale」202606-17 https://aws.amazon.com/blogs/machine-learning/context-intelligence-for-your-data-and-ai-agents-at-scale/ D. Allemang, J. Sequeda, Increasing the LLM Accuracy for Question Answering: Ontologies to the Rescue!, 2024 https://arxiv.org/abs/2405.11706 AWS Glue Developer Guide「Adding business context」 dbt Labs, Semantic Layer vs. Text-to-SQL: 2026 Benchmark Update https://docs.aws.amazon.com/glue/latest/dg/catalog-business-context.html https://docs.getdbt.com/blog/semantic-layer-vs-text-to-sql-2026 A. Karpathy「llm-wiki」gist, 2026-04 D. Edge et al., From Local to Global: A Graph RAG Approach, 2024 https://gist.github.com/karpathy/442a6bf555914893e9891c11519de94f https://arxiv.org/abs/2404.16130 AWS Prescriptive Guidance「Semantic Layer for Agentic AI using Ontology, Symbolic Reasoning, and Virtual Knowledge Graph」 https://docs.aws.amazon.com/prescriptive-guidance/latest/semantic-layer-agentic-ai-ontology-reasoning-virtualknowledge-graph/ 知識の地図を描く ─ オントロジーとは何か? | DevelopersIO 2026 Palantir / Microsoft Fabric IQ / Databricks / Snowflake / Google Cloud の各公開ド キュメント(34 枚目) palantir.com/docs / learn.microsoft.com/fabric/iq / databricks.com/blog / snowflake.com/blog / cloud.google.com/blog 59