Note dal metodo
Blog

What is a vector database?
Vector databases are designed to store and search high-dimensional data, such as embeddings of text, images, or audio. These tools…

Database Design: Why 73% of IT Projects Fail Before They Even Begin
Do you know why that new business app that was supposed to ‘change everything’ has become slow and error-prone? The…

New Emerging Databases in 2025
In 2025, the database landscape is experiencing unprecedented acceleration, driven by artificial intelligence, cloud-native computing and multi-model architectures. Emerging solutions…

HBIM: 3D reconstructions of ancient buildings
HBIM, which stands for Heritage or Historic Building Information Modeling, is a data-driven technology that aims to capture and represent…

PostGIS: introduction to the spatial database
Spatial data have become a key piece of information for many applications in recent years. Their use is no longer…

ElasticSearch: how and when to use it
Textual search engines are a feature that plays an important role in the construction of applications. The user experience is…

SQL: triggers in Oracle
Databases can play an active role in validating and implementing business rules. Through triggers it is possible, in fact. to…

SQL: Recursive CTE
In some scenarios, there is a need to store hierarchies within the database, such as the corporate organizational chart or…

SQL: correlation
In the SQL language, it is possible to condition the execution of a query on the values of the tuples…

SQL: Common Table Expression
Expressing complex queries in SQL language can be really difficult. Dividing the problem into mini-queries is the best strategy to…