BLOG – Karol Wieliczko – databases and machine learning issues
The 23ai database, as the name suggests and the numerous announcements on the official website, has been integrated with artificial intelligence (AI) technology. One of the solutions in this area is the Vector Search functionality, which, as you will soon see, simply takes modern data processing to a whole new level. This is particularly important …
Oracle AWR (Automatic Workload Repository) reports are a diagnostic tool available in Oracle databases that helps analyze system performance and identify areas requiring optimization. At first glance they look, let’s be honest, quite complicated. Lots of sections, lots of numbers and parameters. Due to their detailed and technical nature, they require some experience in use. …
In this article, we will look at how to quickly configure the Oracle 21C database for programming purposes using Docker. What are Docker containers? It is a packaging format that accumulates code and apprenticeships in a form that allows quick and reliable operation in all computing environments. Using containerization, we can quickly start the platform …
Recently, I was reported a problem, consisting in the slow operation of the inquiry in the production database. As it turned out, the reason was the use of the wrong plan by the optimizer, which in effect led to a heavy load on the base and slowed work of the application. The same question is …
For as long as I can remember, I have always been interested in the real estate market. This was due to my frequent change of apartments and the fact that each time I carried out all sales and purchase formalities myself. Searching for a good location is an extremely exciting, but also time-consuming process. In …
Tom Kyte, author of many books related to Oracle databases, on his blog he once described the history of the impact of atmospheric precipitation on the speed of SQL queries in the Oracle database. This article is unfortunately no longer available, but I will try to describe this strange story myself. But what’s the matter? …
When dealing with Machine Learning issues, we often face the problem of obtaining valuable data. We do not always have access to professional bases, powered by the content exactly what we care about. The construction of a machine (scraper), which will download the content from the Internet we are interested in. Writing an article (The …