Arktos: towards the modeling, design, control and execution of ETL processes
Information Systems - Data extraction, cleaning and reconciliation
Modelling Product Structures by Generic Bills-of-Materials
Modelling Product Structures by Generic Bills-of-Materials
Similarity Flooding: A Versatile Graph Matching Algorithm and Its Application to Schema Matching
ICDE '02 Proceedings of the 18th International Conference on Data Engineering
The Value of Information Sharing in a Two-Level Supply Chain
Management Science
Supply Chain Inventory Management and the Value of Shared Information
Management Science
The Data Mapping Problem: Algorithmic and Logical Characterizations
ICDEW '05 Proceedings of the 21st International Conference on Data Engineering Workshops
EDI, XML and e-business frameworks: A survey
Computers in Industry
Business Process Modeling for Organizational Knowledge Management
Concurrency, Graphs and Models
Design of product ontology architecture for collaborative enterprises
Expert Systems with Applications: An International Journal
Simulating the ERP Diffusion Behavior in Industrial Networks
ICSEA '08 Proceedings of the 2008 The Third International Conference on Software Engineering Advances
A structural equation model for analyzing the impact of ERP on SCM
Expert Systems with Applications: An International Journal
Sharing knowledge in a supply chain using the semantic web
Expert Systems with Applications: An International Journal
A generic and customizable framework for the design of ETL scenarios
Information Systems - Special issue: The 15th international conference on advanced information systems engineering (CAiSE 2003)
A core ontology for business process analysis
ESWC'08 Proceedings of the 5th European semantic web conference on The semantic web: research and applications
Estimating software project effort for manufacturing firms
Computers in Industry
Hi-index | 12.05 |
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.