| WinCC数据库中压缩数据的访问方法研究 |
| |
| 引用本文： | 樊广军,谢红清,梁建章.WinCC数据库中压缩数据的访问方法研究[J].机械工程与自动化,2006(2):124-126. |
| |
| 作者姓名： | 樊广军 谢红清 梁建章 |
| |
| 作者单位： | 中南大学,机电工程学院,湖南,长沙,410083 |
| |
| 摘 要： | 对于频率较大的轴承振动信号,数据存储量大且存储速度快,数据的存储方式是压缩的二进制数据格式,不能以常规的SQL查询方式实现数据库的访问。在WinCC系统所提供的数据库操作功能不能满足实际需要的情况下,对WinCCV6的数据库应用进行了二次开发以直接获得和分析数据库中的数据。并以“往复式压缩机故障诊断系统”为例,阐述了利用Visual C＋＋6．0访问WinCC数据库的方法、语法以及访问过程,给出了针对振动信号的查询方法,并证实了该方法的可行性和稳定性。
|
| 关 键 词： | WinCC数据库 压缩数据 |
| 文章编号： | 1672-6413(2006)02-0124-03 |
| 收稿时间： | 2006-01-23 |
| 修稿时间： | 2006年1月23日 |
Study and Method of Querying Compressed Data in WinCC Database |
| |
| FAN Guang-jun,XIE Hong-qing,LIANG Jian-zhang.Study and Method of Querying Compressed Data in WinCC Database[J].Mechanical Engineering & Automation,2006(2):124-126. |
| |
| Authors: | FAN Guang-jun XIE Hong-qing LIANG Jian-zhang |
| |
| Affiliation: | College of Mechanical and Electrical Engineering,Central South University, Changsha410083 ,China |
| |
| Abstract: | In order to get and analyse the data in WinCC database directly,a secondary developed application based on WinCC database was implemented because the query functions it provided can't meet the demand of our project purpose,especially querying the vibrating signal data which were stored largely and quickly by means of binary format and can't be queried with normal SQL language.The article demonstrated the method,syntax and process of operating WinCC database with Visual C~(()_(++)) in the project of "the fault diagnosis system for reciprocation compressor".The feasibility and reliability of our vibrating signal data solution were proved. |
| |
| Keywords: | Visual C 6 0 WinCC OLE DB |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
|
