EDBT 2026 Demo / reviewers in the wild / expert
Yuliang Zhao
dblp:19/1386
· DBLP profile ↗
32ranked-venue papers
5as first author
30since 2021 · last 2026
—ORCID · conflict
Domains — the database's venue-derived domains; a paper can count in several
Artificial intelligence and machine learning · 19 · 5 first-author · 19 since 2021Graphics, computer vision, multimedia, augmented reality and games · 5 · 5 since 2021Computer networks · 4 · 4 since 2021Applied, interdisciplinary, general and emerging computing · 2 · 2 since 2021Systems, architecture and hardware · 1Software engineering, systems software and programming languages · 1
| Year | Publication | Venue | Position |
|---|---|---|---|
| 2026 | A robust and interpretable framework for sports activity recognition based on wearable sensor signals and image representations
Jian Li 0063, Yibo Fan, Junhui Gong, Ruoyu Chen 0001, Yuliang Zhao |
Eng. Appl. Artif. Intell. | 7 |
| 2026 | Home-based sarcopenia diagnosis via multimodal gait analysis and personalized large language model intervention
Yinghao Liu, Xiaoyu Xie, Hong Su, Fuming Zheng, Yuliang Zhao |
Eng. Appl. Artif. Intell. | 8 |
| 2026 | Explainable optical information flow neural network
Xunman Xiao, Yanbing Lin, Chao Lian, Zhiyou Guan, Haofu Ji, Fangyin Lu, Weiyi Zhao, Lianjiang Li, Yuliang Zhao |
Eng. Appl. Artif. Intell. | 10 |
| 2026 | Enhanced human lower-limb motion recognition using flexible sensor array and relative position image
Chao Lian, Wayne Jason Li, Yafeng Kang, Dongyu Zhou, Zhikun Zhan, Meng Chen 0007, Jiao Suo, Yuliang Zhao |
Pattern Recognit. | 9 |
| 2026 | TDI-TFFNet: Infusing time dependent images and two-stream feature fusion network for gymnastic activity recognition
Chao Lian, Dongyu Zhou, Yafeng Kang, Tianang Sun, Xiaoyong Lyu, Zhikun Zhan, Yuliang Zhao |
Pattern Recognit. | 8 |
| 2026 | Spatiotemporal feature fusion of multinode radial pulse waves for physiological cycle recognition
Junhui Gong, Xiaoyong Lv, Le Yang 0004, Tianang Sun, Yuliang Zhao |
Pattern Recognit. | 7 |
| 2025 | In-Context Multitask Learning for Few-shot Fine-tuning of Large Language Models in Traditional Chinese Medicine Tongue DiagnosisabstractTongue diagnosis is integral to Traditional Chinese Medicine (TCM) for evaluating a patient’s body constitution. Yet, this field faces challenges such as indirect constitution diagnosis, a dearth of labeled datasets, and the complexities of few-shot learning. Existing studies focus mainly on analyzing tongue color and coating, rather than directly analyzing the body constitution from the patient’s tongue. Moreover, the lack of publicly available datasets with constitution labels impedes model development for constitution diagnosis. The resource-intensive process of creating large-scale labeled datasets calls for efficient training methods on small datasets. Addressing these issues, this paper presents an In-Context Multitask Learning approach to improve few-shot fine-tuning accuracy for Large Language Models (LLMs) in constitution diagnosis. We created a dataset for color-coating analysis and a few-shot dataset with constitution labels and a structured prompt-label framework, allowing LLMs to learn from varied datasets. Our method shows improved performance over traditional methods in constitution diagnosis and significantly boosts LLMs’ generalization and robustness in TCM’s complex diagnostic tasks, providing a viable path for automating tongue diagnosis. Changzeng Fu, Zelin Fu, Shaojun Yan, Xiaoyong Lyu, Yuliang Zhao |
ICASSP | 5 |
| 2025 | M3ADD: A Novel Benchmark for Physiology Signal-based Automatic Depression Detection with Multimodal Multitask Multievent FrameworkabstractThe prevalence of depression is escalating, especially among youth, which has become a critical mental health concern. Current assessment methods, relying heavily on questionnaires, clinical observations, and AI-driven analyses, are limited by their focus on single-event data, failing to encapsulate the nuanced expressions of depressive symptoms. Moreover, a significant oversight in existing research is the underutilization of electromyogram (EMG) alongside electroencephalogram (EEG) data, which could provide a more holistic view of unconscious body behaviors. Additionally, given the high variability of depression among individuals, traditional analysis models are in urgent need of refinement to accommodate the personality of different individuals. To address these limitations, we propose M3ADD, a novel benchmark for Automatic Depression Detection that employs a Multimodal, Multitask, and Multievent framework. We collected EEG and EMG data from 97 participants across varied events (interview, reading tasks, walking), coupled with standardized questionnaires assessing depression, wellbeing, and personality, enriching our multitask learning approach. Our benchmark recognition algorithm leverages multitask learning, channel and interactive attention mechanisms to synthesize event-specific and modal-specific features, enhancing adaptability to individual differences and improving data utilization efficiency. M3ADD surpasses existing models by achieving 87% accuracy in detecting depression and 95% accuracy in assessing wellbeing, providing a promising avenue for early identification. Changzeng Fu, Kaifeng Su, Yikai Su, Fengkui Qian, Siyang Song, Le Yang 0004, Xiaoyong Lv, Yuliang Zhao |
ICASSP | 11 |
| 2025 | Hierarchical Similarity Loss Enhanced Depth and Structural Fidelity in Monocular RGB-to-Depth Mapping with Adversarial TrainingabstractThe conversion of monocular RGB images to depth maps is crucial in robotic applications. Current supervised learning approaches, dependent on high-quality RGB-Depth pairs, struggle with indoor environments characterized by multiple objects and fluctuating lighting, leading to inaccurate and unstable depth estimations. Additionally, commercial depth cameras on robots produce incomplete and light-sensitive depth maps, further degrading estimation quality. To surmount these issues, We created a comprehensive dataset of 9,600 RGB-Depth image pairs, capturing a range of indoor scenes under various lighting (dim, normal, and strong lighting), and interference conditions (local strong light interference, specular reflection interference, background similarity interference, and combinations of these factors). This dataset serves as a foundation for our proposed monocular RGB-to-depth mapping framework, which employs a hierarchical similarity loss to enhance the model’s structural feature learning from reference depth maps, improving the fidelity of estimated depth maps. We also integrated adversarial training and attention mechanisms to refine the depth consistency between the estimated and original depth maps. Experiments show our method surpasses current benchmarks in metrics like Threshold Accuracy, SILog, and MSE, demonstrating its robustness and potential for real-world applications, even with poor-quality inputs. Changzeng Fu, Yikai Su, Kaifeng Su, Le Yang 0004, Xiaoyong Lv, Yuliang Zhao |
ICASSP | 7 |
| 2025 | The First MPDD Challenge: Multimodal Personality-aware Depression DetectionabstractDepression is a widespread mental health issue affecting diverse age groups, with notable prevalence among college students and the elderly. However, existing datasets and detection methods primarily focus on young adults, neglecting the broader age spectrum and individual differences that influence depression manifestation. Current approaches often establish a direct mapping between multimodal data and depression indicators, failing to capture the complexity and diversity of depression across individuals. This challenge includes two tracks based on age-specific subsets: Track 1 uses the MPDD-Elderly dataset for detecting depression in older adults, and Track 2 uses the MPDD-Young dataset for detecting depression in younger participants. The Multimodal Personality-aware Depression Detection (MPDD) Challenge aims to address this gap by incorporating multimodal data alongside individual difference factors. We provide a baseline model that fuses audio and video modalities with individual difference information to detect depression manifestations in diverse populations. This challenge aims to promote the development of more personalized and accurate de pression detection methods, advancing mental health research and fostering inclusive detection systems. More details are available on the official challenge website: https://hacilab.github.io/MPDDChallenge.github.io. Changzeng Fu, Zelin Fu, Qi Zhang 0124, Xinhe Kuang, Jiacheng Dong, Kaifeng Su, Yikai Su, Junfeng Yao, Yuliang Zhao, Shiqi Zhao 0001, Siyang Song, Yuichiro Yoshikawa, Björn W. Schuller, Hiroshi Ishiguro |
ACM Multimedia | 10 |
| 2025 | Adaptive Deformable Convolutional Neural Network Framework for depression-related behavioral analysis in mice
Jian Li 0063, Xiaoyong Lyu, Yuliang Zhao |
Eng. Appl. Artif. Intell. | 8 |
| 2025 | CIR-DFENet: Incorporating cross-modal image representation and dual-stream feature enhanced network for activity recognition
Yuliang Zhao, Jin-Liang Shao, Xiru Lin, Tianang Sun, Jian Li 0063, Chao Lian, Xiaoyong Lyu, Binqiang Si, Zhikun Zhan |
Expert Syst. Appl. | 1 |
| 2025 | Disease and personality information enhanced depression detection based on the TransGCL framework
Yuliang Zhao, Jian Li 0063, Chao Lian, Kaixuan Tian, Changzeng Fu |
Neurocomputing | 1 |
| 2025 | An Intelligent Badminton Handle With Multinode MEMS Sensors for Explainable Motion RecognitionabstractIntelligent sensing technologies are transforming sports training by enabling precise motion analysis, critical for skill development and performance optimization. This study introduces a badminton racket handle embedded with a lightweight, multi-node MEMS-based sensing system designed for real-time motion recognition. To capture distributed grip forces, swing trajectories, and impact mechanics at the player-equipment interface, the system employs an ergonomic design ensuring natural gameplay. A hybrid feature extraction approach, integrating time-and frequency-domain features with a 1D-CNN, achieves a classification accuracy of 97.89% across ten badminton actions. To enhance interpretability and provide actionable insights, explainable AI using SMDL-attribution identifies key motion features, revealing biomechanical inefficiencies in grip strength, swing consistency, and wrist motion. Seamlessly integrated with Virtual Reality (VR) platforms, the system delivers immersive, real-time feedback, transforming training into an interactive and data-driven experience. By combining advanced sensing, machine learning, and explainable AI, this system establishes a new benchmark for intelligent sports monitoring, with broad applications in sports training, rehabilitation, and human-computer interaction. Jian Li 0063, Yibo Fan, Ruoyu Chen 0001, Siyuan Liang 0004, Yuliang Zhao |
IEEE Internet Things J. | 7 |
| 2025 | Dynamic Multisensor Fusion Framework With Adaptive Spatiotemporal Optimization for IoT-Based Motion RecognitionabstractMotion recognition in IoT-based sensor systems is crucial for applications such as healthcare and human-computer interaction. However, one key challenge—data structure inconsistencies—complicates the performance of existing systems, particularly in dynamic real-world environments. Traditional fusion approaches lack the adaptability required to address sensor inconsistencies and fail to fully leverage the potential of multisensor data. To overcome this challenge, we propose a dynamic multisensor fusion framework (DMSFF) with adaptive spatiotemporal optimization. This framework introduces a dynamic sensor weighting mechanism that prioritizes reliable data while suppressing noise, ensuring robustnesss. A transformer-based fusion architecture captures spatiotemporal features, modeling complex intersensor relationships and long-term dependencies. Additionally, a motion kernel matching module aligns the data with canonical motion patterns, improving feature extraction and enhancing the recognition of subtle activities. The framework is validated on benchmark datasets, including those with real-world noise and structural inconsistencies, achieving an accuracy of 99.48%. This work establishes a new benchmark for multisensor motion recognition, providing scalable and robust solutions for smart healthcare and human-computer interaction. Jian Li 0063, Yibo Fan, Xiaoyong Lyu, Yuliang Zhao |
IEEE Internet Things J. | 5 |
| 2025 | Automatic three-dimensional reconstruction of transparent objects with multiple optimization strategies under limited constraints
Xiaopeng Sha, Xiaopeng Si, Yuliang Zhao |
Image Vis. Comput. | 5 |
| 2025 | Multi-temporal image fusion empowered convolutional neural networks for recognition of 9 common mice actions
Jian Li 0063, Yuliang Zhao |
Knowl. Based Syst. | 3 |
| 2025 | Incorporating image representation and texture feature for sensor-based gymnastics activity recognition
Chao Lian, Yuliang Zhao, Tianang Sun, Jin-Liang Shao, Yinghao Liu, Changzeng Fu, Xiaoyong Lyu, Zhikun Zhan |
Knowl. Based Syst. | 2 |
| 2025 | Skeletal joint image-based multi-channel fusion network for human activity recognition
Tianang Sun, Chao Lian, Fanghecong Dong, Jin-Liang Shao, Qijun Xiao, Zhongjie Ju, Yuliang Zhao |
Knowl. Based Syst. | 8 |
| 2025 | MPRNet: A Temporal-Aware Cross-Modal Encoding Framework for Personality RecognitionabstractRecent advances in personality recognition have improved trait inference from multimodal data, yet many existing methods rely on short-term video segments or static images, limiting the modeling of temporal dynamics due to short video durations, sparse frame-level annotations, and inconsistent modality coverage across audio, text, and visual channels. These limitations make it difficult to model how personality traits manifest over time and across modalities in naturalistic settings. To address these challenges, we introduce the Northeast University Personality Recognition (NEUPR) dataset, comprising 654 self-reported and discussion-based videos collected through MBTI assessments. NEUPR offers naturally expressed multimodal dataincluding audio, facial expressions, eye movements, and speech transcripts-captured across diverse participants and real-world settings. Building on this dataset, we propose MPRNet, a unified framework for dynamic personality recognition featuring two core innovations: (1) a multimodal encoder that leverages LSTM to capture temporal dependencies across longer sequences and integrates latent personality embeddings extracted from BERT representations of text to enrich semantic context, fused through adaptive weighting and enhanced by Gram encoding to preserve local feature patterns; and (2) a feature enhancement module that incorporates learnable positional encoding and channel attention to address modality imbalance and improve sensitivity to spatially salient features across modalities. Experimental results demonstrate that MPRNet outperforms state-of-the-art methods across multiple datasets, while ablation studies confirm the effectiveness of its components. By explicitly modeling temporal variation and enhancing cross-modal fusion, MPRNet enables more robust personality inference. This work establishes both a benchmark dataset and an adaptive modeling framework for multimodal personality analysis, advancing dynamic trait recognition. Jian Li 0063, Junhui Gong, Shifeng Wang, Yuliang Zhao |
IEEE Trans. Affect. Comput. | 7 |
| 2025 | Sparse Emotion Dictionary and CWT Spectrogram Fusion With Multi-Head Self-Attention for Depression Recognition in Parkinson's Disease PatientsabstractDepression is prevalent in patients with Parkinson's disease (PD), due to the dramatic negative impact that behavioral disorders have on daily life. Regrettably, most researchers in the past ignored the study of depression in PD patients, especially when depressive symptoms and PD symptoms are coupled together, it is difficult for researchers to recognize depression from the macro physiological signs of PD patients. Researchers are increasingly turning their attention to the subtle phenomena of emotional expression in conversation, using the textual and spectral features extracted from the audio of interviews as the primary support for understanding emotional states. However, there is still a lack of effective technical means to fuse these two features to recognize depression in PD patients. In this study, we proposed an innovative image fusion approach, fusing a sparse emotion dictionary with textual features and a Continuous Wavelet Transform (CWT) spectrogram with spectral features for the precise recognition of depression in PD patients. The fusion process integrates low-dimensional emotion-related textual cues, contributing to a more comprehensive extraction of emotionally relevant information. Subsequently, we introduce a High and Low Frequency Feature Fusion Multi-headed Self-Attention (HL-MSA) mechanism within a high and low frequency feature fusion network to amalgamate information across different frequency features within the images. The results underscore the efficacy of this novel fusion approach in effectively extracting depressive features in PD patients, attaining advanced recognition performance. Notably, this endeavor represents a pioneering stride in seamlessly fusing a sparse emotion dictionary and CWT spectrogram, exemplifying a promising and effective initiative for recognizing depression in PD patients. Jian Li 0063, Yuliang Zhao, Yinghao Liu, Yuanyi Wu, Wanyue Wang |
IEEE Trans. Affect. Comput. | 2 |
| 2025 | Image Encoding and Fusion of Multi-Modal Data Enhance Depression Diagnosis in Parkinson's Disease PatientsabstractThe diagnosis of depression in individuals with Parkinson's Disease (PD) through the utilization of multimodal fusion techniques represents a significant domain. The primary challenge involves the creation of a robust fusion framework to address the heterogeneity among different modalities effectively. However, previous studies primarily focused on interactions between heterogeneous data, neglecting the structural similarities among isomorphic data, resulting in a substantial loss of feature information when merging heterogeneous data. In this study, we introduced a multi-modal data image encoding and fusion approach for diagnosing depression in PD patients. Additionally, we proposed a multi-modal dataset encompassing motion, facial expression, and audio data. First, we designed an RGB and sparse coding method to encode the multi-modal data, achieving the isomorphic transformation of multi-modal information and extracting feature information from lower-dimensional spaces. Furthermore, we introduced a Spatial-Temporal Network (STN) to fuse the three types of encoded images. We incorporated the Relation Global Attention (RGA) to enhance feature extraction and leverage all encoded image location feature nodes for balanced decision attention. Finally, recognizing the limitations of traditional machine learning algorithms in handling multi-tasks in medical diagnosis, we established a multi-task weighted loss function to achieve depression identification and severity prediction through Multi-Task learning (MTL). Jian Li 0063, Yuliang Zhao, Wayne Jason Li, Changzeng Fu, Chao Lian |
IEEE Trans. Affect. Comput. | 2 |
| 2025 | Multimodal Depression Assessment Framework Integrating Personality and Gait for Older Adults With Medical ConditionsabstractElderly individuals often suffer from underlying medical conditions, resulting in a significant decline in quality of life and a heightened susceptibility to depression. Presently, AI screening tools based on behavioral indicators offer an objective and effective approach to diagnosing depression. However, current AI depression screening tools are primarily tailored to adolescents and adults, exhibiting shortcomings in their applicability and accuracy for elderly individuals with underlying medical conditions. To address the above issues, first, this paper constructs a depression dataset for elderly people with underlying diseases by using semi-structured interviews. Second, based on cognitive science insights, it is recognized that personality factors significantly influence behavioral expressions and also determine the attitudes of elderly individuals toward current life circumstances/health issues. Therefore, besides annotating depression severity, the Big Five-10 personality scale was utilized to annotate participant personalities. Finally, a late fusion-based multi-task learning framework was proposed, and the effects of introducing gait information and personality annotation on the performance of depression assessment were investigated. The experimental findings affirm the importance of integrating gait information and personality assessment in improving depression detection effectiveness. This study provides valuable foundational resources, as well as beneficial references and insights, for the research on depression in the elderly. Yuliang Zhao, Jian Li 0063, Siyang Song, Chao Lian, Yinghao Liu, Changzeng Fu |
IEEE Trans. Affect. Comput. | 1 |
| 2025 | CTPEM: A Cross-Temporal Progressive Enhancement Model Tackling Object-Level Building Damage Detection and Vanishing Small FeaturesabstractThe detection and statistics of damaged buildings are crucial for rescue work, especially when detecting object-level and small buildings. Existing detection technologies mainly focus on pixel-level analysis, often ignoring the significance of object-level analysis and the identification of small buildings. To address these challenges, a Cross-Temporal Progressive Enhancement Model (CTPEM) is proposed. In CTPEM, the Visual Center Guided Enhancement (VCGE) module is proposed, which uses multiple visual centers to learn the binary relationship between pre- and post-temporal features to capture global and local information. Meanwhile, the Progressive Small Object Enhancement (PSOE) module is proposed, which is used to capture tiny and small-sized features through multiple feature maps at varying depths, aiming to reduce the influence of gradually vanishing features. Compared with state-of-the-art (SOTA) methods, CTPEM achieves superior performance in detecting damaged buildings, particularly small and tiny targets. Extensive experimental results demonstrate the effectiveness and practical value of our approach for accurate casualty assessment, and further facilitate more efficient disaster response and optimal resource allocation. The CTPEM code is available at https://github.com/GZPLHJ181107/CTPEM. Zhoupeng Guo, Xiaopeng Sha, Xinqi Sang, Yuliang Zhao |
IEEE Trans. Geosci. Remote. Sens. | 6 |
| 2024 | Image expression of time series data of wearable IMU sensor and fusion classification of gymnastics action
Yuliang Zhao, Fanghecong Dong, Tianang Sun, Zhongjie Ju, Le Yang 0004, Lianjiang Li, Xiaoyong Lv, Chao Lian |
Expert Syst. Appl. | 1 |
| 2024 | Global joint information extraction convolution neural network for Parkinson's disease diagnosis
Yuliang Zhao, Yinghao Liu, Jian Li 0063, Xiaoai Wang, Ruige Yang, Chao Lian, Zhikun Zhan, Changzeng Fu |
Expert Syst. Appl. | 1 |
| 2024 | WashRing: An Energy-Efficient and Highly Accurate Handwashing Monitoring System via Smart RingabstractThe outbreak of COVID-19 has greatly changed everyone's lifestyle all over the world. One of the best ways to prevent the spread of infections is by washing hands properly. Although a number of hand hygiene monitoring systems have been proposed, they either cannot achieve high accuracy in practice or work only in limited environments such as hospitals. Therefore, a ubiquitous, energy-efficient and highly accurate hand hygiene monitoring system is still lacking. In this paper, we presentWashRing—the first smart ring-based handwashing monitoring system. In WashRing, we design a Partially Observable Markov Decision Process (POMDP) based adaptive sampling approach to achieve high energy efficiency. Then, we design an automatic feature extraction scheme based on wavelet scattering and a CNN-LSTM neural network to achieve fine-grained gesture recognition. Finally, we model the handwashing gesture classification as a few-shot learning problem to mitigate the burden of collecting extensive data from five fingers. We collect data from 25 subjects over 2 months and evaluate the system performance on both commercial OURA ring and customized ring. Evaluation results show that WashRing achieves 97.8% accuracy which is 10.2%–15.9% higher than state-of-the-arts. Our adaptive sampling approach reduces energy consumption by 64.2% compared to fixed duty cycle sampling strategies. Weitao Xu, Huanqi Yang, Jiongzhang Chen, Chengwen Luo 0001, Jia Zhang 0028, Yuliang Zhao, Wen Jung Li |
IEEE Trans. Mob. Comput. | 6 |
| 2023 | Phase-Based Quantification of Sports Performance Metrics Using a Smart IoT SensorabstractSports performance is often judged based on the results of a series of motions rather than observing and analyzing the detailed sequential motions that lead to the results. Hence, subjective feedback from the coaches is often ineffective in improving player performance. In this work, we custom-built a smart Internet of Things wristband motion sensor to implement data-based sports performance evaluation. A phase-based feature selection method is also proposed to assess the athletes’ sequential detailed motion for selected sport activities. To demonstrate the merits of this technology, we quantified the quality of the sequential motions of a specific type of volleyball serve by analyzing 183 samples of motion data obtained from a total of 18 players. The general skill levels (i.e., elite, subelite, and amateur) of the players were identified by machine learning algorithms, with accuracies of up to 95%. Moreover, we adopted biomechanical principles to extract 11 motion-related performance metrics from various phases of the players’ serve motion. We identified the distributions of these metrics across different skill levels and found eight key metrics that were highly correlated to the skill level of a players. We suggest that these metric distributions can be used as a reference for providing feedback to the coaches and players, to improve a player’s skill in the future. This phased-based analysis method can potentially be applied across many sports to increase the effectiveness of athletes’ training. Meng Chen 0007, Hui Fang Szu, Hsin Yen Lin, Yifan Liu 0003, Ho-Yin Chan, Yuliang Zhao, Guanglie Zhang, Jeffrey Da-Jeng Yao, Wen Jung Li |
IEEE Internet Things J. | 7 |
| 2023 | RSMNet: A Robust Stacked Multiscale Feature Fusion Network for Visible RS ImagesabstractThe aircrafts and ships in visible remote sensing (RS) images are of different scales. They are difficult to detect as they may be easily obscured by complex weather conditions such as snow and cloud. Therefore, it is important to eliminate the interference of complex weather conditions in order to detect these multi-scale objects accurately. This letter proposes an improved robust stacked multi-scale feature fusion network RSMNet to address this problem from two aspects. First, a stacked dilated convolution is used to enlarge the receptive fields of high-resolution images and improve the ability to extract multi-scale information. Second, the maps of extracted features are resized and integrated to refine the connection among different layers. Compared to the original Faster R-CNN model, RSMNet provides a 2% and 3.9% higher AP in the detection of aircrafts and ships, respectively. RSMNet also shows much more robust performance than the original model in detection under cloudy and snowy conditions. Jian Li 0063, Ruige Yang, Yuliang Zhao, Xiaoai Wang, Lianjiang Li, Qiang Fu 0017 |
IEEE Geosci. Remote. Sens. Lett. | 3 |
| 2023 | Adaptive uneven illumination correction method for autonomous live-line maintenance robot
Yuze Qiu, Yahao Wang, Shaolei Wu, Yuliang Zhao, Erbao Dong |
Multim. Tools Appl. | 8 |
| 2018 | A query execution scheduling scheme for Impala systemabstractSummary Impala system is an open source, analytic MPP database for Apache Hadoop. Impala system uses a query execution scheduling scheme that assigns near‐equal bytes retrieval tasks for different hosts to ensure system load balance. However, such “load balance” cannot guarantee a short response time for Impala system, when there are original loads in the system. Traditional query execution scheduling methods require either some assumptions or particular architecture, which cannot be directly used in Impala system. In this paper, we present a query execution scheduling scheme for Impala system. If the query fetches data from a single table, the scheme exploits the maximum flow algorithm. If the query fetches data from multiple tables, the scheme employs a cost‐based algorithm with heuristic pruning rules. In addition, we propose a cost model for Impala system, which considers parallel execution, communication cost, and cluster load. The performance of the proposed scheme is evaluated by the TPC‐DS benchmark, and experimental results show that the scheme can reduce the query response time by 10%‐30%. Ling Chen 0001, Yuliang Zhao, Yi Yang 0001, Mingqi Lv, Yong Wu 0007, Jingchang Wang |
Concurr. Comput. Pract. Exp. | 2 |
| 2017 | Logical query optimization for Cloudera Impala system
Jiaoyang Ma, Ling Chen 0001, Mingqi Lv, Yi Yang 0001, Yuliang Zhao, Yong Wu 0007, Jingchang Wang |
J. Syst. Softw. | 5 |