Information Systems Reengineering, Integration and Normalization: Heterogeneous Database Connectivity
暫譯: 資訊系統重構、整合與正規化：異質資料庫連接性
Fong, Joseph S. P., Wong Ting Yan, Kenneth
相關主題
商品描述
Database technology is an important subject in Computer Science. Every large company and nation needs a database to store information. The technology has evolved from file systems in the 60's, to Hierarchical and Network databases in the 70's, to relational databases in the 80's, object-oriented databases in the 90's, and to XML documents and NoSQL today. As a result, there is a need to reengineer and update old databases into new databases. This book presents solutions for this task.
In this fourth edition, Chapter 9 - Heterogeneous Database Connectivity (HDBC) offers a database gateway platform for companies to communicate with each other not only with their data, but also via their database. The ability of sharing a database can contribute to the applications of Big Data and surveys for decision support systems. The HDBC gateway solution collects input from the database, transfers the data into its middleware storage, converts it into a common data format such as XML documents, and then distributes them to the users. HDBC transforms the common data into the target database to meet the user's requirements, acting like a voltage transformer hub. The voltage transformer converts the voltage to a voltage required by the users. Similarly, HDBC transforms the database to the target database required by the users.
This book covers reengineering for data conversion, integration for combining databases and merging databases and expert system rules, normalization for eliminating duplicate data from the database, and above all, HDBC connects all legacy databases to one target database for the users.
The authors provide a forum for readers to ask questions and the answers are given by the authors and the other readers on the Internet.
商品描述(中文翻譯)
資料庫技術是計算機科學中的一個重要主題。每個大型公司和國家都需要一個資料庫來儲存資訊。這項技術從1960年代的檔案系統演變到1970年代的階層式和網路資料庫，再到1980年代的關聯式資料庫，1990年代的物件導向資料庫，以及今天的XML文件和NoSQL。因此，有必要將舊資料庫重新設計和更新為新資料庫。本書提供了這項任務的解決方案。
在這第四版中，第9章 - 異構資料庫連接（HDBC）為公司提供了一個資料庫閘道平台，使它們不僅能夠通過數據進行交流，還能通過其資料庫進行交流。共享資料庫的能力可以促進大數據應用和決策支持系統的調查。HDBC閘道解決方案從資料庫收集輸入，將數據轉移到其中介儲存，轉換為通用數據格式，如XML文件，然後將其分發給用戶。HDBC將通用數據轉換為目標資料庫，以滿足用戶的需求，類似於電壓變壓器中心。電壓變壓器將電壓轉換為用戶所需的電壓。同樣，HDBC將資料庫轉換為用戶所需的目標資料庫。
本書涵蓋了數據轉換的重新設計、整合以結合資料庫和合併資料庫及專家系統規則、正規化以消除資料庫中的重複數據，以及最重要的，HDBC將所有舊資料庫連接到一個目標資料庫供用戶使用。
作者提供了一個論壇，讓讀者可以提出問題，並由作者和其他讀者在互聯網上給予回答。
作者簡介
Joseph Fong taught at City University of Hong Kong in Computer Science for 27 years and as a database researcher. He published many journal papers in data conversion management: file to database, database to database, database integration, database normalization, expert database systems, and one universal database for all legacy databases. He had been chairman of Database Special Interest group of Hong Kong Computer Society for a decade, and owner of two US patents on Universal database and Internet-based database interoperability. His PhD thesis was on database transformation. This book covers his major database theories and practice. Joseph is also interested in eLearning and is the founding chairman of International Hybrid Learning Society.
Kenneth Wong is an IT engineer and researcher. He graduated at City University of Hong Kong as a M.Phil. student by doing research in universal database. He was also a database administrator in a hosiptal in Hong Kong. He has been working as I.T. Practitioner in International Hybrid Learning Society since June 2016. He is a computer professional in web design technology and I.T in education. Now, he specializes in system and networking migration projects for world-wide companies.
作者簡介(中文翻譯)
約瑟夫·方（Joseph Fong）在香港城市大學教授計算機科學達27年，並擔任資料庫研究員。他在資料轉換管理方面發表了許多期刊論文，包括檔案轉資料庫、資料庫轉資料庫、資料庫整合、資料庫正規化、專家資料庫系統，以及一個通用資料庫以支援所有舊有資料庫。他曾擔任香港計算機學會資料庫特別興趣小組的主席十年，並擁有兩項美國專利，分別涉及通用資料庫和基於網際網路的資料庫互操作性。他的博士論文是關於資料庫轉換。本書涵蓋了他的主要資料庫理論和實踐。約瑟夫也對電子學習感興趣，並且是國際混合學習協會的創始主席。
黃建德（Kenneth Wong）是一位IT工程師和研究員。他在香港城市大學以M.Phil.學生身份畢業，研究主題為通用資料庫。他曾在香港的一家醫院擔任資料庫管理員。自2016年6月以來，他一直在國際混合學習協會擔任IT從業人員。他是一位專業的計算機專家，專注於網頁設計技術和教育中的IT。目前，他專注於全球公司的系統和網路遷移專案。
