• Journal of Korea Spatial Information System Society
• /
• v.7 no.3 s.15
• /
• pp.119-130
• /
• 2005

A spatial data warehouse is a system that stores geographical information as a subject oriented, integrated, time-variant, non-volatile collection for efficiently supporting decision. This system consists of a builder and a spatial data warehouse server. A spatial data warehouse server suspends user services, stores transferred data in the data repository and constructs index using stored data for short response time. Existing methods that construct index are bulk-insertion and index transfer methods. The Bulk-insertion method has high clustering cost for constructing index and searching cost. The Index transfer method has improper for the index reconstruction method of a spatial data warehouse where periodic source data are inserted. In this paper, the efficient index reconstruction method using a partial index in a spatial data warehouse is proposed. This method is an efficient reconstruction method that transfers a partial index and stores a partial index with expecting physical location. This method clusters a spatial data making it suitable to construct index and change treated clusters to a partial index and transfers pages that store a partial index. A spatial data warehouse server reserves sequent physical space of a disk and stores a partial index in the reserved space. Through inserting a partial index into constructed index in a spatial data warehouse server, searching, splitting, remodifing costs are reduced to the minimum.

• IE interfaces
• /
• v.15 no.2
• /
• pp.159-171
• /
• 2002

Data Warehouses integrate data from multiple heterogeneous information sources and transform them into a multidimensional representation for decision support applications. Data warehousing has emerged as one of the most powerful tools in delivering information to users. Most previous researches have focused on marketing, customer service, financing, and insurance industry. Further, relatively less research has been done on data warehouse systems in the complex manufacturing industry such as ship production, which is characterized complex product structures and production processes. In the ship production, data warehouse systems is a requisite for effective cost analysis because collecting and analysis of diverse and large of cost-related(material/production cost, productivity) data in its operational systems, was becoming increasingly cumbersome and time consuming. This paper proposes architecture of the data warehouse systems to support cost analysis in the ship production. Also, in order to illustrate the usefulness of the proposed architecture, the prototype system is designed and implemented with the object of the enterprise of producing a large-scale ship.

• The Journal of the Korea institute of electronic communication sciences
• /
• v.8 no.12
• /
• pp.1803-1810
• /
• 2013

In a warehouse, because there exist frequent changes of stock status and the quality of some contents are influenced by the environment such as temperature, fast and accurate management of the warehouse's environment is very important for Warehouse Management Systems. However, due to the absence of a unified standard for the communication protocol between RFID nodes and centralized MAC schemes for RFID communications in previous studies have severe problems. Therefore, in this paper, we propose a WiMedia MAC based RFID cooperative relay transmission scheme for warehouse management system applications.

• Journal of Korean Society of Industrial and Systems Engineering
• /
• v.34 no.1
• /
• pp.1-8
• /
• 2011

Controlling industrial vehicle operated by human in warehouse was not simple since the information transfer for controlling the vehicle was not easy. However, as the technology for the WMS (Warehouse Management System) has been advanced and the PDA (Personal Digital Assistant) has come into wide use in a workplace, the control of man-operated vehicle became less difficult as do to AGVS (Automated Guided Vehicle System). This study examines the ways to improve the efficiency of warehouse operation through introducing rule of task assignment for the vehicles, particularly forklift. This study, basically, refer to AGV operation policy because a great number of studies for AGV dispatching rule have been done and the mechanism for the controlling vehicles is very similar. The workers in field prefer to simple dispatching rules such as Shortest Retrieval Time First (SRTF), Shortest Travel Time First (STTF), and Longest Waiting Time First (LWTF). However, these rules have potential disadvantage. Thus, several rules made up by combining rules mentioned above are introduced and these new rules use threshold value or evaluation formula. The effectiveness of these new rules are tested by simulation and the results are compared. This study proposes favorable dispatching rules for forklift in warehouse for the efficiency of the vehicle operation and stability of service level.

• THE INTERNATIONAL COMMERCE & LAW REVIEW
• /
• v.59
• /
• pp.81-112
• /
• 2013

This article intends to examine main features of revision in relation to the duration of cover in the Institute Cargo Clauses 2009 and the results of analysis are as followings. First, the cover, which had been "warehouse to warehouse", has been extended to what may be called "shelf to unloading". Thus the insurance attaches when the goods are first moved within the warehouse or place of storage at the named place for the purpose of immediate loading for the commencement of transit. Secondly, the new termination Clause 8.1.3 requires an election by the assured, or their employees, to use a vehicle or container, for storage other than in the ordinary course of transit. Thirdly, Clause 10.1, which deals with the assured's voluntary change of voyage, was amended to solve the problem that the words "held covered" could be misunderstood by an assured without specialist knowledge of English marine insurance law to be a guarantee of cover, even where cover would not be commercially available. Finally, Clause 10.2 is designed to solve the so-called "phantom ship problem", arising from the harsh decision in The Prestrioka. The new Clause 10.2 provides protection for an innocent assured in the situation of a phantom ship.

• Journal of applied mathematics & informatics
• /
• v.19 no.1_2
• /
• pp.397-414
• /
• 2005

In the existing literature, most of the purchasing models were developed only for retailers problem ignoring the constraint of storage capacity of retailers shop/showroom. In this paper, we have developed a deterministic model of wholesaler-retailers' problem of single product. The storage capacity of wholesaler's warehouse/showroom and retailers' showroom/shop are assumed to be finite. The items are transported from wholesaler's warehouse to retailers' Own Warehouse (OW) in a lot. The customer's demand is assumed to be displayed inventory level dependent. Demands are met from OW and that spaces of OW will immediately be filled by shifting the same amount from the Rented Warehouse (RW) till the RW is empty. The time duration between selling from OW and filling up its space by new ones from RW is negligible. According to relative size of the retailers' existing (own) warehouse capacity and the demand factors, different scenarios are identified. Our objectives are to optimize the cost functions of wholesaler and two retailers separately. To solve this problem, a real coded Genetic Algorithm (GA) with roulette wheel selection/reproduction, whole arithmetic crossover and non-uniform mutation is developed. Finally a numerical example is presented to illustrate the results for different scenarios. To compare the results of GA, Generalised Reduced Gradient Method has been used for the problem. Also, a sensitivity analysis has been performed to study the variations of the optimal average cost with respect to the different parameters.

• International Commerce and Information Review
• /
• v.7 no.1
• /
• pp.55-74
• /
• 2005

Recently, many enterprises have attempted to construct data warehousing systems for decision-support. Data warehouse is an intelligent store of data that can aggregate vast amounts of information. Building DW requires two important development issues:(i) DW for the decision making of business users and (ii) metadata within it. Most DW development methodologies have not considered metadata development; it is necessary to adopt a DW development methodology which develops a DW and its metadata simultaneously. Metadata is a key to success of data warehousing system and is critical for implementing DW. That is, metadata is crucial documentation for a data warehousing system where users should be empowered to meet their own information needs; users need to know what data exists, what it represents, where it is located, and how to access it. Furthermore, metadata is used for extracting data and managing DW. However, metadata has failed because its management has been segregated from the DW development process. Metadata must be integrated with data warehousing systems. Without metadata, the decision support of DW is under the control of technical users. Therefore, integrating data warehouse with its metadata offers a new opportunity to create a more adaptive information system. Therefore, this paper proposes a DW development methodology from a metadata perspective. The proposed methodology consists of five phases: preparatory, requirement analysis, data warehouse (informational database) development, metastore development, and maintenance. To demonstrate the practical usefulness of the methodology, one case is illustrated

• Journal of the Korean Society of Tobacco Science
• /
• v.24 no.2
• /
• pp.88-93
• /
• 2002

This study was carried out to investigate the changes of chromatic, chemical and organoleptic characteristics of green leaf tobaccos during storage in warehouse. Eight grades(flue-cured ; A2O, B2O, C2L and D2L, burley ; A2T, B2T, C2W and D2W) of green loaves produced in 2001 were stored during 8 months(Oct. 30, 2001 to Jun. 30, 2002) in warehouse of Kimcheon(flue-cured) and Namwon(burley) Leaf Tobacco Processing factory, respectively. Moisture contents of D2L in flue-cured and four grades in burley were significantly decreased during storage in warehouse. Redness(a) values of six grades except for D2L and D2W were significantly increased during storage. Lightness(L), yellow(b) and pH values, and the contents of nicotine, total nitrogen and total sugar were not changed during storage. Irritations of flue-cured tobacco were increased, whereas tastes were decreased during storage. Irritations and tastes of burley tobacco were little changed during storage. The result suggests that the flue-cured green leaf being processed as early as possible for minimizing the deterioration of smoke taste during storage in warehouse.

• Fire Science and Engineering
• /
• v.24 no.4
• /
• pp.47-54
• /
• 2010

This study is analyze the damage of warehouse fire accident be made through the fire characteristic database of combustibles and real scale fire test of warehouse mock-up. Combustibles fire tests are carried out for database using RCT (Room Corner Tester) to predict fire growth the goods. A mockup ($3m{\times}3m{\times}2.4m$) of clothes warehouse was built and real scale fire test by LSC (Large Scale Calorimeter) base on the fire characteristic DB. The mock-up of clothes warehouse is made of two type sandwich panels (Glass wool, EPS foam sandwich panel). As a mock-up test result, test 1 (Glass wool sandwich panel) and test 2 (EPS foam sandwich panel) indicating fire growth such as 5 MW, 11 MW of maximum HRR (Heat Release Rate).

• International Journal of Safety
• /
• v.5 no.2
• /
• pp.29-33
• /
• 2006

A numerical flow analysis of the case of a refrigeration warehouse where an unusual death of an operator occurred by deficiency of oxygen is performed by using STAR-CD program of the computational fluid dynamics (CFD) code. The refrigeration room of the warehouse for storing the fruits maintains an atmosphere of 95% nitrogen and 5% oxygen by volume. When the operator was found dead in the refrigeration room, the room was in normal operating conditions except for the fact that the auxiliary door had been left open. For the flow analysis, unsteady 3-dimensional natural convection with mass transfer is considered. The flow analysis result is compared with the oxygen concentration level measured against time during on-site investigation. The change in oxygen concentration level in the warehouse due to the opening of the auxiliary door is found to be negligible.