Distributed query processing for structured and bibliographic databases

• Main Authors: LIM, Ee Peng, LU, Ying
• Format: text
• Language: English
• Published: Institutional Knowledge at Singapore Management University 1997
• Subjects: Digital libraries; Internet databases; Interoperable databases; Databases and Information Systems; Numerical Analysis and Scientific Computing
• Online Access: https://ink.library.smu.edu.sg/sis_research/920; https://ink.library.smu.edu.sg/context/sis_research/article/1919/viewcontent/c16f4e187c398aa4110898a00b8a5fbcc30d.pdf
• Institution: Singapore Management University

To support future digital library systems which draw information from different sources on the internet, we have to provide integrated queries to pre-existing database servers which contain structured, semi-structured and unstructured data. In this paper, we specifically examine the problem of querying both existing structured relational databases and bibliographic databases. By adopting the well-accepted Z39.50 standard protocol to access bibliographic databases in different legacy library systems, we have developed an extended SQL model, known as HarpSQL, to support integrated queries to both SQL databases and bibliographic databases. Using HarpSQL, one can not only query bibliographic databases in an SQL manner, but also perform join(s) between SQL and bibliographic databases. A distributed query processor supporting HarpSQL queries has been developed. We will present our query processing strategy that is based on client-server interaction model between the distributed query processor and the various remote database servers.