Query Optimization for Distributed Spatio-Temporal Sensing Data Processing.

The unprecedented development of Internet of Things (IoT) technology produces humongous amounts of spatio-temporal sensing data with various geometry types. However, processing such datasets is often challenging due to high-dimensional sensor data geometry characteristics, complex anomalistic spatial regions, unique query patterns, and so on. Timely and efficient spatio-temporal querying significantly improves the accuracy and intelligence of processing sensing data. Most existing query algorithms show their lack of supporting spatio-temporal queries and irregular spatial areas. In this paper, we propose two spatio-temporal query optimization algorithms based on SpatialHadoop to improve the efficiency of query spatio-temporal sensing data: (1) spatio-temporal polygon range query (STPRQ), which aims to find all records from a polygonal location in a time interval; (2) spatio-temporal k nearest neighbors query (STkNNQ), which directly searches the query point's k closest neighbors. To optimize the STkNNQ algorithm, we further propose an adaptive iterative range optimization algorithm (AIRO), which can optimize the iterative range of the algorithm according to the query time range and avoid querying irrelevant data partitions. Finally, extensive experiments based on trajectory datasets demonstrate that our proposed query algorithms can significantly improve query performance over baseline algorithms and shorten response time by 81% and 35.6%, respectively.

Chemotherapy plus concurrent irreversible electroporation improved local tumor control in unresectable hilar cholangiocarcinoma compared with chemotherapy alone.

INTRODUCTION: Unresectable hilar cholangiocarcinoma (UHC) is a malignant tumor and has a poor prognosis. IRE is a novel non-thermal ablative therapy that causes cellular apoptosis via electrical impulses. To compare the curative effect for UHC, chemotherapy plus concurrent IRE and chemotherapy alone were set up. MATERIALS AND METHODS: From July 2015 to May 2019, 47 patients with UHC were analyzed to chemotherapy + IRE group (n = 23) or chemotherapy alone group (n = 24) in this study. Treatment response was assessed with computed tomography (CT) or magnetic resonance imaging (MRI) 1 month after treatment and every 3 months thereafter. Local tumor progression (LTP), time to LTP, overall survival (OS) and procedure-related complications were compared between the two groups. RESULTS: Chemotherapy plus concurrent IRE group showed a tendency toward a decreased rate of LTP (16.7% vs. 39.5%; p = 0.039) and an increased complete response rate (52.2% vs. 12.5%; p = 0.011) compared with chemotherapy alone group. Time to LTP was significantly longer in the chemotherapy plus concurrent IRE group compared to chemotherapy alone group (11.2 months vs. 4.2 months; p = 0.001). Median OS was significantly longer in the chemotherapy plus concurrent IRE group compared to chemotherapy alone group (19.6 months vs. 10.2 months; p = 0.001). CONCLUSIONS: Chemotherapy plus concurrent IRE improved local control and prolonged time to LTP and OS in patients with UHC.