A Conceptual Data Model and Its Automatic Implementation for IoT-Based Business Intelligence Applications

In the context of Industry 4.0, the analysis of Internet-of-Things (IoT) data with business intelligence (BI) technologies has acquired high relevance. However, designing and implementing IoT-based BI applications is hard for several reasons. Therefore, we propose a novel conceptual data model based on UML profiles and model-driven architecture (MDA) for modeling and implementing IoT-based BI applications. Our approach provides highly readable data models of IoT, which are also compatible with traditional BI data models. Furthermore, it could help in the implementation process of the IoT subsystem through automatic code generation.

[1]  Athanasios V. Vasilakos,et al.  Information-centric networking for the internet of things: challenges and opportunities , 2016, IEEE Network.

[2]  Reinhard German,et al.  UML2 activity diagram based programming of wireless sensor networks , 2010, SESENA '10.

[3]  Paul Davidsson,et al.  Cloud, Edge, or Both? Towards Decision Support for Designing IoT Applications , 2018, 2018 Fifth International Conference on Internet of Things: Systems, Management and Security.

[4]  Paulo F. Pires,et al.  COMFIT: A development environment for the Internet of Things , 2017, Future Gener. Comput. Syst..

[5]  Rafik Bouaziz,et al.  An UML profile for representing real-time design patterns , 2017, J. King Saud Univ. Comput. Inf. Sci..

[6]  Mario Piattini,et al.  Metrics for data warehouse conceptual models understandability , 2007, Inf. Softw. Technol..

[7]  Athanasios V. Vasilakos,et al.  Low-Latency and Resource-Efficient Service Function Chaining Orchestration in Network Function Virtualization , 2020, IEEE Internet of Things Journal.

[8]  Juan Trujillo,et al.  A UML Based Approach for Modeling ETL Processes in Data Warehouses , 2003, ER.

[9]  Samira Si-Said Cherfi,et al.  Conceptual Modeling Quality - From EER to UML Schemas Evaluation , 2002, ER.

[10]  Sandro Bimonte,et al.  Conceptual model for spatial data cubes: A UML profile and its automatic implementation , 2015, Comput. Stand. Interfaces.

[11]  Omar Boussaïd,et al.  Design and Implementation of Active Stream Data Warehouses , 2019, Int. J. Data Warehous. Min..

[12]  Athanasios V. Vasilakos,et al.  Big data analytics: a survey , 2015, Journal of Big Data.

[13]  Athanasios V. Vasilakos,et al.  When things matter: A survey on data-centric internet of things , 2016, J. Netw. Comput. Appl..

[14]  Matteo Golfarelli,et al.  Modern Software Engineering Methodologies Meet Data Warehouse Design: 4WD , 2011, DaWaK.

[15]  Esteban Zimányi,et al.  A model-driven framework for ETL process development , 2011, DOLAP '11.

[16]  Faïez Gargouri,et al.  Structural Model of Real-Time Databases , 2008, ICEIS.

[17]  Bran Selic,et al.  Execution of UML models: a systematic review of research and practice , 2018, Software & Systems Modeling.

[18]  Ralph Kimball,et al.  The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling , 1996 .

[19]  Mike Surridge,et al.  Model-driven interoperability: engineering heterogeneous IoT systems , 2016, Ann. des Télécommunications.

[20]  Olfa Mosbahi,et al.  RWiN: New Methodology for the Development of Reconfigurable WSN , 2017, IEEE Transactions on Automation Science and Engineering.

[21]  Carlos Ordonez,et al.  Enhancing ER Diagrams to View Data Transformations Computed with Queries , 2019, DOLAP.

[22]  Kurt Geihs,et al.  FRASAD: A framework for model-driven IoT Application Development , 2015, 2015 IEEE 2nd World Forum on Internet of Things (WF-IoT).

[23]  Henry Muccini,et al.  A Study on MDE Approaches for Engineering Wireless Sensor Networks , 2014, 2014 40th EUROMICRO Conference on Software Engineering and Advanced Applications.

[24]  Athanasios V. Vasilakos,et al.  Model-Driven Development Patterns for Mobile Services in Cloud of Things , 2018, IEEE Transactions on Cloud Computing.

[25]  Athanasios V. Vasilakos,et al.  Software-Defined Networking for Internet of Things: A Survey , 2017, IEEE Internet of Things Journal.

[26]  Matteo Golfarelli,et al.  A Reference Architecture and Model for Sensor Data Warehousing , 2018, IEEE Sensors Journal.

[27]  Christian S. Jensen,et al.  Join operations in temporal databases , 2005, The VLDB Journal.

[28]  Pankesh Patel,et al.  Enabling high-level application development for the Internet of Things , 2015, J. Syst. Softw..

[29]  Veda C. Storey,et al.  Big data technologies and Management: What conceptual modeling can do , 2017, Data Knowl. Eng..

[30]  Ivica Crnkovic,et al.  Model-Driven Engineering for Mission-Critical IoT Systems , 2017, IEEE Software.

[31]  Stefano Rizzi,et al.  ProtOLAP: rapid OLAP prototyping with on-demand data supply , 2013, DOLAP '13.

[32]  Jean-Marc Petit,et al.  Extending Conceptual Data Model for Dynamic Environment , 2012, ER.

[33]  Athanasios V. Vasilakos,et al.  The Quest for Privacy in the Internet of Things , 2016, IEEE Cloud Computing.

[34]  Kenji Tei,et al.  Model-Driven-Development-Based Stepwise Software Development Process for Wireless Sensor Networks , 2015, IEEE Transactions on Systems, Man, and Cybernetics: Systems.

[35]  Rafik Bouaziz,et al.  Definition of Design Patterns for Advanced Driver Assistance Systems , 2016, VikingPLoP '16.

[36]  Emmanuel Lasso,et al.  Estimating Avocado Sales Using Machine Learning Algorithms and Weather Data , 2018, Sustainability.

[37]  Athanasios V. Vasilakos,et al.  Energy-Efficient Provisioning for Service Function Chains to Support Delay-Sensitive Applications in Network Function Virtualization , 2020, IEEE Internet of Things Journal.

[38]  Athanasios V. Vasilakos,et al.  EDAL: An Energy-Efficient, Delay-Aware, and Lifetime-Balancing Data Collection Protocol for Heterogeneous Wireless Sensor Networks , 2015, IEEE/ACM Transactions on Networking.

[39]  Athanasios V. Vasilakos,et al.  The role of big data analytics in Internet of Things , 2017, Comput. Networks.

[40]  Sushma Jain,et al.  A survey towards an integration of big data analytics to big insights for value-creation , 2018, Inf. Process. Manag..

[41]  Constantin Scheuermann,et al.  A Metamodel for Cyber-Physical Systems , 2017 .

[42]  Ivar Jacobson,et al.  The unified software development process - the complete guide to the unified process from the original designers , 1999, Addison-Wesley object technology series.

[43]  Federico Ciccozzi,et al.  MDE4IoT: Supporting the Internet of Things with Model-Driven Engineering , 2016, IDC.

[44]  Paulo F. Pires,et al.  An approach based on the domain perspective to develop WSAN applications , 2015, Software & Systems Modeling.