Integrated queries to existing bibliographic and structured databases

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

It is widely accepted that future digital library applications have to be built upon different kinds of database servers to draw upon different forms of data, including bibliographic, text, multimedia, and structured data. In this paper, the problem of integrating existing public bibliographic databases and structured databases which reside at different locations in the network is addressed. Although bibliographic data is semistructured, its attribute set is often determined by an international standard known as MARC. To unify bibliographic and structured data, the well-known SQL was extended to model bibliographic related attributes and queries. In particular, a new data type was added to model attributes in the bibliographic database. Specialized functions have also been designed that can be used to formulate queries on bibliographic data, as well as queries on both bibliographic and structured data. By combining the SQL extensions with other query language extensions that access general text data, it is believed that a versatile query language layer can be made available for future digital library application development.