ERP data sharing framework using the Generic Product Model (GPM)

doi:10.1016/j.eswa.2010.05.013

2011-02-01

PRE

Naoufel Cheikhrouhou *

Rémy Glardon

DOI：10.1016/j.eswa.2010.05.013

原文链接

原文求助

摘要

En 中文

Nowadays all product life cycle processes are investigated deeply in order to get an advantage over competitors To support these processes several software applications are available However this wide range of heterogeneous applications leads to a large variety of hardware and operating systems data management software data models schemas and data semantics that hinder the information sharing process To tackle this problem Hitachi Company has developed a modeling language called Generic Product Model (GPM) in addition to several translators from native formats to GPM for storing sharing and visualizing product data in a single data warehouse In order to broaden the range of application data able to be stored and shared using the GPM data warehouse this paper presents a methodology and a translator that allow management data to be included in a GPM data warehouse Given the fact that most management data are stored in Enterprise Resource Planning (ERP) software and that the latter allows extraction of database contents into Excel files we propose a translator that handles Enterprise Resource Planning management data that are already extracted into Excel Format The proposed framework enables data management contained in flat Excel Files to be translated into structured GPM data Translation methodologies are given for the translation of mass production and customized product data through two case studies one in the computer retail sector and the other in the extrusion machine industry (C) 2010 Elsevier Ltd All rights reserved

Keyword:

Generic Product Model

Management data

Enterprise Resource Planning

Information sharing