City of Lohja creates chatbot to power document insights with Oracle AI solution
The Finnish city of Lohja, working with Oracle partner Miracle Finland Oy, built an internal support chatbot using OCI Enterprise AI, Oracle Autonomous AI Lakehouse, Oracle AI Vector Search, and Oracle Graph. The chatbot connects large language models to analyze internal documents and extract entities such as projects, decisions, and people, combining graph and vector queries to answer approximately 85% of HR and ICT helpdesk support questions.
Overview
The Finnish city of Lohja, working with Oracle partner Miracle Finland Oy, built an internal support chatbot using OCI Enterprise AI, Oracle Autonomous AI Lakehouse, Oracle AI Vector Search, and Oracle Graph. The chatbot connects large language models to analyze internal documents and extract entities such as projects, decisions, and people, combining graph and vector queries to answer approximately 85% of HR and ICT helpdesk support questions.
This entry has 15 published fields tied to exact passages in an immutable source capture.
Inspect the highlighted sourceThe challenge
As the city's internal document archive grew, employees for its HR support and ICT helpdesk support services needed faster, more accurate answers than keyword search could deliver.
The solution
Working with Oracle partner Miracle Finland Oy, the city built a centralized knowledgebase using Oracle Autonomous AI Lakehouse and Oracle APEX. The solution uses OCI Enterprise AI to connect large language models that analyze documents and extract key entities such as projects, decisions, and people, storing those connections in Oracle Autonomous AI Database with Oracle Graph, and uses Oracle AI Vector Search to run semantic similarity searches.
Reported business value
The chatbot can answer approximately 85% of support questions, helping city employees save time and improve decision-making.
Sources
Open any source and check the claim yourself — that is the point of the register.
This record was researched and written with AI assistance, and its claims were checked against the sources above. (EU AI Act art. 50 transparency notice.)
Other government & public sector entries in the register.
GovTech unlocks data insights to improve nationwide services with Databricks
Singapore's Government Technology Agency (GovTech) migrated from an on-premises dashboarding system to the Databricks Data + AI Platform on AWS with Unity Catalog and Delta Lake, cutting dashboard creation time from 90 to 30 days, democratizing data across 50% of corporate divisions in the first year, and saving 8,000 labor hours annually.
GovTech· SingaporeDelta Lake · Lakeflow Connect · Lakeflow Jobs +1Estonia rolls out Bürokratt, an AI-guided virtual assistant network for public services
Bürokratt is a network of chatbots deployed on Estonian public sector institutions' websites, letting people obtain information from institutions and use public and information services via virtual assistants. It is a state-created, AI-based digital assistant that helps institutions deliver modern, efficient, around-the-clock customer service using large language models.
City of Helsinki pilots watsonx.ai for multilingual customer care chatbot translation
The City of Helsinki collaborated with IBM Client Engineering and IBM Consulting on a Proof of Value testing whether IBM watsonx.ai could translate foreign-language questions into Finnish for its customer care chatbot, which supports Finnish, English, and Swedish. Watsonx.ai scored 0.90 on the COMET machine-translation metric for English-to-Finnish translation (versus 0.91 for the incumbent system) and 0.87 for Swedish-to-Finnish (versus 0.86), performing on par with the city's existing translation solution.
City of Helsinki· FinlandIBM watsonx.ai
Madrid builds VisitMadridGPT on Azure OpenAI to answer tourists in 95+ languages
The City of Madrid, with partner iUrban, built the VisitMadridGPT virtual assistant on Microsoft Azure OpenAI Service to give tourists accurate, real-time, personalized information in more than 95 languages, drawing from the city's official tourism content. Users average 2.8 questions and spend about 4 minutes 18 seconds per session with a low bounce rate, and the city analyzes assistant conversations to identify popular topics and refine its digital marketing strategy.
Madrid Destino / Madrid City Council· SpainAzure OpenAI ServiceWas this helpful?
Your feedback helps us improve our use case database