virtual7 Blog

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 words or span of words which denote an Entity, in this case a SKILL. For this I’ve been using spacy

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 will receive something like this:  Our text: “As an IT consulting and software company, virtual7 GmbH develops solutions and IT

Hardly anyone remembers the poster campaign from 2012, a slogan that has never fit as well as this year.

In one of my older blogposts “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 the query gets executed. It turned out that the method provided in the old blogpost did not print out all

It happens again and again that (Oracle) database applications are “too slow”. We then try to find out what the cause is and, if we are lucky, we find an idea to change the SQL statement that is causing the problem so that the application is “fast enough”. What is often overlooked in this whole

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 long waiting sessions. If you run a real-world application on a server, not necessarily an ADF application, you can run

Grouping data is an important function of data analysis. Attributes – such as “price class” – often facilitate group formation in a BI application. Sometimes, however, a BI user has to compile their data according to their own, new groups for which no attributes are available in the database. Oracle Business Intelligence Suite (OBI) provides

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 with this problem. But what if you don’t want to spend any money?Oracle could tell you all that need to

In this article, I would like to introduce the Persistant Staging Area – PSA for short – which Roelant Vos describes in his blog. This is used successfully in projects that we support. DWH Base A data warehouse (DWH) is often divided into three or four basic layers. The staging area is the first layer

Als Kind dachte ich, im Jahr 2021 könnten Autos fliegen und Roboter wären unsere alltäglichen Begleiter. Heute würde ich Marty McFly nicht raten ins Jahr 2021 zu reisen, sicherlich wäre er ein wenig enttäuscht. Alle Zukunftsvisionen, die mich als Kind fasziniert haben, wurden durch die Realität verdrängt. Ist das Digitalisierung? Heute bin ich froh, wenn

In this blog, I will explain how to show or hide the expand icon of an af:tree component depending on available children. The image on the left shows how a simple af:tree component renders. We see that each of the master nodes (departments) shows an icon that is used to expand the node. The problem

This is the sixth in a series of articles on our “Home Office Challenges App (HOCA)”. It describes StencilJS and the way we used it for our application. What is StencilJS? Many of you have already heard about big JavaScript Frameworks like React, Angular, or Vue.js. They are well-suited for a wide range of applications