摘要：【中文】本发明公开了数据库索引优化建议与验证的方法和装置，涉及数据库技术领域。该方法的一具体实施方式包括：根据预定规则生成模拟数据；对所述模拟数据应用候选索引；对所述模拟数据执行结构化SQL语句，以得到第一性能参数集；对经索引的模拟数据执行所述结构化SQL语句，以得到第二性能参数集；以及比较所述第一性能参数集和所述第二性能参数集，以得到比较结果。该实施方式克服了在线上数据库验证优化结果时对业务造成影响的问题。 【EN】The invention discloses a database index optimization suggestion and verification method and device, and relates to the technical field of databases. One embodiment of the method comprises: generating simulation data according to a preset rule; applying a candidate index to the simulated data; executing a structured SQL statement on the simulation data to obtain a first performance parameter set; executing the structured SQL statement on the indexed simulation data to obtain a second performance parameter set; and comparing the first performance parameter set and the second performance parameter set to obtain a comparison result. The implementation mode solves the problem that the online database verifies the optimization result to influence the service.

摘要：【中文】本申请公开了一种无灯控路口停车让行控制方法及系统,车辆检测装置实时检测主路上的车辆信息，车辆提醒装置接收到车辆检测装置发送的车辆信息后进行车辆提醒，并对支路车辆进行抓拍获取支路车辆从当前时刻到停止线前的状态信息；如果支路车辆从当前时刻到停止线前的状态信息表征车辆未按所述车辆提醒装置的提醒进行停车避让，则启动主路提醒装置并对支路车辆进行抓拍记录。通过设置在主路的车辆检测装置和支路的车辆提醒装置，实现了对支路上的车辆的提醒。使得支路上的车辆能够实时获知主路上车辆的情况，并且配合车辆抓拍对支路车辆不停车避让行为进行抓拍，降低了主路和支路交叉口发生交通事故的概率。 【EN】The application discloses a method and a system for controlling the stopping and passing of a light-free control intersection, wherein a vehicle detection device detects vehicle information on a main road in real time, a vehicle reminding device reminds the vehicle after receiving the vehicle information sent by the vehicle detection device, and the vehicle reminding device carries out snapshot on a branch vehicle to obtain the state information of the branch vehicle from the current moment to the front of a stop line; and if the state information of the branch road vehicles from the current moment to the front of the stop line indicates that the vehicles do not carry out parking avoidance according to the reminding of the vehicle reminding device, starting the main road reminding device and carrying out snapshot recording on the branch road vehicles. The vehicle detection device arranged on the main road and the vehicle reminding device arranged on the branch road realize the reminding of the vehicles on the branch road. The condition of the vehicles on the main road can be known in real time by the vehicles on the branch road, the non-stop avoidance behavior of the vehicles on the branch road is snapshotted by matching with vehicle snapshotting, and the probability of traffic accidents at the intersection of the main road and the branch road is reduced.

摘要：【中文】本发明公开的一种基于网关控制器的智能家居报警系统，包括网关控制器，网关控制器上设置有声光报警器，网关控制器电连接有无线路由器和安装在门窗上的门窗传感器，无线路由器通过导线连接有调制解调器且通过调制解调器与互联网连接。本发明一种基于网关控制器的智能家居报警系统，通过在门窗上安装门窗传感器，遇到门窗非正常打开，门窗传感器传递信号给网关控制器，并由声光报警器发出警报；同时，该报警信息通过无线路由器上传至互联网以提醒户主，能够显著提升家居安全性。 【EN】The invention discloses an intelligent home alarm system based on a gateway controller, which comprises the gateway controller, wherein an audible and visual alarm is arranged on the gateway controller, the gateway controller is electrically connected with a wireless router and a door and window sensor arranged on a door and a window, and the wireless router is connected with a modem through a lead and is connected with the Internet through the modem. According to the intelligent home alarm system based on the gateway controller, the door and window sensors are arranged on the doors and the windows, and when the doors and the windows are opened abnormally, the door and window sensors transmit signals to the gateway controller, and the audible and visual alarm gives out an alarm; meanwhile, the alarm information is uploaded to the internet through the wireless router to remind a householder, and the home safety can be remarkably improved.

摘要：【中文】本发明实施例提供一种相似文章去重的方法、装置、终端及计算机可读存储介质，方法包括：按照预设的召回方式获取包括至少两篇待处理文章的候选集，召回方式包括以下至少之一：标题方式、关键字方式、图文哈希方式、全文哈希方式；对候选集中的待处理文章进行相似分析处理，获得待处理文章之间的相似信息；根据相似信息确定候选集中的相似文章，对相似文章进行去重处理。本发明提供的技术方案，通过预设的四种召回方式来获取包括待处理文章的候选集，通过获得待处理文章之间的相似信息，根据相似信息确定候选集中的相似文章，对相似文章进行去重处理，能够避免相同或者相似文章的重复下发，从而可以保证服务的下发质量，有效地提高用户的阅读体验。 【EN】The embodiment of the invention provides a method, a device, a terminal and a computer readable storage medium for duplicate removal of similar articles, wherein the method comprises the following steps: obtaining a candidate set comprising at least two articles to be processed according to a preset recall mode, wherein the recall mode comprises at least one of the following modes: title mode, keyword mode, image-text hash mode and full-text hash mode; carrying out similar analysis processing on the articles to be processed in the candidate set to obtain similar information among the articles to be processed; and determining similar articles in the candidate set according to the similar information, and performing deduplication processing on the similar articles. According to the technical scheme provided by the invention, the candidate set comprising the articles to be processed is obtained through four preset recall modes, similar information among the articles to be processed is obtained, the similar articles in the candidate set are determined according to the similar information, and duplicate removal processing is carried out on the similar articles, so that repeated issuing of the same or similar articles can be avoided, the issuing quality of service can be ensured, and the reading experience of a user can be effectively improved.

摘要：【中文】本发明公开了一种室内煤气远程报警系统，包括PLC，PLC分别连接有多个一氧化碳传感器、声光报警器和断路器，断路器与室内总电源连接，PLC连接有GPRS通信模块，GPRS通信模块连接有两个或两个以上移动终端。本发明还公开了一种室内煤气远程报警方法，依次进行一氧化碳浓度监测，断开总电源，开启声光报警器，并将实时监测数据通过GPRS通信模块传送给移动终端，煤气泄漏，完成报警，本发明能够向两个或两个以上终端进行远程报警，以实现迅速对煤气泄露作出应对，保证了煤气泄漏的稳妥处理，同时避免了火灾、爆炸等其他事故。 【EN】The invention discloses an indoor gas remote alarm system which comprises a PLC, wherein the PLC is respectively connected with a plurality of carbon monoxide sensors, an audible and visual alarm and a circuit breaker, the circuit breaker is connected with an indoor main power supply, the PLC is connected with a GPRS communication module, and the GPRS communication module is connected with two or more mobile terminals. The invention also discloses an indoor gas remote alarm method, which comprises the steps of monitoring the concentration of carbon monoxide, disconnecting the main power supply, starting the audible and visual alarm, transmitting real-time monitoring data to the mobile terminal through the GPRS communication module, and finishing alarm when gas leaks.

摘要：【中文】本发明公开的一种适用于通讯设备的固线单元，包括包覆带，包覆带两端分别固接有锁紧带a和锁紧带b，锁紧带a上设置有定位槽a，锁紧带b上连接有定位单元；定位单元包括横截面为矩形的长槽，沿长槽的长向两侧壁均匀设置有若干圆孔，长槽内还设置有柱状的长轴，锁紧带b穿过长槽且缠绕在长轴上；长槽的底面还设置有定位槽b。本发明一种适用于通讯设备的固线单元，通过长轴缠绕锁紧带b，长轴固定在对应位置的圆孔内，能有效的锁紧电缆，同时在使用热缩管吹热，冷却后能抱紧电缆，通过定位槽a和定位槽b与预设的螺纹孔锁定本发明，结构简单，有很好的实用价值。 【EN】The invention discloses a wire fixing unit suitable for communication equipment, which comprises a wrapping belt, wherein two ends of the wrapping belt are respectively and fixedly connected with a locking belt a and a locking belt b, a positioning groove a is formed in the locking belt a, and a positioning unit is connected to the locking belt b; the positioning unit comprises an elongated slot with a rectangular cross section, a plurality of round holes are uniformly arranged along two long-direction side walls of the elongated slot, a columnar long shaft is also arranged in the elongated slot, and the locking belt b penetrates through the elongated slot and is wound on the long shaft; the bottom surface of the long groove is also provided with a positioning groove b. According to the wire fixing unit suitable for the communication equipment, the locking belt b is wound on the long shaft, the long shaft is fixed in the round hole in the corresponding position, the cable can be effectively locked, meanwhile, the heat shrinkable tube is used for blowing heat, the cable can be tightly held after cooling, and the wire fixing unit is locked with the preset threaded hole through the positioning groove a and the positioning groove b, and is simple in structure and high in practical value.

摘要：【中文】本发明公开了一种适用于音响的降噪密封圈，包括密封圈本体，密封圈本体由内而外依次由泡沫层、降噪层和橡胶层组成，本发明还公开了一种适用于音响的降噪密封圈的制备方法，将泡沫层、降噪层和橡胶层紧密嵌合，然后置于高温高压环境中固化，得到降噪密封圈，本发明通过在音响上的喇叭处设置包含密封圈，通过降噪层有效吸收音响工作过程中产生的噪音，起到吸声效果，并通过在降噪层的外壁设置泡沫层，利用泡沫层大大减缓了喇叭所产生的振动，使得喇叭与音响之间存在缓冲，从而使喇叭所引起的共振基本消失，外层的橡胶层起保护作用。 【EN】The invention discloses a noise reduction sealing ring suitable for a sound device, which comprises a sealing ring body, wherein the sealing ring body consists of a foam layer, a noise reduction layer and a rubber layer from inside to outside in sequence.

摘要：【中文】本发明公开的一种适用于滤波器的固线单元，包括包覆带，包覆带的两端分别固定连接有锁定条a和锁定条b，锁定条a的端部还设置有圆形的定位孔a，锁定条b上还设置有定位单元；定位单元包括沿锁定条b长向设置有长槽，长槽内依次设置有若干相连接的圆形定位孔b。本发明一种适用于滤波器的固线单元，采用热缩管作为包覆带，在加热情况进行线缆的包覆，自然冷却后会更加紧固线缆；同时使用定位孔a和长槽上定位孔b的进一步固定，加强了线缆的紧固，有很好的实用价值。 【EN】The invention discloses a wire fixing unit suitable for a filter, which comprises a cladding belt, wherein two ends of the cladding belt are respectively and fixedly connected with a locking strip a and a locking strip b; the positioning unit comprises a long groove arranged along the length direction of the locking strip b, and a plurality of connected circular positioning holes b are sequentially arranged in the long groove. According to the wire fixing unit suitable for the filter, the heat shrinkage pipe is used as the cladding belt, the cable is clad under the heating condition, and the cable is more fastened after natural cooling; and meanwhile, the positioning hole a and the positioning hole b on the elongated slot are further fixed, so that the fastening of the cable is enhanced, and the cable fixing device has good practical value.

摘要：【中文】本发明公开的一种基于网关控制器的智能家居空气净化系统，包括网关控制器和内置WIFI控制模块的空气净化器，网关控制器和空气净化器共同电连接有无线路由器，无线路由器通过导线连接有调制解调器且通过调制解调器与互联网连接，网关控制器还电连接有安装在门窗上的门窗传感器。本发明一种基于网关控制器的智能家居空气净化系统，通过在门窗上安装门窗传感器，门窗打开时门窗传感器传递信号给网关控制器，网关控制器传递给无线路由器通过无线路由器控制空气净化器来实现空气净化器的开关，从而实现空气净化器的自动操作，提高了产品的实用性、易用性和人性化程度。 【EN】The invention discloses an intelligent household air purification system based on a gateway controller, which comprises the gateway controller and an air purifier with a built-in WIFI control module, wherein the gateway controller and the air purifier are jointly and electrically connected with a wireless router, the wireless router is connected with a modem through a lead and is connected with the Internet through the modem, and the gateway controller is also electrically connected with a door and window sensor arranged on a door and a window. According to the intelligent household air purification system based on the gateway controller, the door and window sensors are installed on the doors and the windows, the door and window sensors transmit signals to the gateway controller when the doors and the windows are opened, the gateway controller transmits the signals to the wireless router, and the wireless router controls the air purifier to open and close, so that the air purifier is automatically operated, and the practicability, the usability and the humanization degree of the product are improved.

摘要：【中文】本发明公开的一种适用于滤波器的线卡，包括包覆带，包覆带的两端分别连接有固定板和锁紧带；锁紧带上沿长向设置有锁紧槽；沿固定板长向分为固定板a和固定板b，固定板a上设置有固定槽a，固定板b上设置有固定槽b。本发明一种适用于滤波器的线卡，以水平设置的固定板为基板，通过固定板a上的固定槽a进行线缆的紧固，必要时还与滤波器上预设的螺纹孔配合固定线卡，通过固定板b上固定槽b也能与预设的螺纹孔配合固定线卡的位置；通过热缩管进一步对线缆抱紧，锁紧线缆；固定板选用硬塑料，保证与滤波器锁紧一端时，另一端不易移动，有很好的实用价值。 【EN】The invention discloses a wire clamp suitable for a filter, which comprises a cladding belt, wherein two ends of the cladding belt are respectively connected with a fixing plate and a locking belt; a locking groove is formed in the upper edge of the locking belt along the length direction; the fixing plate is divided into a fixing plate a and a fixing plate b along the length direction of the fixing plate, wherein a fixing groove a is formed in the fixing plate a, and a fixing groove b is formed in the fixing plate b. The invention relates to a line card suitable for a filter, which takes a horizontally arranged fixing plate as a base plate, fastens a cable through a fixing groove a on a fixing plate a, and is matched with a threaded hole preset on the filter to fix the line card if necessary, and can also be matched with the threaded hole preset on a fixing plate b to fix the position of the line card through a fixing groove b on a fixing plate b; further clasping the cable through a heat shrink tube to lock the cable; the fixed plate is made of hard plastic, so that when one end of the fixed plate is locked with the filter, the other end of the fixed plate is not easy to move, and the fixed plate has good practical value.