What is an anomaly?

Question

What is an anomaly?

Amit Mohanty · Answer

The term anomaly is used to describe a discrepancy between two parts of a database. In a retail database, for example, you may have a customer and an invoice table. If you are no longer selling to customers, you may want to purge them from your database periodically. If you delete a customer but keep their invoices for the purchases they have made, you have an anomaly. There is an invoice for a customer that doesn't exist anymore. By deleting all of a customer's invoices when you delete a customer, this anomaly can be avoided. For more details check the below article. https://www.scaler.com/topics/anomalies-in-dbms/

Brahma Prakash Shukla · Answer

An anomaly is a deviation from the norm, a glitch or an error that doesn't fit in with the rest of the pattern of the database . Normalization takes care of these anomalies.

Vishal Yelve · Answer

Hi Naresh, An anomaly is any user activity that is sufficiently different from the historical activity of the same user . Please refer to below links for more details https://cloudmonitor.ai/2022/02/azure-anomaly-detection-api/ https://learn.microsoft.com/en-us/azure/cognitive-services/anomaly-detector/

What is an anomaly?

Answers (3)