01 Intro 11i

translatoryazooInternet και Εφαρμογές Web

12 Νοε 2013 (πριν από 8 χρόνια και 3 μήνες)

408 εμφανίσεις

01 Intro 11i

Extensible Markup Language

Extensible Markup Language (XML) describes data objects called XML documents that are composed
of markup and data.

Extensible Markup Language

XML describes data objects called XML documents that:

Are comp
osed of markup language for structuring the document data

Support custom tags for data definition, transmission, validation, and

Have become a standard way to describe data on the Web

Are processed by XML processors

XML was developed by an X
ML working group headed by the World Wide Web Consortium (W3C) with
the following design goals:

XML is usable over the Internet.

It supports a wide variety of applications.

It is compatible with Standard Generalized Markup Language (SGML).

XML can be proce
ssed using easy
write programs.

It has a minimum number of optional features.

XML is human
legible and reasonably clear.

XML enables quick design preparation.

It enables formal and concise design.

The XML documents are easy to create.

The XML document
s can be verbose.

Advantages of Using XML

XML enables:

A simple and extensible way to describe data

The ability to interchange data

Simplified business
business communication

Writing of smart agents

The ability to perform smart searches

A sample XML


Advantages of Using XML

XML’s strongest point is its ability to perform data interchange. Because different groups of people
rarely standardize on a single set of tools, it takes a significant amount of work for two groups to
communicate. XM
L makes it easy to send structured data across the Web so that nothing gets lost in

When using XML, you can receive XML
tagged data from your system, and you can receive XML
data from another system. Neither of the users has to know ho
w the other user’s system is organized. If
another partner or supplier teams up with your organization, you do not have to write code to exchange
data with their system. You simply require them to follow the document rules defined in the DTD. You
can also
transform those documents using XSLT.

When writing an agent, one of the challenges is to make sense of incoming data. A good agent
interprets information intelligently, and then responds to it accordingly. If the data sent to an agent is
structured with XM
L, it is much easier for the agent to understand exactly what the data means and how
it relates to other pieces of data it may already know.

XML Standards

XML Standards

The following XML standards are covered in this course:


XML language speci

defines the rules that govern XML document structure, and
how XML processors must read them.


document type definition (DTD)

provides the definition and relationships of elements
contained in an XML document. A DTD validates an XML document.


XML Namespaces

provide a mechanism to distinguish elements with the same name but
different definitions used in the same XML document.


XML Path Language (XPath)

provides syntax for searching an XML Document. XPath
expressions are used in an XSL s
tylesheet to match specific nodes.


XML Schema

provides a way to describe the XML document structure using data type
definitions and uses namespace support. XML Schema is the preferred way to validate XML documents.


Extensible Style Sheet La
nguage (XSL)

is implemented by XSL Transformations (XSLT) to
specify how to transform an XML document into another document. XSLT uses an XML vocabulary for
transforming or formatting XML documents.

Oracle XML Support

Oracle XML Support

Tools and Frameworks:

Oracle XML Database (XDB), Oracle JDeveloper 10
, Oracle
Internet File System (iFS), Oracle Application Development Framework (ADF) in JDeveloper, Oracle
Portal, Oracle Application Server Reports Services, and Oracle Dynamic Services
can be used to build
XML applications.

Database and Middle
Tier Frameworks:
Oracle Application Server 10

provides the environment for the
XSQL Pages framework, J2EE services which support XML applications, and Web Services.

Database Storage:
In Oracle Da
tabase 10

the Oracle XDB enables XML documents to be stored in and
retrieved from relational tables, XMLType columns, and character large object (CLOB) types. Oracle Text
(interMedia Text) can be used to efficiently search XML documents stored in XMLType

or CLOB columns.

Oracle XML Developer’s Kit (XDK) 10

Oracle XDK 10

is available in Oracle JDeveloper 10
, Oracle
Application Server 10

and Oracle Database 10
. Oracle XDK provides the following components, tools
and utilities:

XML Parsers, XSLT Proce
ssors, XSLT VM, XML Schema processors

XML Java Beans, XML Class Generator, XSQL Servlet, XML SQL Utility (XSU)

XML Pipeline Processor, TransX Utility

Building XML Applications with Oracle Technology

An XML application is an application process that oper
ates on XML data, either stored in or
generated from some data source.

Oracle XML applications can be built in one of the following ways:



Building an XML Application with Oracle Technology

The diagram illustrates wh
ere an XML application processing XML data (solid lines) can run (dotted lines)
on the client, middle tier, or the database. The data may also reside in the Oracle database in XML or
relational form.

XML Applications Without Programming

Oracle XML Develope
r’s Kit (XDK) provides components, such as the XSQL servlet, which process XSQL
pages containing SQL statements and generate a result containing database data in an XML format. The
XSQL servlet can be installed on any Java
enabled Web server, such as Oracl
e Application Server 10
The Oracle

DBUri servlet provides a browser
based interface for easy retrieval and transformation of
data stored in an Oracle Database 10

XML Applications by Using Programming

Applications can be developed with the APIs provided

by the Oracle XDK. Web applications, developed
with JDeveloper, can use JDBC to connect with an Oracle database to create powerful yet relatively
simple data
driven XML applications.

Oracle Database 10

has inbuilt features for storing, manipulating, tran
sforming and validating XML
data. These features are accessible through the Oracle XDK and XML functionality available to SQL and
PL/SQL services in the database.

Course Environment and Data

Course Environment and Data

Client Software

Oracle JDeve
loper 10

for creating, editing, and validating XML documents

SQL*Plus or SQL*Plus to execute SQL or PL/SQL operations on the database

Oracle XML Developer's Kit and Utilities for command
line processing

Java classes that use the Oracle XM
L Parser:


The TestXPath class to test XPath expressions on XML documents


The ShowXmlNS class to display the effects of using XML Namespaces

Oracle BI Publisher Desktop

tier Software

Production environments will run the XSQL servlet in Oracle Applica
tion Server

Development environments, as in this course, use JDeveloper’s embedded J2EE
Container to run the middle
tier software in the client.

Analytic integration provided by Oracle BI Server.

Database Software

Oracle Database 10

with the Oracle
XML/DB features installed and enabled


schemas that hold copies of the data from the HR Oracle Sample Schema.

An Oracle E
Business Suite 11.5.10 CU2 or later instance.

What Can Oracle BI Publisher Do?

Business reports


Purchase orders

s orders


Government forms

Tax forms

Marketing materials


EDI/EFT (eText documents)

Example: Financial Reports

Example: Business Reports


Example: Purchase Orders

Example: Sales O

Example: Contracts

Example: Government Forms

Example: Tax Forms

Example: Marketing Materials

Example: XML

Example: EDI/EFT

Why Oracle BI Publisher?

Removes complexity

Reduces time to develop, test, and dep

Reduces total cost, including maintenance

Increases developer productivity

Enables flexible customizations

Follows Oracle’s development standards

Enables ease of use

Document Management Requirements

Rich formatted reports

Partner reports

Financial s

Government forms

Marketing materials






Multiple destinations

Oracle BI Publisher

Oracle BI Publisher has the capability to perform the following tasks in all the formats of
your business requirements:

Author re

Manage reports

Deliver reports

Classic Reporting Tool Issues

Mimic report requirements:

Must be the same geometry, font, margin size, and so on

Classic Reporting Tool Issues

More requirements

Classic Reporting Tool Issues

ic Reporting Tool Issues

1 data set : 10 layouts : 30 languages >> 300 reports

Requires highly
skilled engineers for customization

Within the eBusiness Suite, reporting, prior to Oracle BI Publisher, was accomplished using Oracle
Reports. The definiti
ons used by Oracle Reports are kept in Report Definition Files (RDF).

Classic Reporting Tool Issues

High development cost

High customization cost

Difficult upgrade

OracleBI Publisher: Advantages

Separate data/layout/UI translation


Reduced maintenance

OracleBI Publisher: Advantages

Business consultants use familiar desktop tools for layout customization

Support for multiple data sources

OracleBI Publisher: Advantages

OracleBI Publisher: Advantages

One Template,
Multiple Sources

RTF templates are converted to XSL
FO, and then formatted to multiple outputs.

OracleBI Publisher: Advantages

Government Sources

Download PDF forms from the government Web site.

Send back the exact form filled with data

cleBI Publisher: Advantages

Extract Once, Publish Many Times

OracleBI Publisher: Advantages

Batch Processing, XML APIs

OracleBI Publisher: Advantages

Inbound Document Capture

Inbound documents converted to XML and fed back to database

Business Suite Uses Oracle BI Publisher

Oracle BI Publisher Technology

Open standard technologies

W3C XSL:FO implementation

Pure Java

Pluggable data in XML

Output formats in PDF, RTF, HTML, and others

Support for Internet Printing Protocol, Web
DAV, Internet Fax Protocol, and SMTP

Oracle BI Publisher Technology

Users can design layout templates using familiar desktop applications such as Adobe Acrobat and MS
Word, there are now many XSL editors available on the market for the user to take adv
antage of.

Performance and Scalability

based implementation

Reduced memory footprint

Ability to handle large XML input files

The fastest XSL
FO implementation


Printing from MS Excel is not accepted by financial auditors.

PDF security le
vels for:

only/editable text

Copyable text

Printable text

Password protecting text

Language Support

Expensive language
specific printers are not needed.

The full set of Unicode fonts is included.

Scalable fonts can be embedded with CID mapping tables

Oracle BI Publisher supports:





Language Support


Communicate with partners around the world.

No dependency on installed languages

No dependency on database character set

Create a template for any language/territory

Translate template or send to third party

Support for XLIFF (XML Localization Interchange File Format)

Recognizes any combination of:

185 language codes

244 territory codes