Publication Type
Journal Article
Version
publishedVersion
Publication Date
1-1997
Abstract
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.
Discipline
Databases and Information Systems | Numerical Analysis and Scientific Computing
Research Areas
Data Science and Engineering
Publication
Journal of Network and Computer Applications
Volume
20
Issue
1
First Page
3
Last Page
24
ISSN
1084-8045
Identifier
10.1006/jnca.1996.0036
Publisher
Elsevier
Citation
LIM, Ee Peng and LU, Ying.
Integrated queries to existing bibliographic and structured databases. (1997). Journal of Network and Computer Applications. 20, (1), 3-24.
Available at: https://ink.library.smu.edu.sg/sis_research/8
Copyright Owner and License
Authors
Creative Commons License
This work is licensed under a Creative Commons Attribution-NonCommercial-No Derivative Works 4.0 International License.
Additional URL
https://doi.org/10.1006/jnca.1996.0036
Included in
Databases and Information Systems Commons, Numerical Analysis and Scientific Computing Commons