Episodic, semantic, procedural: Oracle's Spring AI sample splits agent memory into three stores
AlexAtOracleAIDB · reddit · 2026-11-13
An Oracle developer sample (posted by someone on the Oracle AI Database team) splits agent memory into three layers with different storage. Episodic: conversation history in a relational table via Spring AI's JDBC chat memory repository, with MessageChatMemoryAdvisor pulling the last 100 messages per request. Semantic: domain knowledge via RetrievalAugmentationAdvisor running hybrid search — vector similarity for paraphrases plus keyword matching for exact strings like order IDs, merged with Reciprocal Rank Fusion; embeddings come from an ONNX all-MiniLM-L12-v2 model loaded into the database, and the hybrid vector index syncs in the background. Procedural: u/Tool Java methods (order lookup, returns) registered on the ChatClient and invoked by a local Ollama model — though the author notes these are developer-written procedures, not learned ones. Chat history, the retrieval index, and order tables share one instance and connection pool.
More from coding & agent
- Amplitude launches Wave: AI that decides what to build next from product data — testingcatalog · 2026-11-13
- jxnlco: when AI makes you faster, go deep on new things and grow your taste — jxnlco · 2026-11-13
- jxnlco at DeepMind-backed Code Summit: 'if you want good taste, you have to eat' — jxnlco · 2026-11-13
- Vibe-coded space-defense game ORBITAL SIEGE shows Three.js gameplay from one prompt — kimmonismus · 2026-11-13
- AI-generated WebGL2 shader bends light around a black hole on the first try — kimmonismus · 2026-11-13
- Sententos puts a personal agent in your Mac's notch that can take over your screen — ycombinator · 2026-11-13