In the bygone era of database management, sluggish SQL queries often led to suspicions directed at indexes. Manual creation, deletion, and rebuilding of indexes were labor-intensive tasks, even with the assistance of scripts. However, these generic index treatments applied to diverse databases were neither precise nor efficient. Considering the distinct Read more…
Recently, I was talking to the IT infrastructure manager of a magnificent industry in the western region of Paraná. When we were talking about databases, I asked if the database was in the cloud. Demonstrating a concern for greater flexibility, control, and other issues pertinent to the company, the decision Read more…
Recently, I found myself confronted with the challenge of presenting detailed information about receivable invoices from a company. A crucial requirement was displaying the salesperson and department linked to the original sale. However, the complexity arose from multiple invoices grouping distinct sales for different salespeople and departments. To meet the Read more…
In a world overflowing with data, Data Mining projects stand out as an essential tool to uncover valuable insights. One of the most fascinating aspects of these projects is the need to go beyond the obvious, aiming to extract knowledge not immediately apparent in data analysis. Let’s explore how this Read more…
Introduction: Recently, I found myself tasked with analyzing an application that was causing an excessive number of redundant records to be stored in the database. The issue stemmed from the fact that certain pieces of information, which ideally should have been updated, were instead generating entirely new records. In this Read more…
Are you looking to integrate Google Sheets into your application? Google Sheets API provides a powerful way to interact with your spreadsheets programmatically. In this blog post, we will walk you through the process of authenticating and accessing the Google Sheets API. Prerequisites Before you begin, you’ll need the following: Read more…
Introduction In today’s data-driven business landscape, the efficient handling of data is critical for making informed decisions and shaping effective strategies. However, managing data from various sources can be a time-consuming and error-prone process. In this blog post, we will explore a Python script that automates the flow of data Read more…
In recent database management tasks, I encountered the need to extract an “attendant” ID from a JSON document stored in a CLOB column within the table df_nsf_mov_det. This information was crucial for storing the value in another table. The challenge lay in the fact that the “response” field contained a Read more…
Hello! I’m Dênio, a professional with over 15 years of experience in IT and a bachelor’s degree in Economics, which enriches my knowledge in Data Science. Since 2006, I’ve been working in data-related roles, honing my expertise in data analysis, management and utilization. This combination equips me to extract valuable Read more…