Search⌘ K
AI Features
Home
Courses
Simple Anomaly Detection using SQL

Preparing the Data

Explore how to prepare server log data for anomaly detection by creating a complete time-status code axis using PostgreSQL functions. Understand the importance of filling data gaps with zero values in SQL tables to improve accuracy when analyzing web server response codes.

We'll cover the following...

Data in server logs

Application servers such as Nginx, Apache, and IIS write very useful information to access logs. The data in these logs can be instrumental in identifying anomalies.

We will analyze logs of a web application, so the data we are most interested in is the timestamp and the status code of every response from the server. To illustrate the type of insight, we can ...