This course is intended for computing sophomores and aims at presenting basic principles of relational DBMS and the practice of these fundamentals. The course content is mainly the following: Chapter 1: Introduction to databases Chapter 2: Relational Model Chapter 3: Relational Algebra Chapter 4: Standardization Chapter 5: SQL Language Chapter 6: Practical work A set of exercises are included at the end of the document. We added a tutorial section and directed to allow students to apply the concepts learned in the five chapters.

Les processus complexes industriels présentent des dynamiques hautement non linéaires et possèdent un grand nombre de variables, pour lesquels il est parfois difficile d'obtenir un modèle mathématique précis qui permet de détecter les états anormaux. En effet, les techniques de l'IA, ont prouvé leur efficacité dans le contrôle et la surveillance des systèmes industriels. L'objectif, est de les appliquer dans un système de fabrication du ciment à des fins de supervision. Ceci permet d'éviter les arrêts inutiles, réduire la consommation d'énergie et évoluer la production. Plusieurs outils peuvent permettre de réaliser un tel travail. Parmi eux, la plateforme PCS, la bibliothèque CEMAT et FuzzyControl++.

In this book, we propose several modules of diagnosis for complex and dynamic systems. These modules are based on the three algorithms colony of ants, which are AntTreeStoch, Lumer & Faieta and Binary ant colony. These algorithms have been chosen for their simplicity and their vast field of application. However, these algorithms cannot be used under their basal form for the development of diagnostic modules since they have several limitations. We have also proposed several adaptations in order that these algorithms can be used in diagnostic modules. We have proposed a parallel version of the algorithm AntTreeStoch based on a reactive multi-agents system. This version allows minimizing the influence of initial sort on the outcome of classification. We have also introduced a new parameter called Sid, which allows several ants to connect to the same position, and we have modified the movements of ants by promoting the path of the ant the most similar. For the algorithm Lumer & Faieta, we have accelerated the speed of construction of classes by adding a speed setting different for each Ant. To reduce the number of movements, we have proposed a new variable that allows saving the identifiers of objects displaced by the same Ant. To improve the quality of classification, we have also added to the algorithm of the indices to report the classes trunks constructed. For the algorithm Binary ant colony, we have proposed a variant called "Hybrid wrapper/filter-based ACO-SVM". This algorithm allows the selection of parameters. It combines the techniques of filters and enveloping methods in taking advantage of the rapidity of the Fisher report and the adaptation of selected settings to the classifier SVM. It improves the quality of classification according to the data nature in the database for learning and the type of the kernel function used. It also allows adjusting the hyperparameters of the kernel function. We tested these algorithms based on data from two industrial systems, which are the sintering system and the pasteurization system, as well on a few databases of UCI (University of California, Irvine).

Quo Vadis Machine Learning-Based Systems Condition Prognosis?—A Perspective

Benbouzid, Mohamed, and Tarek Berghout. 2023. “Quo Vadis Machine Learning-Based Systems Condition Prognosis?—A Perspective”. Electronics 12 (3) : 527. Publisher's Version Abstract

Data-driven prognostics and health management (PHM) is key to increasing the productivity of industrial processes through accurate maintenance planning. The increasing complexity of the systems themselves, in addition to cyber-physical connectivity, has brought too many challenges for the discipline. As a result, data complexity challenges have been pushed back to include more decentralized learning challenges. In this context, this perspective paper describes these challenges and provides future directions based on a relevant state-of-the-art review.

Lithium-ion Battery State of Health Prediction with a Robust Collaborative Augmented Hidden Layer Feedforward Neural Network Approach

Berghout, Tarek, et al. 2023. “Lithium-ion Battery State of Health Prediction with a Robust Collaborative Augmented Hidden Layer Feedforward Neural Network Approach”. IEEE Transactions on Transportation Electrification. Publisher's Version Abstract

Lithium-ion (Li-ion) batteries play an important role in providing necessary energy when acting as a main or backup source of electricity. Indeed, the unavailability of battery aging discharge data in most real-world applications makes the State of Health (SoH) assessment very challenging. Alternatively, accelerated aging is therefore adopted to emulate the degradation process and to achieve an SoH estimate. However, accelerated aging generates limited deterioration patterns suffering from a higher level of complexity due to the non-linearity and non-stationarity imposed by harsh conditions. In this context, this paper aims to provide a predictive model capable of solving incomplete data problems by providing two main solutions for each of the problems of complexity and missing patterns, respectively. First, to overcome the problem of lack of patterns, a robust collaborative feature extractor (RCFE) is designed by collaborating between a set of improved restricted Boltzmann machines (I-RBMs) to be able to share learning knowledge among different locally trained I-RBMs to create a more generalized global extraction model. Second, a set of RCFEs is then evolved through a neural network with an augmented hidden layer (NAHL) to enhance the predictive ability by further exploring representation learning to overcome pattern complexity issues. The designed RCFE-NAHL is trained to predict SoH using constant current (CC) discharge characteristics by implying multiple characteristics recorded through the constant voltage (CV) charging process as indicators of health. The proposed SoH prediction approach performances are evaluated on a set of battery life cycles from the well-known NASA database. In this context, the achieved results clearly highlight the higher accuracy and robustness of the proposed learning model.

2DF-IDS: Decentralized and differentially private federated learning-based intrusion detection system for industrial IoT

Othmane, Friha, et al. 2023. “2DF-IDS: Decentralized and differentially private federated learning-based intrusion detection system for industrial IoT”. Computers & Security 127. Publisher's Version Abstract

Advanced technologies, such as the Internet of Things (IoT) and Artificial Intelligence (AI), underpin many of the innovations in Industry 4.0. However, the interconnectivity and open nature of such systems in smart industrial facilities can also be targeted and abused by malicious actors, which reinforces the importance of cyber security. In this paper, we present a secure, decentralized, and Differentially Private (DP) Federated Learning (FL)-based IDS (2DF-IDS), for securing smart industrial facilities. The proposed 2DF-IDS comprises three building blocks, namely: a key exchange protocol (for securing the communicated weights among all peers in the system), a differentially private gradient exchange scheme (achieve improved privacy of the FL approach), and a decentralized FL approach (that mitigates the single point of failure/attack risk associated with the aggregation server in the conventional FL approach). We evaluate our proposed system through detailed experiments using a real-world IoT/IIoT dataset, and the results show that the proposed 2DF-IDS system can identify different types of cyber attacks in an Industrial IoT system with high performance. For instance, the proposed system achieves comparable performance (94.37%) with the centralized learning approach (94.37%) and outperforms the FL-based approach (93.91%) in terms of accuracy. The proposed system is also shown to improve the overall performance by 12%, 13%, and 9% in terms of F1-score, recall, and precision, respectively, under strict privacy settings when compared to other competing FL-based IDS solutions.

Faulty Detection System Based on SPC and Machine Learning Techniques

Benrabah, Mohamed-Elamine, Ouahab Kadri, and Nadia-Kenza Mouss. 2023. “Faulty Detection System Based on SPC and Machine Learning Techniques”. Revue de l’Intelligence Artificielle : 969-977. Publisher's Version Abstract

Starting from a worrying observation, that companies have difficulties controlling the anomalies of their manufacturing processes, in order to have a better control over them, we have realized a case study on the practical data of the Fertial Complex to analyze the main parameters of the ammonia neutralization by nitric acid process. This article proposes a precise diagnostic of this process to detect dysfunction problems affecting the final product. We start with a general diagnosis of the process using the SPC method, this approach is considered an excellent way to monitor and improve the product quality and provides very useful observations that allowed us to detect the parameters that suffer from problems affecting the quality. After the discovery of the parameters incapable to produce the quality required by the standards, we applies two machine learning technologies dedicated to the type of data of these parameters for detected the anomaly, the first technique called The kernel connectivity-based outlier factor (COF) algorithm consists in recording for each object the degree of being an outlier, the second technique called the Isolation Forest, its principle is to establish a forest to facilitate the calculation and description. The results obtained were compared in order to choose which is the best algorithm to monitor and detect the problems of these parameters, we find that the COF method is more efficient than the isolation forest which leads us to rely on this technology in this kind of process in order to avoid passing a bad quality to the customer in future.

IoT-based food traceability system: Architecture, technologies, applications, and future trends

Mehannaoui, Raouf, Kinza-Nadia Mouss, and Karima Aksa. 2023. “IoT-based food traceability system: Architecture, technologies, applications, and future trends”. Food Control 145. Publisher's Version Abstract

An effective Food Traceability System (FTS) in a Food Supply Chain (FSC) should adequately provide all necessary information to the consumer(s), meet the requirements of the relevant agencies, and improve food safety as well as consumer confidence. New information and communication technologies are rapidly advancing, especially after the emergence of the Internet of Things (IoT). Consequently, new food traceability systems have become mainly based on IoT. Many studies have been conducted on food traceability. They mainly focused on the practical implementation and theoretical concepts. Accordingly, various definitions, technologies, and principles have been proposed. The “traceability” concept has been defined in several ways and each new definition has tried to generalize its previous ones. Nevertheless, no standard definition has been reached. Furthermore, the architecture of IoT-based food traceability systems has not yet been standardized. Similarly, used technologies in this field have not been yet well classified. This article presents an analysis of the existing definitions of food traceability, and thus proposes a new one that aims to be simpler, general, and encompassing than the previous ones. We also propose, through this article, a new architecture for IoT-based food traceability systems as well as a new classification of technologies used in this context. We do not miss discussing the applications of different technologies and future trends in the field of IoT-based food traceability systems. Mainly, an FTS can make use of three types of technologies: Identification and Monitoring Technologies (IMT), Communication Technologies (CT), and Data Management Technologies (DMT). Improving a food traceability system requires the use of the best new technologies. There is a variety of promising technologies today to enhance FTS, such as fifth-generation (5G) mobile communication systems and distributed ledger technology (DLT).

Laboratoire D'automatique et Productique

Publications by Year: 2017

Pages

Recent Publications

Quo Vadis Machine Learning-Based Systems Condition Prognosis?—A Perspective

Lithium-ion Battery State of Health Prediction with a Robust Collaborative Augmented Hidden Layer Feedforward Neural Network Approach

2DF-IDS: Decentralized and differentially private federated learning-based intrusion detection system for industrial IoT

Faulty Detection System Based on SPC and Machine Learning Techniques

IoT-based food traceability system: Architecture, technologies, applications, and future trends