An Optimization Algorithm of Real-time Customer-counting Query Based on Multiple Time Granularities

doi:10.3969/j.issn.1006-2475.2011.08.041

Computer and Modernization ›› 2011, Vol. 1 ›› Issue (8): 149-152.doi: 10.3969/j.issn.1006-2475.2011.08.041

• 数据库 • Previous Articles Next Articles

An Optimization Algorithm of Real-time Customer-counting Query Based on Multiple Time Granularities

SU Li-kai

Educational Technology Center, Guangdong University of Business Studies, Guangzhou 510320, China

Received:2011-06-16 Revised:1900-01-01 Online:2011-08-10 Published:2011-08-10

Abstract

Abstract: The real-time flow of customer data changed with time is classified as the time series. According to the receiving frequency, the relational model is applied for the storage of the customer data. In order to weaken the influence of the query efficiency of the real-time customer-counting by the receiving frequency, the views of the customer data with multiple time granularities are established and the query efficiency is improved.

Key words: multiple time granularities, time series, query optimization

CLC Number:

TP301

SU Li-kai. An Optimization Algorithm of Real-time Customer-counting Query Based on Multiple Time Granularities[J]. Computer and Modernization, 2011, 1(8): 149-152.

[1]	LIU Rui-xue, LI Wen, LIU Fang, DU Shou-guo. Prediction of Time Series with Missing Value Based on Tensor Autoregressive Completion [J]. Computer and Modernization, 2023, 0(09): 51-58.
[2]	SUN Zi-yu, REN Ran, WEI Xi-zhe. Research on Stock Classification and Forecast Based on DTW-TCN [J]. Computer and Modernization, 2023, 0(08): 31-37.
[3]	ZHANG Zi-sen, XU Xiao-zhong. Load Forecasting Based on Decomposition and Multi-component Ensemble Learning [J]. Computer and Modernization, 2023, 0(03): 96-101.
[4]	LIANG Ke-jin, ZHANG Hai-jun, LIU Ya-qing, ZHANG Yu, WANG Yue-yang. Speech Emotion Recognition of Hybrid Multi-scale Convolution Combined with Dual-layer LSTM [J]. Computer and Modernization, 2023, 0(01): 63-68.
[5]	SHI Zhi-wei, WU Zhi-feng, ZHANG Zhe. Stock Volatility Prediction of LightGBM-GRU Model under Corrective Learning Strategy [J]. Computer and Modernization, 2023, 0(01): 95-102.
[6]	ZHOU Chang-ye, LI Cheng. Prediction of Railway Freight Volume Based on GS-LSTM Model [J]. Computer and Modernization, 2022, 0(10): 24-28.
[7]	ZHANG Su-ning, WANG Fang, ZHU Yan, JING Dong-sheng. Power Demand Forecast of Different Types in Multiple Regions Based on Extreme Gradient Boosting [J]. Computer and Modernization, 2022, 0(03): 18-22.
[8]	CHEN Xiao-lei, WANG Xing-xing, SHEN Hao-yang. Combination Forecasting Model of Time Series Data in Smart Agriculture [J]. Computer and Modernization, 2021, 0(09): 121-126.
[9]	ZHU Xu, ZHU Xiao-xiao, WANG Ji-min. Variable-length Motif Mining of Time Series Based on Matrix Profile [J]. Computer and Modernization, 2021, 0(05): 44-50.
[10]	ZHAO Ying, ZHAI Yuan-wei, CHEN Jun-jun, TENG Jian. Time Series Forecasting Model Based on LSTM-Prophet Nonlinear Combination [J]. Computer and Modernization, 2020, 0(09): 6-11.
[11]	YANG Yong-jiao, XIAO Jian-yi, ZHAO Chuang-ye, ZHOU Kai-dong. An Anomaly Detection Algorithm for Smart Grid Time Series Data #br# Based on Combination of Isolation Forest and Random Forest [J]. Computer and Modernization, 2020, 0(03): 99-.
[12]	LI Zhao-tong, ZHANG Wei-shan, GUO Wu-wu. LSTM-based Working State Prediction of Industrial Internet Equipment [J]. Computer and Modernization, 2020, 0(01): 1-.
[13]	XU Guo-yan1, ZHU Jin1, SI Cun-you2, HU Wen-bin2, LIU Fan1. Combined Hydrological Time Series Forecasting Model Based on CNN and MC [J]. Computer and Modernization, 2019, 0(11): 23-.
[14]	WANG Yu-fei1, DU Tian-cang1,2 . Analysis and Application of Time Series Prediction Based on #br# Holt-Winters in Big Data Monitoring System [J]. Computer and Modernization, 2019, 0(11): 29-.
[15]	YU Li-ling， JIN Hao-yu . Prediction of Blood Glucose Based on K-means Clustering Algorithm with RBF Neural Network [J]. Computer and Modernization, 2019, 0(03): 9-.

An Optimization Algorithm of Real-time Customer-counting Query Based on Multiple Time Granularities

Knowledge

Abstract

Cite this article

share this article

References

Related Articles 15

Recommended Articles

Metrics

Comments