• About Heli

HeliFromFinland

~ Heli's thoughts on Machine Learning, AI, AI Agents, Database Designing, Oracle SQL Developer Data Modeler, User Groups and much more

HeliFromFinland

Author Archives: Helifromfinland

Select AI Agents: Santa’s Workshop Runs on Oracle, Reindeer Health Copilot. And the wrap up. (6/6)

24 Wednesday Dec 2025

Posted by Helifromfinland in AI Agents

≈ Leave a comment

Tags

agents, ai, christmas, Oracle, selectai

By Heli and Marko Helskyaho

Last but definitely not least:

Reindeer Health Copilot: Santa’s AI veterinarian on Duty 24/7.

Reindeer Health Copilot is a proactive wellness guardian or a “digital veterinarian” for Santa’s nine famous reindeer, ensuring they’re flight-ready for Christmas Eve. It monitors real-time vitals, predicts fatigue or issues, and recommends fixes to keep the team flight-ready for the big night. 

What this Agent does:

  1. Ingests real-time telemetry: Pulls data from sensors (heart rate, steps, “carrot intake” as energy proxy, flight altitude stress, rest hours) stored as time-series JSON in tables like REINDEER_TELEMETRY.
  2. Analyzes trends: Uses hybrid search across:
    • Relational metrics for current stats.
    • Vector embeddings of historical health logs to spot patterns (for example, “Prancer’s heart rate spikes in cold winds”).
    • Graph connections to team dynamics (for example, “Dancer’s pace affects Cupid’s endurance”).
  3. Reasons Proactively: Follows the ReAct loop:
    • Runs NL2SQL for quick aggregates (for example, “Average carrot consumption last 7 days”).
    • Calls weather REST APIs for environmental risks (for example, icing on antlers).
    • Uses LLM reasoning to score flight readiness and simulate scenarios (for example, “What if we hit turbulence over the Atlantic?”).
  4. Acts and alerts: Recommends or automates actions. On Christmas Eve (today!), it runs continuous checks for last-minute go/no-go decisions.

Built with Select AI Agents’ ReAct (Reasoning + Acting) pattern, the Copilot follows a loop:

Observe (gather data), Reason (analyze with an LLM), Act (execute tools), and Reflect (learn from outcomes). Everything runs natively in Oracle Autonomous Database 26ai, inheriting enterprise security like row-level access (e.g., only elves with clearance see Blitzen’s vitals). Key components of the solutions are:

  • Data Sources:
    • Time-series JSON logs (REINDEER_TELEMETRY table with fields like reindeer_id, timestamp, carrot_intake, heart_rate, flight_hours).
  • Tools Used:
    • NL2SQL: Converts natural questions like “Is Vixen overworked?” into optimized queries.
    • RAG (Retrieval-Augmented Generation): Pulls context from vectorized health guidelines or past incident reports.
    • LLM Reasoning: Uses OCI GenAI or a local model (for example, Llama via Ollama) to score risks and simulate scenarios.
    • External Integration: REST calls to weather APIs for flight risk assessment.
  • Memory: Maintains short-term (current flight) and long-term (seasonal trends) context for multi-turn interactions.

This could be a sample report from the agent:

Korvatunturi Health Bulletin – Christmas Eve 2025  

Scanning telemetry for Dasher, Dancer, Prancer, Vixen, Comet, Cupid, Donner, Blitzen, and Rudolph…  

Overall Fleet Status: GREEN – 98.4% readiness  

• Rudolph: Nose glow at 100% (extra bright for fog over London). Carrot intake optimal.  

• Dasher & Dancer: Top speed calibrated; minor wind chill noted—recommend heated blankets pre-takeoff.  

• Prancer & Vixen: Energy reserves high after double oats; no issues. 

• Comet & Cupid: Slight fatigue trend from rehearsals (+8% heart rate)—suggest 30-min rest cycle now.  

• Donner & Blitzen: Thunder-ready; weather API shows clear skies ahead.  

Predicted Risks: 3% chance of mid-Pacific yawn spike, mitigated by in-flight snack protocol.  

All systems ho-ho-go! Sleigh cleared for departure at 20:00 UTC.  

Merry Christmas to all, and to all a safe flight! 🦌✨

(Sources: REINDEER_TELEMETRY_VECTORS, WEATHER_API, FLIGHT_HISTORY)

Why it’s technically impressive (and Reindeer-approved)

  • Predictive power: Spots issues hours ahead using time-series trends and vector similarity to past Christmases.
  • Secure as the Korvatunturi Vault: All vitals stay in the database. Row-level security prevents unauthorized elf (or hacker) peeks at Rudolph’s glow metrics.
  • Scales to Christmas crunch: Handles billions of telemetry points efficiently even during tonight’s peak.
  • Real-world twin: Swap reindeer for delivery trucks, wind turbines, or hospital monitors and the same agent framework keeps operations humming.

The Reindeer Health Copilot is the agent making sure everything runs smoothly tonight… because even Santa needs a copilot. 🎅🦌

Ho ho healthy holidays!

How were all these components created? Here’s some code examples.

To create the ReindeerHealthCopilot agent:

BEGIN

  DBMS_CLOUD_AI_AGENT.CREATE_AGENT(

    agent_name => ‘ReindeerHealthCopilot’,

    attributes => ‘{

       “profile_name”: ‘OCI_GPT4O’,

        “role”: “You are a jolly reindeer health expert. Analyze data, predict issues, and suggest fixes with festive optimism.”

     }’,

     description    => ‘Monitors reindeer vitals for Christmas readiness’

  );

END;

/  

Add some Tools:

BEGIN

  DBMS_CLOUD_AI_AGENT.CREATE_TOOL(

    tool_name  => ‘WeatherForecast’,

    attributes => ‘”instruction”: “This tool fetches and returns the weather forecast from the specified URL.”,

      “function”: “get_url_content”

‘

  );

END;

/

: more tools

: more tools

Create some Tasks:

BEGIN

  DBMS_CLOUD_AI_AGENT.CREATE_TASK(

    task_name => ‘ReindeerHealthTask’,

    attributes => ‘{“instruction”: “Handle reindeers: {query}”,

                    “tools”: [“REINDEER_HEALTH_VECTORS”, “WeatherForecast”]}’

  );

END;

/

: more tasks

: more tasks

Create the Team:

BEGIN                                                               

  DBMS_CLOUD_AI_AGENT.CREATE_TEAM( 

    team_name  => ‘SantasAgents’,                                                           

    attributes => ‘{“agents”: 

[{“name”:”NiceList Analyst”,”task” : “NiceListTask”},

 {“name”:”WishList Resolver”,”task” : “WishlistTask”}

 {“name”:”SleighRoute Optimizer”,”task” : “SleighRouteTask”}

 {“name”:”Giftwrap Foreman”,”task” : “GiftwrapTask”}

 {“name”:”ReindeerHealth Copilot”,”task” : “ReindeerHealthTask”}],

                    “process”: “sequential”}’

);                                                               

END;                                                                     

/

And finally an example of calling the Agents:

l_response :=  DBMS_CLOUD_AI_AGENT.RUN_TEAM(

  team_name   => ‘SantasAgents’,

  user_prompt => ‘Check Comet”s energy levels after last rehearsal. Flight tomorrow?’

 ,params      => ‘{“conversation_id”: “‘ || l_conversation_id || ‘”}’

);

Why Santa (and every CIO) loves Select AI Agents:

  • Zero data leaves Korvatunturi (or your data center) 
  • Agents respect row-level security (for example, Mrs. Claus still can’t see the Naughty list) 
  • Quick response even with billions of wish-list rows 
  • Full audit trail for when the EU asks why little Pierre got coal 
  • Scales from one laptop demo to planetary delivery night without code changes

With Select AI Agents, your database doesn’t just store data. The database thinks, reasons, and acts like the world’s jolliest autonomous workforce. 

Merry Christmas! 🤶🧑‍🎄🌲🎁 🦌

Select AI Agents: Santa’s Workshop Runs on Oracle, GiftWrap Foreman (5/6)

24 Wednesday Dec 2025

Posted by Helifromfinland in AI Agents

≈ Leave a comment

Tags

ai, artificial-intelligence, machine-learning, technology

By Heli and Marko Helskyaho

GiftWrap Foreman: The Select AI Agent orchestrating Santa’s wrapping line.

The GiftWrap Foreman is the production manager for the Korvatunturi’s wrapping stations, ensuring every gift is packaged perfectly, on time, and with zero waste. This agent automates manufacturing workflows, like just-in-time inventory in factories or order fulfillment in e-commerce, all executed securely within your database. The GiftWrap Foreman balances loads, predicts bottlenecks, and triggers robotic wrappers keeping the sleigh on schedule without a single unwrapped box left behind.

What It actually does.

  1. Monitors inventory queues: Watches for incoming assignments from agents like WishList Resolver (the GIFT_MANIFEST table), tracking stock levels, wrapping materials (ribbon, paper patterns), and station capacities.
  2. Assesses and prioritizes: Uses hybrid search to scan:
    • Relational data for gift specifications (size, fragility, personalization like “From Santa”).
    • Vector embeddings of past wrapping patterns to match optimal methods (for example, “sparkly paper for fairy rugs”).
    • JSON logs from robotic arms for real-time status (for example, “Station 7: 80% uptime”).
  3. Reasons and dispatches: Leverages the ReAct pattern for smart allocation:
    • Predicts delays with time-series analysis (for example, “Peak hour jam at fragile toy line”).
    • Calls external REST APIs for supply checks (for example, ribbon vendor stock).
    • Reflects on efficiency, rerouting tasks (for example, “Shift bike wraps to Station 12”).
  4. Executes and reports: Triggers PL/SQL procedures to activate robots or alert elves, updates the manifest, and generates shift reports. If materials run low, it auto-orders via integrated suppliers.

l_response := DBMS_CLOUD_AI_AGENT.RUN_TEAM(
team_name => ‘SantasAgents’,
user_prompt => ‘Incoming: 1,247 SparkleWeave Fairy Rugs for London kids. Prioritize glitter paper, check Station 3 capacity, and flag if bows are low.’
,params => ‘{“conversation_id”:”‘ || l_conversation_id || ‘”}”
);

Based on the prompt it knows to choose GiftWrap Foreman Agent from the Agent Team.

Sample response:

Wrapping orders received. Let’s deck the halls efficiently!

Queue Analysis: 1,247 Fairy Rugs (fragile level: medium, size: small). Glitter paper stock: 1,500 sheets (sufficient). Station 3 at 65% capacity (idle bots available).

Optimized Dispatch:  

Batch 1-400 to Station 3 (ETA: 14:22, using auto-bow applicator).  

Batch 401-800 to Station 5 (cross-trained elves for custom tags).  

Batch 801-1,247 to robotic line 9 (high-speed wrap, 98% ribbon match).

Alerts: Bows low (projected shortage by 18:00)—auto-order 500 units from ElfThread API (delivery: 23-Dec 16:45). Waste minimized: 0.2% paper trim.

Manifest updated in GIFT_QUEUE. All gifts sleigh-ready by 20:00!

Tinsel up, bottlenecks down. Ho ho hustle! 🎀🤖 

(Sources: WRAP_INVENTORY_VECTORS, STATION_LOGS, SUPPLIER_REST)

Why it’s technically impressive: 

  • Workflow automation: Combines NL2SQL for queue queries, RAG for material matching, and REST tools for vendor syncs, scaling to millions of gifts without custom code.
  • Predictive precision: Uses graph analytics to model station flows, preventing jams like Black Friday overloads or Christmas Eve rush.
  • Secure and traceable: Enforces row-level security; audits every wrap for “Why did this bike get red paper?” compliance.
  • Beyond the Holidays: Repurpose for warehouse operations, dispatch pickers, optimize packing lines, or many more tasks, all in your Oracle data perimeter.

The GiftWrap Foreman gets your gifts wrapped faster than a reindeer can prance. It’ll tie up your loose ends with a bow on top! 🎁🛠️

Select AI Agents: Santa’s Workshop Runs on Oracle, Sleigh Route Optimizer (4/6)

24 Wednesday Dec 2025

Posted by Helifromfinland in AI Agents

≈ Leave a comment

Tags

ai, artificial-intelligence, business, technology

By Heli and Marko Helskyaho

Sleigh Route Optimizer: The Select AI Agent keeping Santa’s deliveries on track.

The Sleigh Route Optimizer is the logistics brain that ensures Santa doesn’t miss a single chimney on Christmas Eve. It’s an autonomous agent designed to dynamically recalculate Santa’s global delivery path in real-time, handling everything from last-minute address changes to blizzard reroutes. With 1.9 billion stops across 195 countries, one kid’s move or an 11th-hour wish could cascade into hours of delays! The Optimizer prevents that by blending graph analytics, external data pulls, and LLM-powered reasoning, all inside Oracle Autonomous Database 26ai, inheriting the same ironclad security that protects the Naughty List.

What does this AI Agent do?

  1. Monitors triggers: Watches for changes on event streams. For example, a child relocates (update on CHILD_ADDRESSES table) or adds a wish (from WishList Resolver). 
  2. Gathers context: Uses hybrid search to pull:
    • Spatial data for chimney coordinates and no-fly zones (for example, airports).
    • Relational tables for delivery windows and gift weights.
    • Graph analytics on the “world delivery network” (nodes: houses; edges: flight paths weighted by wind, fuel, and reindeer fatigue).
  3. Reasons and optimizes: Employs the ReAct loop for multi-step planning:
    • Queries weather APIs (REST tool) for real-time headwinds.
    • Runs graph shortest-path algorithms to minimize distance while maximizing “magic factor” (e.g., grouping by time zone).
    • Reflects on constraints like reindeer endurance (cross-referencing Reindeer Health Copilot) and iterates if needed (for example, “Swap Prancer for Rudolph on icy routes?”).
  4. Executes and updates: Outputs an optimized route manifest as JSON, triggers sleigh adjustments via PL/SQL, and logs the plan for audits. If risks spike, it escalates to Santa with alternatives.

An example call to the Agent is done by calling the Team. Based on the prompt it knows what Agent to call. Let’s see an example of a last minute change on the gift wish:

l_response :=  DBMS_CLOUD_AI_AGENT.RUN_TEAM(

  team_name   => ‘SantasAgents’,

  user_prompt => ‘Suzy in Singapore just changed her wish from LEGO to a drone. Can we still make it by Christmas Eve?’

 ,params      => ‘{“conversation_id”: “‘ || l_conversation_id || ‘”}’

);

Sample response:

Checking… Suzy’s original wish was LEGO Creator 31142 (stock: 2,847 units in APAC warehouse).
New request: DJI Mini 4 Pro (stock: 11 units, arriving Singapore 23-Dec 14:20).
Route recalculated: Sleigh-7 can pick up during existing Singapore window at 02:14:31 local time.
Updated manifest sent to GiftWrap Foreman.
Drone secured. Suzy stays on Nice List.
Ho ho ho! Merry Christmas! Only 1,234,567 more houses to go! 

Another example of five kids changing their address:

l_response := DBMS_CLOUD_AI_AGENT.RUN_TEAM(
team_name => ‘SantasAgents’,
user_prompt => ‘Reroute for Tokyo: 5 new kids added in Shibuya district due to family move. Factor in 20mph winds from the north.’
,params => ‘{“conversation_id”:”‘ || l_conversation_id || ‘”}”
);

Sample Response:

Route recalculation underway, Santa! Analyzing 847,392 Asia-Pacific stops…

Original ETA Impact: +14 minutes delay from Tokyo insert (Shibuya cluster: 5 new houses, avg. gift weight 2.3kg). Winds at 20mph NNE could add 8% drag on Sleigh-3.

Optimized Plan:  

Shift Tokyo window to 23:47-00:12 JST (post-wind peak).  

Reroute via Yokohama detour: Total distance -2.7km, fuel savings 1.4 carrots equivalent.  

Reindeer swap: Dasher leads (high-wind specialist); Prancer rests.  

New sequence: House #JP-456 → #JP-789 (new Shibuya) → #JP-012 (group +12% efficiency).

Global impact: Zero net delay. Full manifest updated in SLEIGH_PLAN table.

Clear skies ahead—ho ho hover! 🛷🌪️ 

(Sources: WORLD_GRAPH, WEATHER_REST, REINDEER_VITALS)

Why It’s Technically Impressive (and Logistics-Game-Changing)

  • Graph-powered smarts: Leverages Oracle’s spatial and graph features for Traveling Salesman Problem variants.
  • Real-time resilience: Handles “11th-hour” chaos, using NL2SQL for quick data pulls and RAG for historical route learnings.
  • Secure by design: Row-level security ensures only cleared elves see classified paths and full audits for “Why did we skip Fiji?” queries.
  • Enterprise mirror: Translate to real operations: optimize delivery fleets for Amazon, reroute trucks amid traffic, or plan field service techs, all without data leaving your Oracle perimeter.

The Sleigh Route Optimizer optimizes the sleigh (or supply chain) faster than you can say “Rudolph with your nose so bright!” 🎅🗺️

Select AI Agents: Santa’s Workshop Runs on Oracle, WishList Resolver Agent (3/6)

24 Wednesday Dec 2025

Posted by Helifromfinland in AI Agents

≈ Leave a comment

By Heli and Marko Helskyaho

WishList Resolver: The Select AI Agent that turns vague dreams into deliverable gifts.

The WishList Resolver is the magical middleman between a child’s wild imagination and Santa’s finite toy inventory. It’s a fully autonomous agent that takes fuzzy, last-minute wishes (like “I want a puppy that never grows” or “a robot that sings Jingle Bells”) and translates them into precise, stock-available gift recommendations, all while respecting the Korvatunturi’s strict data privacy rules.

This agent uses natural language understanding, hybrid search, and tool orchestration to handle ambiguous queries in real-time, making it a blueprint for e-commerce recommendation engines or customer intent resolvers in any enterprise.

How does this agent work?

  1. Parses the wish: 
    • Starts with natural language input from a child (or parent), using an LLM to break it down into key attributes (age-appropriate, category, features, budget constraints, e.g., “under $50 for a 7-year-old”).
  2. Searches the catalog: Leverages Oracle’s unified hybrid search to query:
    • Relational tables for toy specs (price, age range, availability).
    • Vector embeddings of product descriptions to match semantic intent (for example, “eternal puppy” → stuffed animals with “low-maintenance” tags).
    • JSON docs for user history (past gifts, allergies) and graph analytics for trending items.
  1. Reasons and ranks: Applies the ReAct pattern to iterate:
    • Scores matches based on similarity and stock levels.
    • Checks for substitutes if exact matches are out (for example, cannot find real flying carpet, suggest a drone with lights or a carper with magical pattern).
    • Factors in logistics like “deliverable by Christmas Eve” via integrated route data.
  2. Resolves and responds: 
    • Outputs a curated list with reasons, images (if multimodal), and confirmation updating the manifest via PL/SQL if approved. Everything stays in the database for zero-leak security.

EXEC DBMS_CLOUD_AI_AGENT.set_team(team_name  => ‘SantasAgents’);

SELECT AI AGENT I want a magical flying carpet for my dollhouse, but it has to be sparkly and safe for a 6-year-old girl in London

Sample response:

Ho ho ho! Let’s make that wish come true, little dreamer! Your “magical flying carpet” sounds like a cozy adventure for your dollhouse. Scanning the Korvatunturi catalog…

Top Match (92% Fit): SparkleWeave Fairy Rug – Soft fabric glider with LED lights and safe, detachable wings. Age 5+, £24.99. In stock: 1,247 units (London warehouse ETA: 24-Dec 23:45). Why? Matches “sparkly” (glitter threads) and “flying” (gentle ramp launch—no batteries needed). Backup Option (78% Fit): Enchanted Cloud Blanket – Plush throw with hidden pockets for doll “flights.” Age 4+, £18.50. Stock: 892 units. Safer for tiny hands, but less “carpet-y.

Pro Tip: Pairs perfectly with your 2024 WishList fave, the Mini Doll Jetpack! Shall I add to the sleigh manifest?

Merry matching! 🎁✨ 

(Sources: TOY_CATALOG_VECTORS, CHILD_WISH_HISTORY)

Why It’s Technically Impressive (and Elf-Approved)

  • The team notices this is a wish and gives the task to agent-elf WishList Resolver
  • Handles ambiguity: Uses vector search for semantic matching (for example, “flying carpet” → airborne toys) and NL2SQL for precise filters (for example, “age <=6 AND sparkly=1”).
  • Secure and scalable: Inherits row-level security, only verified kids see personalised results.
  • Audit-ready: Logs every resolution for “Why did Timmy get a drone instead?” queries from skeptical parents or regulators.
  • Real-world power: Beyond holidays, it’s like an AI product recommender for Amazon, grounded in your inventory data, no external APIs needed unless you add them.

It’ll resolve your queries faster than you can say “Jingle all the way!” 🎄 🎁

Select AI Agents: Santa’s Workshop Runs on Oracle, NiceList Analyst Agent (2/6)

24 Wednesday Dec 2025

Posted by Helifromfinland in AI Agents

≈ Leave a comment

Tags

christmas, holiday, santa, santa-claus

By Heli and Marko Helskyaho

NiceList Analyst is the most emotionally sensitive agent in Santa’s workshop. But what does it do?

  1. Listens to the child’s question
    • Example: “Have I been nice enough this year, Santa?”
  2. Finds the child’s record using hybrid search across:
    • Relational tables (name, address, age, region)
    • Vector embeddings of millions of daily behavior logs (“helped little sister with homework”, “forgot to feed the hamster”, etc.)
    • Letters to Santa, teacher notes, and elf field reports
  3. Reasons in real time using the ReAct loop:
    • Runs vector similarity searches to find similar children from past years
    • Uses NL2SQL to calculate “niceness score” trends over the last 12 months
    • Pulls direct evidence (e.g., “+12 points for sharing toys on 12-Dec”, “–8 points for the cookie incident on 3-Dec”)
  4. Gives a truthful, kind, and evidence-based answer, complete with citations so the child (or parent) can see the receipts.

How does it work? 

Emil Johansson from Helsinki asks a question:

“Santa, have I been naughty or nice this year? My name is Emil Johansson, I live in Helsinki and I’m 9.”

The AI Agents team starts the process.

l_response :=  DBMS_CLOUD_AI_AGENT.RUN_TEAM(

  team_name   => ‘SantasAgents’,

  user_prompt => ‘Santa, have I been naughty or nice this year? My name is Emil Johansson, I live in Helsinki and I’m 9.’

 ,params      => ‘{“conversation_id”: “‘ || l_conversation_id || ‘”}’

);

Sample response:

Dear Emil Johansson (Helsinki, age 9),

After reviewing 2844 behavior events from 2025:

• You helped your brother build a snow fort on 14 separate days (+140 points)

• Shared your chocolate advent calendar every single day of December so far (+240 points)

• One small incident with the classroom hamster on 8.11.2025 (–15 points, already forgiven)

Final Nice Score: 94.7 % → CONFIRMED NICE LIST (Top 8 % worldwide)

Extra gift unlocked: the purple glitter unicorn you quietly hoped for.

Keep being awesome. See you on the 24th!

Love, Santa 🎅

Why it’s technically impressive (and a little magical)?

  • The team gives the task to agent-elf NiceList Analyst based on the prompt
  • 100 % private: Emil’s entire behavioral history never leaves the Oracle database  
  • Row-level security: Only Santa (and authorized elves) can query the full Nice/Naughty List  
  • Quick response even when 1.9 billion children are asking at the same time on Christmas Eve  
  • Full audit trail: Every verdict is logged for the European Elf Data Protection Board

The NiceList Analyst proves that with Select AI Agents you can build deeply personal, highly secure, and instantly responsive AI experiences whether you’re Santa Claus or a bank answering “Why was my loan approved/denied?”

🎄

Select AI Agents: Santa’s Workshop Runs on Oracle (1/6)

24 Wednesday Dec 2025

Posted by Helifromfinland in AI Agents

≈ Leave a comment

By Heli and Marko Helskyaho

Even Korvatunturi (Santa lives in Korvatunturi, not in North Pole!) upgraded to Oracle AI Database 26ai this year, and Select AI Agents turned Santa’s centuries-old operation into a fully autonomous, real-time gift-delivery intelligence system, all inside an Oracle Autonomous Database.

The Korvatunturi Use Case (100% real code, 0% reindeer magic) was built by Santa’s elves. They built five Select AI agents using the new DBMS_CLOUD_AI_AGENT package. Each agent is a first-class database object, runs inside the database, and inherits the same security policies that protect the Naughty/Nice list. We all know how important and sensitive that data is!

The five AI Agents (NiceList Analyst, WishList Resolver, Sleight Route Optimizer, GiftWrap Foreman, and Reindeer Health Copilot) are described in the table below. All the agents work in Santa’s team ‘SantasAgents’.

Agent NameShort Job DescriptionKey Tools Used
NiceList AnalystAnswers “Have I been naughty or nice?” with evidence.RAG + Vector Search on behavior logs
WishList ResolverTurns “I want a puppy that never grows” into actual catalog items.NL2SQL + Hybrid search across toy catalog
Sleigh Route OptimizerRe-calculates delivery route when a kid moves or adds 11th-hour wishes.Graph analytics + REST to a weather API
GiftWrap ForemanTriggers robotic gift-wrapping stations when inventory runs low.PL/SQL procedures + external REST
Reindeer Health CopilotMonitors key metrics (tracks carrot consumption, flight endurance, rest cycles, environmental factors etc.) and predicts the wellbeing of Santa’s reindeer fleet. It flags potential problems early and recommends actions, for example, extra oats for Rudolph or a vet check for Comet.Time-series JSON + LLM reasoning

In the next blog posts we will investigate in more detail what these AI Agents do and how they have been implemented.

Joel Kallman, Jerusalem, and the Oracle Community in Israel #JoelKallmanDay

11 Wednesday Oct 2023

Posted by Helifromfinland in General

≈ Leave a comment

It’s Joel Kallman Day again. And we still miss him dearly.

A place Joel loved was Israel, and especially Jerusalem. When we visited Jerusalem during the ilOUG event in July 2013, Joel said to me that his life is now complete, he always wanted to see Jerusalem. We both were quite emotional during that trip. I did my trip on behalf of my grandfather, who was never able to visit Jerusalem in person but was following my trip from home.

Joel would be very sorry to see the situation in Israel, and Jerusalem, today. He believed in peace and harmony, and wanted everybody to be friends.

The Oracle community in Israel has been strong and active for many years. That community had a special place in Joel’s heart.

I hope the ilOUG and the whole Oracle Community in Israel are safe and will remain safe. I wish you a peace in the country, soon. Stay safe.

Oracle CloudWorld, the Community, and the ACE Program #JoelKallmanDay

11 Tuesday Oct 2022

Posted by Helifromfinland in General

≈ Leave a comment

It obviously takes a Joel Kallman Day to get me writing a blog post! And it does make sense since Joel was a true community supporter. He always made me feel I am doing valuable work when sharing my knowledge. And that I should always try to contribute more to the community.

Next week is the Oracle CloudWorld in Las Vegas. The first time for a long time the community gets together, invited by Oracle. Joel would appreciate this. It still hurts to realize he will not be there.

I am excited to meet so many friends after all these years, and so looking forward making new friends. The community is extremely important and makes the techie life even better: computers are fun but even more fun when you can share the feeling with other people. Another important part of the event is hearing what’s coming next on the Oracle space and what people have done using the Oracle technology, the techie part itself.

Of course, I will do my part of sharing the knowledge too. I will be talking about one of my favorite topics: machine learning. Machine Learning in the Cloud – Without Any Panic. I want to talk about this topic because I have realized many people are curious and interested in machine learning but worried about the complexity of it. What if I cannot understand machine learning? What if it is too difficult for me? In my session I will explain the features Oracle has created in the Oracle Cloud Infrastructure (OCI) to make using machine learning as easy as possible. And it is easy. There is no reason to panic and worry, you will be fine with machine learning. And to remind: the community is there to help you, if any problems. You can always ask for advice or guidance if you think you do not know what to do next.

I will also attend an Oracle ACE Program Roundtable with Jennifer Nicholson (Director, ACE Program Management, Oracle) to discuss how an individual can contribute to the community. We will discuss about the Oracle ACE Program, Oracle’s premier community program that recognizes & rewards individuals for their contributions to the Oracle community. Oracle ACEs love sharing their knowledge and helping the Oracle community, and therefore the ACE Program is an important part of the community. There are many ways you can contribute: you can write blog posts or books, speak, mentor…Whatever feels comfortable to you. And guess what, you do not only feel good when helping others, you will also learn a lot! And you will make amazing friends!

I hope to see many of you at the CloudWorld, or any of the other amazing Oracle Community events during this year or the years to come. Being a techie is fun, but being a techie with a supporting community is so much more fun!

#JoelKallmanDay

11 Monday Oct 2021

Posted by Helifromfinland in Events

≈ Leave a comment

Joel Kallman was one of my favorite persons at Oracle and I can honestly say I miss him a lot.

There are no words to express my appreciation on Tim Hall’s suggestion to dedicate October 11th 2021 to Joel.

I decided not to write a tech tip but to tell you about the blog post I wrote a while ago. This is the last project I worked with Joel. When I was done with the first version of the post, I sent it to Oracle for comments. I got the commented version back when Joel was already gone. Those comments included also his comments. Those who knew Joel know how polite those comments were. He was always so kind and caring. Reading and editing his comments was heartbreaking.

I want to dedicate this blog post to Joel. I miss you, my friend. Thank you for everything!

https://blogs.oracle.com/database/post/covid-19-tracking-app-finland

Generate REST services

17 Friday Apr 2020

Posted by Helifromfinland in Data Modeler, Database design

≈ 2 Comments

While generating the DDLs for the table you can also generate the REST services for the table easily.

To generate the DDL select File, Export, DDL File.

ddl

Then select the RDBMS Site and the relational model wanted and press Generate.

ddl2

Select Generate REST Services.

ddl3

And the script now not only includes the table generation (and whatever else you chose) but also REST enabling scripts.

ddl4

P.S. If you want to isolate the tables from users with views, you can easily create a view for a table (and then grant privileges to views instead of tables). Just like described above you can create the REST services for views as well.

To create the views for tables select Tools, Table to View Wizard.

view

Select the tables wanted.

view3

And then generate the DDLs as described.

view2

 

← Older posts

Subscribe

  • Entries (RSS)
  • Comments (RSS)

Archives

  • December 2025
  • October 2023
  • October 2022
  • October 2021
  • April 2020
  • October 2019
  • October 2018
  • June 2018
  • December 2017
  • October 2017
  • September 2017
  • July 2017
  • April 2017
  • March 2017
  • February 2017
  • January 2017
  • December 2016
  • November 2016
  • October 2016
  • September 2016
  • August 2016
  • July 2016
  • June 2016
  • May 2016
  • April 2016
  • March 2016
  • February 2016
  • December 2015
  • November 2015
  • October 2015
  • September 2015
  • August 2015
  • July 2015
  • June 2015
  • May 2015
  • April 2015
  • March 2015
  • January 2015
  • December 2014
  • November 2014
  • October 2014
  • September 2014
  • August 2014
  • June 2014
  • May 2014
  • April 2014
  • January 2014
  • December 2013
  • November 2013

Categories

  • Data Modeler
  • Database design
  • Events
  • General
  • Machine learning and AI
    • AI Agents
  • Oracle
  • SQL Developer

Meta

  • Create account
  • Log in

Blog at WordPress.com.

Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy
  • Subscribe Subscribed
    • HeliFromFinland
    • Join 53 other subscribers
    • Already have a WordPress.com account? Log in now.
    • HeliFromFinland
    • Subscribe Subscribed
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar
 

Loading Comments...