实时历史数据库-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.000690s ]
SELECT `pid`,`ty`,`tty`,`ttty`,`title`,`seotitle`,`seokeywords`,`seodescription` FROM `tp_news` WHERE ( status=1 AND id=313 ) LIMIT 1 [ RunTime:0.000304s ]
SHOW COLUMNS FROM `tp_sort` [ RunTime:0.000608s ]
SELECT `inlinkurl` FROM `tp_sort` WHERE ( id=8 ) LIMIT 1 [ RunTime:0.000099s ]
SHOW COLUMNS FROM `tp_sort` [ RunTime:0.000642s ]
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.000144s ]
SELECT `inlinkurl` FROM `tp_sort` WHERE ( id=2 ) LIMIT 1 [ RunTime:0.000080s ]
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.000132s ]
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.000085s ]
SHOW COLUMNS FROM `tp_news` [ RunTime:0.000721s ]
SELECT * FROM `tp_news` WHERE ( status=1 AND pid=2 AND ty=53 ) ORDER BY disorder desc,id desc LIMIT 0,8 [ RunTime:0.000701s ]
SELECT * FROM `tp_news` WHERE ( status=1 AND pid=2 AND ty=52 ) ORDER BY disorder desc,id desc LIMIT 0,8 [ RunTime:0.000489s ]
SELECT * FROM `tp_news` WHERE ( status=1 AND pid=2 AND ty=54 ) ORDER BY disorder desc,id desc LIMIT 0,8 [ RunTime:0.002330s ]
SELECT `inlinkurl` FROM `tp_sort` WHERE ( id=15 ) LIMIT 1 [ RunTime:0.000136s ]
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.000132s ]
SELECT `inlinkurl` FROM `tp_sort` WHERE ( id=17 ) LIMIT 1 [ RunTime:0.000077s ]
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.000101s ]
SELECT `inlinkurl` FROM `tp_sort` WHERE ( id=22 ) LIMIT 1 [ RunTime:0.000064s ]
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.000093s ]
SELECT `inlinkurl` FROM `tp_sort` WHERE ( id=21 ) LIMIT 1 [ RunTime:0.000054s ]
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.000098s ]
SELECT `inlinkurl` FROM `tp_sort` WHERE ( id=8 ) LIMIT 1 [ RunTime:0.000081s ]
SELECT `inlinkurl` FROM `tp_sort` WHERE ( id=2 ) LIMIT 1 [ RunTime:0.000077s ]
SELECT `inlinkurl` FROM `tp_sort` WHERE ( id=15 ) LIMIT 1 [ RunTime:0.000067s ]
SELECT `inlinkurl` FROM `tp_sort` WHERE ( id=19 ) LIMIT 1 [ RunTime:0.000067s ]
SELECT `inlinkurl` FROM `tp_sort` WHERE ( id=19 ) LIMIT 1 [ RunTime:0.000061s ]
SELECT `inlinkurl` FROM `tp_sort` WHERE ( id=18 ) LIMIT 1 [ RunTime:0.000097s ]
SELECT `inlinkurl` FROM `tp_sort` WHERE ( id=o ) LIMIT 1 [ RunTime:0.000177s ]
SELECT `inlinkurl` FROM `tp_sort` WHERE ( id=22 ) LIMIT 1 [ RunTime:0.000096s ]
SELECT `inlinkurl` FROM `tp_sort` WHERE ( id=23 ) LIMIT 1 [ RunTime:0.000118s ]
SELECT `inlinkurl` FROM `tp_sort` WHERE ( id=21 ) LIMIT 1 [ RunTime:0.000099s ]
SELECT `img1` FROM `tp_sort` WHERE ( id=2 ) LIMIT 1 [ RunTime:0.000176s ]
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.000082s ]
SELECT `inlinkurl` FROM `tp_sort` WHERE ( id=2 ) LIMIT 1 [ RunTime:0.000080s ]
SELECT `inlinkurl` FROM `tp_sort` WHERE ( id=2 ) LIMIT 1 [ RunTime:0.000144s ]
SELECT * FROM `tp_news` WHERE ( status=1 AND id=313 ) LIMIT 1 [ RunTime:0.000325s ]
SELECT COUNT(*) AS tp_count FROM `tp_news` WHERE ( status=1 AND id=313 ) LIMIT 1 [ RunTime:0.000208s ]
update tp_news set hits=hits+1 where id=313 [ RunTime:0.001383s ]
SHOW COLUMNS FROM `tp_qt` [ RunTime:0.000642s ]
SELECT * FROM `tp_qt` WHERE ( status=1 AND pid=1 and ty=313 ) ORDER BY sendtime desc,id desc LIMIT 0,100 [ RunTime:0.000100s ]
SELECT * FROM `tp_qt` WHERE ( status=1 AND pid=2 and ty=313 ) ORDER BY sendtime desc,id desc LIMIT 0,10 [ RunTime:0.000118s ]
SELECT `inlinkurl` FROM `tp_sort` WHERE ( id=8 ) LIMIT 1 [ RunTime:0.000103s ]
SELECT `inlinkurl` FROM `tp_sort` WHERE ( id=10 ) LIMIT 1 [ RunTime:0.000097s ]
SELECT `inlinkurl` FROM `tp_sort` WHERE ( id=11 ) LIMIT 1 [ RunTime:0.000122s ]
SELECT `inlinkurl` FROM `tp_sort` WHERE ( id=12 ) LIMIT 1 [ RunTime:0.000088s ]
SELECT `inlinkurl` FROM `tp_sort` WHERE ( id=2 ) LIMIT 1 [ RunTime:0.000112s ]
SELECT `inlinkurl` FROM `tp_sort` WHERE ( id=15 ) LIMIT 1 [ RunTime:0.000072s ]
SELECT `inlinkurl` FROM `tp_sort` WHERE ( id=17 ) LIMIT 1 [ RunTime:0.000067s ]
SELECT `inlinkurl` FROM `tp_sort` WHERE ( id=17 ) LIMIT 1 [ RunTime:0.000063s ]
SELECT `inlinkurl` FROM `tp_sort` WHERE ( id=22 ) LIMIT 1 [ RunTime:0.000079s ]
SELECT `inlinkurl` FROM `tp_sort` WHERE ( id=39 ) LIMIT 1 [ RunTime:0.000071s ]
SELECT * FROM `tp_news` WHERE ( status=1 AND pid=7 AND ty=32 ) ORDER BY disorder desc,id desc LIMIT 0,6 [ RunTime:0.000322s ]
SELECT * FROM `tp_news` WHERE ( status=1 AND pid=43 AND ty=44 ) ORDER BY disorder desc,id desc LIMIT 0,1 [ RunTime:0.000382s ]
SELECT * FROM `tp_news` WHERE ( status=1 AND pid=43 AND ty=45 ) ORDER BY disorder desc,id desc LIMIT 0,1 [ RunTime:0.000412s ]
SELECT `inlinkurl` FROM `tp_sort` WHERE ( id=21 ) LIMIT 1 [ RunTime:0.000124s ]

应用类

平台类

工具类

下载中心

技术文章

在线体验

实时历史数据库-mtHistorian

关于我们

产品中心

解决方案

联系我们

欢迎登录