Academia.eduAcademia.edu

Outline

Title
Abstract
Introduction
Methodology 2.1 Edas Method
Material Utilization
Results and Discussions
Conclusion
References

Selection of Manufacturing Process using EDAS method

Profile image of Manjula SelvamManjula SelvamProfile image of Chinnasami SChinnasami S

2025, REST Publisher

https://doi.org/10.46632/AAE/3/1/2
visibility

…

description

8 pages

link

1 file

Abstract

The decision-making phase of a manufacturing method entails deciding on the most appropriate technique to effectively and cost-effectively turn the beginning ingredients into final products. With the goal to maximize productivity, decrease expenses, while preserving consistent quality, it essential to consider an array of components when choosing a manufacturing process. This includes layout, substances, price, quantity, and assurance. The consequences of manufacturing process selection on product quality, economical capacity for production, the time to market, adaptability, and environmental sustainability is what gives this topic research significance. Optimizing results for a business's operations and strategic plan necessitates careful examination of multiple elements. Alternate Parameters: "Sand casting", "Gravity die casting", and "Investment casting". Evaluation Parameters: "Flexibility", "Productivity", "Accuracy" and "Complexity". For the Selection of Manufacturing Process, the best alternate parameter would be "Sand Casting". The Respective Ranks are "Sand casting" is in the 1st Rank, "Additive Manufacturing" is in the 2nd Rank, "Gravity Die casting" is in the 3rd Rank, "Pressure Die casting" is in the 4rth Rank, and "Investment Casting" is in the 5fth Rank.

Related papers

Process Selection from Design to Manufacture
Juan Luis Alonso Aguilar
View PDFchevron_right
Early design stage selection of best manufacturing process
Ian Grosse

Journal of Engineering Design, 2019

Design for additive manufacturing (DFAM) calls for more complex designs to best utilise unique design freedoms to improve designs. Conversely, less complex designs are generally more suitable for conventional manufacturing processes due to the higher cost to produce features that are more complex. As additive manufacturing (AM) emerges as an increasingly viable option to produce products beyond initial prototyping, the choice of conventional versus additive manufacturing must occur as early as possible in the design process as this choice can substantially affect how the product is designed. Realising the right decision too late in a design process will lead to wasted design time, increased time to market the product, a functionally inferior design, and/or a costlier product. To address this critical decision, we introduce a Design for any X Manufacturing (DFXM) method to use at early design stages to identify the best process for a given product design in cases where comprehensive current process databases may not yet be available to a designer to screen process choices. This DFXM method customises targeted questions to break down concepts into the key elements while capturing any known disparate process choices within consistent formulations. The method relates any measurable metrics found for any criteria at conceptual design within these formulations to evaluate them accordingly. A technique is introduced to simplify and focus voluminous process capability information toward that needed for this specialised early stage decision. After initial inputs from a designer, an algorithm automatically computes the best process choice as a function of expected order quantity. Three illustrative case studies demonstrate the practical application of this DFXM method in representative design scenarios.

View PDFchevron_right
Process Selection from Design to Manufacture[1]
Nanda Pandia
View PDFchevron_right
COST-BASED RANKING FOR MANUFACTURING PROCESS SELECTION SELECTION DES PROCEDES DE FABRICATION SELON DES CRITERES ECONOMIQUES
Amal Esawi

RESUME La sélection d'un procédé de fabrication comprend deux étapes. La première consiste a évaluer les différents procédés afin de vérifier qu'ils permettent, d'un point de vue technique, d'obtenir un produit en accord avec les spécifications. La seconde étape consiste a classer les procédés retenus selon des critères économiques. Cette phase fait intervenir des techniques simples d'estimation de coût. Cependant, on rencontre au cours de cette sélection deux types de problèmes.

View PDFchevron_right
Selection methodologies of materials and manufacturing processes
Sydney Santos

Materials Research, 2003

The present work discusses some principles of materials selection and examines a few selection criteria and contexts in which this technical activity takes place. Emphasis is given to the concept of Merit Indices, and to the methodology employed for its deduction. The Materials Properties Charts and their integration with the Merit Indices are introduced and illustrated by the former of the two case studies here presented whilst the second associates the methodology of materials selection to process selection.

View PDFchevron_right
CLASSIFICATIONS OF MANUFACTURING PROCESSES AND STRATEGY USED IN SELECTING SUITABLE PROCESSES FOR SUITABLE APPLICATIONS
Dr. Osama M Elmardi

CLASSIFICATIONS OF MANUFACTURING PROCESSES AND STRATEGY USED IN SELECTING SUITABLE PROCESSES FOR SUITABLE APPLICATIONS, 2019

This research paper explains briefly the different types of manufacturing processes and manufacturability of engineering materials. The objective of this paper is to study the manufacturing processes of classical materials from the view point of their classifications, and strategy used in selecting suitable processes for suitable applications.

View PDFchevron_right
Multi-criteria selection of manufacturing processes in the conceptual process planning
Dejan Lukic

Advances in Production Engineering & Management, 2017

Process planning is one of the most difficult tasks in product development caused by the large number of technical, technological, economic, environmental and other criteria. Accordingly, the selection of manufacturing processes is a complex multi-criteria decision making problem since it considers a number of possible alternative manufacturing processes in addition to a large number of specified criteria. This paper represents the computer-aided methodology for the multi-criteria evaluation and selection of manufacturing processes at the stage of conceptual process planning. The developed methodology is primarily focused on the mapping of product design and manufacturing requirements. Manufacturing processes that fail to meet the given conditions on the basis of 10 criteria such as materials, production volume, productivity, dimensional accuracy, surface finish, etc., are eliminated according to the developed rules. Then, the multi-criteria evaluation and ranking of manufacturing processes is performed based on 5 criteria: manufacturing cycle time, process flexibility, material utilization, quality and operating costs. Based on this methodology, a system is developed for the multi-criteria selection of manufacturing processes, whose implementation is presented in the case of the hip joint endoprosthesis.

View PDFchevron_right
Module 3 Selection of Manufacturing Processes
Shaiilesh Shrivastava

The purpose of this lecture is to outline various casting processes, several defects that appear in casting and corresponding remedial measures, and general recommendations to achieve a good quality casting.

View PDFchevron_right
MANUFACTURING PROCESSES-I LECTURE NOTES Prepared by MELİH BAYRAMOĞLU
Derviş Mehmet Başak

Course Type: Compulsory Year of Study: 3 Course Semester: Fall (16 Weeks) ECTS: 5 Name of Lecturer(s) :Prof.Dr. MELİH BAYRAMOĞLU

View PDFchevron_right
The development and use of a software tool for selecting manufacturing processes at the early stages of design
Amal Esawi

2000

Choosing the right manufacturing process for making a component is an important consideration at the early stages of design. Frequently, the choice of process is based on previous experience or tradition, thereby missing the opportunity to use a new or more suitable process. Lost opportunities could be avoided if the designer had access to a quick efficient selection tool that would guide the selection. In this paper, a systematic procedure for selecting the optimum process to manufacture a component is described.

View PDFchevron_right

References (43)

  1. Herring, M. L., J. I. Mardel, and B. L. Fox. "The effect of material selection and manufacturing process on the surface finish of carbon fibre composites." Journal of Materials Processing Technology 210, no. 6-7 (2010): 926-940.
  2. Vasconcelos, Teófilo, Sara Marques, José das Neves, and Bruno Sarmento. "Amorphous solid dispersions: Rational selection of a manufacturing process." Advanced drug delivery reviews 100 (2016): 85-101.
  3. Van Luttervelt, C. A. "On the selection of manufacturing methods illustrated by an overview of separation techniques for sheet materials." CIRP annals 38, no. 2 (1989): 587-607.
  4. Esawi, A. M. K., and M. F. Ashby. "Computer-based selection of manufacturing processes: Methods, software and case studies." Proceedings of the Institution of Mechanical Engineers, Part B: Journal of Engineering Manufacture 212, no. 8 (1998): 595-610.
  5. Sathiyaraj Chinnasamy, Vimala Saravanan, Nathiya Murali, M. Ramachandran, "Optimization of Welding Process Parameters using the MOORA Method", Building Materials and Engineering Structures, 2(4), December 2024, 9-17.
  6. Ambhore, Dhairysheel, Akash Tiwari, Ujval Patel, Jishnu Patil, and M. Ramachandran. "Effect of aluminium oxide nano filler in tetrafluoroethane (R-134a) refrigerant." In IOP Conference Series: Materials Science and Engineering, vol. 810, no. 1, p. 012018. IOP Publishing, 2020.
  7. Mohiuddin, Mohammed Quadir. "Role of a women entrepreneur in agcc (ARAB GULF cooperation council) women empowerment." Journal of Interdisciplinary Research (ISSN: 2408-1906) 1, no. 2 (2016).
  8. Sundram, Suja, Manju Shree Raman, and S. Balamuralitharan. "Influence of process parameters on machining studies on stir casted MMCs with AA6351 and TiO2 by grey and desirability approaches." Materials Today: Proceedings 77 (2023): 551-556.
  9. Somesh Nagalla, Deepak Das, Nihari Paladugu, A Study on Key Drivers and Deterrents in Digital Payment in the State of Odisha, Journal on Electronic and Automation Engineering, 3(2), June 2024, 25-41.
  10. Chau, O. L., and Celik Parkan. "Selection of a manufacturing process with multiple attributes: A case study." Journal of Engineering and Technology Management 12, no. 3 (1995): 219-237.
  11. Manc ¸anares, Cauê G., Eduardo de S. Zancul, Juliana Cavalcante da Silva, and Paulo A. Cauchick Miguel. "Additive manufacturing process selection based on parts' selection criteria." The International Journal of Advanced Manufacturing Technology 80 (2015): 1007-1014.
  12. Hlupic, Vlatka, and Ray J. Paul. "Guidelines for selection of manufacturing simulation software." IIE transactions 31, no. 1 (1999): 21-29.
  13. Yim, Sungshik, and David Rosen. "Build time and cost models for additive manufacturing process selection." In International Design Engineering Technical Conferences and Computers and Information in Engineering Conference, vol. 45011, pp. 375-382. American Society of Mechanical Engineers, 2012.
  14. Gauchi, Jean-Pierre, and Pierre Chagnon. "Comparison of selection methods of explanatory variables in PLS regression with application to manufacturing process data." Chemometrics and Intelligent Laboratory Systems 58, no. 2 (2001): 171-193.
  15. Joshi, Ritvik, Jishnu Patil, Sidakdeep Singh Luthra, and Sankalp Gaud Prof Giridhar Chavan. "Three Wheeled Omnidirectional Soccer Robot Modelling and Wireless controlling using Bluetooth enabled PlayStation Controller." REST J. Emerg. trends Model. Manuf 5, no. 2 (2019).
  16. Mohiuddin, Mohammed Quadir. "Evaluation of Organizational Psychology using GRA Method.", Trends in Finance and Economics, 1(1), June 2023, 8-14.
  17. Sundram, Suja, Sunil E. Tambvekar, S. Sekar, Shiv Kant Tiwari, and R. Gopinathan. "THE EFFECT OF SERVICE QUALITY ON PATIENT LOYALTY MEDIATED BY PATIENT SATISFACTION." Journal of Pharmaceutical Negative Results 13 (2022).
  18. Chandrasekar Raja, Soniya Sriram, Vidhya Prasanth, M. Ramachandran, "Assessing Sustainable Eco-Friendly Refrigerants: An EDAS Methodology Approach", /Building Materials and Engineering Structures, 2(4), December 2024, 18-28.
  19. Somesh Nagalla, Nihari Paladugu, Deepak Das, The Development of Pedagogical Tasks and Evaluation of Computer Mediated Communication for Using GRA Method, Journal on Innovations in Teaching and Learning, 3(4), December 2024, 13-20.
  20. Dagdeviren, Metin. "A hybrid multi-criteria decision-making model for personnel selection in manufacturing systems." Journal of Intelligent manufacturing 21 (2010): 451-460.
  21. Naidu, Sasikumar, Rapinder Sawhney, and Xueping Li. "A methodology for evaluation and selection of nanoparticle manufacturing processes based on sustainability metrics." Environmental science & technology 42, no. 17 (2008): 6697-6702.
  22. Govindan, Kannan, Kiran Garg, Seema Gupta, and P. C. Jha. "Effect of product recovery and sustainability enhancing indicators on the location selection of manufacturing facility." Ecological indicators 67 (2016): 517-532.
  23. Mani, Mahesh, Jatinder Madan, Jae Hyun Lee, Kevin W. Lyons, and S. K. Gupta. "Sustainability characterisation for manufacturing processes." International journal of production research 52, no. 20 (2014): 5895-5912.
  24. Guimarães, Alexandre Magno Castañon, José Eugenio Leal, and Paulo Mendes. "Discrete-event simulation software selection for manufacturing based on the maturity model." Computers in Industry 103 (2018): 14-27.
  25. Mohiuddin, Mohammed Quadir. "Retention strategies for talent." International Journal of Management, IT and Engineering 4, no. 10 (2014): 26-42.
  26. Sundram, Suja, Himanshu Chauhan, Iskandar Muda, Femmy Effendy, Somya Choubey, and Ity Patni. "The effects of electronic word-of-mouth (E-WOM) on integrated results and destination picture of traditional image of tourists." Webology 19, no. 1 (2022): 4847-4866.
  27. Nihari Paladugu, Somesh Nagalla, Deepak Das, Comprehensive Evaluation and Ranking of Technology-Enhanced Learning Methods A Comparative Analysis, Journal on Innovations in Teaching and Learning, 3(3), September 2024, 8-18.
  28. Wang, Yuanbin, Ray Y. Zhong, and Xun Xu. "A decision support system for additive manufacturing process selection using a hybrid multiple criteria decision-making method." Rapid Prototyping Journal (2018).
  29. Kahraman, Cengiz, Mehdi Keshavarz Ghorabaee, Edmundas Kazimieras Zavadskas, Sezi Cevik Onar, Morteza Yazdani, and Basar Oztaysi. "Intuitionistic fuzzy EDAS method: an application to solid waste disposal site selection." Journal of Environmental Engineering and Landscape Management 25, no. 1 (2017): 1-12.
  30. Asante, Dennis, Zheng He, Nana Osae Adjei, and Bismark Asante. "Exploring the barriers to renewable energy adoption utilising MULTIMOORA-EDAS method." Energy Policy 142 (2020): 111479.
  31. Kundakcı, Nilsen. "An integrated method using MACBETH and EDAS methods for evaluating steam boiler alternatives." Journal of Multi-Criteria Decision Analysis 26, no. 1-2 (2019): 27-34.
  32. Kutlu Gündogdu, Fatma, Cengiz Kahraman, and Hatice Nida Civan. "A novel hesitant fuzzy EDAS method and its application to hospital selection." Journal of Intelligent & Fuzzy Systems 35, no. 6 (2018): 6353-6365.
  33. Karas ¸an, Ali, and Cengiz Kahraman. "A novel interval-valued neutrosophic EDAS method: prioritization of the United Nations national sustainable development goals." Soft Computing 22 (2018): 4891-4906.
  34. Zhan, Jianming, Haibo Jiang, and Yiyu Yao. "Covering-based variable precision fuzzy rough sets with PROMETHEE-EDAS methods." Information Sciences 538 (2020): 314-336.
  35. Li, Ying-ying, Jian-qiang Wang, and Tie-li Wang. "A linguistic neutrosophic multi-criteria group decision-making Chinnasami Sivaji et al. / Aeronautical and Aerospace Engineering, 3(1), March 2025, 12-19 approach with EDAS method." Arabian Journal for Science & Engineering (Springer Science & Business Media BV) 44, no. 3 (2019).
  36. Sundram, Dr Suja, and Dr P. Kavitha. "A Review On Customer Service Quality in Big Bazaar Tirupur." Int. J. of Aquatic Science 12, no. 3 (2021): 1867-1876.
  37. Chinnasami Sivaji, Vidhya Prasanth, M. Ramachandran, Chandrasekar Raja, "Applications of the MOORA method for Manufacturing Environment", Journal on Electronic and Automation Engineering, 3(4), December 2024, 1-10.
  38. Somesh Nagalla, Deepak Das, Nihari Paladugu, Exploring Optimization Techniques Applications in Metal Cutting, Food Chemistry, and Embedded Systems, REST Journal on Advances in Mechanical Engineering, 3(2), June 2024, 15-21.
  39. Wei, Guiwu, Cun Wei, and Yanfeng Guo. "EDAS method for probabilistic linguistic multiple attribute group decision making and their application to green supplier selection." Soft Computing 25, no. 14 (2021): 9045-9053.
  40. Feng, Xiangqian, Cuiping Wei, and Qi Liu. "EDAS method for extended hesitant fuzzy linguistic multi-criteria decision making." International Journal of Fuzzy Systems 20 (2018): 2470-2483.
  41. Taderera, Faustino, Said Al-Nabhani, Vibha Bhandari, Paul Sundar Kirubakaran, Hanan Hamood Abdullah Al Rahbi, Godwell Karedza, Mike Sikwila, and Suja Sundaram. "Marketing excellence: myth or reality in oman." International Journal of Arts & Sciences 7, no. 04 (2014): 195-206.
  42. Somesh Nagalla, Nihari Paladugu, Deepak Das, Optimization of Bio-based Polymer Composites Using Grey Relational Analysis (GRA) Method, REST Journal on Advances in Mechanical Engineering, 3(3), September 2024, 19-31.
  43. Yanmaz, Ozgur, Yakup Turgut, Emine Nisa Can, and Cengiz Kahraman. "Interval-valued Pythagorean fuzzy EDAS method: An application to car selection problem." Journal of Intelligent & Fuzzy Systems 38, no. 4 (2020): 4061-4077.

Related papers

A methodology for the selection of manufacturing processes based on the design of the Manufacturing Matrix
Nattapong Kongprasert

This study proposes a decision method to help designers and engineers select the manufacturing process that meet the production performances, including environmental impacts. It has intended to make a decision on manufacturing parameters such as quality, time, cost and environmental impact. The methodology is structured and supported by a matrix called the manufacturing matrix. It is used to evaluate the relationships between the manufacturing process of each product attribute and the process parameters. The method is in 4 steps: create the manufacturing matrix, generate the solutions, evaluate the solutions and select the manufacturing process. The methodology is applied on an industrial case study in the leather good industry. It is able to help practically designers and engineers select the suitable manufacturing process.

View PDFchevron_right
SINGLE OBJECTIVE CRITERIA FOR SELECTION OF MANUFACTURING METHOD
Poornima G Naik

In order to improve the manufacturing cycle more than 110 manufacturing processes have been proposed. The objectives aimed at and the functions focused on by these processes vary. The process should be able to meet daily production requirement, which at the same time should utilize full capacity of the machine and its tooling and should reduce to a minimum idle operator and idle machine time and must provide the maximum utilization of minimum amount of material. The process should be flexible enough to accommodate reasonable changes in design. This poses a great challenge to a manager in selection of effective and economical manufacturing process. Different organizations have different objectives and based on their specific requirement they deploy suitable process conforming to their objective. Based on their needs, the weights assigned to the objectives vary. Today’s business scenario is highly competitive, complex and dynamic in nature which demands strategic planning meeting the challenges of changing time. In this paper we have made an attempt to enable the end user a quick selection of appropriate manufacturing method based on a single objective. A tool is developed for the purpose which provides two different types of interfaces to an end user. One interface is GUI based which is user friendly and provides a simple drag and drop operation for the selection of manufacturing methods based on a single objective and a method classification. The second method is command - line interface enabling the end user to query the database using Manufacturing Query Language (MQL) designed by us. Parse tree is developed and text parsing is used for parsing the query. The query language is designed for the manufacturing domain and renders the end user free from the intricacies involved in SQL syntax involving filtering, joins etc. MQL currently comprises of few commands which can be queried by the end user for the selection of manufacturing methods based on a single objective and a method classification. It is subject to future enhancements. Our current work focuses on a single objective. It is an idealistic scenario where a single objective defines the selection of manufacturing method. In realsituations multi objective criteria is required for the purpose. Nevertheless this is our first attempt towards development of such tool and our future work involves modification of the tool and parser to take account of multiple objectives and functions

View PDFchevron_right
Non-conventional Manufacturing using the EDAS Method
Chinnasami S, Ramya Sharma

REST Publisher, 2024

A process that uses mechanical energy is conventional machining. Alternative energy sources are used by unconventional machines. In non-conventional machining, the three main types of energy are thermal, chemical, and electrical. non-standard machining, also referred to as modern machining, is a machining technique that removes, deforms, and modifies the properties of materials such as plates by utilizing electricity, energy types include electromagnetic energy, bio fuels, acoustic energy, electrochemical energy, and thermal energy. Tools and work pieces are in direct touch during conventional machining procedures. The tool and indeed the work piece do not have to come into physical contact for non-traditional machining procedures to work. The distinctions between conventional and non-conventional machining processes are examined in this article. The lead phase is typically coated using a paste made from a combination of lead & lead oxide powder, additives, and the necessary amount of acid and water after the sulphated mixture has been reduced to a fine lead mass to achieve the requisite density. On the other hand, non-conventional machining uses the most recent and cutting-edge processing technologies. No materials or machine tools come into contact with each other throughout this operation. Electric beam, electric arc, plasma cutting, and infrared beam are a few examples of non-conventional tools in use. Complex forms can be machined using those atypical machining techniques, in part due to the utilisation of cutting-edge CNC technology. The usage of these procedures is frequently determined by the material's shear strength, for instance, when wear resistant alloys and special combinations are involved. In order to create complicated and exact shapes in materials like titanium, stainless steel, hightemperature short (HSTR) alloys, jute composites, ceramics, refractories, and other hard materials, nontraditional machining (NTM) procedures are now often used. The goal of the current investigation using mechanical composites is to ascertain its effect. Brazilian consumers' food purchase intentions are influenced by a variety of manufacturing techniques, brands, prices, and labels. high-grade vegetable oils. Solvents, which may be hazardous, are used in conventional manufacturing processes. The environment suffers as a result. Change Manufacturing procedures, which don't require solvent use might necessitate the use of cutting-edge technologies like plant genetic engineering. looking into the use of genetic modification utilised in food production has a greater potential for reducing environmental effect. The EDAS score primarily based on the space from the suggest agreement machine is the installed energy for a manufacturing plant. Experts' critiques and derived numbers do not trust each different concerning solar energy and geothermal electricity.

View PDFchevron_right
Single Objective Single Function Criteria for Selection of Manufacturing Method
Poornima G Naik

n order to improve the manufacturing cycle more than 110 manufacturing processes have been proposed. The objectives aimed at and the functions focused on by these processes vary. The process should be flexible enough to accommodate reasonable changes in design. This poses a great challenge to a manager in selection of effective and economical manufacturing process. Different organizations have different objectives and based on their specific requirement they deploy suitable process conforming to their objective. Based on their needs, the weights assigned to the objectives vary. Today’s business scenario is highly competitive, complex and dynamic in nature which demands strategic planning meeting the challenges of changing time. In this paper we have made an attempt to enable the end user a quick selection of appropriate manufacturing method based on a single objective and a single function. This is the extension of our earlier work focusing on a single objective. For this purpose a tool is developed which provides two different types of interfaces to an end user. One interface is GUI based which is user friendly and provides a simple drag and drop operation for the selection of manufacturing methods based on a single objective , function and a method classification. The second method is command - line interface enabling the end user to query the database using Manufacturing Query Language (MQL) designed by us. Parse tree is developed and text parsing is used for parsing the query. The query language is designed for the manufacturing domain and renders the end user free from the intricacies involved in SQL syntax involving filtering, joins etc. MQL currently comprises of few commands which can be queried by the end user for the selection of manufacturing methods based on a single objective, a single function and a method classification. It is subject to future enhancements. Our current work focuses on a single objective and single function. It is an idealistic scenario where a single objective and function define the section of manufacturing method. In real situations multi objective and multi function criteria is required for the purpose. Our future work involves modification of the tool and parser to take account of multiple objectives and functions

View PDFchevron_right
Multi Objective Criteria for Selection of Manufacturing Method
Poornima G Naik

Based on the objectives aimed at and the functions focused on by the process , more than 100 manufacturing processes have been proposed in order to improve the manufacturing cycle. The process should be able to meet daily production requirement, which at the same time should utilize full capacity of the machine and its tooling and should r educe to a minimum idle machine time, operator time , WIP and lead time and must provide the maximum utilization of minimum amount of material. In view of highly competitive, complex and dynamic nature of business, demanding a strategic planning to meet the challenges of changing time, there lies a great challenge in front of manager to select an effective and economical manufacturing process. The process should be flexible enough to accommodate reasonable changes in design . Different organizations have different objectives which are weighted differently based on their priorities. Based on the weights assigned to different objectives suitable processes are deployed conforming to the objectives. In this paper we have made an attempt to enable the end user a quick selection of appropriate manufacturing method based on multiple objectives weighted differently . A tool is developed for the purpose which provides two different types of interfaces to an end user. One interface is GUI based which is user friendly and provides a simple drag and drop operation for the selection of manufacturing method based on multiple objectives. The second method is command - line interface enabling the end user to query the database using human like query language termed as Manufacturing Query Language (MQL) designed by us. In most of the organizations data is stored in a persistent storage medium such as database which demands the knowledge of ‘Structured Query Language’ (SQL) for information retrieval, which involves complex constructs for sorting, filtering and joining data from multiple tables. This poses a great challenge to the manager for extracting useful information from the database . To address this issue, we have developed a grammar for human interface to database which involves execution of human like queries for information retrieval from the database based on multiple objectives. Human like queries can be constructed based on this grammar which is parsed using finite state automata. The state table and state graphs are developed for different queries. State information is stored in a database as a measure towards improving efficiency. These queries in turn are evaluated by mapping to the corresponding SQL commands internally. Hence human like query is a layer on top of SQL to render the end user free from intricacies involved in SQL.

View PDFchevron_right
580 California St., Suite 400
San Francisco, CA, 94104
© 2025 Academia. All rights reserved