• Title/Summary/Keyword: Data-Warehouse

Search Result 348, Processing Time 0.025 seconds

Construction Project Performance Management Using BSC and Data Warehouse (BSC를 활용한 Data Warehouse 기반의 건설 프로젝트 성과관리)

  • Park, Moon-Seo;Kim, Nam-Ho;Lee, Hyun-Soo;Ahn, Chang-Bum;Lee, Kyu-Sung
    • Korean Journal of Construction Engineering and Management
    • /
    • v.10 no.2
    • /
    • pp.14-25
    • /
    • 2009
  • Many companies have managed their business performance in order to achieve their enterprise purpose. Performance management which applied concept of BSC (Balanced Scorecard) is widely used all over the world. In the construction industry, BSC-based performance management is currently introduced with needs of balanced performance evaluation. However, most companies actually have intermediate level of adapting BSC. It is important to understand its process or and structure. Therefore, this paper is focused on making performance management process and defining each phase of it. In addition, the model and system are established with putting them together. With developing performance process in construction, the construction companies are supposed to detect the deficiencies of the current performance management systems and take some opportunity to be helped for supporting their decision-making. In conclusion, this paper will provide the construction industry with the opportunities to enhance the values of performance management system and construction application.

Scientific fire investigation by NFPA 921 CODE based on frozen warehouse fire case (냉동창고 화재 사례를 기반으로 하는 NFPA 921 CODE에 의한 과학적 화재조사 연구)

  • Park, Kyong-Jin;Lee, Yong-KI;Cha, Sung-Sig;Jung, Dong-Young;Kim, Jang-Oh
    • Journal of the Korea Academia-Industrial cooperation Society
    • /
    • v.19 no.8
    • /
    • pp.78-85
    • /
    • 2018
  • In this study, we investigated the cases where there were many opinions in the judgment of the cause of ignition in the case of 20 cases of frozen warehouse fire that occurred in 2017.The research methodology is the scientific fire survey method prescribed by the NFPA 921 CODE. Scientific fire investigation method is fire investigation method by logical reasoning through hypothesis setting, minimizing errors in judgment of ignition source. On the other hand, unscientific fire investigation methods cause many errors by the intervention of irrational factors such as subjective estimation, reasoning judgment, etc. This eventually leads to the problem of human and material responsibility and academic deterioration. In particular, fire not seen as compared to sighted fire makes more errors in ignition sources in the cause investigation. In this study, we set the hypothesis A and hypothesis B based on the review of the fire investigation report and the field survey on the fire case of the cold storage warehouse front line that occurred at ** city ** Mart in 2017.The set hypothesis was tested by the NFPA 921 code. This analytical method will be constructed by NEW Paradigm as a source of fire that is not seen in the future and a source of ignorant fire.In addition, the experimental data of this study will be used to inform the manufacturer and operator of the refrigeration warehouse and serve as basic data for fire prevention.

An Efficient Incremental Maintenance of SPJ Materialized Views (SPJ 실체화 뷰의 효율적인 점진적 관리 기법)

  • Lee, Ki-Yong;Son, Jin-Hyun;Kim, Myoung-Ho
    • The KIPS Transactions:PartD
    • /
    • v.13D no.6 s.109
    • /
    • pp.797-806
    • /
    • 2006
  • In the data warehouse environment, materialized views are typically used to support efficient query processing. Materialized views need to be updated when source data change. Since the update of the views need impose a significant overhead, it is essential to update the views efficiently. Though various view maintenance strategies have been discussed in the past, the efficient maintenance of SPJ materialized views has not been sufficiently investigated. In this paper, we propose an efficient incremental view maintenance method for SPJ materialized views that minimizes the total accesses to data sources. The proposed method finds an optimal view maintenance strategy using a dynamic programming algorithm. We also present various experimental results that shows the efficiency of our proposed method.

Trajectory Data Warehouses: Design and Implementation Issues

  • Orlando, Salvatore;Orsini, Renzo;Raffaeta, Alessandra;Roncato, Alessandro;Silvestri, Claudio
    • Journal of Computing Science and Engineering
    • /
    • v.1 no.2
    • /
    • pp.211-232
    • /
    • 2007
  • In this paper we investigate some issues and solutions related to the design of a Data Warehouse (DW), storing several aggregate measures about trajectories of moving objects. First we discuss the loading phase of our DW which has to deal with overwhelming streams of trajectory observations, possibly produced at different rates, and arriving in an unpredictable and unbounded way. Then, we focus on the measure presence, the most complex measure stored in our DW. Such a measure returns the number of distinct trajectories that lie in a spatial region during a given temporal interval. We devise a novel way to compute an approximate, but very accurate, presence aggregate function, which algebraically combines a bounded amount of measures stored in the base cells of the data cube. We conducted many experiments to show the effectiveness of our method to compute such an aggregate function. In addition, the feasibility of our innovative trajectory DW was validated with an implementation based on Oracle. We investigated the most challenging issues in realizing our trajectory DW using standard DW technologies: namely, the preprocessing and loading phase, and the aggregation functions to support OLAP operations.

Study on location selection of integrated depot of warehouse stores utilizing AHP method (AHP법을 활용한 창고형 매장의 통합 Depot 위치선정에 관한 연구)

  • Park, Byoung-Jun;Nam, Tae-Hyun;Yeo, Gi-Tae
    • Journal of Digital Convergence
    • /
    • v.17 no.2
    • /
    • pp.135-144
    • /
    • 2019
  • The importance of logistics of warehouse stores has increased as their prices are cheaper and more convenient than those of large supermarkets. However, few studies on integrated depot location selection of warehouse stores have been conducted. In this regard, this study aims to derive factors for integrated depot location selection and calculate weights and select the location priority of target candidates by introducing an analytic hierarchy process (AHP). The analysis results exhibited that the most important selection factor was the cost reduction in transportation and delivery (0.198) followed by distance reduction in transportation and delivery (0.168), and time reduction in transportation. This study quantified the reduction in cost and increase in efficiency if depots were integrated and operated thereby presenting more realistic foundational data to hands-on workers. For the future study, the analysis model will be needed to be advanced through additional investigation on the factors in the analysis.

Strategy to Improve the Management Efficiency of Meta Data Mining System (메타데이터 마이닝 시스템의 관리효율성의 제고전략)

  • Yun, Yong-Un
    • Proceedings of the Korean Operations and Management Science Society Conference
    • /
    • 2005.05a
    • /
    • pp.276-279
    • /
    • 2005
  • Many large organizations that have allocated resources to Data Administration(DA) have DA-context meta data mining. Also meta data is an interesting topic in the data warehouse world. This conceptual view gradually cleared up, and recently we have been talking more confidently about the back-room and front-room meta data. We describe the processes and problems that characterize the general architecture of s meta data mining system to do improve management efficiency that require further research and development.

  • PDF

A Case Study of OLAP and Data Mining on the Analytical Knowledge Creation in Organizations (OLAP과 데이터마이닝을 이용한 조직내 분석지 생성에 관한 사례연구)

  • Cho, Jae-Hee
    • Knowledge Management Research
    • /
    • v.5 no.1
    • /
    • pp.69-82
    • /
    • 2004
  • Prior research on knowledge management focused more on the experiential knowledge based on individual's experience or knowhow than on the analytical knowledge extracted from corporate data. This study examines the effects of the data warehouse technology, especially OLAP(on line analytical processing) and data mining techniques, on the analytical knowledge creation in organizations, linking analytical knowledge creation to data analysis method through real world case studies.

  • PDF

Web Information Extraction and Multidimensional Analysis Using XML (XML을 이용한 웹 정보 추출 및 다차원 분석)

  • Park, Byung-Kwon
    • Journal of Korea Multimedia Society
    • /
    • v.11 no.5
    • /
    • pp.567-578
    • /
    • 2008
  • For analyzing a huge amount of web pages available in the Internet, we need to extract the encoded information in web pages. In this paper, we propose a method to extract and convert web information from web pages into XML documents for multidimensional analysis. For extracting information from web pages, we propose two languages: one for describing web information extraction rules based on the object-oriented model, and another for describing regular expressions of HTML tag patterns to search for target information. For multidimensional analysis on XML documents, we propose a method for constructing an XML warehouse and various XML cubes from it like the way we do for relational data. Finally, we show the validness of our method through the application to US patent web pages.

  • PDF

A Study of Impementaton Methodology for Data Warehouse (데이터웨어하우스 구축 방법론에 대한 연구)

  • Lee, Byong-Soo;Lee, Sang-Rak;Chang, Keun;Yoon, Ju-Yong
    • Proceedings of the Korea Society for Industrial Systems Conference
    • /
    • 1999.05a
    • /
    • pp.3-9
    • /
    • 1999
  • Using Information systems to process massive data, quickly and exactly, organizations have chances to enhance their performance. The limitations of IS function to support decision-making, however, have been frequently mentioned. In this context, in addition to traditional mathematical model that is a kernel of DSS, the needs for Data Warehouse which is a system supporting business process analysis are emerging. In this study, for those needs, first, we introduce issues of implementation methodology for D/W, especially various models relating development process. Then, we investigate correlation between these models and key factors for success of D/W.

  • PDF

A Study on Efficient Stock Arrangement of Distribution Center Using MBA Analysis and Simulation in Retail Business (유통업에서 MBA분석과 시뮬레이션을 이용한 물류센타 재고배치 효율화에 관한 연구)

  • Yeo, Sung-Joo;Seong, Kil-Young;Wang, Gi-Nam
    • IE interfaces
    • /
    • v.22 no.3
    • /
    • pp.234-242
    • /
    • 2009
  • It is most important for distribution center in retail business to delivery commodities in a timely manner. Accordingly, many companies try to make distribution center effective using the Warehouse Management System(WMS) integrated legacy system. Also, the Customer Relationship Management(CRM) is the most typical paradigm in management lately. Even though the WMS and CRM are independent system of each other, WMS, coupled with CRM makes customer satisfied more effectively. In this paper, we proposed the methodology for inventory location after analyzing and applying customer buying pattern data in the CRM through the MBA(Market Basket Analysis), which is part of data mining. We used an example modeling a real distribution center in retail through a 3D simulation tool and examined correlation between commodities using customer buying pattern. After that, we applied it to the inventory location system through the MBA in an example. Finally, we identified decrease in the time for picking, which is the majority of distribution center. Besides, we proposed a simulation methodology before applying new methodology. Consequently, it removes potential errors in advance and makes a optimized inventory location system.