English  |  正體中文  |  简体中文  |  Items with full text/Total items : 74010/74010 (100%)
Visitors : 24681606      Online Users : 301
RC Version 7.0 © Powered By DSPACE, MIT. Enhanced by NTU Library IR team.
Scope Tips:
  • please add "double quotation mark" for query phrases to get precise results
  • please goto advance search for comprehansive author search
  • Adv. Search
    HomeLoginUploadHelpAboutAdminister Goto mobile version

    Please use this identifier to cite or link to this item: http://ir.lib.ncu.edu.tw/handle/987654321/65639

    Title: 電子巡檢系統的改善方案-以A公司為例;A Study on Electronic Patrol System Improvement – The Case of Company “A”
    Authors: 梁羿翔;LIANG,YI-HSIANG
    Contributors: 資訊管理學系在職專班
    Keywords: OLAP;ETL;Cube;行動裝置;OLAP;ETL;Cube;mobile device
    Date: 2014-07-10
    Issue Date: 2014-10-15 17:06:58 (UTC+8)
    Publisher: 國立中央大學
    Abstract: 電子巡檢系統的改善方案-以A公司為例
    本改善方案是以解決各個分廠的資料庫效能為首要目標,採行的作法為將現行資料庫分割為 OLTP與 OLAP 架構,一方面限制OLTP資料表增長,降低笛卡兒乘積的組合進而提昇整體電子巡檢系統的效率。另一方面使用ETL工具自動將各分廠的 OLAP資料彙整回總處,實現建置巡檢紀錄單一窗口的資料來源目標,並且進一步的完成商業智慧模型的開發。最後採用行動裝置方案,主動告知並提供主管即時之巡檢紀錄,大幅提升資訊獲得的效率。

    關鍵字: OLAP、ETL、Cube、行動裝置
    ;A Study on Electronic Patrol System Improvement – The Case of Company “A”
    In the cement industry, it is necessary to monitor the operating status of facilities in order to ensure smooth operations and to prevent environment safety hazards. However, a typical cement factory occupies a vast territory, and is faced with severe level of dust. Therefore, it is impractical to deploy video surveillance systems to monitor the entire factory. As a result that manual patrol procedures have to be implemented. The traditional patrol procedure requires all records be written and kept on paper. There are many potential problems with the paper-based system: it is impossible to ensure that the assigned staff was at right place at the right time as expected, and filled in the requisite data; and it is difficult for supervisors to audit the patrol records. Hence, company “A” decided to deploy an electronic patrol system to solve the problem.
    The initial success resulting in an all out deployment covering all 11 factories in Company “A”. While the electronic patrol system result in vast improvements, it generates a tremendous amount of patrol records, causing performance bottle necks. The performance problems are multifold, including data aggregation, report generation, response to inquiry, excessive time for server/PDA connections (downloading patrol assignments and uploading patrol records, etc. In addition, the patrol data from the 11 plants are not integrated, thus management in the headquarter has to access the data one factory at a time. Moreover, the data is so complicated that daily reports are only available on the next day, making realtime visibility a much desirable feature.
    This study aims to provide a solution to integrate the independent databases across all factories, and to solve the database performance issue. First, we propose to establish a new OLAP structure, along with the current OLTP database, so as to limit OLTP table data growth, and to reduce Cartesian product in database joins. Second, we propose to use ETL tools to push OLAP table from each plant to headquarter for automatic data aggregation. Third, the development of business intelligence features are also proposed. Finally, we employ mobile devices to provide senior managers with realtime patrol records, so that realtime visibility can be achieved.
    Keyword: OLAP, ETL, Cube, mobile device.
    Appears in Collections:[資訊管理學系碩士在職專班 ] 博碩士論文

    Files in This Item:

    File Description SizeFormat

    All items in NCUIR are protected by copyright, with all rights reserved.

    社群 sharing

    ::: Copyright National Central University. | 國立中央大學圖書館版權所有 | 收藏本站 | 設為首頁 | 最佳瀏覽畫面: 1024*768 | 建站日期:8-24-2009 :::
    DSpace Software Copyright © 2002-2004  MIT &  Hewlett-Packard  /   Enhanced by   NTU Library IR team Copyright ©   - 隱私權政策聲明