关于XML和SQL的一个练习-业设计外文资料翻译.docVIP

附录 A 外文翻译-原文部分 An Exercise about XML and SQL What?This?Exercise?is?About XML is found in more and more applications today. With its non-proprietary format, XML can be used to represent and exchange information in an application. The information for most applications is stored in some fashion. A relational database is the most common location for persisting information. With databases storing information and XML used for representing information, a relationship exists between the two technologies. WebSphere Studio Application Developer has tooling that supports this relationship as well as individual relational database design tools and XML authoring tools. There are tools for working with existing databases schemas or creating new database schemas. There are also editors for specific types of XML documents. In this exercise you will use some of the XML tools and some of the features in the Data Perspective in WebSphere Studio Application Developer. User?Requirement User must have DB2(version 7.2) and WebSphere Studio Application Developer installed. The Invest database must be setup (c:\yourbank\lab5\dbsetup.bat)?and?the?source?files?used?in the lab must?be?available?at?c:\yourbank\lab5. What?You?Should?Be?Able?to?Do After completing this lab you should understand how to connect to an active database and import the schema into WebSphere Studio Application Developer. You should be able to add foreign keys to a table schema. By the end of this lab you will also be able to create SQL statements from multiple tables using the SQL statement wizard. Finally, you should be able to use the XML to SQL wizard to query the active database and return the information in an XML document. With the XML results, you will use the XML to XML mapping wizard to translate the results to another XML format. Introduction The Invest database contains three tables for storing information on stocks owned by a customer and customer contact information. To extract this information from the dat