ryan-giggs.hashnode.devOracle AI Vector Search: Querying Vectors and Optimizing with IndexesOracle Database 23ai's AI Vector Search enables powerful semantic search capabilities, but to truly harness its potential, you need to understand how to query vector data efficiently and when to use vector indexes. This guide explores querying vector...6d ago·9 min read
ryan-giggs.hashnode.devAnalytics EngineeringWeek 4 of Data Engineering Zoomcamp by @DataTalksClub complete Just finished Module 4 - Analytics Engineering with dbt. Learned how to: ✅ Build transformation models with dbt ✅ Create staging, intermediate, and fact tables ✅ Write tests to ensure dat...Feb 15·1 min read
ryan-giggs.hashnode.devData Warehousing & BigQueryWeek 3 of Data Engineering Zoomcamp by @DataTalksClub complete! Just finished Module 3 — Data Warehousing with BigQuery. Learned how to: Create external tables from GCS bucket data Build materialized tables in BigQuery Partition and cluster tables f...Feb 8·1 min read
ryan-giggs.hashnode.devOracle AI Vector Search Workflow: From Data to Semantic SearchOracle Database 23ai introduces AI Vector Search, a powerful feature that enables semantic search capabilities directly within the database. Unlike traditional keyword-based searches, vector search understands the meaning and context behind your quer...Feb 6·14 min read
ryan-giggs.hashnode.devUnderstanding Semantic Search: Vector Embeddings and Similarity SearchSemantic search represents a fundamental shift in how we retrieve information from databases and search engines. Unlike traditional keyword-based search that relies on exact text matches, semantic search understands the meaning and context behind que...Feb 2·14 min read