:::

詳目顯示

回上一頁
題名:整合型企業大型資料庫及其更新機制建置之實務研究--以我國疾病管制局NIIS整合型中央資料庫建置為例
書刊名:資訊管理學報
作者:邱瑞科陳聖棋詹前隆 引用關係翁頌舜 引用關係顏哲傑張啟明
作者(外文):Chiu, Ruey-keiChen, Sheng-chiChan, Chien-lungWeng, Sung-shunYen, Che-chiehChang, Chi-ming
出版日期:2004
卷期:11:4
頁次:頁51-76
主題關鍵詞:整合型企業資料庫全國預防接種資訊管理系統分散式資料庫系統中繼資料更新機制Integrated enterprise databaseNational immunization information systemDistributed databaseMetadataRefresh mechanism
原始連結:連回原系統網址new window
相關次數:
  • 被引用次數被引用次數:期刊(1) 博士論文(0) 專書(0) 專書論文(0)
  • 排除自我引用排除自我引用:0
  • 共同引用共同引用:0
  • 點閱點閱:41
我國行政院衛生署疾病管制局執行國內疾病預防及維護國人保健防疫的工作,多年來即對國人自嬰幼兒開始,由基層衛生局所及合約醫療院所實施多種預防接種措施,並將預防接種分別記錄於其所屬縣市衛生局的全國預防接種資訊管理系統(National Immunization Information System, NIIS)資料庫中,為了更有效推動預防接種之工作成效,疾病管制局著手建置一個在中央集中控管的整合型全國預防接種中央資料庫系統。 本研究提出一個有效建置全國預防接種整合型中央資料庫系統及其更新問題解決的機制,從不同層面考量,提供以跨資料庫間的資訊整合架構為重要目的,將分散於各縣市衛生局、衛生所之預防接種相關資料庫進行整合並建置一個有效支援預種管理及決策分析之中央資料庫。系統雛型建置測試顯示,資料庫選擇性複製策略在運作上兼具系統整體效能及儲存成本;透過中繼資料處理對應交易紀錄檔之更新機制的自動化處理更提高了資料使用效益與資料取得效率,其效率對微軟之SQL資料庫管理系統進行標竿測試比較結果,在少量資料更新時,雖稍有遜色,但當資料量超過某一數量時,其效率則有超越之勢,但兩者並無明顯的差異。建置完成後,其效益評估顯示,它不僅可提供全國性預防接種快速進行統計分析的資訊化管理功能,更可對疫苗採購庫存管理及配送之最佳化規劃提供最完整的資料來源。
In order to prevent national disease and maintain national health, Center for Disease Control (CDC), Department of Health, Executive Yuan, operates the mission of national immunization during the last decades. Currently, the immunization records of each individual are centrally recorded in the database of National Immunization Information System (NIIS) located at each country's and city's bureau of health. CDC attempts to implement a centralized and integrated database for NIIS to more effectively promote and operate the tasks of national preventive immunization. In this research, we present our implementing experience of building the integrated Central Database with its refresh mechanism for NIIS. The objective of this study is to provide an integrated central database implementing and refreshing framework to integrate inoculation relative databases that are distributed over and located at each bureau of health. The resulting benefits show that the system implementation of adopting a selective replication strategy for database design could have the advantages on both effectively enhancing system performance and reducing the computer storage cost. In additions, by using transaction logs with metadata mapping to build an automatic refresh mechanism could obtain better result of enhancing the data utilization and efficiency of data retrieval. We also conduct the benchmark testing with Microsoft SQL Server. The result shows when the transaction data are small, the refresh efficiency of our mechanism is a little bit worse, however, when transaction data are larger than a certain amount, our mechanism is apparently better than Microsoft SQL Server, but two systems have no significant difference. After completing the implementation, the central database may provide the functions of promptly generating the statistical analysis for national immunization, enhancing the completion rate of immunization, and conducting the optimal planning for vaccine procurement, inventory management, and distribution.
期刊論文
1.邱瑞科、Boe, W. J.(1995)。An Efficient Refresh Mechanism for Distributed Views: Analytic Modeling and Cost Analysis。資管評論,5。  new window
2.Amoroso, D. L.、Atkinson, J.、Secor, S.(1993)。A Study of the Data Management Construct: Design, Construction, and Utilization。System Science,4,490-499。  new window
3.Delis, A.、Roussopoulos, N.(1998)。Techniques for Update Handling in the Enhanced Client-Server DBMS。IEEE Transactions on Knowledge and Data Engineering,10(3),458-476。  new window
4.Franklin, M. J.、Carey, M. J.、Livny, M.(1997)。Transactional Client-Server Cache Consistency: Alternatives and Performance。ACM Transactions on Database Systems,22(3),315-363。  new window
5.Gray, J.、Pat, H.、O'Neil, P.、Shasha, D.(1996)。The Dangers of Replication and a Solution。ACM Proceedings SIGMOD,25(5),173-182。  new window
6.Lindsay, B. G.、Haas, L.、Mohan, C.、Pirahesh, H.、Wilms, P.(1986)。A Snapshot differential Refresh Algorithm。ACM Proceedings SIGMOD,15(2),53-60。  new window
7.Pacitti, E.、Simon, E.(2000)。Update Propagation Strategies to Improve Freshness in Lazy Master Replicated Databases。The Very Large Database Journal,8,305-318。  new window
8.Roger, K.、Dennis, M.(1985)。A Database Design Methodology and Tool for Information Systems。ACM Transactions on Office Information Systems,3(1),2-21。  new window
9.Sheth, A. P.、Larson, J. A.(1990)。Federated Database Systems for Managing Distributed, heterogeneous, and Autonomous Databases。ACM Computing Surveys,22(3),183-226。  new window
10.Thomas, G.、Thompson, G. R.、Chung, C. W.、Barkmeyer, E.、Carter, F.、Templeton, M.、Fox, S.、Hartman, B.(1990)。Heterogeneous Distributed Database Systems for Production Use。ACM Computing Surveys,22(3),237-266。  new window
11.Traiger, I. L.、Gary, J.、Galtieri, C. A.(1982)。Transactions and Consistency in Distributed Database Systems。ACM Transactions on Database Systems,7(3),323-342。  new window
會議論文
1.邱瑞科、陳盛儀、詹前隆、翁頌舜(2003)。全國性預防接種疫苗採購預測模型建立之研究。沒有紀錄。  延伸查詢new window
2.邱瑞科、詹前隆、翁頌舜、陳聖棋(2003)。NIIS管理決策輔助先導性系統規劃之研究。沒有紀錄。  延伸查詢new window
3.顏哲傑、張啟明、邱瑞科、詹前隆、翁頌舜、何文雄、周建成、陳聖棋(2002)。NIIS全國預防接種資訊管理系統。沒有紀錄。  延伸查詢new window
4.顏哲傑、張啟明、邱瑞科、詹前隆、翁頌舜、陳聖棋、陳盛儀(2002)。企業資訊倉儲化之決策應用-以NIIS為例。沒有紀錄。  延伸查詢new window
5.顏哲傑、詹前隆、張啟明、邱瑞科、翁頌舜、簡榮廷、江鴻屏(2003)。全國性預防接種管理系統之資訊探勘應用-以嬰幼兒疫苗接種失約人口分群為例。沒有紀錄。  延伸查詢new window
6.Adiba, M. E.、Lindsay, B. G.(1980)。Database Snapshots。Montreal, Canada。86-91。  new window
7.Gamal-Eldin, M. S.、Thomas, G.、Elmasri, R.(2000)。Integrating Relational Databases with Support for Updates。沒有紀錄。202-209。  new window
8.Novak, D.、Fry, J.(1976)。The State of the Art of logical Database Design。Long Beach, CA。30-39。  new window
學位論文
1.倪正耀(1994)。分散式資料庫系統測試檯,沒有紀錄。  延伸查詢new window
2.張明惠(1986)。中央控制的分散式資料庫管理系統,沒有紀錄。  延伸查詢new window
圖書
1.何文雄、周建成(2001)。行政院衛生署疾病管制局全國性預防接種系統規格書。行政院衛生署疾病管制局全國性預防接種系統規格書。沒有紀錄:財團法人資訊工業策進會電子商務應用推廣中心。  延伸查詢new window
2.Connolly, T.、Begg, C.、Strachan, A.(1998)。Database Systems--A Practical Approach to Design, Implementation, and Management。Addison-Wesley。  new window
3.何文雄(2000)。行政院衛生署整合型衛生所PHIS視窗版發展計畫書。行政院衛生署整合型衛生所PHIS視窗版發展計畫書。沒有紀錄。  延伸查詢new window
4.宋鎧、范錚強、郭鴻志、陳明德、季延平(2001)。管理資訊系統。臺北:華泰文化圖書公司。  延伸查詢new window
5.施威銘(2001)。SQL Server 2000管理與設計實務。SQL Server 2000管理與設計實務。臺北。  延伸查詢new window
6.Date, C. J.、黃加佩(1997)。資料庫系統概論。臺北:儒林圖書公司。  延伸查詢new window
7.陳長念(2003)。XML與資料庫Web應用實務。XML與資料庫Web應用實務。臺北。  延伸查詢new window
8.曾守正、周韻寰(1999)。資料庫系統之理論與進階實務。資料庫系統之理論與進階實務。臺北。  延伸查詢new window
9.Soukup, R.、Dalaney, K.、楊尊一(2000)。完全剖析Microsoft SQL Server 7.0。完全剖析Microsoft SQL Server 7.0。臺北。  延伸查詢new window
10.Adrienne, T.(2001)。Metadata Solutions。Metadata Solutions。沒有紀錄。  延伸查詢new window
11.Ponniah, P.(2001)。Data Warehousing Fundamentals - A Comprehensive Guide for IT Professionals。Data Warehousing Fundamentals - A Comprehensive Guide for IT Professionals。沒有紀錄。  new window
 
 
 
 
第一頁 上一頁 下一頁 最後一頁 top