• Proceedings of the Korean Information Science Society Conference
• /
• 1998.10b
• /
• pp.389-391
• /
• 1998

데이터 웨어하우스에서는 시간에 따라 변화되는 데이터를 관리함으로써 좀더 정확하게 요약화된 정보를 제공할 수 있다. 거의 모든 데이터 웨어하우스는 원시 데이터로 관계형 데이터베이스를 사용하지만, 관계형 데이터베이스는 시간 데이터에 대해 실제적인 지원을 하지 않는다. 그러므로 시간 변이 데이터에 대한 정확한 정보를 얻기가 어렵다. 본 논문에서는 이러한 시간 변이 데이터의 지원이 가능한 시간지원 데이터 웨어하우스를 설계하고자 한다. 이를 위해, 기존의 데이터 웨어하우스에서 원시 데이터로 사용하는 관계형 데이터베이스에 시간지원질의 처리 계층을 결합하는 방법을 보이고, 시간지원 데이터의 간격 시간에 대한 요약화 방법으로 시간지원 집계 트리 전략을 소개한다.

• Proceedings of the Korea Information Processing Society Conference
• /
• 2006.11a
• /
• pp.313-316
• /
• 2006

기존에 기업의 의사결정을 위해 사용되는 데이터 웨어하우스나 데이터 마트에서 성능향상을 위한 많은 연구들이 있었다. 하지만 복잡한 업무요건이 추가되고 기업의 요구가 다양해짐에 따라 RDBMS의 성능은 점점 낮아지고 이를 해결하기 위한 필요성이 요구되었다. 따라서 본 논문에서는 이를 해결하기 위해 버퍼기능을 하는 PL/SQL Package를 구현하여 효율적인 질의 최적화 방법을 제안하고자 한다. 그리고 본 논문에서 제안한 방법이 기존의 방법보다 성능이 좋다는 것을 실험을 통해 증명해 보였다.

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

• Korean Journal of Construction Engineering and Management
• /
• v.6 no.1 s.23
• /
• pp.89-98
• /
• 2005

Recently the construction industry in Korea is facing problems such as low productivity, contraction of the domestic construction market, growing competition, and so on. To enhance the competitiveness continuously through efficiency in this business environments, construction companies need to make efforts to measure and accumulate performance data based on the strategic factors. When analysing performance of construction projects, the unique characteristics of each project should be considered properly, by which the managers can identify current status of project in various perspectives. This study proposes the performance analysis system using the concepts of balanced scorecard and data warehouse technology. The suggested system provides the management with the flexibility in analyzing performance data by applying the pre-defined key performance indicators and the function of multi-dimensional analysis.

• Safety and Health at Work
• /
• v.6 no.1
• /
• pp.56-61
• /
• 2015

Frozen food processing workers work under a cold environment which can cause several adverse health effects.This study explored factors affecting workers' health in the frozen food industry in Thailand. Participants comprised 497 workers exposed to a cold working environment and 255 office workers who served as the controls. Data were collected by a survey on the work environment, and the interview of workers for abnormal symptoms. The exposed group had the following characteristics: 52.7% male, overall average age of 27 (SD 6.6) years old, attained elementary education (Grade 4 and Grade 6) (54.1%), married (48.9%), smokers (21.3%), alcohol consumption (31.0%), duration of work was between 1 and 5 years (65.2%), working 6 days a week (82.7%), 1-5 hours of overtime per week (33.8%), office workers (33.9%); work category: sizing (6.9%), peeling (28.3%) dissecting (22.2%), and in the warehouse (8.6%). The temperature in the work environment ranged from $17.2^{\circ}C$ to $19.2^{\circ}C$ in most sections, $-18.0^{\circ}C$ in the warehouse, and $25^{\circ}C$ in the office areas. Warehouse workers had more abnormal symptoms than controls including repeated pain in the musculoskeletal system (OR 11.9; 95% CI 6.12-23.45), disturbance throughout the body (OR 4.60; 95% CI 2.00-10.56), respiratory symptoms (OR 9.73; 95% CI 3.53-26.80), episodic finger symptoms (OR 13.51; 95% CI 5.17-35.33). The study results suggest that workers' health should be monitored especially with regard to back and muscle pain, respiratory symptoms, episodic finger symptoms, and cardiovascular symptoms. Health promotion campaigns such as antismoking and reduction of alcohol consumption should be established because smoking and alcohol consumption are contributing factors to the pathogenesis of Raynaud's phenomenon and peripheral vascular disorders such as hypertension and heart disease.

• Journal of Digital Convergence
• /
• v.13 no.12
• /
• pp.319-324
• /
• 2015

This paper proposes an integrated management system for products of game software development. Those products generated over software life-cycle are generally huge in numbers, various in kinds and interconnected in relationships among them. Especially they are highly complex and tightly coupled each other because they are used to build another world which is composed of multi-modal data such as graphics, sound, logics and so on. Therefore it is critical to manage development products in an integrated manner to guarantee the quality of software. The proposed system is designed to provide project/requirement/configuration/traceability management capabilities and interfacing to CASE standards. To achieve the objective, it is based on data warehouse technologies which provide central repositories of heterogeneous data, multi-aspect reporting&analysis capabilities, traceability, verification, etc.

• Proceedings of the Korean Society of Precision Engineering Conference
• /
• 2006.05a
• /
• pp.615-616
• /
• 2006

Many manufacturing companies manage their production-related data for quality management and production management. Nevertheless, production related-data should be closely related to each other Stored data is mainly used to monitor their process and products' error. In this paper, we provide an enterprise-wide production data model for decision support system and product automation. Process data, quality-related data, and test data are integrated to identify the process inter or intra dependency, the yield forecasting, and the trend of process status. In addition, it helps the manufacturing decision support system to decide critical manufacturing problems.

• Journal of Information Technology Applications and Management
• /
• v.13 no.1
• /
• pp.137-147
• /
• 2006

Spatiotemporal data are records of the spatial changes of moving objects over time. Most data in corporate databases have a spatiotemporal nature, but they are typically treated as merely descriptive semantic data without considering their potential visual (or cartographic) representation. Businesses such as geographical CRM, location-based services, and technologies like GPS and RFID depend on the storage and analysis of spatiotemporal data. Effectively handling the data analysis process may be accomplished through spatiotemporal data warehouse and spatial OLAP. This paper proposes a multidimensional model for spatiotemporal data analysis, and cartographically represents the results of the analysis.

• Journal of Korea Spatial Information System Society
• /
• v.2 no.2 s.4
• /
• pp.89-97
• /
• 2000

This paper deals with the method which can apply spatial-data warehouses into the spatial data infrastructure in the view of clearinghouse. First, we classify the type of available data warehouses in the consider with patterns and properties of spatial data infrastructure. Then we suggest strategies for building and expanding data warehouses into various organizations. After considering all the factors, we suppose how the national spatial data warehouse come into being.

• Industrial Engineering and Management Systems
• /
• v.12 no.3
• /
• pp.172-180
• /
• 2013

We herein consider a stochastic multi-item inventory management problem in which a warehouse sells multiple items with stochastic demand and periodic replenishment from a supplier. Inventory management requires the timing and amounts of orders to be determined. For inventory replenishment, trucks of finite capacity are available. Most inventory management models consider either a single item or assume that multiple items are ordered independently, and whether there is sufficient space in trucks. The order cost is commonly calculated based on the number of carriers and the usage fees of carriers. In this situation, we can reduce future shipments by supplementing items to an order, even if the item is not scheduled to be ordered. On the other hand, we can reduce the average number of items in storage by reducing the order volume and at the risk of running out of stock. The primary variables of interest in the present research are the average number of items in storage, the stock-out volume, and the number of carriers used. We formulate this problem as a multi-objective optimization problem. In a numerical experiment based on actual shipment data, we consider the item shipping characteristics and simulate the warehouse replenishing items coordinately. The results of the simulation indicate that applying a conventional ordering policy individually will not provide effective inventory management.