Load Balancing and Processing Data From Internet of Things Smart Devices

Michał Gorawski


The evolution of Internet of Things and Information and Communication Technology is determined by systems’ ability to efficiently store and process massive amount of data connected with rapid flow of information. The smart devices creating Internet of Things produce massive amount of data, and while smart devices are independent, data analyst needs an effective mechanism to collect all these data, aggregate them and analyse. In this paper author presents Distributed Spatio- Temporal Data Warehouse systems as a platform to collect and analyse Internet of Things data such as smart sensor data and mobility data


Data Warehouse; Load Balancing; Internet of Things; Smart Meters; Mobility modelling

Full Text:




González M.C., Hidalgo C.A., Barabási A.-L.: Understanding individual human mobility patterns. Nature, vol. 453, 2008, p. 779÷782.

Eder J., Koncilia C.: Changes of Dimension Data in Temporal Data Warehouses. p. 284÷293. Springer Berlin Heidelberg, Berlin, Heidelberg (2001). DOI 10.1007/ 3-540-44801-2˙28. URL http://dx.doi.org/10.1007/3-540-44801-2_28

Ekman F., Keranen A., Karvo J., Ott J.: Working day movement model. Proceedings of the 1st ACM SIGMOBILE Workshop on Mobility Models, MobilityModels ’08, p. 33÷40. ACM, New York, NY, USA (2008). DOI 10.1145/1374688.1374695. URL http://doi.acm.org/10.1145/1374688.1374695.

Foremski P., Gorawski M., Grochla K.: Source Model of TCP Traffic in LTE Networks. p. 125÷135. Springer International Publishing, Cham (2014). DOI 10.1007/978-3-319-09465-6˙14. URL http://dx.doi.org/10.1007/ 978-3-319-09465-6_14

Gorawski M.: Architektura Przemysłowych Hurtowni Danych. X Konf. Systemy Czasu Rzeczywistego. Ustroń 2003.

Gorawski M.: Indeksowanie i równoważenie obciążeń w rozproszonych systemach przestrzenno-temporalnych hurtowni danych. Rozprawa doktorska.

Gorawski M.: Load Balancing in Data Warehouse – Evolution and Perspectives. Wydawnictwo Politechniki Wrocławskiej, 2013, p. 175÷185.

Gorawski M.: Zaawansowane hurtownie danych. Monografia. Politechnika Śląska, Gliwice 2017.

Gorawski M., Bańkowski S., Gorawski M.: Indeksowanie węzłów gridowej hurtowni danych telemetrycznych o indeksach: Mvb, stcat, mdpas. Zesz. Nauk. Wydz. ETI, Politechnika Gdańska, 2006.

Gorawski M., Bańkowski S., Gorawski M.: The software agents in a database grid. Proceedings of the International Multiconference on Computer Science and Information Technology. XXII Autumn Meetings of PIPS, Wisła, Poland 2006.

Gorawski M., Gabryś M.: Telemetryczny System Zintegrowanego Odczytu Liczników. Współczesne problemy sieci komputerowych, WNT, Warszawa 2004, p. 203÷211.

Gorawski M., Gorawski M.: Balanced spatio-temporal data warehouse with r-mvb, stcat and bitmap indexes. International Symposium on Parallel Computing in Electrical Engineering (PARELEC’06), 2006, p. 43÷48. DOI 10.1109/PARELEC.2006.21

Gorawski M., Gorawski M., Bankowski S.: Selection of indexing structures in grid data warehouses. In: Proceedings of the International Multiconference on Computer Science and Information Technology. XXII Autumn Meetings of PIPS, Wisła, Poland 2006.

Gorawski M., Gorawski M., Bańkowski S.: Selection of indexing structures in grid data warehouses with software agents. In: Int. J. Comput. Sci. Appl, 2007.

Gorawski M., Gorawski M., Dyduch S.: Use of grammars and machine learning in etl systems that control load balancing process. In: 2013 IEEE 10th International Conference on High Performance Computing and Communications 2013 IEEE International Conference on Embedded and Ubiquitous Computing, 2013, p. 1709÷1714. DOI 10.1109/HPCC.and.EUC.2013.243

Gorawski M., Gorawski M., Faruga M.: Stah-tree: Quality tests of hybrid index for spatio-temporal aggregation. In: Proceedings of the 2008 Conference on New Trends in Multimedia and Network Information Systems, p. 115÷124. IOS Press, Amsterdam, The Netherlands, The Netherlands, 2008. URL:


Gorawski M., Grochla K.: The real-life mobility model: RLMM. In: 2013 Second International Conference on Future Generation Communication Technology (FGCT), IEEE, 2013, p. 201÷206.

Gorawski M., Isakow J.: Algorytm adaptacyjnego równoważenia obciążeń zapytań w rozproszonych przestrzenno-temporalnych hurtowniach danych. In: BDAS – Bazy Danych: Aplikacje i Systemy. Ustron, Poland 2013.

Gorawski M., Lis D.: Architektura CUDA w bezopóznieniowych hurtowniach danych. In: Studia Informatica, Vol. 32, 2011, p. 157÷167.

Gorawski M., Lis D., Gorawski M.: The Use of a Cloud Computing and the CUDA Architecture in Zero-Latency Data Warehouses. Springer Berlin Heidelberg, Berlin, Heidelberg, 2013, p. 312÷322. DOI 10.1007/978-3-642-38865-1˙32.

URL: http://dx.doi.org/10.1007/978-3-642-38865-1_32

Gorawski M., Marks P., Gorawski M.: Modeling Data Stream Intensity in Distributed Stream Processing System. Springer, Berlin, Heidelberg 2013, p. 372÷383.

Gorawski M., Skrzewski M., Gorawski M., Gorawska A.: Neural Networks in Petrol Station Objects Calibration. Springer International Publishing, 2015, p. 714÷723.

Gorawski M., Wardas R.: The workload balancing ETL system basing on a learning machine. In: Studia Informatica, Vol. 31, 2010, p. 517÷530.

Gorawski M., Bankowski S.: Rbtat: Red-black table aggregate tree. In: International Conference on Man-machine Interactions, September 25-27, 2009 The Beskids – Kocierz Pass, Poland 2009.

Hua K., Lo Y., Young H.: GeMDA: A Multidimensional Data Partitioning Technique for Multi-processor Database Systems. In: Distributed and Parallel Databases, 2001, p. 211÷236.

Huang J., Qian F., Guo Y., Zhou Y., Xu Q., Mao Z.M., Sen S., Spatscheck O.: An in-depth study of LTE: Effect of network protocol and application behavior on performance. In: Proceedings of the ACM SIGCOMM 2013 conference on SIGCOMM, ACM, 2013, p. 363÷374.

Lee K., Hong S., Kim S.J., Rhee I., Chong S.: Slaw: Self-similar least-action human walk. IEEE/ACM Transactions on Networking 20(2), 2012, p. 515÷529. DOI 10.1109/TNET.2011.2172984

Marks P.: Wybrane problemy ładowania strumieni danych do hurtowni danych. Rozprawa doktorska.

NhatHai Phan Dino Ienco, D.M.P.P., Teisseire M.: Mining multi-relational gradual patterns. In: Proceedings of the SIAM International Conference on Data Mining (SDM 2015), Vancouver, Canada 2015.

NhatHai Phan P.P., Teisseire M.: All in one: Mining multiple movement patterns. In: International Journal of Information Technology & Decision Making (IJITDM), 2016.

NhatHai Phan Dino Ienco P.P., Teisseire M.: Mining time relaxed gradual moving object clusters. In: In Proceedings of the 20th ACM SIGSPATIAL International Conference on Advances in Geographic Information Systems (ACM GIS 2012), Redondo Beach, California 2012.

DOI: http://dx.doi.org/10.21936/si2017_v38.n4.822