{'fraction_non_alphanumeric': 0.012715712988192553, 'fraction_numerical': 0.0, 'mean_word_length': 4.989130434782608, 'pattern_counts': {'":': 0, '<': 0, '<?xml version=': 0, '>': 0, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
Accessing Databases from Esterel

A current limitation in reactive systems design is the lack of database support in tools such as Esterel Studio. This report proposes a way of integrating databases and Esterel by providing an Application Programming Interface (API) for relational database use inside Esterel. As databases and Esterel programs are often executed on dieren t machines, result sets from database queries may be processed either locally and according to the synchrony hypothesis, or remotely along several reactive cycles. These dieren t scenarios are reected in the development of two APIs detailed in this report. Their utility is demonstrated by means of a case study modelling a warehouse storage system as might be used by a direct order company. The system employs a robot whose task it is to collect items from a customer’s order and assemble them in one place. In addition to customer and order data, the underlying database stores spatial data detailing the position of items in the warehouse. Both robot and warehouse are implemented using the Lego Mindstorms robotics system.