Author
Abstract
The rapid growth of Internet of Things (IoT) deployments generates continuous, high-volume telemetry that strains query processing in large-scale databases, and static rule-based or cost-based optimizers do not adapt to the resulting workload variability. This research proposes a machine learning-based query performance optimization framework that identifies high-priority telemetry records from predicted operating conditions and formalizes a mathematically defined priority-scoring mechanism that a database system can use to allocate indexing, caching, and execution resources adaptively. The framework was developed and validated using the publicly available Environmental Sensor Telemetry Dataset (405,184 raw IoT records collected over eight days from three Raspberry Pi-based sensor nodes; cleaned to 385,452 records), with a binary hazard label derived from carbon-monoxide (CO) concentration against an EPA-informed threshold. Seven candidate classifiers, K-Nearest Neighbors, Logistic Regression, an Artificial Neural Network, Gaussian Naive Bayes, Linear Discriminant Analysis, a Support Vector Machine, and CatBoost, were trained on a stratified-representative 10,000-record sample (8,000 train / 2,000 test, class balance within 0.5 percentage points of the full population) and compared on accuracy, precision, recall, F1-score, prediction variance, and mean absolute error. CatBoost was selected as the proposed model, achieving 99.9% accuracy (95% CI: 99.76–100.00%), compared with 92.1–95.0% for the next-best classifiers. A correlation analysis quantified strong collinearity among CO, LPG, and smoke channels (r ≈ 1.00) and a moderate negative association with humidity (r ≈ −0.70 to −0.71), which is shown to reduce the effective dimensionality of the sensor feature space and motivates a composite-index recommendation for the underlying time-series store. The trained classifier's output probability is used to define a formal query/index priority score and a resource-allocation objective for adaptive optimization. Results demonstrate that the proposed framework provides a statistically validated, computationally efficient basis for adaptive IoT query optimization; full deployment-scale latency benchmarking against a live database engine is identified as future work.
Suggested Citation
Handle:
RePEc:gvu:itdw00:v:8:y:2026:i:4:id:2404
DOI: 10.36548/jitdw.2026.4.001
Download full text from publisher
Corrections
All material on this site has been provided by the respective publishers and authors. You can help correct errors and omissions. When requesting a correction, please mention this item's handle: RePEc:gvu:itdw00:v:8:y:2026:i:4:id:2404. See general information about how to correct material in RePEc.
If you have authored this item and are not yet registered with RePEc, we encourage you to do it here. This allows to link your profile to this item. It also allows you to accept potential citations to this item that we are uncertain about.
We have no bibliographic references for this item. You can help adding them by using this form .
If you know of missing items citing this one, you can help us creating those links by adding the relevant references in the same way as above, for each refering item. If you are a registered author of this item, you may also want to check the "citations" tab in your RePEc Author Service profile, as there may be some citations waiting for confirmation.
For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: Journal Manager (email available below). General contact details of provider: https://irojournals.com/itdw .
Please note that corrections may take a couple of weeks to filter through
the various RePEc services.