XML資料庫之差勤流程管理系統設計與實作

Design and Implementation of Attendance Management System with XML Database

吳家慶(Chia-Ching Wu)

指導教授 ： 李肇林

國立臺灣大學/電機資訊學院/資訊工程學研究所/碩士(2008年)

https://doi.org/10.6342/NTU.2008.03031

摘要

差勤管理是幾乎每個單位至部門每天皆須面對處理的繁瑣事務，舉凡個人各類假別申請、待處理申請單提醒、申請進度查詢、單位或部門負責人申請單核准以及每月各類假別資訊統計等實際需求。
本論文中運用PHP、Web Services、AJAX、XSLT、Java、XML Database、UTF-8編碼等技術工具，建置以Web Services為架構之分散式系統，並結合XML資料格式具階層式特性以及關聯式資料庫採正規化使資料一致性的理念，設計此系統提供各項申請單執行狀態、每年或每月各類假別統計資訊，以利使用者可清楚了解所需資訊，並藉由系統主動發送訊息或透過系統自動發送電子郵件方式等機制，主動通知與提醒代理人與核可人所需處理申請單，以避免申請單遭遺忘，俾有效輔助使用者掌握各項資訊。

關鍵字

差勤 ； 工作流程 ； 表單

並列摘要

Most departments need to handle the miscellaneous business, such as applying applications, reminding the pending applications, querying the progress of applications, approving the applications and the statistic information of monthly applications.
Using PHP、Web Services、AJAX、XSLT、Java、XML Database and UTF-8 code to develop the distributed Web Services system, and integrate the hierarchical feature of XML data format and the normalization concept of relational database for the consistency of the data. The system provides the functions such as application status, statistic information of annual or monthly applications to let the user get the clear picture of what she or he needs. The system also reminds the user of pending applications by message notification or Email automatically, in order to avoid forgetting to deal the application and assist the user to handle each kind of information.

並列關鍵字

attendance ； work flow ； form ； xml database

參考文獻

[3] Danny Brian, The Definitive Guide to Berkeley DB XML, 2006

[22] LAMS, Leave Application Management System, 2007, http://sourceforge.net/projects/lams/

參考資料

[1] Brett McLaughlin , Mastering Ajax, Part 1: Introduction to Ajax, Dec. 2005, http://www-128.ibm.com/developerworks/xml/library/wa-ajaxintro1.html

[2] Brett McLaughlin , Mastering Ajax, Part 2: Make asynchronous requests with JavaScript and Ajax, Jan. 2006, http://www-128.ibm.com/developerworks/xml/library/wa-ajaxintro2/