01 Intro 11i

translatoryazooInternet and Web Development

Nov 12, 2013 (3 years and 9 months ago)

119 views

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
interpretation



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
-
to
-
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
-
to
-
business communication



Writing of smart agents



The ability to perform smart searches

A sample XML

document:




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
translation.

When using XML, you can receive XML
-
tagged data from your system, and you can receive XML
-
tagged
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:

1.

The
XML language speci
fication

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


2.

A
document type definition (DTD)

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

3.

XML Namespaces

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

4.

The
XML Path Language (XPath)

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


5.


An
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.


6.

The
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

Development
Tools and Frameworks:

Oracle XML Database (XDB), Oracle JDeveloper 10
g
, 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
g

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

Database Storage:
In Oracle Da
tabase 10
g
,

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
g
:

Oracle XDK 10
g

is available in Oracle JDeveloper 10
g
, Oracle
Application Server 10
g,

and Oracle Database 10
g
. 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:



Nonprogrammatically



Programmatically



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
g
.
The Oracle

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

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
g

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
g

for creating, editing, and validating XML documents



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



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



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

Middle
-
tier Software



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




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
g

with the Oracle
XML/DB features installed and enabled



ORA
x

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



Invoices



Purchase orders



Sale
s orders



Contracts



Government forms



Tax forms



Marketing materials



XML



EDI/EFT (eText documents)




Example: Financial Reports





Example: Business Reports







Example:
Invoices



Example: Purchase Orders


























Example: Sales O
rders





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
loy



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
tatements



Government forms



Marketing materials



Contracts



Checks



Labels



XML



EFT/EDI



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
ports



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







Class
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



Flexibility



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
.



Ora
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




E
-
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




Stream
-
based implementation



Reduced memory footprint



Ability to handle large XML input files



The fastest XSL
-
FO implementation

Security




Printing from MS Excel is not accepted by financial auditors.



PDF security le
vels for:



Read
-
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:



CJK



BiDi



Unicode



MLS


Language Support





Translation


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