• Title/Summary/Keyword: Automatic Warehouse

Search Result 37, Processing Time 0.022 seconds

Materialized View Selection Algorithm using Clustering Technique in Data Warehouse (데이터 웨어하우스에서 클러스터링 기법을 이용한 실체화 뷰 선택 알고리즘)

  • Yang, Jin-Hyuk;Chung, In-Jeong
    • Proceedings of the Korea Information Processing Society Conference
    • /
    • 2000.04a
    • /
    • pp.28-35
    • /
    • 2000
  • In order to acquire the precise and fast response for an analytical query, proper selection of the views to materialize in data warehouse is very crucial. In traditional algorithms, the whole relation is considered to be selected as materialized views. However, materializing the whole relation rather than a part of relation results in much worse performance in terms of time and space cost. Therefore, we present a new algorithm for selection of views to materialize using clustering method in order to improve the performance of data warehouse including this problem. In the presented algorithm, ASVMR(Algorithm for Selection of Views to Materialize using Reduced table), we first generate reduced tables in data warehouse using automatic clustering based on attribute-values density, then we consider the combination of reduced tables as materialized views instead of the combination of the original base relations. We also show the experimental results in which both time and space cost are approximately 1.8 times better than the conventional algorithms.

  • PDF

Development of RFID based Automatic Warehouse System Using PDA (PDA를 이용한 RFID 기반 자동 창고 시스템 개발)

  • Hwang, Du-Gwan;Kim, Seong-Ho
    • Proceedings of the Korean Institute of Intelligent Systems Conference
    • /
    • 2007.11a
    • /
    • pp.316-319
    • /
    • 2007
  • 복잡해지는 비즈니스로 인해 생산에 필요한 직접비용보다 유통${\cdot}$물류 등의 간접비용의 부담이 점차 증가추세를 보이고 있으며 그로 인해 기업의 부담이 커지고 있다. 최근 기존 마그네틱테이프나 바코드 등이 갖고 있는 구조적, 기능적 한계를 극복할 수 있는 새로운 수단으로 RFID(Radio Frequency Identification) 기술이 각광받고 있다. 이에 본 연구에서는 유통 및 물류 분야에서 각광받고 있는 RFID 기술을 물류 창고의 최적관리에 적용하여 봄으로써 이의 활용가능성에 대해 고찰하고자 한다.

  • PDF

Automatic Distribution System using a Micro Controller Unit (MCU를 이용한 자동 분류 시스템)

  • Kim, Tae-Hyoung;Lee, Chan-Jae;Kwon, Jae-Hyoung;Kim, Young-Seong;Kim, Yik-Hyoun;Tak, Bo-Mi;Soh, Dea-Wha
    • Journal of the Speleological Society of Korea
    • /
    • no.81
    • /
    • pp.35-41
    • /
    • 2007
  • According as the industry develops recently, the import and export freight amount is increasing sharply, but physical distribution processing equipment ability had achieved conveyance, surge and setup of physical distribution by human's labor ability. But, inefficiency is indicated in operation of product line and warehouse or physical distribution storage equipment because is ceilinged the processing physical distribution amount and the efficiency in physical distribution processing by these labor ability.

Smart Warehouse Management System Utilizing IoT-based Autonomous Mobile Robot for SME Manufacturing Factory (중소제조기업을 위한 IoT기반의 자율이동모듈을 활용한 스마트 창고관리 시스템 개발)

  • Kim, Jeong-A;Jeong, Jongpil
    • The Journal of the Institute of Internet, Broadcasting and Communication
    • /
    • v.18 no.5
    • /
    • pp.237-244
    • /
    • 2018
  • The Smart Factory level of manufacturing factories of SMEs now lacks a system for grasping the accurate inventory amount associated with inventory movements in managing warehouses at the basic level. Also, it is difficult to manage accurate materials for loss of data due to worker manual work and production method due to experience. In order to solve this problem, in this paper, automatic acquisition of inventory to minimize manual work to grasp workers' Inventory and improve automation is done. In the smart warehouse management system using the IoT-based autonomous mobile module, the autonomous mobile module acquires the data of the inventory storage while moving through the line. In order to grasp the material of the Inventory storage, The Camera module recognizes the name of the inventory storage. And Then, If output matches, the data measured by the sensor is transferred to the server. This data can be processed, saved in a database, and real-time inventory quantity and location can be grasped in a web-based monitoring environment for administrators. The Real-time Automatic Inventory (RAIC) systems is reduce manual tasks and expect the effects of automated inventory management systems.

Materialized View Selection Algorithm using Clustering Technique in Data Warehouse (데이터 웨어하우스에서 클러스터링 기법을 이용한 실체화 뷰 선택 알고리즘)

  • Yang, Jin-Hyuk;Chung, In-Jeong
    • The Transactions of the Korea Information Processing Society
    • /
    • v.7 no.8
    • /
    • pp.2273-2286
    • /
    • 2000
  • In order to acquire the precise and fast response for an analytical query, proper selection of the views to materialize in data warehouse is very crucial. In traditional view selection algorithms, the whole relations are considered to be selected as materialized views. However, materializing the whole relations rather than a part of relations results in much worse performance in terms of time and space cost. Therefore, we present an improved algorithm for selection of views to materialize using clustering method to overcome the problem resulted from conventional view selection algorithms. In the presented algorithm, ASVMRT(Algorithm for Selection of Views to daterialize using Iteduced Table). we first generate reduced tables in clata warehouse using automatic clustering based on attrihute-values density, then we consider the combination of reduced tables as materialized views instead of the combination of the original hase relations. For the justification of the proposecl algorithm. we show the experimental results in which both time and space cost are approximately 1.8 times better than the conventional algorithms.

  • PDF

Development of Inventory Control System for Large-scale Retailers using Neural Network and (s*,S*) Policy (신경회로망과 (s*,S*) 정책을 이용한 대규모 유통업을 위한 재고 관리 시스템의 개발)

  • 김우주
    • The Journal of Information Systems
    • /
    • v.6 no.1
    • /
    • pp.223-256
    • /
    • 1997
  • Since the business scales of retailing companies become to be very large and the number of items dealt increases explosively, automation of inventory management becomes one of the most important issues to solve in retailing industry. In order to accomplish this automation of inventory management, there must be a great need to a method which can perform real-time decision making on inventory control in an automatic fashion, while communicating with inventory information systems like POS system and automatic warehousing system. But even in this circumstance, there are also many obstructions to such automation like varying demands, limited capacity of warehouse and exhibition room, need for strategic consideration on inventory control, etc., in a real sense. Due to these reasons, it seems very difficult that most large-scaled retailing companies get fully automated inventory management system. To overcome those difficulties and reflect them into inventory control, we propose a automated inventory control methodology for retailing industry based on neural network and policy model. Especially, policy model is devised to deal with dynamic varying demands and using this model, strategic goals on inventory can be considered into inventory control mechanism. Our proposed approach is implemented in workstation and its performance is also empirically verified also against to real case of one of the major retailing firm in Korea.

  • PDF

Development of Remote Control and Management System for Dried Mushroom Grader via Internet (인터넷을 이용한 건표고 등급선별장치의 원격제어 및 관리 시스템 개발)

  • Choi, T. H.;Hwang, H.
    • Journal of Biosystems Engineering
    • /
    • v.24 no.3
    • /
    • pp.267-274
    • /
    • 1999
  • An internet and network based software and related interface have been developed, which can remotely control and manage an on-site operating system. Developed software modules were composed of two parts: monitoring/management modules and control/diagnosis modules were developed for the network status, warehouse, production and selling status. Modules of control with diagnosis were developed for the on-site operating system and interface. Each module was integrated and the whole modules have been tested with an automatic mushroom grading/sorting system which was built in a laboratory. Developed software modules worked successfully without any uncommon situations such as system down caused by the software or data transfer error. Each software module was developed independently in order to apply easily to other existing on-site systems such as rice processing centers, fruit and vegetable sorting, packaging and distribution centers scattered over the country.

  • PDF

Development of a Grain Drying and Storage System for Bulk Facilities of Grain Custody Warehouse -Square Silo System- (곡물보관창고의 산물시설화를 위한 곡물 건조저장시설의 개발 -사각 사일로 시스템-)

  • 정종훈;유수남
    • Journal of Biosystems Engineering
    • /
    • v.20 no.2
    • /
    • pp.151-161
    • /
    • 1995
  • A basic proposal on the design of a grain drying and storage system was suggested for the bulk facilities of grain custody warehouses. A model square silo system was designed and developed on the basis of the proposal. A square silo system made of steel plate was developed with a stirring device, an automatic moisture meter and an auto-control system of PLC. Then, the developed square silo system was evaluated through drying experiments with rough rice. The square silo system could dry grains uniformly with a stirring device and an auto-control system regardless of grain depth. The developed square silo system can be well adapted for the bulk facilities of grain custody warehouses.

  • PDF

A Modeling Process for Generating RFID Business Event and Warehouse Management System (RFID 비즈니스 이벤트 생성을 위한 모델링 프로세스 및 창고관리 시스템의 응용)

  • Jung Min-Sun;Moon Mi-Kyeong;Yeom Keun-Hyuk
    • Proceedings of the Korean Information Science Society Conference
    • /
    • 2006.06c
    • /
    • pp.205-207
    • /
    • 2006
  • 유비쿼터스 컴퓨팅 환경의 실현 가능성이 높아지면서 Automatic identification and Data Capture(AIDC)에 대한 많은 연구들이 이루어지고 있다. AIDC 기술 중 하나인 Radio Frequency IDentification(RFID)는 라디오 주파수에 따라 반응하는 태그를 이용하여 사람이나 사물을 인식하는 기술이다. 또한 RFID 특성을 지원하면서 발생 이벤트를 효율적으로 처리하기 위해 다양한 미들웨어가 개발되고 있다. 그러나 미들웨어의 지원에도 불구하고 RFID 시스템 개발자는 많은 부가적 지식을 알아야만 한다. 이 점을 해결하여 RFID 기술을 편리하게 사용하도록 돕는 Business Aware Framework(BizAF)이 제시되었다. 본 논문에서는 BizAF를 기반으로 여러 애플리케이션을 개발한 경험을 바탕으로 RFID 비즈니스 이벤트들을 생성하기 위한 모델링 프로세스를 제시하고자 한다.

  • PDF

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

  • Kim, Jong-Jun;Lee, Yun-Sig;Shin, Sang-Ryong;Lee, Ho-Taek;Jo, Dae-Ha
    • Proceedings of the KSME Conference
    • /
    • 2001.06b
    • /
    • pp.436-441
    • /
    • 2001
  • In this paper, stacker crane is modeled as rigid elements and discrete flexible beam connections by kinematics & dynamics solver package program instead of deriving the equations of motion which describes the total dynamics of the system. For the simulation of structural dynamics, ADAMS, a software for the simulation of multiple rigid body dynamics, is used. Some kinds of works are fulfilled to examine the dynamic characteristics of system. In order to verify the analysis method, the results of simulation and experiment are compared.

  • PDF