The processing of information in real-time (through the processing of complex events) has become an essential task for the optimal functioning of manufacturing plants. Only in this way can artificial intelligence, data extraction, and even business intelligence techniques be applied, and the data produced daily be used in a beneficent way, enhancing automation processes and improving service delivery. Therefore, professionals and researchers need a wide range of tools to extract, transform, and load data in real-time efficiently. Additionally, the same tool supports or at least facilitates the visualization of this data intuitively and interactively. The review presented in this document aims to provide an up-to-date review of the various tools available to perform these tasks. Of the selected tools, a brief description of how they work, as well as the advantages and disadvantages of their use, will be presented. Furthermore, a critical analysis of overall operation and performance will be presented. Finally, a hybrid architecture that aims to synergize all tools and technologies is presented and discussed.

To further evolve urban quality of life, this paper explores the potential of crowdsensing and crowdsourcing in the context of smart cities. To aid urban planners and residents in understanding the nuances of day-to-day urban dynamics, we actively pursue the improvement of data visualisation tools that can adapt to changing conditions. An architecture was created and implemented that ensures secure and easy connectivity between various sources, such as a network of Internet of Things (IoT) devices, to merge with crowdsensing data and use them efficiently. In addition, we expanded the scope of our study to include the development of mobile and online applications, emphasizing the integration of autonomous and geo-surveillance. The main findings highlight the importance of sensor data in urban knowledge. Their incorporation via Tepresentational State Transfer (REST) Application Programming Interface (APIs) improves data access and informed decision-making, and dynamic data visualisation provides better insights. The geofencing of the application encourages community participation in urban planning and resource allocation, supporting sustainable urban innovation.