EE2: Development of data organization methods and systems

EU Responsible (Organization)GEORGE KOURTIDIS BROTHERS S.A. & ELKE – INTERNATIONAL UNIVERSITY OF GREECE
Start Date1/1/2022 12:00:00 AM
Expiry date30/9/2023 12:00:00 AM

Description

Industrial research in the development of methods for organizing data. This process involves collecting heterogeneous data from various sources and integrating them into the fact table and dimension tables of the data warehouse in a snowflake shape. A multidimensional data model will be developed that will display the data in the form of cubes. The development of data cubes enables the transformation and modeling of data in multiple dimensions. The data warehouse schema that will be developed consists of: a) dimension tables with information about the dimensions of the cube and b) fact tables with characteristic fields that will be foreign keys to the related dimension tables. At the same time, a system for recording raw materials during the product production process and a decision-making system through analysis and correlation rules will be developed. Finally, appropriate programs in free software (e.g. Python) will be developed for the implementation of the methods and systems. Also, the programs will have the ability to be integrated into the technologies with which the platform will be implemented.

drone square

The deliverables of EE2 are the following:

  • P2.1: Data Warehouse Model Technical Reference Λήψη Τεχνικής αναφοράς σχεδίου υλοποίησης έργου σε μορφή PDF
  • P2.2: Data analysis method and correlation rules Λήψη Τεχνικής αναφοράς σχεδίου υλοποίησης έργου σε μορφή PDF
  • P2.3: Free software program (e.g. Python) for data analysis and association rules Λήψη Τεχνικής αναφοράς σχεδίου υλοποίησης έργου σε μορφή PDF
  • P2.4: Program in free software (e.g. Python) making
    decisions through analyses and correlation rules Λήψη Τεχνικής αναφοράς σχεδίου υλοποίησης έργου σε μορφή PDF