Abstract:XML has become the data representation standard on Internet, and widely used in data exchange and data warehouse. But the file characteristics of XML cannot guarantee the security of data and concurrent access and the precision of RDBMS theory and maturity of RDBMS can be achieved fast and concurrent access to data. The paper combines the advantages of XML and RDBMS and comes up with a XML storage resolution based on RDBMS to simplify the management of XML data and data warehouse building. It allows users to manage XML data based RDBMS transparently by using Oracle XML DB, relative to the middleware method mapping strategy. It can significantly improve the efficiency of the XML data storage.