System RX: one part relational, one part XML

  • Authors:
  • Kevin Beyer;Roberta J. Cochrane;Vanja Josifovski;Jim Kleewein;George Lapis;Guy Lohman;Bob Lyle;Fatma Özcan;Hamid Pirahesh;Normen Seemann;Tuong Truong;Bert Van der Linden;Brian Vickery;Chun Zhang

  • Affiliations:
  • IBM Almaden Research Center, San Jose CA;IBM Almaden Research Center, San Jose CA;IBM Almaden Research Center, San Jose CA;IBM Silicon Valley Lab, San Jose CA;IBM Silicon Valley Lab, San Jose CA;IBM Almaden Research Center, San Jose CA;IBM Silicon Valley Lab, San Jose CA;IBM Almaden Research Center, San Jose CA;IBM Almaden Research Center, San Jose CA;IBM Silicon Valley Lab, San Jose CA;IBM Silicon Valley Lab, San Jose CA;IBM Silicon Valley Lab, San Jose CA;IBM Silicon Valley Lab, San Jose CA;IBM Almaden Research Center, San Jose CA

  • Venue:
  • Proceedings of the 2005 ACM SIGMOD international conference on Management of data
  • Year:
  • 2005

Quantified Score

Hi-index 0.00

Visualization

Abstract

This paper describes the overall architecture and design aspects of a hybrid relational and XML database system called System RX. We believe that such a system is fundamental in the evolution of enterprise data management solutions: XML and relational data will co-exist and complement each other in enterprise solutions. Furthermore, a successful XML repository requires much of the same infrastructure that already exists in a relational database management system. Finally, XML query languages have considerable conceptual and functional overlap with relational dataflow engines. System RX is the first truly hybrid system that comingles XML and relational data, giving them equal footing. The new support for XML includes native support for storage and indexing as well as query compilation and evaluation support for the latest industry-standard query languages, SQL/XML and XQuery. By building a hybrid system, we leverage more than 20 years of data management research to advance XML technology to the same standards expected from mature relational systems.