The first duel between a human and a machine took place as early as the mid-fifties. At that time, Maniac, a computer, played chess against a human for the first time – and won. Nowadays,…
Recently I've been working on a ML pipeline to recognize SKILLs from domain-specific documents.This is basically a NER (Named Entity Recognizer ) task, where you have a corpus of data (text) and you find specific…
Have you ever had to write a text, but didn’t know how to continue after the first sentence? Don’t worry, AI can fix that. Just go to this website, enter what you’ve got, and you…
In one of my older blogs “Dump VO query and it’s parameter with their values”, I described a technique on how to print or dump out a query and its parameters to the log when…
Es kommt immer wieder es vor, dass (Oracle-) Datenbankanwendungen "zu langsam" sind. Dann wird versucht herauszufinden woran es liegt und wenn man Glück hat findet sich eine Idee das verursachende SQL-Statement so zu ändern, dass…
In this blog, I show how to pass information from your ADF application to the DB session. This allows the DB administrator to identify problematic sessions on the DB side, like long-running SQL statements or…
Die Gruppierung von Daten ist eine wichtige Funktion der Datenanalyse. Attribute - wie z.B. "Preisklasse" - erleichtern oftmals die Gruppenbildung in einer BI-Anwendung. Manchmal muss ein BI-Nutzer jedoch seine Daten nach eigenen, neuen Gruppen zusammensetzen,…
Motivation Did you ever had a foreign PL/SQL-Package in Oracle that was not documented but you needed to understand what is going on inside the package?There are tools on the market that could help you…
In diesem Beitrag möchte ich die Persistant Staging Area – kurz PSA - vorstellen, welche Roelant Vos in seinem Blog beschreibt. Diese ist in von uns betreuten Projekten erfolgreich im Einsatz. DWH Basis Ein Data…