XML has recently established itself as the standard for representing data in scientific and business applications and the standard for exchanging data among applications on the Web. We therefore regard XML-related research as the most promising and challenging direction for the community of database researchers. But, it is noticed that most business data, even for new web-based applications, have and will be stored in relational databases, because relational databases can offer effective, perfect and user-familiar functions. This has created the requirement of exchanging business data in XML among applications based on relational database systems. Under the drive of requirement and technology, how to resolve the question of storing XML data by using an RDB and publishing relational data as an XML document is a hotspot. This paper addresses these issues.In this paper, we firstly present an introduction to XML-related technology and heterogeneity between XML and relational databases. Then we focus on the techniques of storing and publishing XML based on an RDB in academe. Next we introduce and review XML support for data exchange in commercial DBMSs( Oracle, DB2, SQL Server), which comes from industrial community. Then we have developed anapplication with commercial DBMSs in eBusiness domain--online bookstoreretailer's system and supplier's system. Finally, we conclude and forecast the perspectives of this domain.
|