Minimizing the Worst Case Execution Time of Diagnostic Fault Queries in Real Time Systems Using Genetic Algorithm

The number of embedded systems in safety-critical applications are continuously increasing. These systems requires high level of reliability and have strict timing constraints specially in case of fault occurrence. One method to enhance the reliability and availability of these systems is to introduce the concept of optimization of diagnostic fault queries and real time database management systems. Both of them can be used to trace back failures to faults and trigger suitable recovery actions. Our major concern is the completion of diagnostic query in bounded time in order to satisfy timing constraints for fault recovery (e.g. actuator freezing). For this purpose it is important to provide a solution which can optimize the diagnostic fault queries in a manner that they can complete their execution within the pre-defined deadline of the real time system. Our proposed algorithm optimize the diagnostic fault queries using genetic algorithm, so that the overall Worst Case Execution Time (WCET) of these queries can be minimized. A diagnostic query is represented in the form of (i) Left Deep Tree (LDT) and (ii) Bushy Tree (BT). Each query tree is converted into multiple task graphs by considering different combinations of nodes (in query tree). Our genetic algorithm selects the task graph with minimum make span (scheduling length), so that the goal of fault diagnosis within the defined deadline of the real time system can be achieved. The evaluation based on our results shows that the WCET of the diagnostic queries is better in case of bushy trees and ring topology.

[1]  G. Farber,et al.  Calculating worst-case execution times of transactions in databases for event-driven, hard real-time embedded systems , 2000, Proceedings 2000 International Database Engineering and Applications Symposium (Cat. No.PR00789).

[2]  Faïez Gargouri,et al.  Structural Model of Real-Time Databases: An Illustration , 2008, 2008 11th IEEE International Symposium on Object and Component-Oriented Real-Time Distributed Computing (ISORC).

[3]  Nagarajan Kandasamy,et al.  Time-constrained failure diagnosis in distributed embedded systems: application to actuator diagnosis , 2005, IEEE Transactions on Parallel and Distributed Systems.

[4]  Jozef Kratica,et al.  A Genetic Algorithm for the Index Selection Problem , 2003, EvoWorkshops.

[5]  Li Xiongfei,et al.  Embedded Database Query Optimization Algorithm Based on Particle Swarm Optimization , 2015, 2015 Seventh International Conference on Measuring Technology and Mechatronics Automation.

[6]  Youmin Zhang,et al.  Bibliographical review on reconfigurable fault-tolerant control systems , 2003, Annu. Rev. Control..

[7]  Roman Obermaisser,et al.  Time-triggered scheduling of query executions for active diagnosis in distributed real-time systems , 2017, 2017 22nd IEEE International Conference on Emerging Technologies and Factory Automation (ETFA).

[8]  Samir Khuller,et al.  Minimizing Communication Cost in Distributed Multi-query Processing , 2009, 2009 IEEE 25th International Conference on Data Engineering.

[9]  Guillaume Ducard,et al.  Fault-tolerant Flight Control and Guidance Systems: Practical Methods for Small Unmanned Aerial Vehicles , 2009 .

[10]  Mustapha Ouladsine,et al.  Fault Tolerant Control Strategy Based on the DoA: Application to UAV , 2009 .

[11]  Pu Wang,et al.  A Multi-copy Join Optimization of Information Integration Systems Based on a Genetic Algorithm , 2008, 2008 The Third International Multi-Conference on Computing in the Global Information Technology (iccgi 2008).

[12]  Shiwen Li,et al.  Query Optimization of Distributed Database Based on Parallel Genetic Algorithm and Max-Min Ant System , 2015, 2015 8th International Symposium on Computational Intelligence and Design (ISCID).

[13]  Rolf Isermann,et al.  Fault-tolerant actuators and drives—Structures, fault detection principles and applications , 2009 .

[14]  Volker Markl,et al.  Estimating Join Selectivities using Bandwidth-Optimized Kernel Density Models , 2017, Proc. VLDB Endow..

[15]  Jing Xu,et al.  QScheduler: A Tool for Parallel Query Processing in Database Systems , 2014, 2014 19th International Conference on Engineering of Complex Computer Systems.

[16]  Guillaume Ducard,et al.  Fault-tolerant Flight Control and Guidance Systems , 2009 .

[17]  Stoyan Vellev.  AN ADAPTIVE GENETIC ALGORITHM WITH DYNAMIC POPULATION SIZE FOR OPTIMIZING JOIN QUERIES , 2008 .

[18]  Rolf Isermann,et al.  Fault-tolerant actuators and drives - Structures, fault detection principles and applications , 2009, Annu. Rev. Control..