Hello there! 👋 I'm Luca, a BI Developer with a passion for all things data, Proficient in Python, SQL and Power BI ...

In a world where data sprawls across clouds, data centres and edge locations, managing it all has become a messy, expensive challenge. That’s what brought IT leaders, CIOs and database professionals ...

An essential bridge connecting human language and structured query languages (SQL) is text-to-SQL. With its help, users can convert their queries in normal language into SQL commands that a database ...

Abstract: In recent years, XML technology has won wide attention from both industry and academic. It can be used to mark data, define the data type and their own markup language. It is a ...

Abstract: The filtering of XML data is the basis of many complex applications. Lots of algorithms have been proposed to solve this problem. One important challenge is that the number of path queries ...

This project is on the use of SQL and PL/SQL to solve shortest path problems on large networks on an Oracle database. It provides solutions in pure SQL (based on previous articles by the author), and ...

We continue to see increased migration to the cloud, with analytical workloads leading that charge. Customers have indicated that analytics in the cloud best aligns to employee skillsets, deployment ...

In this post, we will talk about how to validate XML against XSD in Notepad++. An XML (eXtensible Markup Language) file is a markup file that consists of a set of rules for encoding documents in both ...