doubles-that-could-be-integers
By Data Quality
Data quality issue
Incorrectness > semantic > term > numeric
Datasets sometimes define their numeric data incorrectly at the term level. There is an important distinction between decimal numbers (including integers) and floating-point numbers. Both are defined in XML Schema 1.1: Datatypes. It is especially common to represent decimal numeric data using floating-point numbers.
Purpose
This query gives an overview of the properties that are likely to using floating-point numbers to represent decimal numeric data.
Implementation
This is done by automatically converting each double (xsd:double
) to an integer (xsd:integer
), and back to a double again. If no information was lost, the double could have been modeled as an integer.