计算机与现代化 ›› 2011, Vol. 1 ›› Issue (8): 149-152.doi: 10.3969/j.issn.1006-2475.2011.08.041

• 数据库 • 上一篇    下一篇

一种基于多时间粒度的实时客流查询优化算法

苏礼楷   

  1. 广东商学院教育技术中心,广东 广州 510320
  • 收稿日期:2011-06-16 修回日期:1900-01-01 出版日期:2011-08-10 发布日期:2011-08-10

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

SU Li-kai   

  1. 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: 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

中图分类号: