Development of an management information system as knowledge base model for machining process characterisation

Abstract

The current paper intends to use the typical problems of parameter selection and optimization in machining processes to bring out the design ideas that form the foundation of n-tier management information systems (MIS). These ideas can be used for creating data-driven, scalable enterprise information systems. The current phase (phase I) of the implementation highlights the capabilities of these design ideas in improving three key functional parameters of MIS, i.e. multi-dimensionality, isolation and scalability. The problem area of machining process characteristics of non traditional machining has been chosen with two specific goals in mind: A typical machining process has multiple parameters and various corresponding relationships can be found among such parameters. This will be used to highlight the degree of multi-dimensionality that can be achieved from a simple design pattern. The phase II of this paper can actually shift focus from the design of a generic management information system to a specific problem area of machining. This incorporates the features of an expert system in providing the customer or end user with maximum encapsulation of technical data and much improved decision-making capabilities within the system. Some complex machining processes such as abrasive water jet machining (AWJM), wire electrical discharge machining (WEDM) and electro discharge machining (EDM) are characterized by a large number of parameters which are not available in a structured fashion, thus, all the data associated with AWJM, WEDM and EDM systems has been conglomerated and presented in a normalized fashion. The essential features of the current research include the extraction of the relevant data from a large pool of data, with a distinct architecture of MIS, having three scalable layers. The normalization of the available data has been dealt with management information system and presented in the form of a software named “machining expert”. The code for the software provided is easy to understand, being written in Visual Basic and Access server for implementation. The developed “machining expert” for handling non traditional machining (NTM) data can also be extended with suitable design extensions to handle business logic by interacting with the end user. The current paper is applicable to any research on the structure and design of MIS in manufacturing technology.