• Journal of the Korea Society of Computer and Information
• /
• v.23 no.3
• /
• pp.49-54
• /
• 2018

A data warehouse is a system that collectively manages and integrates data of a company. And provides the basis for decision making for management strategy. Nowadays, analysis data volumes are reaching critical size challenging traditional data ware housing approaches. Current implemented solutions are mainly based on relational database that are no longer adapted to these data volume. NoSQL solutions allow us to consider new approaches for data warehousing, especially from the multidimensional data management point of view. In this paper, we extend the data warehouse design methodology based on relational database using star schema, and have developed a consistent design methodology from information requirement analysis to data warehouse construction for large scale data warehouse construction based on MongoDB, one of NoSQL.

• Journal of the Korea Society for Simulation
• /
• v.22 no.4
• /
• pp.119-128
• /
• 2013

We need to consider a number of technical constraints to build new warehouses. In particular, it is essential to assure that the flow of trucks is smooth and seamless even in large size warehouses. The flow of trucks in warehouses are subject to, for instance, the routes of trucks, the frequency and the time stamps of their in-and-out's. Also, the routes of trucks interfere each other. Thus, finding good flow of trucks in a warehouse is a tough task when all interferences among trucks are considered. In this paper, we find some layouts of the routes of trucks exhibiting good performance based on simulation. we use ARENA ver. 11 for simulation.

• Journal of Biosystems Engineering
• /
• v.5 no.1
• /
• pp.33-42
• /
• 1980

This study was carried out to investigate the actual environmental paddy storage conditions in conventional Korean farm warehouses. The paddy storage conditions by the locations and sizes of warehouses were figured out. The effectiveness of the small insulated box for storing paddy was also examined. Observations were made at sixteen different warehouses located in Moonsan-Myeon, Jinyandg-gun, Gyungnam Province from July lst to September 28 th, the period which was considered to be the worst for storing grains. The results are as follows ; 1. the average temperatures of rough rice and air inside the warehouse were 0.9 and 0.7$^\circ$ higher than the outside air temperature. 2. The average relative humidity in warehouses was 1.5percent higher than that of the atomosphere. This fact resulted in the increased moisture content of grains. Therefore, the ventilation for equalizing the relative humidity of inside and outside of warehouses was required. 3. The dry matter of stored rough rice was decreased by 1.1 percent in average druing the observation period. In order to reduce the dry matter loss, application of new grain storing method ;hermetic storage or filling inert gas storage, was highly recommended. 4. Environmental conditions for storing rough rice in a warehouse located in a sloping site are, in general , better than those of a warehouse located in a flat site. But as far as the dry matter of rough rice was concerned, above situation is not always satisfactory. Because it is fairly frequent to observe the higher rate of moisture absorption by grains stored in a warehouse located in a sloping site. 5. Environmental conditions for storing rough rice in a large-scale warehouse were better than those in a small size warehouse. Therefore, it is advisible for farmers to store their grins in the large-scale warehouses commonly used by villagers. 6. It was undesirable to store rough in a insulated box.

• The KIPS Transactions:PartD
• /
• v.19D no.1
• /
• pp.1-14
• /
• 2012

As the size of the data warehouse is large, the selection of indices on the data warehouse affects the efficiency of the query processing of the data warehouse. Indices induce the lower query processing cost, but they occupy the large storage areas and induce the index maintenance cost which are accompanied by database updates. The bitmap join indices are well applied when we optimize the star join queries which join a fact table and many dimension tables and the selection on dimension tables in data warehouses. Though the bitmap join indices with the binary representations induce the lower storage cost, the task to select the indexing attributes among the huge candidate attributes which are generated is difficult. The processes of index selection are to reduce the number of candidate attributes to be indexed and then select the indexing attributes. In this paper on bitmap join index selection problem we reduce the number of candidate attributes by the data mining techniques. Compared to the existing techniques which reduce the number of candidate attributes by the frequencies of attributes we consider the frequencies of attributes and the size of dimension tables and the size of the tuples of the dimension tables and the page size of disk. We use the mining of the frequent itemsets as mining techniques and reduce the great number of candidate attributes. We make the bitmap join indices which have the least costs and the least storage area adapted to storage constraints by using the cost functions applied to the bitmap join indices of the candidate attributes. We compare the existing techniques and ours and analyze them in order to evaluate the efficiencies of ours.

• Korea Real Estate Review
• /
• v.27 no.1
• /
• pp.45-57
• /
• 2017

In this study, the factors influencing logistics warehouse price were analyzed using Hedonic price model. All the actual transaction cases of the logistics centers in Gyeonggi province for 10 years from 2006 to 2015 were investigated. In this hedonic model, statistically significant variables includes building, economic, investment and time characteristics. The analysis permits a better insight of price determinants of warehouse price. First, the purchase price of large size logistics centers is relatively high. Second, the indirect investment shows higher price due to active investment tendency. Third, Foreign investors with various know-how on investment are leading the selling price.

• Proceedings of the Korean Institute of Interior Design Conference
• /
• 2005.10a
• /
• pp.193-196
• /
• 2005

The value of all goods and services produced in the economy divided by population has risen from $7.355 in 1998 to $12.646 in 2003. In other to maintain higher standard of lifestyle, people are 'hungry' for time. The idea of saving time and money by providing many different types of products altogether in one space was implemented with the advent of large warehouse style discount stores. These type of retailers grew in size and popularity during the 1990s and 2000s, causing a decline in sales in the old, traditional downtown markets. From ancient to twenty-first century, the role of the grocery store has been that of the social center of the community; a place of unity and interaction of people. The experience a customer engages in at a grocery store is comparable to that of a museum. Not only is the grocery store a unique, physical space to visit, but also a rich collection of fascination items. The layout of the interior space is meticulously planned for the efficiency of customer circulation and the success of product exhibition. Eye catching graphics and attractive lighting also add to the appeal of the grocery store's high style. Shoppers are no longer satisfied with just buying good products at a lower price. Shoppers prefer to spend time in an entertaining environment. The Hanaro Mart project in this study propose the idea of warehouse style discount stores which can satisfy all the demands of customers and their various activities. This study will open up unique dimensions of aesthetic expression and experience in the interior environments. Shopping for food is an unavoidable task. If food shopping is enjoyable, more people will spend more time at it.

• Conservation Science in Museum
• /
• v.13
• /
• pp.1-11
• /
• 2012

While the project for registering the unregistered relics that had been stored in the relic storage warehouse was in progress, restoration operations were started for the large size pottery pieces that had been excavated from the Geumgangsa Temple Site and it is attempted to explain the pottery pieces and to introduce the process of the overall conservation treatment. About 600 pieces of large size pottery had been separately stored in more than 40 relic boxes in their original damaged condition without making it possible to figure out their shape, size, usage and quantity at all. Due to the enormous number and weight of the pottery pieces, they were, first of all, pre-classified largely into 6 groups of pottery pieces in consideration of the visible features such as pottery thickness, color sense and glaze brilliance, etc. for each kind of pottery raw material. However, as a result of making them adhere together on a temporary basis, they turned out to be only one piece of pottery in reality. In this restoring process, in order to see if the generally used cyanoacrylate adhesive was in fact safe when a very large, heavy and deformed pottery piece was to be put together, its safeness was checked by examining the adhesion velocity, adhesion strength and dissolution velocity for both from low to high viscosities through preliminary experiments. In order to restore the lost parts after putting the existing pieces together, diversified epoxy resins were used to fit their shapes. Considering that the bottom of the restored relic was shaped to be not flat but round without allowing it to stand alone, an exhibition mount was manufactured so that the relic could be stored stably and used readily for exhibition.

• Journal of the Korea Institute of Information and Communication Engineering
• /
• v.20 no.11
• /
• pp.2033-2038
• /
• 2016

Big data analysis, in the large amount of data stored as the data warehouse which it refers the process of discovering meaningful new correlations, patterns, trends and creating new values. The important issue of a meta-analysis is not the significance test, the effect size of the predictor variable on the criterion variable. We reviewed a total of 236 samples among 6 studies published on the topic related Collagen intake on skin between 2000 and 2016 in Korea. The results of the study are summarized as follows. First, we concluded that the path between before and after of Sebum (SB) had the largest effect size of (r = .416) Therefore, the effect of the Collagen intake intervention showed an explanatory power of 17 (%) about. Next, the path between before and after of Moisture (MS) had the higher the effect size of (r = .318). Thus, we present the theoretical and practical implications of these results.

• Korean Journal of Agricultural Science
• /
• v.17 no.1
• /
• pp.65-75
• /
• 1990

This study is purposed to examine how fanner's living conditions and managements have been improved during the last five years(1985 through 1989) on the basis of the information got from the sample survey of 30 farm households chosen in Galma-ri, Buseok-Myeon, Seosan county, Chungnam province. The followings are major results of the study. (1) There have been much improvement of kitchen facilities and increasing number of cultural goods, but not much in the condition of sanitation facilities. (2) The size of farm warehouse and stall have been greatly enlarged and there has been large variation in the heads of big animals such as cattle during the surveyed period. This may reflect the facts that farm managements become more diversified and commercialized. (3) It is shown that fanners more voluntarily accept new fanning techniques about their concerning crops. Also there have been rapid changes in the pattern of upland cropping system, adjusting to the commercialization of agriculture. (4) Currently, fanners tend to react to the price signal of market system more sensitively than before. Accordingly, agricultural income structure is varied subject to price fluctuation in the short run period.

• Journal of the Korean Society for Precision Engineering
• /
• v.29 no.4
• /
• pp.461-468
• /
• 2012

Silo is a warehouse for storing granular materials such as grain, cement, petroleum compound and coal. When compared to other warehouses, the silo can use space efficiently. The coal silo are consists of silo, tunnel and extractor. Of these, there are not sufficient study and design data on tunnel. It depends heavily upon trial and error method by field engineers with several years of experience. Recently, silos are constructed with a large size, and tunnel becomes to be in danger of severe cracking and collapse by a huge load of coal. So it is necessary to analyze structural safety for tunnel. In this study, the problems of the tunnel are analyzed by field data, and reinforcement of structural weak area using FE analysis has been carried out to design the tunnel satisfying structural safety. From FE Analysis, the reinforced model which does not exceed the yield strength of the material has been proposed.