• Anjana Yadav
• Dr.Balveer Singh

The Online Analytical Processing (OLAP) is highly suitable for examination and processing of healthcare data by utilizing the consistent models in IoT devices. The OLAP models are introduced on large medical data warehouses for computation and decision making to reduce the processing overhead of data in IoT devices. The multidimensional, relational and hybrid representation of healthcare data are specifically used for describing the OLAP models. The multidimensional data cube model is examined in sturdy time for processing of OLAP queries over IoT devices. The query processing is highly expensive and time consuming for large medical data warehouses. This cost and time of query processing are reduced by using several strategies and heuristics to offer efficient OLAP examination by improving the performance materialized medical data cube selection strategy in IoT devices. The query processing is also improved by using the data clustering over huge data warehouses storing the different types of information such as medical, defence, industrial and confidential transmitted through IoT devices. These numerous amounts of medical information are easily and quickly accessed and processed by IoT users, if the data is arranged into groups using clustering rather than in raw form. The main motive of this research paper is given an extensive collection of valuable healthcare data about OLAP analysis, models, query processing techniques, problems and optimization methods in various environments using ioT devices. Hence, the researchers can be utilized the important medical data over IoT devices to implement novel and efficient techniques for OLAP data analysis. A brief literature of prior researches is further illustrated in textual and tabular arrangements to give the inspiration to researchers for implementing innovative hypothesis for OLAP data examination.

Data Clustering, IoT, Materialized Data Cube, OLAP, Optimization, Query Processing, Warehouse

"Exploration of various Models used for Online Analytical Process (OLAP) : A Review", International Journal of Emerging Technologies and Innovative Research (www.jetir.org), ISSN:2349-5162, Vol.9, Issue 7, page no.e307-e310, July-2022, Available :http://www.jetir.org/papers/JETIR2207440.pdf

"Exploration of various Models used for Online Analytical Process (OLAP) : A Review", International Journal of Emerging Technologies and Innovative Research (www.jetir.org | UGC and issn Approved), ISSN:2349-5162, Vol.9, Issue 7, page no. ppe307-e310, July-2022, Available at : http://www.jetir.org/papers/JETIR2207440.pdf