A Relational Database Management System approach for Data Integration in manufacturing process

被引:0
|
作者
Corallo, A. [1 ]
Espostito, M. [1 ]
Massafra, A. [1 ]
Totaro, S. [1 ]
机构
[1] Univ Salento, CORE Lab, Lecce, Italy
来源
2018 IEEE INTERNATIONAL CONFERENCE ON ENGINEERING, TECHNOLOGY AND INNOVATION (ICE/ITMC) | 2018年
关键词
PostreSQL; Data Integration; Data Retrieval; Industry; 4.0; Smart Factory; BIG DATA; DISCOVERY;
D O I
暂无
中图分类号
TM [电工技术]; TN [电子技术、通信技术];
学科分类号
0808 ; 0809 ;
摘要
In this paper we introduce a data integration system by implementing a function into the context of PostgreSQL. The aim of this work is to collect files to process from two different data sources (a platform of Physical Testing Software (PTS) and another one of Physical Simulation Software (PSS)), in order to retrieve specific records through a query and integrate them. Both these platforms contain a large amount of files in semi-structured or unstructured format. This approach allows analysing data from different sources and creating a database remaining always in the PostgresSQL context. Indeed, the code is modular and it can be customizable for the specific scope. This approach reduces the information exchange with the client and the computational cost, because the instructions are applied all in once (on-the-fly) to the files stored in the Network File System (NFS). Furthermore, the integration outputs and the related data can be stored within it. One of the objectives of this work is to perform a new product introduction (NPI) for multi-sources data retrieval and integration. The result is a modular approach, customizable and suitable for the most of the integration and retrieval issues. The architecture proposed allows all the authorized users to access to the data in parallel, independently and on the same device, by running query straightly on the file through the Structured Query Language (SQL).
引用
收藏
页数:7
相关论文
共 50 条
  • [1] An approach to relational database schema integration
    Lukovic, I
    Mogin, P
    INFORMATION INTELLIGENCE AND SYSTEMS, VOLS 1-4, 1996, : 3210 - 3215
  • [2] Integration of a relational database with multimedia data
    Chung, SM
    Mah, PS
    Kim, JL
    TWENTIETH ANNUAL INTERNATIONAL COMPUTER SOFTWARE & APPLICATIONS CONFERENCE (COMPSAC'96), PROCEEDINGS, 1996, 20 : 290 - 297
  • [3] Cathode manufacturing relational data collection and process control system
    Effgen, Michael A.
    2008 IEEE INTERNATIONAL VACUUM ELECTRONICS CONFERENCE, 2008, : 324 - 325
  • [4] Cathode manufacturing relational data collection and process control system
    Effgen, Michael P.
    EIGHTH IEEE INTERNATIONAL VACUUM ELECTRONICS CONFERENCE, 2007, : 139 - 140
  • [5] Cathode Manufacturing Relational Data Collection and Process Control System
    Effgen, Michael P.
    2009 IEEE INTERNATIONAL VACUUM ELECTRONICS CONFERENCE, 2009, : 187 - 188
  • [6] Cathode Manufacturing Relational Data Collection and Process Control System
    Wolverton-Spencer, Lindsey
    Effgen, Michael
    2013 IEEE 14TH INTERNATIONAL VACUUM ELECTRONICS CONFERENCE (IVEC), 2013,
  • [7] Mining semiconductor manufacturing data for productivity improvement - an integrated relational database approach
    Dabbas, RM
    Chen, HN
    COMPUTERS IN INDUSTRY, 2001, 45 (01) : 29 - 44
  • [8] A workflow model based on relational database and its integration with management information system
    Tian, WJ
    PROCEEDINGS OF SECOND INTERNATIONAL WORKSHOP ON CSCW IN DESIGN, 1997, : 584 - 590
  • [9] SMSRD: A Streaming Graph Data Management System Based on Relational Database
    Luo, Yi
    Ren, Peng
    Wang, Weifan
    Liu, Xianbo
    Hu, Yuhang
    Li, Zeming
    Li, Xiangkuan
    Li, Wenyao
    Xing, Chunxiao
    WEB INFORMATION SYSTEMS AND APPLICATIONS, WISA 2024, 2024, 14883 : 239 - 250
  • [10] RELATIONAL DATABASE-MANAGEMENT SYSTEM
    BREARLEY, N
    LIBRARY SOFTWARE REVIEW, 1990, 9 (06): : 400 - 402