資料倉儲資料載入清理與應用之研究-以高齡者生活品質智慧型維護系統為例

施佑達

指導教授 ： 林志麟

元智大學/資訊學院/資訊管理學系/碩士(2003年)

摘要

資料倉儲是現今企業普遍採行的一個技術。企業從組織內外收集各式各樣的資料儲存在資料倉儲中，提供決策者在做決策時所需要的資料。然而由於資料來自於異質性的資料來源，資料不免雜亂，甚至會有錯誤的資料。為了確保資料倉儲的品質，在這些資料存入資料倉儲以前，必須要有一個適當的資料格式轉換及資料清理動作。本研究以高齡者生活品質智慧型維護系統為例，說明如何將資料格式作轉換及資料清理等動作。除了一般資料庫限制，本研究透過專家意見輔以邏輯法則限制來確保資料的正確性。本系統透過架設於高齡者周圍之非察覺式監測器，可以遠端監測高齡者之活動力及生活環境。高齡者親屬可以使用瀏覽器，經由網際網路查詢高齡者之日常生活品質；另一方面，醫師或分析師可以透過本系統之OLAP介面查詢高齡者異常的地方。本系統同時將這些資料存入資料倉儲中，再利關聯法則分析，找出各感應器之間的相關性。

關鍵字

資料倉儲 ； 資料清理 ； 線上分析處理 ； 高齡者 ； 關聯法則

並列摘要

Data warehouse is a sort of common technique that used by enterprises nowadays. Enterprises collect and save all kinds of data that from organizations into Data warehouse, and they provide necessary material to people who make decisions. Because of the heterogeneity, it is likely to be disordered and even has mistakes in it. There must be a suitable data format transformation and Data Clean process before we put the data in data warehouse for making sure the quality of it. This research gives Elder Intelligent Manatenance System for the quality of life as an example, and it states the process of data format transformation and data identified by the opinions of specialists and supported by the limitations of logical rules to ensure the accuracy of data. This system can monitor the activity and the surrounding environment of the elder remotely by setting imperceptible sensors nearby. Their relatives can use navigators to surf on the Internet to inquire the quality of daily life, and also doctors and analysts can seek abnormal situations of the elder with OLAP interface. At the same time, the system saves data in data warehouse and analyze with association rules, and then find out the relationship between sensors.

並列關鍵字

data warehouse ； data clean ； OLAP ； elder ； association rule

參考文獻

20. 王恩琦，高齡者生活品質智慧型維護系統－資料載入與示程式之自動維護機制，元智大學資訊管理學系，2002

4. Celler, B.G., Earnshaw, W., Ilsar, E.D., Betbeder-Matibet, L., Harris, M., Clark, R., Hesketh, T., Lovell, N.H., 1995, "Remote monitoring of the elderly at home. A multidisciplinary project on aging at the University of New South Wales", Int. J. Biomed. Comp, Vol.40, 1995, 147-155

5. Charu Aggarwal and Phillip Yu. A new framework for itemset generation. In PODS 1998,

9. Kimball, Ralph, The Data warehouse lifecycle toolkit, Wiley, 1998

10. Load, C.J., and Colvin D.P., Falls in the elderly: Detection and assessment, Proceedings of the annual conference on Engineering in Medicine and Biology, vol.13 n 4, p1938-1939