CN 41-1243/TG ISSN 1006-852X
Volume 42 Issue 3
Jul.  2022
Turn off MathJax
Article Contents
WANG Jinling, LI Jianwei, TIAN Yebing, LIU Yanhou, ZHANG Kun. Methods of grinding power signal acquisition and dynamic power monitoring database establishment[J]. Diamond & Abrasives Engineering, 2022, 42(3): 356-363. doi: 10.13394/j.cnki.jgszz.2021.0608
Citation: WANG Jinling, LI Jianwei, TIAN Yebing, LIU Yanhou, ZHANG Kun. Methods of grinding power signal acquisition and dynamic power monitoring database establishment[J]. Diamond & Abrasives Engineering, 2022, 42(3): 356-363. doi: 10.13394/j.cnki.jgszz.2021.0608

Methods of grinding power signal acquisition and dynamic power monitoring database establishment

doi: 10.13394/j.cnki.jgszz.2021.0608
More Information
  • Received Date: 2021-06-08
  • Rev Recd Date: 2022-03-25
  • The grinding power monitoring experimental platform was built with PPC−3 power sensor and NI 9203 acquisition card. An intelligent grinding process decision-making system driven by monitored power data was developed based on LabVIEW software to promote green, efficient and intelligent grinding. In order to overcome the problems of huge amount of bottom process monitoring data (i.e. grinding dynamic power signals collected online) of the decision-making system, mixture with noise and unclear typical characteristics, a method of feature extraction of grinding power signals and establishment of relational database is proposed. The type Ⅱ Chebyshev low-pass filter was used to filter and improve the signal-to-noise ratio of grinding power signals. The peak and the valley characteristic points of power signals were extracted and marked in time domain based on the peak and the valley searching method, and the head and the tail correction and interpolation correction were carried out to ensure the integrity and accuracy of grinding power data. At the same time, the working state of grinding process was marked based on binarization, and the dynamic flow data was converted into string and stored in the cells of relational database. The grinding test results of bearing steel show that the database establishment method can accurately extract the grinding power characteristics and transform 2090000 dynamic data points into 2×52998 cell data, the data volume is reduced to 5.07% of the source data, which significantly reduces the storage scale of data and speeds up the access speed of grinding database.

     

  • loading
  • [1]
    TIAN Y B, LIU F, WANG Y, et al. Development of portable power monitoring system and grinding analytical tool [J]. Journal of Manufacturing Processes,2017,27:188-197. doi: 10.1016/j.jmapro.2017.05.002
    [2]
    易军, 金滩, 张明东. 基于磨削功率测量和巴克豪森无损检测的齿轮成形磨削烧伤研究 [J]. 机械传动,2019,43(9):109-112.

    YI Jun, JIN Tan, ZHANG Mingdong. Research of gear form grinding burn based on grinding power measurement and barkhausen nondestructive test [J]. Journal of Mechanical Transmission,2019,43(9):109-112.
    [3]
    CHI Y L, LI H L, CHEN X. In-process monitoring and analysis of bearing outer race way grinding based on the power signal [J]. Institution of Mechanical Engineers: Journal of Engineering Manufacture,2017,231(14):2622-2635.
    [4]
    DAI C W, DING W F, ZHU Y J, et al. Grinding temperature and power consumption in high speed grinding of Inconel 718 nickel-based superalloy with a vitrified CBN wheel [J]. Precision Engineering,2018,52:192-200. doi: 10.1016/j.precisioneng.2017.12.005
    [5]
    迟玉伦. 基于功率信号的切入式磨削工艺优化关键技术研究 [D]. 上海: 上海理工大学, 2016.

    CHI Yulun. Study on the key technology of plunge grinding optimization based on power signal [D]. Shanghai: University of Shanghai for Science & Technology, 2016.
    [6]
    王新阳, 贾相宇, 陈志泊, 等. 森林生态站大数据快速存储与索引方法 [J]. 农业机械学报,2021(8):195-204, 212.

    WANG Xinyang, JIA Xiangyu, CHEN Zhipo, et al. Research on fast storage and indexing method of big data in forest ecological station [J]. Transactions of the Chinese Society for Agricultural Machinery,2021(8):195-204, 212.
    [7]
    尹晖. 典型机床关键零部件切削磨削比能能效建模及其数据库系统研发 [D]. 湘潭: 湖南科技大学, 2018.

    YIN Hui. Cutting and grinding specific energy efficiency modeling and database system research and development of typical key parts of machine tools [D]. Xiangtan: Hunan University of Science and Technology, 2018.
    [8]
    郑孟蕾, 田凌. 基于时序数据库的产品数字孪生模型海量动态数据建模方法 [J]. 清华大学学报(自然科学版),2021,61(11):1281-1288.

    ZHENG Menglei, TIAN Ling. Digital product twin modeling of massive dynamic data based on a time-series database [J]. Journal of Tsinghua University (Science and Technology),2021,61(11):1281-1288.
    [9]
    LI C, LI J X, SI J H, et al. Flute DB: An efficient and dependable time-series database storage engine: International conference on security, privacy and anonymity in computation, communication and storage [C]. Guangzhou: Springer, 2017.
    [10]
    王玙, 左良利. 关系数据库支持的不确定时间序列存储 [J]. 计算机技术与发展,2019(11):7-11. doi: 10.3969/j.issn.1673-629X.2019.11.002

    WANG Yu, ZUO Liangli. Research on storage of uncertain time series in relational databases [J]. Computer Technology and Development,2019(11):7-11. doi: 10.3969/j.issn.1673-629X.2019.11.002
    [11]
    RHEA S, WANG E, WONG E, et al. Little table: A time-series database and its uses: Proceedings of the 2017 ACM international conference on management of data [C]. Chicago: ACM, 2017.
    [12]
    丁玉美, 高西全. 数字信号处理(第二版) [M]. 西安: 西安电子科技大学出版社, 2001.

    DING Yumei, GAO Xiquan. Digital signal processing (Second Edition) [M]. Xi'an: Xi'an University of Electronic Science and Technology Press, 2001.
    [13]
    周鹏, 许钢, 马晓瑜. 精通LabVIEW信号处理 [M]. 北京: 清华大学出版社, 2013.

    ZHOU Peng, XU Gang, MA Xiaoyu. Proficient in LabVIEW signal processing [M]. Beijing: Tsinghua University Press, 2013.
    [14]
    李建伟, 田业冰, 张昆, 等. 面向磨削数据库的功率信号压缩方法研究 [J]. 制造技术与机床,2021(8):117-121.

    LI Jianwei, TIAN Yebing, ZHANG Kun, et al. Research on compression method of power signal toward grinding database [J]. Manufacturing Technology & Machine Tool,2021(8):117-121.
  • 加载中

Catalog

    通讯作者: 陈斌, bchen63@163.com
    • 1. 

      沈阳化工大学材料科学与工程学院 沈阳 110142

    1. 本站搜索
    2. 百度学术搜索
    3. 万方数据库搜索
    4. CNKI搜索

    Figures(12)

    Article Metrics

    Article views (246) PDF downloads(46) Cited by()
    Proportional views
    Related

    /

    DownLoad:  Full-Size Img  PowerPoint
    Return
    Return