• The KIPS Transactions:PartD
• /
• v.10D no.3
• /
• pp.407-416
• /
• 2003

As the usage of database systems dramatically increases and the amount of data pouring into them is massive, the performance administration techniques for using database systems effectively are getting more important. Especially in data warehouses, the performance management is much more significant mainly because of large volume of data and complex queries. The objectives and characteristics of data warehouses are different from those of other operational systems so adequate techniques for performance monitoring and tuning are needed. In this paper we extend functionalities of the DBMax, a performance administration tool for Oracle database systems, to apply it to data warehouse systems. First we analyze requirements based on summary management and ETL functions they are supported for data warehouse performance improvement in Oracle 9i. Then, we design architecture for extending DBMax functionalities and implement it. In specifics, we support SQL tuning by providing details of schema objects for summary management and ETL processes and statistics information. Also we provide new function that advises useful materialized views on workload extracted from DBMax log files and analyze usage of existing materialized views.

• Journal of the Korean Society of Safety
• /
• v.38 no.2
• /
• pp.52-59
• /
• 2023

Due to the routine nature of social distancing in accordance with the COVID-19 pandemic, the logistics industry is under rapid development, given that offline demand is focused on online platforms. The number of warehouse workplaces and workers are steadily increasing per annum, and the industrial accident rate of transportation, warehouse, and telecommunication industries to which warehouse employees belong is higher than the total industrial accident rate in Korea. In previous studies, warehouse workers reported exposure to health hazards such as musculoskeletal disorders due to the handling of heavy objects and improper working postures. Accordingly, in this study, a survey was conducted to investigate symptoms of musculoskeletal disorders with focus on parcel delivery workers nationwide. The questionnaire included a musculoskeletal disorder symptom survey table to identify information such as worker occupational history, work type, and signs or symptoms of musculoskeletal disorders. Survey response data from 453 people were obtained to determine the influence of delivery business characteristics on occupational musculoskeletal disorders, and the influencing factors were analyzed. Based on the results, in the analysis of pain with respect to body part, the duration, degree, and frequency of pain were highest in the leg part, and as a result, the average value for the leg part exhibited a significant difference from those of other body parts. In addition, 52.32% of workers exhibited symptoms of musculoskeletal disorders, and a high number of patients with musculoskeletal disorders was observed in the work group with less than three years of service and with ages ranging from 30-39. The results of this study can serve as basic data for the derivation of a management plan that meets the characteristics of musculoskeletal disorders that impact logistics workers overburdened with work due to the rapid increase in parcel delivery volume in accordance with an increase in online consumption.

• Fire Science and Engineering
• /
• v.30 no.2
• /
• pp.98-105
• /
• 2016

A fire risk assessment in rack-type warehouse is typically determined based on the following factors: 1. flammability and fire loads for storage of goods, packing materials, and pallet, 2. a ceiling height of warehouse indoor spaces, and 3. height, arrangement, and spacing for storage racks. For appropriately extinguishing and protecting the fire in warehouses, therefore, it is necessary to classify combustibles considering the previously mentioned factors and to develop design Standards for sprinkler system. As the first step to apply automatic sprinkler system to domestic warehouses, this study investigated characteristics for commodity distribution and warehouse configuration using 28 warehouses in five distribution complexes located in Gyeonggi-do, South Korea. In addition, this study analyzed Standards for commodity distribution adopted in USA, Europe, and Japan. Using the field survey analysis, this study was aimed to provide baseline data to prepare for Commodity Classification Standard for warehouses in South Korea.

• Industrial Engineering and Management Systems
• /
• v.8 no.2
• /
• pp.80-92
• /
• 2009

This paper addresses the inventory rationing issue embedded in the regional supply chain inventory replenishment problem (RSIRP). The concerned supply chain, which was fed by the national supply chain, consisted of a single warehouse distributing a single product to multiple stores (M-stores) with independent and normally distributed customer demand. It was assumed that the supply chain operated under the order-up-to level inventory replenishment system and had only one truck at the regional warehouse. The truck could make one replenishment trip to one store per period (a round trip per period). Based on current inventories and the vehicle constraint, the warehouse must make two decisions in each period: which store in the region to replenish and what was the replenishment quantity? The objective was to position inventories so as to minimize lost sales in the region. The warehouse inventory was replenished in every fixed-interval from a source outside the region, but the store inventory could be replenished daily. The truck destination (store) in each period was selected based on its maximum expected shortage. The replenishment quantity was then determined based on the predetermined order-up-to level system. In case of insufficient warehouse inventories to fulfill all projected store demands, an inventory rationing rule must be applied. In this paper, a new inventory rationing rule named Expected Cost Minimization (ECM) was proposed based on the practical purpose. The numerical results based on real data from a selective industry show that its performance was better and more robust than the current practice and other sharing rules in the existing literature.

• International journal of advanced smart convergence
• /
• v.11 no.3
• /
• pp.187-196
• /
• 2022

In this paper, we propose an example of designing and constructing a roof-type solar power plant structure equipped with a Pseudo-BIPV (Building-Integrated Photovoltaic) shape suitable for use as a roof of a small warehouse with a sandwich-type panel structure. As the characteristics of the roof-type solar power generation facility to be installed in the small warehouse proposed in this study, the shape of the roof is not a general A type, but a right-angled triangle shape with the slope is designed to face south. We chose a structure in which an inverter for one power plant and a control facility are linked by grouping several roofs of buildings. In addition, the height of the roof structure is less than 20 cm from the floor, and it has a shape similar to that of the BIPV, so it is building-friendly because it is almost in close contact with the roof. At the same time, the roof creates a reflective light source due to the white color. By linking this roof with a double-sided solar panel, we designed it to obtain both the advantage of the roof-friendliness and the advantage of efficiency improvement for the electric power generation based on the double-sided panel. Compared to the existing solar power generation facilities using A-shaped cross-sectional modules, the power generation efficiency of roofs in this case is increased by more than 11%, which we can confirm, through the comparison analysis of monitoring data between power plants in the same area. Therefore, if the roof-type solar structure suitable for the small warehouse we have presented in this paper is used, the facilities of electric power generation is eco-friendly. Further it is easier to obtain facility certification compared to the BIPV, and improved capacity of the power generation can be secured at low material cost. It is believed that the roof-type solar power generation facility we proposed can be usefully used for warehouse or factory-based smart housing. Sensor devices for monitoring, CCTV monitoring, or safety and environment management, operating in connection with the solar power generation facilities, are linked with the Internet of Things (IoT) solution, so they can be monitored and controlled remotely.

• Proceedings of the Korea Inteligent Information System Society Conference
• /
• 2001.01a
• /
• pp.448-455
• /
• 2001

Recently, many enterprises have attempted to capitalize knowledge assets on data warehouse (DW). It has been recognized as strategic core process to create corporate competitive advantage and implement enterprise e-biz strategies. However, most approaches to represent knowledge and decision process have limits in considering various knowledge types, their relationships and continuity in knowledge formulation. In addition, they are so inclined to one side such as concept-oriented frameworks or technology-oriented ones. They lack universal and wide-ranging features. This paper presents a comprehensive methodology to accumulate knowledge capital on DW via a properly grained hypermedia model. The methodology consists of three phases: knowledge requirement elicitation, hypermedia modeling, and system implementation. A real-life case for medical DW development is presented to demonstrate the usefulness of the proposed methodology. This methodology is effective when an organization accumulates knowledge assets to put the corporate e-biz or cre-biz strategy into practice.

• 한국IT서비스학회:학술대회논문집
• /
• 2010.05a
• /
• pp.291-295
• /
• 2010

최근 급격한 하드웨어 기술과 데이터베이스 시스템의 발전은 우리 주변에서 발생하는 다양한 분야의 데이터를 자동으로 수집하는 것을 가능하게 하였다. 흔히 데이터 스트림(data stream)이라고 언급되는 끊임없이 생산되는 대용량의 데이터를 효율적으로 처리하여 유용한 정보를 얻어내는 기술은 이미 많은 응용 분야에서 광범위하게 연구되고 있다. 인터넷은 이러한 데이터 스트림을 양산해 내는 주요 원천 중의 하나이다. 인터넷 비즈니스의 활성화와 더불어 웹로그 데이터 스트림은 마케팅, 전략 수립, 고객관리 등 여러 부분에 광범위하게 활용되기 시작했으며, 보다 정확하고 효율적인 분석에 대한 요구사항도 점점 늘어나고 있다. 데이터 웨어하우스(Data Warehouse)는 수집된 데이터를 주제 기반으로 통합하여 시계열 형태로 적재하는 저장소서 유용한 분석이나 의사결정에 많이 사용되어 왔다. 데이터웨어하우스는 데이터를 요약하고 통합 및 정제하는 기능을 제공하여 대용량의 데이터 처리에 적합하고 데이터의 품질을 향상시키기 때문에 데이터 마이닝 분야에서 전처리 과정으로도 많이 이용되어 왔다. 본 논문에서는 웹로그 데이터 스트림에 대한 데이터 웨어하우스를 구축하여 보다 고품질의 유용한 정보를 효율적으로 얻어내는 시스템을 제안한다.

• 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.

• Journal of Korea Multimedia Society
• /
• v.9 no.12
• /
• pp.1529-1541
• /
• 2006

Moving objects have been widely employed in traffic and logistic applications. Spatio-temporal aggregations mainly describe the moving object's behavior in the spatial data warehouse. The previous works usually express the object moving in some certain region, but ignore the object often moving along as the trajectory. Other researches focus on aggregation and comparison of trajectories. They divide the spatial region into units which records how many times the trajectories passed in the unit time. It not only makes the storage space quite ineffective, but also can not maintain spatial data property. In this paper, a spatio-temporal aggregation index structure for moving object trajectory in constrained network is proposed. An extended B-tree node contains the information of timestamp and the aggregation values of trajectories with two directions. The network is divided into segments and then the spatial index structure is constructed. There are the leaf node and the non leaf node. The leaf node contains the aggregation values of moving object's trajectory and the pointer to the extended B-tree. And the non leaf node contains the MBR(Minimum Bounding Rectangle), MSAV(Max Segment Aggregation Value) and its segment ID. The proposed technique overcomes previous problems efficiently and makes it practicable finding moving object trajectory in the time interval. It improves the shortcoming of R-tree, and makes some improvement to the spatio-temporal data in query processing and storage.

• Journal of Korea Multimedia Society
• /
• v.19 no.5
• /
• pp.939-947
• /
• 2016

As the number of legacy database systems and the size of data to manipulate have been vastly increased, it has become more difficult and complex to analyze characteristics of data. To improve the efficiency of data analysis and help administrators to make decisions in business life, BI(Business Intelligence) system is used. To construct data warehouse and cube from legacy database systems makes it easy and fast to transform raw data into integrated and categorized meaningful information. In this paper, we built a BI system for an University administration. Several source system databases were integrated to data warehouse to build data cubes. The implemented BI system shows much faster data analysis and reporting ability than the manipulation in legacy systems. It is especially efficient in multi dimensional data analysis, nonetheless in single dimensional analysis.