Instant Access To 100,000+ Essays!

Microsoft SQL Server XML and Web Application Architecture Table of Contents Introduction 3 Logical Architecture 3 Physical Architecture 4 Integration 7 The Impacts 8 Recommendation for Use 8 Conclusion 9 Sources of Information 10 Introduction Microsoft SQL Server 2000 has has added many new features that SQL Server 7 did not have, among them a series of new XML technologies called SQL Server XML. This technology suite contains many improvements, enhancements, and features that make SQL Server a more Web-friendly application. SQL Server XML can be used to extend, enhance, or even replace the architecture of a Web application. The new features are comprised of two main components: 1. Database components, that allow the database to read, process, and write XML 2. SQL Server XML Internet Server API (ISAPI) application, which allows access to the database over HTTP With XML support in SQL Server 2000, you can query SQL over HTTP with a URL, bring the data down to the browser, and manipulate it on the client machine. By using Internet Explorer 5.0 and XSL to convert the XML to HTML, it is possible to lighten the load on the database ser