HbA1c values calculated from blood glucose levels using truncated Fourier series and implementation in standard SQL database language
Related Experiment Video
Updated: Jul 2, 2026

Improving IV Insulin Administration in a Community Hospital
Published on: June 11, 2012
1Section of Medical Information and Retrieval Systems, Core Unit for Medical Statistics and Informatics, Medical University of Vienna, Vienna, Austria. Wilhelm.Temsch@meduniwien.ac.at
Objectives:
This article presents a mathematical model to calculate HbA1c values based on self-measured blood glucose and past HbA1c levels, thereby enabling patients to monitor diabetes therapy between scheduled checkups. This method could help physicians to make treatment decisions if implemented in a system where glucose data are transferred to a remote server. The method, however, cannot replace HbA1c measurements; past HbA1c values are needed to gauge the method.
Methods:
The mathematical model of HbA1c formation was developed based on biochemical principles. Unlike an existing HbA1c formula, the new model respects the decreasing contribution of older glucose levels to current HbA1c values. About 12 standard SQL statements embedded in a php program were used to perform Fourier transform. Regression analysis was used to gauge results with previous HbA1c values. The method can be readily implemented in any SQL database.
Results:
The predicted HbA1c values thus obtained were in accordance with measured values. They also matched the results of the HbA1c formula in the elevated range. By contrast, the formula was too "optimistic" in the range of better glycemic control. Individual analysis of two subjects improved the accuracy of values and reflected the bias introduced by different glucometers and individual measurement habits.
Related Concept Videos
Hyperglycemia
Average Value of a Function
Hypoglycemia
Type II Diabetes Mellitus III: Clinical Manifestations and Diagnosis
Hormones Regulating Blood Glucose
In addition to accelerating glucose uptake and utilization, insulin has...
z Scores and Area Under the Curve