Skip to main content

Posts

Showing posts from December, 2023

Talking to Oracle Database, this time in plain Slovenian

In my previous blog post, Talking to Oracle Database in plain English I am discussing how to query Oracle Database using natural language queries to retrieve data from an Oracle database. From my quick exploration, I can conclude that AI has definitely entered databases and can be applied in very different scenarios. For example, using SELECT AI in chat application where data can be retrieved and presented from Oracle Database by applying natural language query. But that was in plain English. But what about if my primary natural language isn't English. What if your (and, for this matter also mine) isn't English. What if it is Slovenian? Would SELECT AI still work? Let's examine the very same examples that I used in my previous blog post. Let's talk now ... "po slovensko" (Slovenian) Enough said. Let's try the simplest query of all and let's ask my database what is the total revenue recorded. In Slovenian, the question  what is total revenue tra...

Talking to Oracle Database in plain English

My SQL beginnings It was approx. 35 years ago (gosh, that long!?) when I first met SQL. Structured Query Language to those who might not be  from that era or are not 100% sure of what I am talking about. It was during the labs at faculty when we went to IBM's training center (we didn't have the capacity at faculty at the time) in Radovljica, Slovenia, to learn and play with this (at least for me) new programming language. The language of the 4th generation, so they said. With its roots in boolean algebra and simple structure, we were told that this was almost the same as natural language (english of course. Who would thought one day you would use Slovenian language to query databases too! With all those SELECTs, FROMs, WHEREs, GROUP BYs, HAVINGs, ORDER BYs, etc. it actually sounded really cool and easy. My Select AI beginnings The other day I finally found some time to invest into something else then just daily work, which is obviously something different than the rest of th...