With the rapid development of smart health care, accurate heart rate variability (HRV) estimation for the early detection of diseases has become a hot research topic. Advanced work uses the wireless signal to estimate the heartbeat in a contact-free way, which usually cannot separate multiple users or work in a dynamic environment. In this article, we propose a lightweight heartbeat-sensing method based on RFID tag pairs, which focuses on HRV extraction in a more general sensing scenario. Based on the tag-pair design, we build a novel heartbeat and respiration model to describe the signal relationship between the two tags from the time and space domains. Based on the model, we propose a Calibrated Temporal-Spatial IQ-Shaping-based signal cancellation algorithm to cancel the respiration and extract the heartbeat. To remove the interference in dynamic measurement, we build an IQ-based signal model via a Principal Component Analysis-based interference estimation. To reduce the statistical error in HRV extraction, we further design a neural network to predict the HRV index. We have implemented a system prototype in a real environment with COTS RFID devices. Extensive experiments show that our system can achieve a median RMSSD error of 7.51 ms, which satisfies the medical demand in HRV measurement.

Manual analysis on plan regression is both labor-intensive and inefficient for a large query plan and numerous queries. In this paper, we demonstrate AutoDI, an automatic detection and inference tool that has been developed to investigate why a sub-optimal plan is obtained by analyzing two different plans of the same query. AutoDI consists of two main modules, Difference Finder and Inference. The former aims to find where the two plans are different, and the latter tries to obtain the reasons why the differences come out. In our demonstration, we use a real plan regression in TiDB to show how AutoDI works.

Hybrid Transactional and Analytical Processing (HTAP) databases require processing transactional and analytical queries in isolation to remove the interference between them. To achieve this, it is necessary to maintain different replicas of data specified for the two types of queries. However, it is challenging to provide a consistent view for distributed replicas within a storage system, where analytical requests can efficiently read consistent and fresh data from transactional workloads at scale and with high availability. To meet this challenge, we propose extending replicated state machine-based consensus algorithms to provide consistent replicas for HTAP workloads. Based on this novel idea, we present a Raft-based HTAP database: TiDB. In the database, we design a multi-Raft storage system which consists of a row store and a column store. The row store is built based on the Raft algorithm. It is scalable to materialize updates from transactional requests with high availability. In particular, it asynchronously replicates Raft logs to learners which transform row format to column format for tuples, forming a real-time updatable column store. This column store allows analytical queries to efficiently read fresh and consistent data with strong isolation from transactions on the row store. Based on this storage system, we build an SQL engine to process large-scale distributed transactions and expensive analytical queries. The SQL engine optimally accesses row-format and column-format replicas of data. We also include a powerful analysis engine, TiSpark, to help TiDB connect to the Hadoop ecosystem. Comprehensive experiments show that TiDB achieves isolated high performance under CH-benCHmark, a benchmark focusing on HTAP workloads.