计算机工程
計算機工程
계산궤공정
COMPUTER ENGINEERING
2014年
9期
27-31
,共5页
时间序列%数据库查询%时间序列数据库%曲线绘制%数据压缩%数据分析
時間序列%數據庫查詢%時間序列數據庫%麯線繪製%數據壓縮%數據分析
시간서렬%수거고사순%시간서렬수거고%곡선회제%수거압축%수거분석
time-series%database query%time-series database%curve drawing%data compression%data analysis
时间序列数据在许多领域广泛存在，有海量和复杂的特点，直接查询出所有的原始数据并对其进行分析十分耗时，且对计算机的内存消耗极大。为此，提出一种基于分段极值的时间序列数据查询显示方法，对需要查询分析数据的时间范围进行分段，根据各个时间段数据的极值及总取点个数来确定该时间段的取点个数，通过数据库本身的查询机制实现均匀取点，并结合多线程机制实现各时间段数据的并行查询及曲线绘制。实验结果表明，与传统查询及可视化方法相比，该方法能够指定取点数量，并在取点数量确定的情况下，绘制曲线能较好地逼近原始曲线，且极大地缩短曲线的查询绘制时间，具有较好的工程实用性。
時間序列數據在許多領域廣汎存在，有海量和複雜的特點，直接查詢齣所有的原始數據併對其進行分析十分耗時，且對計算機的內存消耗極大。為此，提齣一種基于分段極值的時間序列數據查詢顯示方法，對需要查詢分析數據的時間範圍進行分段，根據各箇時間段數據的極值及總取點箇數來確定該時間段的取點箇數，通過數據庫本身的查詢機製實現均勻取點，併結閤多線程機製實現各時間段數據的併行查詢及麯線繪製。實驗結果錶明，與傳統查詢及可視化方法相比，該方法能夠指定取點數量，併在取點數量確定的情況下，繪製麯線能較好地逼近原始麯線，且極大地縮短麯線的查詢繪製時間，具有較好的工程實用性。
시간서렬수거재허다영역엄범존재，유해량화복잡적특점，직접사순출소유적원시수거병대기진행분석십분모시，차대계산궤적내존소모겁대。위차，제출일충기우분단겁치적시간서렬수거사순현시방법，대수요사순분석수거적시간범위진행분단，근거각개시간단수거적겁치급총취점개수래학정해시간단적취점개수，통과수거고본신적사순궤제실현균균취점，병결합다선정궤제실현각시간단수거적병행사순급곡선회제。실험결과표명，여전통사순급가시화방법상비，해방법능구지정취점수량，병재취점수량학정적정황하，회제곡선능교호지핍근원시곡선，차겁대지축단곡선적사순회제시간，구유교호적공정실용성。
Time-series is a kind of important data object and is ubiquitous in the world. Due to its very large quality and complexity,data query and analysis base on the source data do pay high costs on time and memory of computer. A method for querying and displaying time-series data based on segmented extreme value is proposed. It segments the range of time to be queried and analyzed into periods of time,and then determines the number of access points in a period of time according to extreme value of each period of time and the total number of access points, accessing the points uniformly through a database query mechanism itself and combined with multi-threading mechanism to achieve parallel query and curve drawing of each time period data. Experimental results show that compared with traditional methods,the number of access points is able to be specified,and the drawn curve has a good approximation of the original curve in the case that the number of access points are determined. It is able to greatly shorten the curve querying and drawing time, with good engineering practicality.
