EE2: Development of data organization methods and systems
| EU Responsible (Organization) | GEORGE KOURTIDIS BROTHERS S.A. & ELKE – INTERNATIONAL UNIVERSITY OF GREECE |
| Start Date | 1/1/2022 12:00:00 AM |
| Expiry date | 30/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.
The deliverables of EE2 are the following:
