Abstract
Managing semistructured data requires more flexibility than traditional database systems provide. Recently we proposed a query language for semistructured data represented as labeled directed graphs. This language is based on matching a partial schema into the database. In this paper we describe how we achieve this matching using constraints. We show how to match a schema into a database without using any additional information. In order to match schemata more efficiently, we are able to incorporate results of previously matched schemata. To this end, we formulate a sufficient condition for schema containment and describe how to test this condition, again, using constraints. We show how the knowledge of schema containment can be used for optimization. As a theoretical contribution we prove that, under some circumstances, schema matches can be found without any backtracking and in polynomial time.
This research was done while André Bergholz was at Humboldt-University Berlin. It was supported by the German Research Society, Berlin-Brandenburg Graduate School in Distributed Information Systems (DFG grant no. GRK 316). André Bergholz is now supported by the German Academic Exchange Service (DAAD program HSP III).
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
S. Abiteboul. Querying semi-structured data. In Proceedings of the International Conference on Database Theory (ICDT), pages 1–18, Delphi, Greece, January 1997.
P. Atzeni, G. Mecca, and P. Merialdo. To weave the web. In Proceedings of the International Conference on Very Large Databases (VLDB), pages 206–215, Athens, Greece, August 1997.
AQM+97._S. Abiteboul, D. Quass, J. McHugh, J. Widom, and J. Wiener. The Lorel query language for semistructured data. Journal of Digital Libraries, 1(1):68–88, 1997.
A. Aho, Y. Sagiv, and J. D. Ullman. Equivalence of relational expressions. SIAM Journal on Computing, 8(2):218–246, 1979.
R. Bartak. Constraint programming: In pursuit of the holy grail. In Proceedings of the Week of Doctoral Students (WDS), Prague, Czech Republic, June 1999.
P. Buneman, S. Davidson, G. Hillebrand, and D. Suciu. A query language and optimization techniques for unstructured data. In Proceedings of the ACM SIGMOD International Conference on Management of Data, pages 505–516, Montreal, Canada, June 1996.
A. Bergholz and J. C. Freytag. Querying semistructured data based on schema matching. In Proceedings of the International Workshop on Database Programming Languages (DBPL), Kinloch Rannoch, Scotland, UK, September 1999.
P. Buneman. Semistructured data. In Proceedings of the Symposium on Principles of Database Systems (PODS), pages 117–121, Tucson, AZ, USA, May 1997.
M. J. Carey and D. Kossmann. On saying “Enough Already!” in SQL. In Proceedings of the ACM SIGMOD International Conference on Management of Data, pages 219–230, Tucson, AZ, USA, May 1997.
S. A. Cook. The complexity of theorem-proving procedures. In Proceedings of the ACM Symposium on Theory of Computing, pages 151–158, Shaker Heights, OH, USA, May 1971.
ECLiPSe-The ECRC Constraint Logic Parallel System, http://www.ecrc.de/eclipse/.
FFK+98._M. Fernandez, D. Florescu, J. Kang, A. Levy, and D. Suciu. Catching the boat with Strudel: Experiences with a web-site management system. In Proceedings of the ACM SIGMOD International Conference on Management of Data, pages 414–425, Seattle, WA, USA, June 1998.
D. Florescu, A. Levy, and D. Suciu. Query containment for conjunctive queries with regular expressions. In Proceedings of the Symposium on Principles of Database Systems (PODS), pages 139–148, Seattle, WA, USA, June 1998.
E. Freuder. A sufficient condition for backtrack-free search. Journal of the ACM, 29(1):24–32, 1982.
A. K. Mackworth. Consistency in networks of relations. Artificial Intelligence, 8(1):99–118, 1977.
J. McHugh, and J. Widom. Query optimization for XML. In Proceedings of the International Conference on Very Large Databases (VLDB), pages 315–326, Edinburgh, Scotland, UK, September 1999.
M. Rudolf. Utilizing constraint satisfaction techniques for efficient graph pattern matching. In Proceedings of the International Workshop on Theory and Application of Graph Transformations (TAGT), Paderborn, Germany, November 1998.
A. Zuendorf. A heuristic for the subgraph isomorphism problem in executing PROGRES. Technical Report AIB 93-5, RWTH Aachen, Aachen, Germany, 1993.
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2000 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Bergholz, A., Freytag, J.C. (2000). Managing Schemata for Semistructured Databases Using Constraints. In: Štuller, J., Pokorný, J., Thalheim, B., Masunaga, Y. (eds) Current Issues in Databases and Information Systems. ADBIS DASFAA 2000 2000. Lecture Notes in Computer Science, vol 1884. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-44472-6_3
Download citation
DOI: https://doi.org/10.1007/3-540-44472-6_3
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-67977-6
Online ISBN: 978-3-540-44472-5
eBook Packages: Springer Book Archive