Preface

This manual describes XBRL Extension to Oracle XML DB.

Audience

This manual is intended for developers building XBRL applications.

Documentation Accessibility

For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc.

Access to Oracle Support

Oracle customers have access to electronic support through My Oracle Support. For information, visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=info or visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.

Related Documents

For more information, see the following Oracle resources:

Oracle XML DB Developer's Guide
Oracle XML Developer's Kit Programmer's Guide

To download free release notes, installation documentation, white papers, or other collateral material, visit Oracle Technology Network (OTN). You must register online before using OTN; registration is free and can be done at

http://www.oracle.com/technetwork/community/join/overview/index.html

If you have a username and password for OTN, then you can go directly to the documentation section of the OTN Web site at

http://www.oracle.com/technetwork/documentation/

For additional information, see:

http://www.w3.org/TR/xml/ – XML (language)
http://www.xml.com/pub/a/98/10/guide0.html – XML introduction
http://www.w3.org/XML/Schema – XML Schema
http://www.w3.org/2001/XMLSchema – XML Schema
http://www.w3.org/TR/xmlschema-0/ – XML Schema: primer
http://www.w3.org/TR/xmlschema-1/ – XML Schema: structures
http://www.w3.org/TR/xmlschema-2/ – XML Schema: data types
http://www.oasis-open.org/cover/schemas.html – XML Schema
http://www.xml.com/pub/a/2000/11/29/schemas/part1.html – XML Schema
http://xml.coverpages.org/xmlMediaMIME.html – media/MIME types
http://www.w3.org/TR/xptr/ – XPointer
http://www.w3.org/TR/xpath – XPath 1.0
http://www.w3.org/TR/xpath20/ – XPath 2.0
http://www.zvon.org/xxl/XPathTutorial/General/examples.html – XPath
XML In a Nutshell, by Elliotte Rusty Harold and W. Scott Means, O'Reilly, January 2001, http://www.oreilly.com/catalog/xmlnut/chapter/ch09.html
http://www.w3.org/TR/2002/NOTE-unicode-xml-20020218/ – Unicode in XML
http://www.w3.org/TR/xml-names/ – XML namespaces
http://www.w3.org/TR/xml-infoset/ – information sets
http://www.w3.org/DOM/ – Document Object Model (DOM)
http://www.w3.org/TR/xslt – XSLT
http://www.w3.org/TR/xsl – XSL
http://www.oasis-open.org/cover/xsl.html – XSL
http://www.zvon.org/xxl/XSLTutorial/Books/Book1/index.html – XSL
http://www.w3.org/2002/ws/Activity.html – Web services
http://www.ietf.org/rfc/rfc959.txt – RFC 959: FTP Protocol Specification
ISO/IEC 13249-2:2000, Information technology - Database languages - SQL Multimedia and Application Packages - Part 2: Full-Text, International Organization For Standardization, 2000
http://java.sun.com/xml/tutorial_intro.html – XML and Java

Note:

Throughout this manual, "XML Schema" refers to the XML Schema 1.0 recommendation, http://www.w3.org/XML/Schema.

Placeholders in Oracle Database XBRL Extension Developer's Guide

The following placeholders are used in this book, in particular in Chapter 5, "Installing XBRL Extension to Oracle XML DB" and Chapter 4, "Administering XBRL Extension to Oracle XML DB".

sys_pass – System password.
xb_sys_pass – Password for database user XBRLSYS, which is the user that creates and administers all XBRL repositories.
xb_sys_ts – A tablespace for user XBRLSYS. For Oracle Database 11g Release 2 (11.2.0.2) or later, the tablespace must use automatic segment space management.
xb_sys_tmp_ts – A temporary tablespace for user XBRLSYS.
xb_rep – Name of an XBRL repository, which is also a database user name. (See "Creating an XBRL Repository".)
xb_rep_pass – Password for database user xb_rep.
xb_rep_ts – A tablespace for XBRL repository xb_rep. For Oracle Database 11g Release 2 (11.2.0.2) or later, the tablespace must use automatic segment space management.
xb_rep_idx_ts – Tablespace for the XMLIndex index storage tables for XBRL repository xb_rep.
xb_rep_tmp_ts – A temporary tablespace for XBRL repository xb_rep.
xb_protocols – Whether or not to use Oracle XML DB Repository to provide protocol access. TRUE means use it; FALSE means do not use it. If XBRL repository xb_rep is likely to contain more than 100,000 documents, then use FALSE for best performance.
obiee_home – Directory where Oracle Business Intelligence Suite Enterprise Edition (OBIEE) is installed.
obieedata_home – Directory where OBIEE data is stored.
oracle_client – Name of your Oracle client for OBIEE. For example, OracleClient11g_home1.
oracle_client_dir – Directory where your Oracle client for OBIEE is installed.

Conventions

The following text conventions are used in this document:

Convention	Meaning
boldface	Boldface type indicates graphical user interface elements associated with an action, or terms defined in text or the glossary.
italic	Italic type indicates book titles, emphasis, or placeholder variables for which you supply particular values.
`monospace`	Monospace type indicates commands within a paragraph, URLs, code in examples, text that appears on the screen, or text that you enter.

Code Examples

The code examples in this book are for illustration only. In many cases, however, you can copy and paste parts of examples and run them in your environment.

Pretty Printing of XML Data

To promote readability, especially of lengthy or complex XML data, output is sometimes shown pretty-printed (formatted) in code examples.

Reminder About Case Sensitivity

When examining the examples in this book, keep in mind the following:

SQL is case-insensitive, but names in SQL code are implicitly uppercase, unless you enclose them in double-quotes.
XML is case-sensitive. You must refer to SQL names in XML code using the correct case: uppercase SQL names must be written as uppercase.

For example, if you create a table named my_table in SQL without using double-quotes, then you must refer to it in XML code as "MY_TABLE".