Challenges and opportunities in designing data structures for a smart city

Costel Ciuchi (), Alin Bonciu (), Ana-Maria Dinca () and Mihai Stoian ()
Additional contact information
Costel Ciuchi: Faculty of Electronics, Telecommunications and Information Technology,National University of Science and Technology POLITEHNICA Bucharest, Romania
Alin Bonciu: Faculty of Automatic Control and Computer Science,National University of Science and Technology POLITEHNICA Bucharest, Romania
Ana-Maria Dinca: Faculty of Electronics, Telecommunications and Information Technology,National University of Science and Technology POLITEHNICA Bucharest, Romania
Mihai Stoian: Faculty of Automatic Control and Computer Science,National University of Science and Technology POLITEHNICA Bucharest, Romania

Smart Cities International Conference (SCIC) Proceedings, 2023, vol. 11, 185-196

Abstract: The Internet of Things generates a vast amount of data in smart cities. However, with the increasing popularity of cloud storage and the ever-improving hardware, data storage is no longer a problem. Despite this, there may still be a need to conduct research and analyze aspects such as data variety and velocity to address some technological issues. This paper explores the concepts of normalization and denormalization in SQL and NoSQL databases, highlighting their advantages and disadvantages. It emphasizes the importance of carefully designing data structures in smart city applications. It is essential to consider the best approach to organize and manage information, taking into account the various areas of interest. To identify relevant data, analytics techniques are required to discover patterns, insights, and trends from large and complex data sets. One way to do this is through AI linked with Machine Learning. This approach can provide a better understanding of policy formulation, resource allocation, infrastructure planning, and service optimization. Additionally, we present a case study of a smart city application called SmartSantander, which illustrates how the use of NoSQL databases and denormalization can improve query performance. This could be a solution for addressing the data velocity problem. The article also emphasizes the importance of interoperability and cybersecurity in smart city data structure design. It highlights the use of JSON as a data interchange format and the need for secure data warehousing to protect sensitive information. Finally, our goal is to outline a solution that a smart city could implement to manage data effectively and securely. We propose using a hybrid approach that satisfies all its needs

Keywords: cloud adoption; marketing plan; migration to cloud; security professionals; deception technology (search for similar items in EconPapers)
JEL-codes: O35 (search for similar items in EconPapers)
Date: 2023
References: View complete reference list from CitEc
Citations:

Downloads: (external link)
https://scrd.eu/index.php/scic/article/view/492/454 (application/pdf)
https://scrd.eu/index.php/scic/article/view/492 (text/html)

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:pop:procee:v:11:y:2023:p:185-196

Access Statistics for this article

More articles in Smart Cities International Conference (SCIC) Proceedings from Smart-EDU Hub, Faculty of Public Administration, National University of Political Studies & Public Administration Contact information at EDIRC.
Bibliographic data for series maintained by Professor Catalin Vrabie ().