一种对时间连续数据进行分析查询的SQL扩展语言  

AN EXTENDED SQL FOR ANALYSING AND QUERYING TIME SERIES DATA

作　　者：崔渊[1] 陶莉[2] 周余洪[1] 刘晓强[1] 杜明[1] 

机构地区：[1]东华大学计算机科学与技术学院,上海201620 [2]东华大学档案馆,上海201620

出　　处：《计算机应用与软件》2015年第5期50-53,共4页Computer Applications and Software

基　　金：上海市教育委员会科研创新项目(12ZZ060);上海市科委启明星项目(12QB1402300)

摘　　要：在家庭电子医疗平台中,存在生理学时间连续数据,实现对其分析和查询是数据利用的基础。针对这类数据的特点,提出以关系型数据库结构化查询语言SQL为基础,定义相似查询算法,快速有效地从给定信号序列中找出符合某一相似度等级的相似子序列。相似匹配使用了分段聚合近似法和小波变换两种算法,易于进行子序列的相似度分级。实验结果表明,该试验系统能够高效、准确地完成设计功能。There is the physiological time series data in home e-health platform. To realise its analysis and query is the basis of data utilisation. In light of the characteristics of such data, we propose that taking the relational database structure query language （SQL） as the basis to define the similarity query algorithm and to find out fast and effectively the similarity subsequence in accordance with a certain similarity level from given signal sequence. The similarity matching uses two algorithms, the segmented aggregation approximation and the wavelet transform. They are easy to implement the similarity grading of subsequenee. Experimental results show that this test system can efficiently and accurately complete the designed function.

关 键 词：时间连续数据 小波变换 扩展结构化查询语言 生理学信号 电子医疗 

分 类 号：TP392[自动化与计算机技术—计算机应用技术]