Predictive maintenance is gradually replacing conventional preventive maintenance, through an informed decision-making process for a fleet operator to proactively monitor the health status of the sea-based equipment and machinery. As a result, the fleet operator will only need to ask for on-time repair and maintenance services instead of periodic maintenance, which saves both time and cost significantly. While moving into this new maritime business model, which is also known as Service-as-a-Product (SaaP), both fleet operators and maintenance, repair, and overhaul (MRO) companies could also build a stronger collaboration in the maritime industries. With the advent of digital transformation towards Industry 4.0 (I4.0), the Industrial Internet-of-Things (IIoT) renders the massive collection of operational and machinery process data from the vessel equipment through sensorization, where these collected real-time information are useful for advanced analytics to predict equipment failure and to avoid unplanned downtime. Unlike other industries, there are a few challenges in the maritime industries when developing a centralized smart vessel equipment monitoring platform. One of the key challenges, is the lack of a feasible data management system, requires the centralized host must be able to handle and manage the telemetry IoT data that is transmitted over the satellite communication, by complying with all cybersecurity considerations and regulations in maritime sector. In this paper, we present a scalable, hybrid cloud-based data management framework that can connect to multiple edge systems where each system is deployed on a physical vessel, to establish a scalable SaaP business model. Hence, the ship-to-shore sensorized data can be processed and monitored via a real-time visualization dashboard through the centralized cloud-based platform. We argue that our approach, would be a turn-key solution that can be implemented for mostly all types of marine equipment and machinery, and thus to further improve the prediction tools to support advanced decision-making techniques, such as optimal time repair of vessel equipment.

The goal of query reverse engineering is to re-generate the SQL query that produced a given result from some known database. The problem has many real world applications where users need to better understand the lineage and trustworthiness of various data reports even when the authors of those reports are no longer reachable or are unable to provide the required explanations anymore. It gets more challenging as the complexities of both the query and database schema increase. Prior work has addressed the reverse engineering of constrained types of SQL queries and sometimes on constrained schemas, such as single-table schemas. In this demonstration, we present a framework called REGAL + , which builds upon, and extends prior work to enable the discovery of Select-Project-Join-Aggregation (SPJA) queries over arbitrary schemas. Without any prior schema knowledge or SQL expertise, the user only needs to upload a data report (e.g., as a spreadsheet), and the system will automatically compute and display the queries capable of generating that report from the database.

Query reverse engineering seeks to re-generate the SQL query that produced a given query output table from a given database. In this paper, we solve this problem for OLAP queries with group-by and aggregation. We develop a novel three-phase algorithm named REGAL 1 for this problem. First, based on a lattice graph structure, we identify a set of group-by candidates for the desired query. Second, we apply a set of aggregation constraints that are derived from the properties of aggregate operators at both the table-level and the group-level to discover candidate combinations of group-by columns and aggregations that are consistent with the given query output table. Finally, we find a multi-dimensional filter, i.e., a conjunction of selection predicates over the base table attributes, that is needed to generate the exact query output table. We conduct an extensive experimental study over the TPC-H dataset to demonstrate the effectiveness and efficiency of our proposal.