實時曆史數據庫-mtHistorian__北京麥斯時代信息技術有限公司

工具類返回列表

實時曆史數據庫-mtHistorian

mtHistorian是一款毫秒級時序數據庫。采用TSM引擎，專注于海量時序數據的高性能讀、高性能寫、高效存儲與實時分析等。

北京麥斯時代-17年專注服務工業企業數字化轉型
獲取産品詳情、行業解決方案、項目案例
【聯系方式】：010-60603318 17310190717

産品詳情相關案例更多信息

一、産品描述

mtHistorian是一款毫秒級時序數據庫。采用TSM引擎，專注于海量時序數據的高性能讀、高性能寫、高效存儲與實時分析等。

主要特點：

無系統環境依賴，部署方便。
極簡架構，無需外部依賴。
專注于IOT監控等場景。
自身具備數據時效管理功能，可按需定制數據的時效時間。
支持連續查詢，降低采樣率，大大減少mtHistorian的系統占用量。
具有豐富的聚合函數，支持Count、MAX、MIN等，支持SQL語句。
具有database、table等概念。
支持Http API數據訪問。

支持的數據流如下圖所示：

二、功能結構

mtHistorian功能結構如圖所示：

三、專業管理工具

mtHistorian提供圖形化的專業管理工具mtHistorian_admin，便于操作人員對數據庫進行查看、編輯、删除、備份/恢複等一系列操作。

支持遠程對mtHistorian進行備份和恢複操作。
支持對mtHistorian的數據時效性進行查詢與配置。
支持按需手動添加數據點，按需維護點表。
支持按需對點進行分組，便于對标簽點的管理與維護。

1、标簽點管理

标簽點管理功能可以按照部門、廠區等條件進行自定義分組，便于區分以及快速查找。并可以對某個節點下的點進行搜索、查看。可根據點名以及描述進行模糊查詢。可以對标簽點的描述、服務類型、服務地址、備注等字段進行修改。如下圖所示：

2、數據操作

數據操作部分可實現以下功能：

根據時間倒序查詢5000條以上數據。
根據數據點進行模糊查詢。
根據時間段，時間區間進行指定查詢。
查詢指定數量的數據。
對數據的值進行手動修改。
删除指定的數據點。

如下圖所示：

基本文件流程錯誤 SQL 調試

D:\wwwroot\mestime.com\index.php ( 0.50 KB )
D:\wwwroot\mestime.com\ThinkPHP\ThinkPHP.php ( 4.63 KB )
D:\wwwroot\mestime.com\ThinkPHP\Library\Think\Think.class.php ( 12.31 KB )
D:\wwwroot\mestime.com\ThinkPHP\Library\Think\Storage.class.php ( 1.38 KB )
D:\wwwroot\mestime.com\ThinkPHP\Library\Think\Storage\Driver\File.class.php ( 3.54 KB )
D:\wwwroot\mestime.com\ThinkPHP\Mode\common.php ( 2.82 KB )
D:\wwwroot\mestime.com\ThinkPHP\Common\functions.php ( 49.89 KB )
D:\wwwroot\mestime.com\ThinkPHP\Library\Think\Hook.class.php ( 4.02 KB )
D:\wwwroot\mestime.com\ThinkPHP\Library\Think\App.class.php ( 13.50 KB )
D:\wwwroot\mestime.com\ThinkPHP\Library\Think\Dispatcher.class.php ( 14.84 KB )
D:\wwwroot\mestime.com\ThinkPHP\Library\Think\Route.class.php ( 13.37 KB )
D:\wwwroot\mestime.com\ThinkPHP\Library\Think\Controller.class.php ( 13.96 KB )
D:\wwwroot\mestime.com\ThinkPHP\Library\Think\View.class.php ( 7.61 KB )
D:\wwwroot\mestime.com\ThinkPHP\Library\Behavior\BuildLiteBehavior.class.php ( 3.69 KB )
D:\wwwroot\mestime.com\ThinkPHP\Library\Behavior\ParseTemplateBehavior.class.php ( 3.89 KB )
D:\wwwroot\mestime.com\ThinkPHP\Library\Behavior\ContentReplaceBehavior.class.php ( 1.91 KB )
D:\wwwroot\mestime.com\ThinkPHP\Conf\convention.php ( 11.18 KB )
D:\wwwroot\mestime.com\Web\Common\Conf\config.php ( 0.27 KB )
D:\wwwroot\mestime.com\function.php ( 57.71 KB )
D:\wwwroot\mestime.com\ThinkPHP\Lang\zh-cn.php ( 2.56 KB )
D:\wwwroot\mestime.com\ThinkPHP\Conf\debug.php ( 1.50 KB )
D:\wwwroot\mestime.com\ThinkPHP\Library\Think\Log.class.php ( 3.87 KB )
D:\wwwroot\mestime.com\Web\Home\Conf\config.php ( 0.65 KB )
D:\wwwroot\mestime.com\config.inc.php ( 4.65 KB )
D:\wwwroot\mestime.com\Web\Home\Common\function.php ( 0.04 KB )
D:\wwwroot\mestime.com\ThinkPHP\Library\Behavior\ReadHtmlCacheBehavior.class.php ( 6.26 KB )
D:\wwwroot\mestime.com\Web\Home\Controller\ListController.class.php ( 3.87 KB )
D:\wwwroot\mestime.com\Web\Tool\TopController.class.php ( 0.20 KB )
D:\wwwroot\mestime.com\ThinkPHP\Library\Think\Template.class.php ( 28.22 KB )
D:\wwwroot\mestime.com\ThinkPHP\Library\Think\Template\TagLib\Cx.class.php ( 22.49 KB )
D:\wwwroot\mestime.com\ThinkPHP\Library\Think\Template\TagLib.class.php ( 9.19 KB )
D:\wwwroot\mestime.com\Web\Runtime\Cache\Home\b23799d1c80e14fac9afd9c3e14e423e.php ( 31.96 KB )
D:\wwwroot\mestime.com\ThinkPHP\Library\Think\Model.class.php ( 60.27 KB )
D:\wwwroot\mestime.com\ThinkPHP\Library\Think\Db.class.php ( 32.51 KB )
D:\wwwroot\mestime.com\ThinkPHP\Library\Think\Db\Driver\Mysql.class.php ( 10.63 KB )
D:\wwwroot\mestime.com\ThinkPHP\Library\Think\Cache.class.php ( 3.85 KB )
D:\wwwroot\mestime.com\ThinkPHP\Library\Think\Cache\Driver\File.class.php ( 5.88 KB )
D:\wwwroot\mestime.com\ThinkPHP\Library\Behavior\WriteHtmlCacheBehavior.class.php ( 0.98 KB )
D:\wwwroot\mestime.com\ThinkPHP\Library\Behavior\ShowPageTraceBehavior.class.php ( 5.25 KB )

SHOW COLUMNS FROM `tp_news` [ RunTime:0.000881s ]
SELECT `pid`,`ty`,`tty`,`ttty`,`title`,`seotitle`,`seokeywords`,`seodescription` FROM `tp_news` WHERE ( status=1 AND id=313 ) LIMIT 1 [ RunTime:0.000344s ]
SHOW COLUMNS FROM `tp_sort` [ RunTime:0.000901s ]
SELECT `inlinkurl` FROM `tp_sort` WHERE ( id=8 ) LIMIT 1 [ RunTime:0.000098s ]
SHOW COLUMNS FROM `tp_sort` [ RunTime:0.000896s ]
SELECT `id`,`catname`,`outlinkurl`,`inlinkurl`,`img1`,`img2`,`seodescription`,`encatname`,`pid` FROM `tp_sort` WHERE ( status=1 and pid=1 ) ORDER BY disorder asc,id asc [ RunTime:0.000134s ]
SELECT `inlinkurl` FROM `tp_sort` WHERE ( id=2 ) LIMIT 1 [ RunTime:0.000094s ]
SELECT `id`,`catname`,`outlinkurl`,`inlinkurl`,`img1`,`img2`,`seodescription`,`encatname`,`pid` FROM `tp_sort` WHERE ( status=1 and pid=2 ) ORDER BY disorder asc,id asc [ RunTime:0.000151s ]
SELECT `id`,`catname`,`outlinkurl`,`inlinkurl`,`img1`,`img2`,`seodescription`,`encatname`,`pid` FROM `tp_sort` WHERE ( status=1 and pid=2 ) ORDER BY disorder asc,id asc [ RunTime:0.000101s ]
SHOW COLUMNS FROM `tp_news` [ RunTime:0.000696s ]
SELECT * FROM `tp_news` WHERE ( status=1 AND pid=2 AND ty=53 ) ORDER BY disorder desc,id desc LIMIT 0,8 [ RunTime:0.001000s ]
SELECT * FROM `tp_news` WHERE ( status=1 AND pid=2 AND ty=52 ) ORDER BY disorder desc,id desc LIMIT 0,8 [ RunTime:0.000604s ]
SELECT * FROM `tp_news` WHERE ( status=1 AND pid=2 AND ty=54 ) ORDER BY disorder desc,id desc LIMIT 0,8 [ RunTime:0.000144s ]
SELECT `inlinkurl` FROM `tp_sort` WHERE ( id=15 ) LIMIT 1 [ RunTime:0.000099s ]
SELECT `id`,`catname`,`outlinkurl`,`inlinkurl`,`img1`,`img2`,`seodescription`,`encatname`,`pid` FROM `tp_sort` WHERE ( status=1 and pid=3 ) ORDER BY disorder asc,id asc [ RunTime:0.000116s ]
SELECT `inlinkurl` FROM `tp_sort` WHERE ( id=17 ) LIMIT 1 [ RunTime:0.000087s ]
SELECT `id`,`catname`,`outlinkurl`,`inlinkurl`,`img1`,`img2`,`seodescription`,`encatname`,`pid` FROM `tp_sort` WHERE ( status=1 and pid=4 ) ORDER BY disorder asc,id asc [ RunTime:0.000960s ]
SELECT `inlinkurl` FROM `tp_sort` WHERE ( id=22 ) LIMIT 1 [ RunTime:0.000070s ]
SELECT `id`,`catname`,`outlinkurl`,`inlinkurl`,`img1`,`img2`,`seodescription`,`encatname`,`pid` FROM `tp_sort` WHERE ( status=1 and pid=5 ) ORDER BY disorder asc,id asc [ RunTime:0.000089s ]
SELECT `inlinkurl` FROM `tp_sort` WHERE ( id=21 ) LIMIT 1 [ RunTime:0.000079s ]
SELECT `id`,`catname`,`outlinkurl`,`inlinkurl`,`img1`,`img2`,`seodescription`,`encatname`,`pid` FROM `tp_sort` WHERE ( status=1 and pid=6 ) ORDER BY disorder asc,id asc [ RunTime:0.000104s ]
SELECT `inlinkurl` FROM `tp_sort` WHERE ( id=8 ) LIMIT 1 [ RunTime:0.000086s ]
SELECT `inlinkurl` FROM `tp_sort` WHERE ( id=2 ) LIMIT 1 [ RunTime:0.000087s ]
SELECT `inlinkurl` FROM `tp_sort` WHERE ( id=15 ) LIMIT 1 [ RunTime:0.000083s ]
SELECT `inlinkurl` FROM `tp_sort` WHERE ( id=19 ) LIMIT 1 [ RunTime:0.000089s ]
SELECT `inlinkurl` FROM `tp_sort` WHERE ( id=19 ) LIMIT 1 [ RunTime:0.000085s ]
SELECT `inlinkurl` FROM `tp_sort` WHERE ( id=18 ) LIMIT 1 [ RunTime:0.000087s ]
SELECT `inlinkurl` FROM `tp_sort` WHERE ( id=o ) LIMIT 1 [ RunTime:0.006490s ]
SELECT `inlinkurl` FROM `tp_sort` WHERE ( id=22 ) LIMIT 1 [ RunTime:0.000155s ]
SELECT `inlinkurl` FROM `tp_sort` WHERE ( id=23 ) LIMIT 1 [ RunTime:0.000164s ]
SELECT `inlinkurl` FROM `tp_sort` WHERE ( id=21 ) LIMIT 1 [ RunTime:0.000118s ]
SELECT `img1` FROM `tp_sort` WHERE ( id=2 ) LIMIT 1 [ RunTime:0.000100s ]
SELECT `id`,`catname`,`outlinkurl`,`inlinkurl`,`img1`,`img2`,`seodescription`,`encatname`,`pid` FROM `tp_sort` WHERE ( status=1 and pid=2 ) ORDER BY disorder asc,id asc [ RunTime:0.000080s ]
SELECT `inlinkurl` FROM `tp_sort` WHERE ( id=2 ) LIMIT 1 [ RunTime:0.000072s ]
SELECT `inlinkurl` FROM `tp_sort` WHERE ( id=2 ) LIMIT 1 [ RunTime:0.000099s ]
SELECT * FROM `tp_news` WHERE ( status=1 AND id=313 ) LIMIT 1 [ RunTime:0.000398s ]
SELECT COUNT(*) AS tp_count FROM `tp_news` WHERE ( status=1 AND id=313 ) LIMIT 1 [ RunTime:0.000263s ]
update tp_news set hits=hits+1 where id=313 [ RunTime:0.001669s ]
SHOW COLUMNS FROM `tp_qt` [ RunTime:0.002229s ]
SELECT * FROM `tp_qt` WHERE ( status=1 AND pid=1 and ty=313 ) ORDER BY sendtime desc,id desc LIMIT 0,100 [ RunTime:0.000104s ]
SELECT * FROM `tp_qt` WHERE ( status=1 AND pid=2 and ty=313 ) ORDER BY sendtime desc,id desc LIMIT 0,10 [ RunTime:0.000114s ]
SELECT `inlinkurl` FROM `tp_sort` WHERE ( id=8 ) LIMIT 1 [ RunTime:0.000092s ]
SELECT `inlinkurl` FROM `tp_sort` WHERE ( id=10 ) LIMIT 1 [ RunTime:0.000100s ]
SELECT `inlinkurl` FROM `tp_sort` WHERE ( id=11 ) LIMIT 1 [ RunTime:0.000094s ]
SELECT `inlinkurl` FROM `tp_sort` WHERE ( id=12 ) LIMIT 1 [ RunTime:0.000114s ]
SELECT `inlinkurl` FROM `tp_sort` WHERE ( id=2 ) LIMIT 1 [ RunTime:0.000116s ]
SELECT `inlinkurl` FROM `tp_sort` WHERE ( id=15 ) LIMIT 1 [ RunTime:0.000095s ]
SELECT `inlinkurl` FROM `tp_sort` WHERE ( id=17 ) LIMIT 1 [ RunTime:0.000086s ]
SELECT `inlinkurl` FROM `tp_sort` WHERE ( id=17 ) LIMIT 1 [ RunTime:0.000080s ]
SELECT `inlinkurl` FROM `tp_sort` WHERE ( id=22 ) LIMIT 1 [ RunTime:0.000102s ]
SELECT `inlinkurl` FROM `tp_sort` WHERE ( id=39 ) LIMIT 1 [ RunTime:0.000085s ]
SELECT * FROM `tp_news` WHERE ( status=1 AND pid=7 AND ty=32 ) ORDER BY disorder desc,id desc LIMIT 0,6 [ RunTime:0.000155s ]
SELECT * FROM `tp_news` WHERE ( status=1 AND pid=43 AND ty=44 ) ORDER BY disorder desc,id desc LIMIT 0,1 [ RunTime:0.000110s ]
SELECT * FROM `tp_news` WHERE ( status=1 AND pid=43 AND ty=45 ) ORDER BY disorder desc,id desc LIMIT 0,1 [ RunTime:0.000505s ]
SELECT `inlinkurl` FROM `tp_sort` WHERE ( id=21 ) LIMIT 1 [ RunTime:0.000132s ]

應用類

平台類

工具類

下載中心

技術文章

在線體驗

實時曆史數據庫-mtHistorian

關于我們

産品中心

解決方案

聯系我們

歡迎登錄