Fundamentals: Analytics

GesamtDB extends SQL with AI operators for multimodal analytics on relational data.

The SQL extensions include five AI operators:

• AIFILTER: semantic boolean filtering in WHERE predicates
• AICLASSIFY: assignment of one label from a user-defined label set
• AISCORE: semantic scoring in a user-defined numeric range
• AIMAP: semantic extraction, transformation, or summarization
• AIJOIN: semantic matching between values from two tables

Operator details:

• AIFILTER
• AICLASSIFY
• AISCORE
• AIMAP
• AIJOIN

GesamtDB automatically detects stored data types (text, image, audio) and selects suitable LLM models for each operator call.