Scenario 2. Content and Document Management: Delivering Personalized Information Using Oracle XML

Problem. A large news distributor receives data from various news sources. This data must be stored in a database and sent to all the distributors and users on demand so that they can view specific and customized news at any time, according to their contract with the news distributor. The distributor uses XSL to normalize and store the data in a database. The stored data is used to back several websites and portals. These websites and portals receive HTTP requests from various wired and unwired clients.

• Solution: Use XSL stylesheets in conjunction with the XSQL Servlet to dynamically deliver appropriate rendering to the requesting service. See Figure 2-3.

• Main Tasks Involved. These are the main tasks involved in Scenario 2:
  1. Data model for database schema is designed for optimum output.

  2. XSL Stylesheets are created for each information source to transform to normalized format. It is then stored in the database.

  3. XSL Stylesheets are created along with XSQL pages to present the data on a web site.

  See also Chapter 6, "Customizing Content with XML: Dynamic News Application".

• Oracle XML Used:
  • XML Parser for Java v2

  • XML-SQL Utility (XSU)

  • XSQL Servlet

Figure 2-3 Scenario 2. Using XML to Deliver Customized News Information