Abstract
We study the data integration and restructuring issues of tabular data. We consider the case where the same set of data is collected from independent sites, stored in different DBMSs or other repositories, organized in different tabular or equivalent semi-structured formats, and published on the web. These sites transform tabular data into XML data with possible syntactic discrepancies in their original tabular structures. Data integration refers to the task of creating an integrated XML view with a pre-specified format by restructuring and integrating different XML documents. Existing XML query algebras are not sufficient for tabular conversions. We propose the XML-T model and the restructuring and integration operators for tabular data. We show with examples the uses of our operators to create “views".
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsPreview
Unable to display preview. Download preview PDF.
References
Christophides, V., et al.: On Wrapping Query Languages and Efficient XML Integration. ACM SIGMOD 2000 (2000)
Fankhauser, P. (ed.): XQuery 1.0 Formal Semantics. W3C XML Query Working Gr. Note (2002)
Naughton, J. (ed.): The Niagara Internet Query System. IEEE Data Eng. Bulletin 24(2)
Gyssens, M. et al: Tables As a Paradigm for Querying and Restructuring. ACM PODS 1996 (1996)
Jagadish, H., Lakshmanan, L., Srivastava, D., Thompson, K.: TAX: a Tree Algebra for XML. In: Proc. DBPL Conf., Rome, Italy (2001)
Krishnamurthy, L., Nadeau, J., Ozsoyoglu, G., Ozsoyoglu, M. (ed.): Pathways database system: an integrated system for biological pathways. Bioinformatics (2003)
Lin, J., Ozsoyoglu, M.: Processing OODB Queries by O-algebra. In: CIKM 1996 (1996)
Madhavan, J., Bernstein, P., Rahm, E.: Generic Schema Matching with Cupid. In: Proc. Of VLDB Conf., Rome, Italy (2001)
Ross, M., Korth, H., Silberschatz, A.: Extended Algebra and Calculus for –1NF Relational Databases. ACM TODS 13(4) (1988)
Shaw, G., Zdonik, S.: A Query Algebra for Object Oriented Databases. In: IEEE ICDE Conf. (1990)
Yu, W., Ozsoyoglu, M., Ozsoyoglu, G.: XML-T Algebra Operators and Implementation Issues. Tech. Report Case Western Reserve University, Cleveland, U.S.A (2002)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2003 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Yu, W., Ozsoyoglu, Z.M., Ozsoyoglu, G. (2003). XML Restructuring and Integration for Tabular Data. In: Mařík, V., Retschitzegger, W., Štěpánková, O. (eds) Database and Expert Systems Applications. DEXA 2003. Lecture Notes in Computer Science, vol 2736. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-45227-0_24
Download citation
DOI: https://doi.org/10.1007/978-3-540-45227-0_24
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-40806-2
Online ISBN: 978-3-540-45227-0
eBook Packages: Springer Book Archive