• Journal of the Korean Society of Manufacturing Technology Engineers
• /
• v.23 no.5
• /
• pp.505-511
• /
• 2014

The functional role of warehouses in modern industry is changing from an established concept of storage to a concept of circulation. The target of this study is to improve the stacker crane's efficiency for the internal operations of the Automated Storage and Retrieval System (AS/RS). Eight operating schemes are proposed under the combination of three conditions, namely, the storing method, the layout type, and the sequence of command execution. The moving distance of the stacker crane is calculated using the same gateway data through a simulation based on a C# program. The optimal operating scheme is proposed based on the analyzed simulation results. In conclusion, the combination of conditions of random storage, two-way type warehouse, and dual command execution elicits optimum results in travel efficiency for the stacker crane.

• Journal of the Korea Safety Management & Science
• /
• v.4 no.4
• /
• pp.73-85
• /
• 2002

The supply chain not only includes the manufacturer and suppliers, but also transporters, warehouses, retailers, and customers themselves. Within each organization, such as manufacturer, the supply chain includes all functions involved in filling a customer request. these functions include, but are not limited to, new product development, marketing, operation, distribution, finance, and customer service. Lean Supply chain coordination improves if all supplier of chain take actions that together increase total supply chain profits. To design of Modularity by the grouping supplier, the proposed method is to develop the most appropriate production system models in the Supply Chain Management which is necessity of the times and its importance. The objects of this study is development of model and cost analysis to the modular production system in Lean SCM. Introduction of modular production system in Lean SCM is effective in reducing the cost in processing, manufacturing, inventory holding, ordering, etc.

• Journal of Korea Port Economic Association
• /
• v.21 no.1
• /
• pp.73-91
• /
• 2005

The goal of the project on developing Korea as the logistics hub of Northeast Asia is to develop Busan Port and Gwangyang Port as international logistics centers by promoting and attracting more warehouses. As is well known, there is intense competition among ports located in major economic blocs to become the regional logistics hub. Gwangyang is second to none in terms of being favorably located at the center of Northeast Asia. Gwangyang Port, however, lacked in SOC construction and faced the poor government support politics hub of Northeast Asia. They are i) expanding the logistics infrastructuressuch as expressway and railroads between Yeosu Airport and Gwangyang Port, ii) Setting up new port hinterland and industrial complex in the vicinity of Gwangyang Port iii) securing high value-added fixed cargo traffic, and iv) improving laws and institutions.

• International Journal of Reliability and Applications
• /
• v.3 no.4
• /
• pp.155-164
• /
• 2002

This paper focuses on how modem data mining can be integrated with real-time relational databases and commercial data warehouses to improve reliability in real-time. An important Issue for many manufacturers is the development of relational databases that link key product attributes with real-time process parameters. Helpful data for key product attributes in manufacturing may be derived from destructive reliability testing. Destructive samples are taken at periodic time intervals during manufacturing, which might create a long time-gap between key product attributes and real-time process data. A case study is briefly summarized for the medium density fiberboard (MDF) industry. MDF is a wood composite that is used extensively by the home building and furniture manufacturing industries around the world. The cost of unacceptable MDF was as large as 5% to 10% of total manufacturing costs. Prevention can result In millions of US dollars saved by using better Information systems.

• Journal of Korean Society of Industrial and Systems Engineering
• /
• v.20 no.43
• /
• pp.25-36
• /
• 1997

The purpose of this paper is to structure a new integrated model that can minimize the total cost for the transportation and inventory systems between m origin points, where origin i has a supply of a commodity, such as distribution centers or warehouses, and n destination points, where destination j requires the commodity. In this case, demands of the destination points are assumed random variables which have a known probability distribution. We will find optimal distribution centers which transport the commodity to the destination points and suggest optimal inventory policy to the selected distribution center which find the optimal pair $$ and safety stock level that minimize total cost with back-ordered case. This new model is formulated as a 0-1 nonlinear integer programming problem. To solve the problem, this paper proposes heuristic computational procedures and program and provides numerical examples.

• Proceedings of the Korean Information Science Society Conference
• /
• 2005.07b
• /
• pp.214-216
• /
• 2005

데이터 웨어하우스에서는 데이터를 다양한 관점으로 분석하기 위해 데이터를 다차원 형태로 유지한다. 이 다차원 데이터를 간단하고 편리한 형태로 사용자에게 표현하기 위해 피벗 테이블이 이용된다. 피벗 테이블은 데이터에 대한 요약된 정보를 제공하는데 널리 사용되는 편리한 표현 방법이지만, 실제 값이 열의 제목으로 나오기 때문에 많은 개수의 열을 가질 수 있다. 이러한 피벗 테이블을 그대로 저장할 경우 관계 DBMS의 테이블 컬럼 수에 제약을 받게 되며, 데이터 저장 및 질의 처리에 성능이 떨어질 수 있다. 이 논문은 관계 데이터베이스의 테이블을 이용하여 피벗 테이블을 효율적으로 저장하는 방법을 제안한다. 이때, 피벗 테이블에 대한 질의물 저장된 형태의 테이블에 적용 가능하도록 질의를 변환시켜야 한다. 따라서 이 연구에서는 피벗 테이블에 대한 관계 연산자들(실렉션, 프로젝션, 합집합, 차집합 카디션 곱)을 효율적으로 변환하는 질의 변환 방범을 제안한다.

• IE interfaces
• /
• v.19 no.4
• /
• pp.291-299
• /
• 2006

In order to enhance sustainable war fighting capabilities, it is important to maintain a good ammunition support system. In this paper, we evaluate the performance of ammunition companies using Imprecise Data Envelopment Analysis (IDEA)-BCC and IDEA-Additive model, which can deal with imprecise data in DEA. The input variables of IDEA models were selected by stepwise multiple regression analysis. With the regression model, we could choose the number of soldiers, officers, and ammunition warehouses as input variables that have significant effects on the output performance. Then, we applied the IDEA-BCC model with the concept of potential efficiency. The results of the model indicate that 8 out of 16 ammunition companies are efficient, 7 are inefficient, and 1 is potentially efficient. We could also identify the possible input excesses and output shortfalls to reach the efficient frontier using the IDEA-Additive model.

• Proceedings of the Korean Information Science Society Conference
• /
• 1999.10a
• /
• pp.281-283
• /
• 1999

본 논문에서는 객체-관계형 데이터베이스 관리 시스템(Object-Relational DBMS: ORDBMS) 기반의 데이터 웨어하우스(Data Warehouse)에서 성능 향상을 위한 인덱싱 기법과 이를 이용한 질의 처리 기법을 제안한다. 지금까지 관계형 DBMS를 기반으로 한 데이터 웨어하우스의 성능향상에 관한 연구는 활발히 이루어져 왔으나, ORDBMS에 기반한 데이터 웨어하우스의 구축 및 질의 처리 성능에 관한 연구는 거의 이루어지지 않고 있다. 데이터 웨어하우스는 기존의 데이터베이스와는 비교할 수 없을 만큼의 대용량 데이터를 가정하므로 ORDBMS를 이용하여 데이터 웨어하우스를 구축하는 경우에도 적절한 성능의 보장이 필수적으로 요구된다. 제안된 인덱싱 기법을 사용함으로써 데이터 웨어하우스 분석용 질의에 포함된 비용이 큰 조인과 그루핑 연산은 비용이 저렴한 인덱스 액세스 연산으로 대치되며, 데이터의 량과 거의 무관하게 질의 처리 비용이 고정되는 효과를 얻을 수 있다.

• Proceedings of the Korean Information Science Society Conference
• /
• 2002.10c
• /
• pp.262-264
• /
• 2002

데이터웨어하우스는 대용량의 데이터를 대상으로 복잡한 분석을 수행하거나 전략적 의사 결정을 위해 사용되기 때문에 신속한 질의 응답을 위한 성능 관리가 무엇보다 중요하다. 데이터웨어하우스는 일반 운영계 시스템과는 다른 목적과 특성을 가지기 때문에 그에 적합한 성능 모니터링 방법이 필요하다. 본 연구에서는 오라클 데이터베이스를 위한 OLTP(On-Line Transaction Processing)용 국산 성능 모니터링 도구인 DBMax를 데이터웨어하우스 환경에 적용할 수 있도록 기능을 확장한다. 우선 기존의 운영계 시스템과는 구분되는 데이터웨어하우스의 특성을 토대로 오라클9i에서 제공하고 있는 성능 항상 기법인 실체화된 뷰(MV: Materialized View)와 EH(Data Extraction, Transformation and Loading) 화장 기능을 모니터링하기 위한 요구사항을 분석하고 이를 지원하기 위한 DBMax 확장 방안을 설계 및 구현한다. 실체화된 뷰와 ETL 확장 기능을 위해 제공되는 오라클9i의 다양한 스키마 객체에 대한 정보 및 성능 관련 지표를 제시하여 SQL 튜닝 기능을 지원하며 사후 분석을 위한 DBMax의 로그 파일에서 의미 있는 SQL문을 추출하여 잠재적으로 유용한 실체화된 뷰를 권고할 수 있도록 기능을 확장한다.

• Journal of Institute of Convergence Technology
• /
• v.7 no.2
• /
• pp.21-23
• /
• 2017

Smart Factories could be regarded as a result of the integration of various key technologies of the fourth industrial revolutions. In smart factory, the IoT (Internet of things) is applied to capture the data generated by the production facility, store and analyze data generated in real time using Big Data technology. In addition, 3D printers are used to print expensive and complex parts, industrial robots supply materials and parts to the production site, store finished products in warehouses. In this paper, we introduced the definition of smart factory and change of job market. Also, we summarize several national policies to support enhancing transformation process of smart factory.