• 제목/요약/키워드: Process Warehouse

Search Result 140, Processing Time 0.025 seconds

Design and Implementation of a Data Mining Query Processor (데이터 마이닝 질의 처리를 위한 질의 처리기 설계 및 구현)

  • Kim, Chung-Seok;Kim, Kyung-Chang
    • The KIPS Transactions:PartD
    • /
    • v.8D no.2
    • /
    • pp.117-124
    • /
    • 2001
  • A data mining system includes various data mining functions such as aggregation, association and classification, among others. To express these data mining function, a powerful data mining query language is needed. In addition, a graphic user interface(GUI) based on the data mining query language is needed for users. In addition, processing a data mining query targeted for a data warehouse, which is the appropriate data repository for decision making, is needed. In this paper, we first build a GUI to enable users to easily define data mining queries. We then propose a data mining query processing framework that can be used to process a data mining query targeted for a data warehouse. We also implement a schema generate a data warehouse schema that is needed to build a data warehouse. Lastly, we show the implementation details of a query processor that can process queries that discover association rules.

  • PDF

A Study on Aircraft Part Management using Smart Work (스마트 워크를 이용한 항공기 부품 관리 방안 연구 -항공기 타이어를 중심으로-)

  • Lee, Doo-Yong;Song, Young-Keun;Jang, Jung-Hwan;Lee, Chang-Ho
    • Journal of the Korea Safety Management & Science
    • /
    • v.13 no.3
    • /
    • pp.209-215
    • /
    • 2011
  • Currently, 10% of the domestic aircraft accidents and 9% of delays and cancellations were generated due to poor maintenance. Aircraft maintenance work is divided into works in material warehouse and in hangar. In material warehouse, the problem in aircraft maintenance work is occurred when the serial number of parts are identified and entered. In hangar, work order are duplicatively written. In addition, the maintenance information is not shared and then work order is wrong delivered. In this study, we analyzed the maintenance process and the informations that occurs in the material warehouse and hangar for large airline company to solve the problems. And serial numbers are replaced by QR code. And documented work order and manual are handled using the tablet PC. In conclusion, this paper studied smart work of maintenance process about tire parts. We expect to improve the inefficiency of identification of serial number and total maintenance time is reduced by real-time information sharing.

Simulation-based Design Validation and Alternatives Analysis of Release Process of Logistics Automation Warehouse (시뮬레이션을 활용한 물류 자동화 창고의 출고 프로세스 설계 검증 및 대안 분석)

  • Moon-Gi Jeong;JongPil Kim;JinSung Park;Kyung-Min Seo
    • Journal of the Korea Society for Simulation
    • /
    • v.32 no.3
    • /
    • pp.75-91
    • /
    • 2023
  • As the business-to-customer (B2C) online market expands after the COVID-19 pandemic, the logistics industry has been constructing automated warehouses to handle multi-product, low-volume logistics. When constructing a logistics automation warehouse, it is crucial to validate that the facility's performance and operational logic are designed to meet the required throughput of the automated warehouse from the system design phase. This study proposes simulation-based validation and optimal alternatives for an H logistics automation warehouse in Iksan, Jeollabuk-do. Firstly, we focused on the box supply and packing processes, which are related to the release process, among the entire logistic processes. Then, we analyzed the potential bottlenecks in the target process and designed and implemented a discrete-event simulation model based on the analysis results. The simulation experiments showed that the facility parameters and operational logic identified in the system design phase did not satisfy the performance requirements of the entire automated warehouse. Additional experiments were conducted to suggest alternatives to meet the system performance requirements by changing the facility parameters and operational logic. We expect that the proposed study will be utilized in the future, not only in the system design phase but also in the system construction phase, for verification purposes to ensure that the construction proceeds according to the design.

Integrated Management Data Warehouse Development Process of Research Expenses in Enterprise Environment (엔터프라이즈 환경의 연구비 통합관리 데이터 웨어하우스 개발 프로세스)

  • Choi, Seong-Man;Yoo, Cheol-Jung;Chang, Ok-Bae
    • The KIPS Transactions:PartD
    • /
    • v.11D no.1
    • /
    • pp.183-194
    • /
    • 2004
  • The existing management job of research expenses has been divided into three parts: budget planning, budget draw-up, and exact settlement of budget. However, it caused some problems. Under this current circumstance it is required to obtain research expenses steadily, to operate efficiently and to use them clearly to solve such problems. As a result of a study on data warehouse development process of existing system integration company (Inmon, IBM) to reflect current trend described above, data warehouse development process of Inmon uses systematic and gradual access as a classical development cycle method. It causes overlap and feedback to the previous step in the process of each step Is requested. And another problem that it is difficult to toil what function refers and corrects data because functions and data are separated during performing development process at data warehouse development process of IBM is caused. Integrated management data warehouse development process of research expenses in the enterprise environment which applies UML at planning and analysis step, design step and implement and test step is suggested in this paper. Information retrieval agent uses existing budget plan DB, budget draw-up DB and budget settlement DB to find out information that a user wants to know. Information retrieval agent collects and saves information at integration database and information integration agent extracts, transports, transforms and loads the data. Information integration agent reduces a user's efforts to access to a number of information sources and check each of them. It also screens out data that a user may not need. As a result, integrated management data warehouse development process of research expenses in the enterprise environment reflects a user's requirements as much as possible and provides various types of information to make a decision which is needed to establish the policy of research expense management. It helps an end user approach his/her desired analysis information quickly and get various data from the comprehensive viewpoint rather than the fragmentary viewpoint. Furthermore, as it integrated three systems into one, it is possible to share data, to integrate the system, to reduce operating expenses and to simplify supporting environment for the decision making.

Implementation of Smart Automatic Warehouse to Improve Space Utilization

  • Hwa-La Hur;Yeon-Ho Kuk;Myeong-Chul Park
    • Journal of the Korea Society of Computer and Information
    • /
    • v.28 no.10
    • /
    • pp.171-178
    • /
    • 2023
  • In this paper, we propose a smart automated warehouse to maximize space utilization. Previous elevator-type automatic warehouses were designed with a maximum payload of 100kg on trays, which has the problem of extremely limiting the number of pallets that can be loaded within the space. In this paper, we design a smart warehouse that can maximize space utilization with a maximum vertical stiffness of 300kg. As a result of the performance evaluation of the implemented warehouse, the maximum payload was 500.6kg, which satisfied the original design and requirements, the lifting speed was 0.5m/s, the operating noise of the device was 67.1dB, the receiving and forwarding time of the pallet was 36.92sec, the deflection amount was 4mm, and excellent performance was confirmed in all evaluation items. In addition, the PLC control method, which designs the control UI and control panel separately, was integrated into the PC system to improve interoperability and maintainability with various process management systems. In the future, we plan to develop it into a fully automatic smart warehouse by linking IoT sensor-based logistics robots.

A Study on the Demand Research for Facilities of Logistics from Factor Comparison (요인비교법을 통한 물류시설 수요조사에 관한 연구)

  • Yoon, Tomes;Kim, Tae-Seok;Lee, Geon-Su;Kang, Kyung-Sik
    • Journal of the Korea Safety Management & Science
    • /
    • v.9 no.5
    • /
    • pp.103-110
    • /
    • 2007
  • To build a most efficient and competitive warehouse, need to reflect tenants various opinions in advance such as location, rentable size, leasing terms, rental, configuration of the building, building structure, traffic flow and amenities. Thus a survey for major tenants which are logistics, retailers and manufactures should be done to figure out potential demand and marketing strategy to lead to be a competitive warehouse. However above survey is time consuming work and requires high cost involvement thus to avoid such an inefficient process and to facilitate investors prompt and right decision making, there should be a tool which helps to make a decision process easier with simple key factors. In other word, we have used above mentioned 'Demand Approach' so far but here I am introducing 'Factors Comparison' which reflects location factors and facility factors. I derived Kwang-myung logistics park's proper rental rate through 'Demand Approach' which analyzed Seoul Metropolitan area's rental warehouse status and rents, and also defined a size of potential demand area and rental. And this report compared the result with an outcome of 'Factors Comparison' then compared each methods and drew a conclusion of 'Factors Comparion's better convenience and efficiency.

Dynamic Characteristics Analysis of Stacker Crane for Automatic Warehouse(I) (자동창고용 스태커 크레인의 동특성 해석(I))

  • Shin, Sang-Ryong;Lee, Yun-Sig;Kim, Jong-Jun;Lee, Ho-Taek;Lee, Sang-Hul;Yun, Suk-Ho
    • Proceedings of the KSME Conference
    • /
    • 2001.06b
    • /
    • pp.428-435
    • /
    • 2001
  • In this paper, the design factors of stacker crane for the automatic warehouse are verified by dynamic simulation process. Simulation model is designed as the form of rigid elements and discrete flexible beam connections. The various result for structural design of stacker crane is produced by dynamic simulation and experiment. For the simulation of structural dynamics, ADAMS which is a software for kinematic & dynamic simulation, is used. In order to verify the analysis method, simulation and experiment result are compared.

  • PDF

A Study on the Performance Result of Logistics Task by Accepting Warehouse Management System (물류센터관리시스템 도입에 따른 물류업무의 생산성 향상에 관한 연구)

  • Choi, Hoon-Young;Lim, Man-Ku;Kang, Kyung-Sik
    • Journal of the Korea Safety Management & Science
    • /
    • v.17 no.3
    • /
    • pp.231-237
    • /
    • 2015
  • This treatise is a study on the effectiveness of logistics tasks through the Warehouse Management System. Using manufacturer 'D' company's logistics operation as an example, we compared before and after cases, in which WMS was used. Upon using WMS, we observed the processes and researched how much the logistics company's performance was affected by the process changes influencing profits.

The Revision of Transit Clause in the Institute Cargo Clauses (협회적하약관(ICC)상 운송조항(Transit Clause)의 변천과정에 관한 연구)

  • Lee, Jay-Bok
    • THE INTERNATIONAL COMMERCE & LAW REVIEW
    • /
    • v.43
    • /
    • pp.337-370
    • /
    • 2009
  • The Joint Cargo Committee of International Underwriting Association of London (IUA) and Lloyd’s Market Association (LMA) have issued the revised version of Institute Cargo Clauses A, B, C, Institute Cargo Clauses (Air) and their accompanying War and Strikes Clauses. The Institute Cargo Clauses ("ICC") were last revised in 1982. Following a two year long consultation process, the latest edition of the ICC clauses became available to the Market on 1st January 2009. The overall result of the amendments to the 1982 ICC has been to create clearer policies that are more favourable to the Assured. Exclusions have also been amended to the advantage of the assured. The Transit Clause has seen a large revision, again more favourable to the Assured. The insurance now attaches within the warehouse or place of storage when the goods are "first moved$\cdots$ for the purpose of the immediate loading into or onto the carrying vehicle or other conveyance for the commencement of transit" whereas previously the insurance would not attach until the goods left the warehouse. Furthermore, the insurance now terminates on completion of unloading from the vessel at (rather than delivery to) the final warehouse or at a warehouse prior to the destination named in the contract of insurance which the Assured or their employees elect to use either for storage or distribution.

  • PDF

A Study on the Reasonable Materials Handling System of Wooden Furniture Industries (목재가구산업의 적정 물류운반시스템에 관한 연구)

  • Chung, Woo-Yang
    • Journal of the Korean Wood Science and Technology
    • /
    • v.24 no.2
    • /
    • pp.71-80
    • /
    • 1996
  • Handling the manufacured goods is the most cost-consuming task in material handling system in wooden furniture industries. Fully automated warehouse for cartoned goods of a furniture manufacturing company was analized to provide plant engineers and managers with some important informations on the utility and profitability of the automated storage and retrieval system(AS/RS). Process-oriented simulation modeling tech-niques were used to describe the system and to propose some alternatives to promote the efficiency of AS/RS. Simulation report could be inter-preted as follows: 1. Warehouse for the furniture goods must be designed in accordance with reliable material handling program and constructed with suitable equipments depending on the specification of packed products. 2. An excess of palletized products induced the indigestion and the inefficiency of AS/RS of the furniture industry and put this high-costly system into the shade. 3. Overcrowded AS/RS of the furniture factories could regain its material handling function by cutting down the deposit of products into the automated warehouse. For this purpose, reducing the regular output and direct delivering the outside products to the destination should be considered as the definite counterplan. And additional operation of conventional handy warehouse was also expected to improve the efficiency of main AS/RS.

  • PDF