{"id":48710,"date":"2026-11-18T17:57:04","date_gmt":"2026-11-18T16:57:04","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/?p=48710"},"modified":"2026-11-18T17:57:06","modified_gmt":"2026-11-18T16:57:06","slug":"ai-for-free-with-oracle","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/ai-for-free-with-oracle\/","title":{"rendered":"AI for free with Oracle"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">AI and Oracle for free? really?<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In this blog post I will describe a use-case with a free AI model provided by Oracle that can be used in the 26ai free edition. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The use-case is: I have a table with additional infos about bands (country, genre, homepage, facebook, youtube, &#8230;). And I have a table with events (concerts, festivals) and the bands playing there. If the bandname matches the bandname in the bands table, then I can see the additional info. And sure, I do not have additional infos for all bands. But maybe there are just bands with different spellings.<\/p>\n\n\n\n<h1 id=\"h-theory\" class=\"wp-block-heading\">Theory<\/h1>\n\n\n\n<h2 id=\"h-the-classical-way\" class=\"wp-block-heading\">The classical way<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Let&#8217;s see what Oracle already offered to find similar content<\/p>\n\n\n\n<h3 id=\"h-lower\" class=\"wp-block-heading\">lower<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Compare the data case-insensitive. If it is written &#8220;Meier&#8221; or &#8220;meier&#8221;, that is the same for us<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; gutter: false; title: ; notranslate\" title=\"\">\nselect name from persons where lower(name) = &#039;meier&#039;;\n<\/pre><\/div>\n\n\n<h3 id=\"h-like\" class=\"wp-block-heading\">like<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">We will use placeholders for parts we are not interested in. If the band is written &#8220;the young gods&#8221; or &#8220;young gods&#8221;, it&#8217;s probably the same<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; gutter: false; title: ; notranslate\" title=\"\">\nselect * from bands where band like &#039;%young gods&#039;\n<\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">regexp_like<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">more powerful than like, using regular expressions. The following is more precise. At the beginning must be 0 or 1 time &#8220;the &#8220;.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; gutter: false; title: ; notranslate\" title=\"\">\nselect * from bands where regexp_like(band, &#039;(^the\\s+)?young gods&#039;);\n<\/pre><\/div>\n\n\n<h3 id=\"h-soundex\" class=\"wp-block-heading\">Soundex<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Start with the 1st char, then calculate an unique code for similar words. &#8220;Meier&#8221; and &#8220;Mayer&#8221; both maps to soundex M600. The disadvantage is that only the first few characters are evaluated. <\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; gutter: false; title: ; notranslate\" title=\"\">\nselect name from persons where soundex(name) like soundex(&#039;meier&#039;);\n<\/pre><\/div>\n\n\n<h2 id=\"h-the-new-ai-vector-search\" class=\"wp-block-heading\">The new AI Vector Search<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Return data with similar content \u2013 with AI vector search. For example, we have images with animals and want to search all images with a horse.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">We have to create an algorithm to create vectors of the image. This is the so-called &#8220;model&#8221;. And it is not easy to create such a model. Imagine a horse, a donkey, and a mule. What are the differences between them? In comparison, a duck is easy to distinguish. So our model must provide a significantly different vector for the duck than for the other animals. &#8220;We&#8221;, or at least most of us will use existing models&#8230;<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"508\" height=\"306\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/image-12.png\" alt=\"\" class=\"wp-image-48760\" style=\"width:242px;height:auto\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/image-12.png 508w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/image-12-300x181.png 300w\" sizes=\"auto, (max-width: 508px) 100vw, 508px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">And now, how we can retrieve images of horses? Calculate the vector of a horse image, then return the data having the smallest vector distance to our calculated vector.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Usually vectors gets quite big. There are more attributes for animals, e.g. color, size, skin\/fur, &#8230;<br>And a vector is calculated for each of these features<\/p>\n\n\n\n<h2 id=\"h-the-all-minilm-l-12-v2-model\" class=\"wp-block-heading\">The all-MiniLM-L 12-v2 model<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Oracle offers the <a href=\"https:\/\/blogs.oracle.com\/machinelearning\/post\/use-our-prebuilt-onnx-model-now-available-for-embedding-generation-in-oracle-database-23ai\">all-MiniLM-L 12-v2 model for download<\/a>. The file is in the <a href=\"https:\/\/en.wikipedia.org\/wiki\/Open_Neural_Network_Exchange\">ONNX<\/a> format and can be loaded in the 26ai database. Download the file to \/u01\/models in this example.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; gutter: false; title: ; notranslate\" title=\"\">\ncreate user if not exists vector identified by vector quota unlimited on users;\ngrant create session, db_developer_role, create mining model to vector;\ncreate or replace directory model_dir as &#039;\/u01\/models&#039;;\ngrant read, write on directory model_dir to vector;\nconnect vector\/vector@\/\/localhost:1521\/orclpdb.erfinder\nbegin\n  dbms_vector.drop_onnx_model (model_name =&gt; &#039;ALL_MINILM_L12_V2&#039;, force =&gt; true);\n  dbms_vector.load_onnx_model (\n  directory =&gt; &#039;model_dir&#039;,\n  file_name =&gt; &#039;all_MiniLM_L12_v2.onnx&#039;,\n  model_name =&gt; &#039;ALL_MINILM_L12_V2&#039;);\nend;\n\/\nselect model_name, algorithm, mining_function from user_mining_models;\nselect vector_embedding(all_minilm_l12_v2 using &#039;Bob Dylan&#039; as data) AS my_vector;\n-- To grant it for other users:\ngrant select on mining model vector.ALL_MINILM_L12_V2 to myuser;\n<\/pre><\/div>\n\n\n<pre class=\"wp-block-code\"><code>&#091;-3.28829587E-002,7.12544471E-002,-4.57076691E-002,3.34124677E-002,-1.0640244E-002,4.99891154E-002,1.04386434E-001,-6.72798455E-002,-7.81936664E-003,-8.73053167E-003,-2.36021634E-002,2.01056106E-003,-2.46723387E-002,-5.60818836E-002,-3.7508145E-002,1.28634855E-001,5.22060208E-002,-8.21595732E-003,1.95498653E-002,-5.5897072E-002,2.00462937E-002,1.13573E-001,-1.04404532E-003,4.60094661E-002,-2.34374423E-002,3.59080993E-002,-1.83110982E-002,4.1176632E-002,-2.09390521E-002,-4.84892018E-002,-6.01600558E-002,1.95941841E-003,-9.55247506E-002,-4.36511822E-002,2.03858018E-002,5.24709793E-003,-8.09903815E-002,2.58681905E-002,8.45895056E-003,-5.15323766E-002,2.27247402E-002,-3.28555144E-002,-2.27001943E-002,-5.32310866E-002,-9.1472546E-005,-1.03046363E-002,-1.69764727E-003,-1.54329734E-002,4.56825159E-002,7.77621344E-002,3.46121155E-002,-7.57156834E-002,-3.00063612E-003,-4.53864262E-002,-3.84752005E-002,-6.36761934E-002,-2.88341157E-002,5.90838827E-002,-8.12250748E-003,-4.64118458E-002,-3.17675695E-002,-4.25537676E-002,-2.16702688E-002,2.84322235E-003,8.61015916E-003,-2.14451943E-002,8.40565786E-002,-5.86571507E-002,-9.2464231E-002,1.56575125E-002,-3.73052713E-003,8.10047705E-003,1.00164764E-001,-6.44701393E-003,4.39257845E-002,-1.54028821E-003,5.98016754E-002,1.09822132E-001,-2.7124064E-002,-4.46104561E-004,3.20078549E-003,2.79765911E-002,5.03437296E-002,-8.46643522E-002,-9.36391726E-002,-6.73487186E-002,1.84180625E-002,9.63722449E-003,1.24550518E-002,-8.65510926E-002,-7.59489909E-002,1.26308557E-002,3.50978156E-003,-6.28657341E-002,-1.58169977E-002,7.58793652E-002,3.8126424E-002,-5.30581661E-002,-6.27498478E-002,2.64155805E-001,-8.89125839E-003,4.76834886E-002,-3.44932079E-002,3.28368917E-002,4.07917947E-002,-2.3367377E-002,-4.72930893E-002,4.23461609E-002,3.70606966E-003,-4.84246351E-002,3.95867899E-002,-6.20418042E-003,-5.71911037E-002,2.7675597E-002,1.08781736E-002,-8.90007392E-002,2.75215507E-002,-1.67274829E-002,-1.55357672E-002,9.31895003E-002,-5.24692051E-002,3.33056785E-003,-6.93096919E-003,-1.27648907E-002,-1.31879762E-001,-5.87911345E-002,-3.01394444E-002,-1.30496789E-002,1.229118E-002,-1.03035718E-002,3.59751955E-002,-6.99997321E-002,1.10877313E-001,-2.81976648E-002,-6.04905449E-002,3.60108092E-002,-1.06216678E-002,-4.39494215E-002,7.80562013E-002,-1.6695112E-001,1.50056444E-002,7.97785446E-002,2.97659002E-002,4.84109372E-002,-2.56663887E-003,-6.71984777E-002,3.34760435E-002,-2.94934344E-002,-9.33799371E-002,-2.78656222E-002,-4.63584922E-002,-1.08145699E-002,7.80638028E-003,-2.63266789E-004,-8.88938643E-003,3.12825069E-002,6.60058409E-002,2.45609395E-002,2.61974223E-002,4.66002934E-002,5.83518781E-002,1.80750992E-003,-2.74173599E-002,-3.43227871E-002,-2.48813797E-002,5.47519652E-003,-5.82680777E-002,-7.43228644E-002,-1.88004076E-002,-1.98282674E-003,2.54240092E-002,-2.25611627E-002,-6.18117265E-002,7.44435415E-002,9.6341148E-003,1.5786672E-002,-1.04088732E-003,3.61631215E-002,-3.38860713E-002,-4.13281173E-002,-4.50802706E-002,1.95613988E-002,-1.99177042E-002,5.17900707E-003,4.90007438E-002,5.03397081E-003,-6.19004597E-004,-1.13240853E-002,-1.02219107E-002,8.01912174E-002,7.19214156E-002,4.65811603E-002,3.64658721E-002,-4.94964374E-003,2.24289093E-002,-6.02491722E-002,7.99450616E-004,-7.01370239E-002,-7.43662044E-002,-5.69670312E-002,4.62124683E-002,-4.12194617E-002,8.31926242E-003,-9.16962977E-003,5.90781793E-002,-8.93979073E-002,2.46489439E-002,2.81920489E-002,3.73301096E-002,-2.34126672E-002,-2.66622845E-002,-4.46192324E-002,-1.0867619E-002,-3.94763537E-002,-6.28683269E-002,-9.89502668E-002,2.84670247E-003,-4.54771668E-002,-5.41057028E-002,1.49319759E-002,-8.64058435E-002,-2.36107074E-002,-8.96388739E-002,7.36331425E-033,-1.30065847E-002,9.65155736E-002,8.05562809E-002,7.79263452E-002,1.354397E-002,-1.92665216E-002,1.22084673E-002,-4.27422523E-002,5.58627024E-002,4.50925622E-003,-2.63720471E-002,1.77200157E-002,3.12984958E-002,-5.7092566E-002,4.52824384E-002,2.39689071E-002,-6.85803741E-002,8.76181796E-002,7.43384063E-002,3.8558092E-002,3.15629202E-003,3.26407105E-002,4.78902496E-002,1.39964083E-002,-8.43583196E-002,-4.61399555E-002,-9.19615477E-003,7.43216872E-002,5.51957591E-003,-2.65764855E-002,3.59744169E-002,2.61799637E-002,-1.89742539E-002,-4.89917509E-002,-9.24255606E-003,2.38266308E-002,5.41158468E-002,5.97609766E-002,5.02838008E-002,-3.57549414E-002,6.40272647E-002,5.00370339E-002,-3.69527489E-002,4.64274175E-002,2.49757692E-002,-6.76745037E-003,8.21680669E-003,5.42990454E-002,-3.16958688E-002,1.39125353E-002,-6.24617971E-002,2.69391462E-002,1.52521878E-002,1.6519472E-002,-1.17503544E-002,-4.99484092E-002,4.65028994E-002,2.52046362E-002,2.21878756E-002,-1.3119689E-003,-6.08432367E-002,3.77141424E-002,4.42493074E-002,-3.14246006E-002,6.79688305E-002,-8.38463474E-003,-4.85547185E-002,4.65472452E-002,-2.1941036E-002,-4.92079766E-004,-5.7777293E-002,2.28965795E-003,-8.90555829E-002,2.1388296E-002,-2.90373433E-002,6.60333186E-002,2.44755242E-002,-1.03102364E-001,-5.32066338E-002,3.33813578E-002,-5.51838949E-002,2.94785537E-002,-6.78635314E-002,3.5423249E-002,-2.19605342E-002,-4.11156788E-002,7.0969604E-002,-5.22063114E-002,3.73266009E-003,1.00158148E-001,4.24587019E-002,-7.08252415E-002,-2.02396E-003,9.50025488E-003,2.54774839E-002,2.5477032E-035,1.43452147E-002,5.16638942E-002,-1.19648194E-002,-2.49146926E-003,1.24402598E-001,5.28191328E-002,1.02975033E-001,-4.78652567E-002,-5.45930974E-002,1.24237491E-002,1.61334034E-002,-7.59155899E-002,3.52150798E-002,4.61573005E-002,8.28202143E-002,5.92956669E-004,-8.56052712E-002,-1.63979232E-002,8.12467374E-003,2.49185823E-002,7.56010786E-002,8.44534859E-002,8.50686207E-002,-3.74653749E-002,5.28270602E-002,2.15788018E-002,3.67684476E-002,8.69528204E-003,-3.50426733E-002,5.644219E-002,2.85430346E-002,6.9013454E-002,-8.73260349E-002,8.75519589E-002,-1.54081145E-002,-6.64589033E-002,1.22624952E-002,-5.2193813E-002,5.41517045E-003,4.24271524E-002,-2.26328755E-003,1.00552432E-001,1.41395396E-002,2.75035575E-003,3.79429497E-002,-3.93360481E-002,1.01929337E-001,1.10946614E-002,8.39847848E-002,2.47093942E-002,-4.82656285E-002,-3.38978358E-002,8.23562592E-002,9.43520106E-003,1.99154788E-003,-1.32039923E-003,-1.74975079E-002,5.25957383E-002,-9.51754451E-002,-3.40001434E-002,1.5815651E-002,5.44813403E-004,-7.75640979E-002,-1.0712678E-001]<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">As you can see, a vector of this model is much bigger than the input &#8220;Bob Dylan&#8221;!<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In 26ai we have a new datatype VECTOR<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nalter table bands add (band_vector vector);\nupdate bands\nset BAND_VECTOR = vector_embedding(all_minilm_l12_v2 using BAND as data);\n<\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">That&#8217;s the table with the 9000 bands. In the table bands_unknown (11&#8217;000 bands) I will add the most probable band and the vector_dist field.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nDECLARE\n  CURSOR c_bands_unknown IS SELECT alias FROM bands_unknown;\n  v_band\n  bands.band%TYPE;\n  v_vector_dist NUMBER;\nBEGIN\n  FOR r IN c_bands_unknown LOOP\n    SELECT band, vector_distance(b.band_vector\n    , vector_embedding(all_minilm_l12_v2 USING r.alias AS data)) INTO v_band, v_vector_dist\n    FROM vector.bands b ORDER BY 2 FETCH FIRST 1 ROW ONLY;\n    UPDATE bands_unknown\n      SET band = v_band, vector_dist = v_vector_dist WHERE alias = r.alias;\nEND LOOP;\nEND;\n\/\n<\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">Afterwards, we can sort the result by vector distance. And the result?<br>Practically all results with a vector distance &lt; 0.01 are correct, except e.g.:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>DC\/AC -&gt; AC\/DC\n<ul class=\"wp-block-list\">\n<li>AC\/DC is a well-known Australian hardrock band<\/li>\n\n\n\n<li>DC\/AC is a small swiss AC\/DC cover band<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Kids -&gt; Children\n<ul class=\"wp-block-list\">\n<li>Children is a hardcore-punk band from Berlin<\/li>\n\n\n\n<li>Kids is a punkrock band from Zurich<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Up to a vector distance of 0.07 the results are quite good, afterwards, the number of false mappings significantly increases.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"535\" height=\"381\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/image-13.png\" alt=\"\" class=\"wp-image-48791\" style=\"width:431px;height:auto\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/image-13.png 535w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/image-13-300x214.png 300w\" sizes=\"auto, (max-width: 535px) 100vw, 535px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">For me, AI is a great tool for finding duplicates here. However, relying solely on AI isn&#8217;t the solution. Some human oversight is still needed. For example, the model isn&#8217;t yet able to recognize that, when working with band-names, linguistic synonyms shouldn&#8217;t be merged.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>AI and Oracle for free? really? In this blog post I will describe a use-case with a free AI model provided by Oracle that can be used in the 26ai free edition. The use-case is: I have a table with additional infos about bands (country, genre, homepage, facebook, youtube, &#8230;). And I have a table&hellip;&nbsp;<\/p>\n","protected":false},"author":123,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"","neve_meta_content_width":0,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":"","neve_meta_reading_time":"","_themeisle_gutenberg_block_has_review":false,"footnotes":""},"categories":[4136,4137,4133,59],"tags":[],"class_list":["post-48710","post","type-post","status-publish","format-standard","category-analytics","category-data-quality","category-database","category-oracle"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v28.8 (Yoast SEO v28.9) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>AI for free with Oracle - dbi services Blog<\/title>\n<meta name=\"description\" content=\"AI and Oracle for free. Possible with free edition and all_minilm_l12_v2 model. Use-case: lookup of band-duplicates\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/ai-for-free-with-oracle\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"AI for free with Oracle\" \/>\n<meta property=\"og:description\" content=\"AI and Oracle for free. Possible with free edition and all_minilm_l12_v2 model. Use-case: lookup of band-duplicates\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/ai-for-free-with-oracle\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi services Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/dbiservices\/\" \/>\n<meta property=\"article:published_time\" content=\"2026-11-18T16:57:04+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-11-18T16:57:06+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/image-12.png\" \/>\n\t<meta property=\"og:image:width\" content=\"508\" \/>\n\t<meta property=\"og:image:height\" content=\"306\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Martin Bracher\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@dbiservices\" \/>\n<meta name=\"twitter:site\" content=\"@dbiservices\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Martin Bracher\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/ai-for-free-with-oracle\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/ai-for-free-with-oracle\\\/\"},\"author\":{\"name\":\"Martin Bracher\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/0f2e8e5d3ccbf8a0917dd46e6956367c\"},\"headline\":\"AI for free with Oracle\",\"datePublished\":\"2026-11-18T16:57:04+00:00\",\"dateModified\":\"2026-11-18T16:57:06+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/ai-for-free-with-oracle\\\/\"},\"wordCount\":603,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/ai-for-free-with-oracle\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/11\\\/image-12.png\",\"articleSection\":[\"Analytics\",\"Data Quality\",\"Database\",\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/ai-for-free-with-oracle\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/ai-for-free-with-oracle\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/ai-for-free-with-oracle\\\/\",\"name\":\"AI for free with Oracle - dbi services Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/ai-for-free-with-oracle\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/ai-for-free-with-oracle\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/11\\\/image-12.png\",\"datePublished\":\"2026-11-18T16:57:04+00:00\",\"dateModified\":\"2026-11-18T16:57:06+00:00\",\"description\":\"AI and Oracle for free. Possible with free edition and all_minilm_l12_v2 model. Use-case: lookup of band-duplicates\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/ai-for-free-with-oracle\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/ai-for-free-with-oracle\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/ai-for-free-with-oracle\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/11\\\/image-12.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/11\\\/image-12.png\",\"width\":508,\"height\":306},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/ai-for-free-with-oracle\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"AI for free with Oracle\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"name\":\"dbi services Blog\",\"description\":\"#BeSharing\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/#organization\",\"name\":\"dbi services\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/dbi-services-logo.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/dbi-services-logo.png\",\"width\":512,\"height\":512,\"caption\":\"dbi services\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/dbiservices\\\/\",\"https:\\\/\\\/x.com\\\/dbiservices\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/dbi-services\\\/\",\"https:\\\/\\\/www.youtube.com\\\/user\\\/dbiservices\"],\"description\":\"Swiss IT consulting and services company specialized in efficient data infrastructures and platforms: databases, application servers, cloud, DevOps, digitalization, analytics, data quality and monitoring. Headquartered in Del\u00e9mont with offices in Nyon, Basel, Bern and Zurich.\",\"email\":\"info@dbi-services.com\",\"telephone\":\"+41 32 422 96 00\",\"legalName\":\"dbi services SA\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/0f2e8e5d3ccbf8a0917dd46e6956367c\",\"name\":\"Martin Bracher\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2025\\\/05\\\/martin_bracher_2048x1536.jpg\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2025\\\/05\\\/martin_bracher_2048x1536.jpg\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2025\\\/05\\\/martin_bracher_2048x1536.jpg\",\"caption\":\"Martin Bracher\"},\"description\":\"Martin Bracher has more than 25 years of experience managing Oracle infrastructures, specializing in high availability (Data Guard, Grid Infrastructure), migrations, and automation with Shell scripting, Ansible, and Saltstack. He leads the Grid Infrastructure Workshop and contributes to the development of the DMK Database Management Kit and the YaK Oracle component. Prior to dbi services, he was Principal Consultant at Trivadis AG (Accenture) and Consultant at Opitz Consulting and CSC Ploenzke. He holds a Dipl. Phil. Nat. in Informatics from the University of Bern. His industry experience covers banking, telecommunications, and public administration.\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/martin-bracher\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"AI for free with Oracle - dbi services Blog","description":"AI and Oracle for free. Possible with free edition and all_minilm_l12_v2 model. Use-case: lookup of band-duplicates","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/ai-for-free-with-oracle\/","og_locale":"en_US","og_type":"article","og_title":"AI for free with Oracle","og_description":"AI and Oracle for free. Possible with free edition and all_minilm_l12_v2 model. Use-case: lookup of band-duplicates","og_url":"https:\/\/www.dbi-services.com\/blog\/ai-for-free-with-oracle\/","og_site_name":"dbi services Blog","article_publisher":"https:\/\/www.facebook.com\/dbiservices\/","article_published_time":"2026-11-18T16:57:04+00:00","article_modified_time":"2026-11-18T16:57:06+00:00","og_image":[{"width":508,"height":306,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/image-12.png","type":"image\/png"}],"author":"Martin Bracher","twitter_card":"summary_large_image","twitter_creator":"@dbiservices","twitter_site":"@dbiservices","twitter_misc":{"Written by":"Martin Bracher","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/ai-for-free-with-oracle\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/ai-for-free-with-oracle\/"},"author":{"name":"Martin Bracher","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0f2e8e5d3ccbf8a0917dd46e6956367c"},"headline":"AI for free with Oracle","datePublished":"2026-11-18T16:57:04+00:00","dateModified":"2026-11-18T16:57:06+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/ai-for-free-with-oracle\/"},"wordCount":603,"commentCount":0,"publisher":{"@id":"https:\/\/www.dbi-services.com\/#organization"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/ai-for-free-with-oracle\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/image-12.png","articleSection":["Analytics","Data Quality","Database","Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/ai-for-free-with-oracle\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/ai-for-free-with-oracle\/","url":"https:\/\/www.dbi-services.com\/blog\/ai-for-free-with-oracle\/","name":"AI for free with Oracle - dbi services Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/ai-for-free-with-oracle\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/ai-for-free-with-oracle\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/image-12.png","datePublished":"2026-11-18T16:57:04+00:00","dateModified":"2026-11-18T16:57:06+00:00","description":"AI and Oracle for free. Possible with free edition and all_minilm_l12_v2 model. Use-case: lookup of band-duplicates","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/ai-for-free-with-oracle\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/ai-for-free-with-oracle\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/ai-for-free-with-oracle\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/image-12.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/image-12.png","width":508,"height":306},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/ai-for-free-with-oracle\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"AI for free with Oracle"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi services Blog","description":"#BeSharing","publisher":{"@id":"https:\/\/www.dbi-services.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.dbi-services.com\/#organization","name":"dbi services","url":"https:\/\/www.dbi-services.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/09\/dbi-services-logo.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/09\/dbi-services-logo.png","width":512,"height":512,"caption":"dbi services"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/dbiservices\/","https:\/\/x.com\/dbiservices","https:\/\/www.linkedin.com\/company\/dbi-services\/","https:\/\/www.youtube.com\/user\/dbiservices"],"description":"Swiss IT consulting and services company specialized in efficient data infrastructures and platforms: databases, application servers, cloud, DevOps, digitalization, analytics, data quality and monitoring. Headquartered in Del\u00e9mont with offices in Nyon, Basel, Bern and Zurich.","email":"info@dbi-services.com","telephone":"+41 32 422 96 00","legalName":"dbi services SA"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0f2e8e5d3ccbf8a0917dd46e6956367c","name":"Martin Bracher","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/05\/martin_bracher_2048x1536.jpg","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/05\/martin_bracher_2048x1536.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/05\/martin_bracher_2048x1536.jpg","caption":"Martin Bracher"},"description":"Martin Bracher has more than 25 years of experience managing Oracle infrastructures, specializing in high availability (Data Guard, Grid Infrastructure), migrations, and automation with Shell scripting, Ansible, and Saltstack. He leads the Grid Infrastructure Workshop and contributes to the development of the DMK Database Management Kit and the YaK Oracle component. Prior to dbi services, he was Principal Consultant at Trivadis AG (Accenture) and Consultant at Opitz Consulting and CSC Ploenzke. He holds a Dipl. Phil. Nat. in Informatics from the University of Bern. His industry experience covers banking, telecommunications, and public administration.","url":"https:\/\/www.dbi-services.com\/blog\/author\/martin-bracher\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/48710","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/123"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=48710"}],"version-history":[{"count":2,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/48710\/revisions"}],"predecessor-version":[{"id":48792,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/48710\/revisions\/48792"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=48710"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=48710"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=48710"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}