3140 - 使用 Db2 13 for z_OS 执行 AI 查询.pdf

1、Sponsored byData Technical Summit IBM TechXchange 2025Performing AI Queries with Db2 13 for z/OS3140Performing AI Queries with Db2 13 for z/OSArtem Minin,Technical Specialist,WSCJohn Goodyear,Technical Specialist,WSCAgenda0102SQL Data Insights OverviewTechZone Lab EnvironmentIBM TechXchange|2025 IBM

2、 CorporationWhat is SQL Data Insights?2025 IBM Corporation 3SQL Data Insights(SQL DI)No-charge downloadable feature of Db2 13 to let you uncover hidden insights in your business data through semantic AI functions IBM TechXchange|2025 IBM Corporation4SQL Data InsightsHow?Select columns from table or

3、view to train and enable AI queries SDI creates vector embeddings powered by IBM research technology A vector embedding is a numerical representation of data that captures its meaning and relationships to other dataWhat?Query data based on semantics rather than explicit keywords Example:find the top

4、 20 most similar customers to“1234”Why?Faster&deeper analysis and action from the data stored on mainframes Zero cost of moving data Less concerns regarding security No need to reserve data scientists Utilize existing investments on the mainframeIBM TechXchange|2025 IBM Corporation5New Semantic AI S

5、QL FunctionsAI_SIMILARITYFind similar entitiesAI_SEMANTIC_CLUSTERFind entities that belong to a group of entitiesAI_COMMONALITYFind most common entities or outliersAI_ANALOGYAnalyze relationships between a pair of entitiesIBM TechXchange|2025 IBM Corporation6With SQL Data Insights,Db2 z/OS isThe ind

6、ustrys firstfirst relational database with embedded AI capabilitiesThe industrys firstfirst vector database for relational data 7Why vectors?8Vectors are used by AI Models to Understand Information9138,195,247,138,195,246,137,194,245,201,194,191,198,191,188,189,182,179,*,164,155,152,161,152,149,173,