I recently had to migrate a PostgreSQL Database to Google’s Cloud Data Warehouse Solution BigQuery. So, I had a bunch of PostgreSQL queries to convert using BigQuery Standard SQL. It was not as easy as I thought it would be.
SQL, or Structured Query Language, is the standard language for interacting with relational databases. But, as you probably know, many dialects of SQL are available depending on the database management system you’re using: PostgreSQL, MySQL, SQL Server, etc.
The first thing you should know is that BigQuery uses legacy SQL or standard SQL. You can set up a default dialect…
Read the original article on Sicara’s blog here.
Image Registration is a fundamental step in Computer Vision. This article presents OpenCV feature-based methods before diving into Deep Learning.
Image registration is the process of transforming different images of one scene into the same coordinate system. These images can be taken at different times (multi-temporal registration), by different sensors (multi-modal registration), and/or from different viewpoints. The spatial relationships between these images can be rigid (translations and rotations), affine (shears for example), homographies, or complex large deformations models.
Welcome to the March edition of our best and favorite articles in AI that were published this month. We are a Paris-based company that does Agile data development. This month, we spotted articles about Neural Networks, Neural Architecture Search and more. We advise you to have a Python environment ready if you want to follow some tutorials :). Let’s kick off with the comic of the month: