Abstract: In a world where key data of a task is stored in different heterogeneous sources, the Extensible Markup Language (XML) a standard format provides a powerful mechanism for data exchange between different applications and integration between different systems.
XML has been tightly integrated into Microsoft & reg; SQL Server & #8482; relational database management system (RDBMS) to help developers build next-generation Web and enterprise applications. This white paper describes the XML functions in SQL Server 2000 and their comparison with those in Oracle.
Why integration of XML and RDBMS?
XML supports information exchange in the following commercial scenarios:
Enterprise-to-Enterprise (B2B)
The integrated supply chain of different suppliers.
Enterprise-to-consumer (B2C)
Browser-based applications that require data retrieval from databases.
Enterprise
Integration, such as enterprise resource planning (ERP) and customer relationship management (CRM) software from different vendors.
These business scenarios require the following XML functions for information exchange:
Commercial systems with loose ING.
SQL Server 2000 provides an XML view for relational data through the XML view, XPath query, and SELECT statements. The ing from XML data to relational tables is provided using the OPENXML and annotation architecture.
Secure HTTP connection to the database.
Query, update, and load XML data from any source.
SQL Server 2000 provides URLs and Microsoft ole db providers for SQL Server (SQLOLEDB) and Microsoft ActiveX & reg; data object (ADO) access data stored in SQL Server.
XML providers in SQL Server 2000
Microsoft & reg; SQL Server & #8482; 2000 is a highly scalable and reliable platform for building XML-based applications. SQL Server 2000 provides the following XML functions:
HTTP access
The new SELECT statement option (for xml) used to retrieve results in XML format)
XML mode
XML view
XPath query
OPENXML
Ole db and ADO access
HTTP access
Microsoft & reg; SQL Server & #8482; 2000 provides three methods for accessing data through HTTP:
SQL statement at URL
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
