• Asia pacific journal of information systems
• /
• v.13 no.4
• /
• pp.191-206
• /
• 2003

More views in data warehouse, can respond to the users more rapidly because the user's requests might be processed by accessing only the materialized views with higher probabilities rather than accessing base relations. But, the update duration for maintaining materialized views limits the number of materialized views in data warehouse. In this paper, we propose the algorithm for reducing update duration of materialized views, of which aggregation functions are maintained by self-maintenance. We also implement the proposed algorithm and evaluate the performance of the algorithm.

• Proceedings of the Korea Inteligent Information System Society Conference
• /
• 1999.03a
• /
• pp.383-392
• /
• 1999

오늘날의 의사결정을 지원하는 시스템에 있어서 데이터 웨어하우스가 널리 활용되고 있다. 이러한 데이터웨어 하우스를 개발하는데 있어서 메타 데이터가 필수적인 요소로 활용되고 있다. 한편, 메타 데이터 연합(Meta Data Coalition)에서 제정한 Metadata Interchange Specification (MDIS)는 이러한 메타 데이터의 표준으로 널리 활용되고 있다. 본 연구는 이러한 표준을 기반으로 한 메타 데이터 스키마를 제시하고 있다. 실제적인 개발에서 이러한 표준은 핵심웨어하우스 계층, 적용 계층, 사용자 탐험 계층 비즈니스 계층으로 구성되어 있다. 이러한 메타 데이터 스키마를 적용한 실제 시스템의 프로토타입을 본 연구에서 구현해 보았다.

• The Journal of The Korea Institute of Intelligent Transport Systems
• /
• v.13 no.3
• /
• pp.1-9
• /
• 2014

This study deals with development of Integrated Transportation Analysis System for Large-scale event. Based on case studies, the requirements of the system were defined and the direction of development was established. The large-scale events that require fast and accurate transportation policy were selected. The data warehouse and data mart were developed by integrating the large-scale event data and the traffic data. Business intelligence system was designed and developed users to allow timely decisions.

• Korean Journal of Construction Engineering and Management
• /
• v.7 no.2 s.30
• /
• pp.127-137
• /
• 2006

Productivity is important to evaluate an efficiency of performed work and organization in construction industry. The productivity should be defined as activity level rather than macro level in order to effectively use productivity data and manage a project. The primary objective of this study is to develop a construction productivity management system using data warehouse, OLAP and data mining technologies which enables to easily accumulate the construction productivity data and perform multi layer analysis. Finally, it is anticipated that the effective use of the developed system would be able to measure the result of project and make a plan of the similar project with reliability.

• Korean Journal of Occupational Health Nursing
• /
• v.26 no.3
• /
• pp.133-141
• /
• 2017

Purpose: The purpose of this study was to identify the relationship between work-related characteristics and job stressors and the factors influencing musculoskeletal symptoms of the warehouse employees. Methods: The research was a cross-sectional, descriptive study. Data were collected from 319 warehouse employees who agreed to participate in the study by using self-report questionnaires. Data were analyzed using descriptive statistics, $x^2-test$, and logistic regression analysis (SPSS 18.0). Results: The overall prevalence of musculoskeletal symptoms was 37.6%. The logistic regression analysis revealed a posture that renders fatigue or pain, repetitive work, and a higher total score of job stressors as the risk factors for musculoskeletal symptoms in many body parts. Conclusion: Employers should plan to educate employees who work in warehouses about the correct working posture to prevent musculoskeletal diseases, stop repetitive work, and manage job stressors.

• Journal of the Korean Association of Geographic Information Studies
• /
• v.12 no.2
• /
• pp.11-22
• /
• 2009

Recently the integration and development of ST(Spatial Technology) and forest geographic information have been used very efficiently for the forest administration. However, even though many application system related to forest information have been developed and improved, there are still paper based inventories management and hand work for data construction and upgrade. In this study the forest information warehouse, which is mapped and managed at work-site operations, was constructed based GIS technology so that the standardization and consistency of current data could be acquired in real time. In addition, these thematic maps were conducted on high resolution satellite images and managed in web based forest information data warehouse form and finally shared through Internet for the very first-line administration officials. This study shows that the forest information standardization service of municipal governments very first time in the Korea and provides the unified decision making support and enterprise formed forest database so that is expected to be the very successful sample to suggest the prototype of national forest spatial data infrastructure.

• Proceedings of the IEEK Conference
• /
• 2008.06a
• /
• pp.725-726
• /
• 2008

In this paper, we introduce an ubiWarehouse system for the management of automobile parts. Because automotive parts are very various in kinds according to companies, models and manufacture year, it's hard to find exactly the desired parts and to control goods in stock. To solve this problem, we propose the model of context recognizer in which context data are expressed in a systematic type of 5W1H. And initial context data are grouped and integrated, and some conflict context information is solved. Finally user's intention is interpreted and served. As a result, the proposed system can be used to enhance conveniency and correctness of the management of various kinds of part's.

• Proceedings of the Korean Society for Information Management Conference
• /
• 1997.08a
• /
• pp.203-208
• /
• 1997

인터넷의 발전과 인트라넷의 등장, 데이터웨어하우스의 출현은 국가간의 산업경쟁력을 더욱 뜨겁게 하고 있다. 원하는 정보를 원하는 때에 원하는 곳에서 신속하게 제공받고, 제공할수 있는 가는 오늘날 정보서비스의 핵심이 되고 있는 것이다. 따라서 정보의 체계적인관리는 필수적이며 데이터웨어하우스의 구축은 매우 중요하다 할 것이다. 본고는 데이터웨어하우스의 발전을 고찰하고 인터넷을 통한 데이터 웨어하우스의 정보활용을 제시하였다.

• Proceedings of the Korean Operations and Management Science Society Conference
• /
• 2001.10a
• /
• pp.101-105
• /
• 2001

This paper is to illustrate the possibility to use organizational knowledge and data warehouse simultaenously for a decision maker. Organizational knowledge is produced for qualitative decision-making process and data warehouse is used for quantitative decision-making process. However, two things are currently implemented separately in many organizations although being needed for decision makers. This research shows a model for building integrated system and a prototyping system based on the model. And its effectiveness is discussed.

• Proceedings of the Korean Operations and Management Science Society Conference
• /
• 1996.10a
• /
• pp.271-274
• /
• 1996

Since the primary purpose of information Engineering focuses on transaction or operation processing, various information needs acquired in Information Strategy Planning phase are not properly utilized from the viewpoint of decision support systems development. In this research, we suggest a case-based reasoning application that supports initial Data Warehouse Modeling by expanding the activities in Information Strategy Planning.