Oracle Database 11g to feature XML enhancements

By Mark Brunelli, News Editor 12 Dec 2006 | SearchOracle.com

Oracle tips, scripts, and expert advice Digg This!     StumbleUpon     Del.icio.us

The main XML upgrades in Database 11g focus on XML DB, Oracle's XML storage and retrieval technology. They include a new binary XML data type, a new XML index and enhanced support for XQuery and other emerging standards, said Willie Hardie, Oracle vice president of database product marketing. Database 11g is currently in the beta testing phase and expected to be released commercially within the next year.

Oracle's database management system (DBMS) has long offered native XML support, meaning that XML data can be stored within the system itself in object-relational or character large object (CLOB) formats. Database 11g expands on this feature by adding the ability to store XML as a binary data type, Hardie said.

"What we're doing with 11g is giving customers more options in terms of how they want to store the data," he said.

Hardie said some of the benefits of native XML support include greater security and the ability to more quickly access the XML data.

"At the end of the day […] an end user doesn't really care too much about where that data sits," he said. "The importance is in how quickly they can get at that data."

On the standards front, Database 11g offers greater support for XQuery, a proposed standard that allows users to extract information from an XML file; the Content Repository API for Java Technology (JSR 170); and SQL XML, which defines a standardized mechanism for using SQL and XML together.

Database 11g also offers "duality" between SQL and XML, meaning that users have the ability to embed XML statements within PL/SQL and vice versa, Hardie said.

Meanwhile, Database 11g developers will have the choice of implementing schema-based or non-schema-based XML definitions, depending on the level of flexibility the application they're working on requires, he said.

"[With a] schema-based-type application, the application needs to know the structure of that piece of XML," he said. "Other times you might not want to know that and you'll store it in a non-schema-based format."

More on Oracle Database 11g: Podcast: Expert says PL/SQL change needed in Oracle 11g Oracle announces full support for Red Hat users

More Database 11g details

Oracle kicked off the Database 11g beta program during its annual OpenWorld conference in October, saying the beta version offers 482 new features designed to address a wide range of database issues.

Database 11g emphasizes greater scalability, offers data compression capabilities and can handle parallel upgrades, Chuck Rozwat, Oracle vice president of server technologies, told the OpenWorld crowd. The compression technology reduces the amount of storage required for data sets by as much as two-thirds, according to Oracle.

The beta database also allows for online application upgrades and includes Oracle's Flashback technology, which reduces the time it takes to recover from database outages.

Oracle says the Database 11g beta testing program is currently open to all existing Oracle Database customers.

Tags: Using Oracle PL/SQL,  Oracle RAC and database clustering,  Oracle database export, import and migration,  Oracle database installation, upgrades and patches,  Oracle error messages,  Oracle database security,  Oracle database performance problems and tuning,  Oracle database design and architecture,  Oracle database backup and recovery,  Oracle database availability,  What's next: Oracle 11g,  VIEW ALL TAGS

Digg This!     StumbleUpon     Del.icio.us

RELATED CONTENT Using Oracle PL/SQL How to concatenate rows into a single CLOB in PL/SQL Working with substitution variables and using EXECUTE IMMEDIATE in PL/SQL How to open a ref cursor in a PL/SQL procedure Oracle's free SQL Developer adds database migration tool Confused about Oracle certification exams ORA-01422 error when procedure returns more than one row Calling procedure inside another procedure in anonymous block How to import comma-delimited text file to Oracle table Oracle updates Microsoft developer tools PL/SQL do's and don't's: Five questions with Steven Feuerstein Oracle RAC and database clustering E-discovery firm swaps out Microsoft SQL for Oracle RAC Firm dumps MySQL on Red Hat for Oracle Database on Oracle Linux How to back up archive log files in RAC eHarmony spurns Microsoft, finds match with Oracle 10g How to back up RAC database with RMAN Using connection load balancing with Oracle RAC 20GB data dictionary causing performance problems Grid computing adoption slow amid fears of complexity DBA 102: Beyond the basics Can I install Oracle binary files on a SAN? Oracle database export, import and migration Oracle data export guide Solving common Oracle errors guide Oracle and SQL Server: BFF? Oracle as data integrator Importing from Oracle 8i to Oracle 10g Export schemas of users of database Exp/imp for complex cross-platform migration and upgrade How to export data by date in Oracle Large data migration from XML database to Oracle 10g Data exchange between Oracle 10g and 8i databases

RELATED GLOSSARY TERMS Terms from Whatis.com − the technology online dictionary PL/SQL  (SearchOracle.com)

RELATED RESOURCES 2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems Search Bitpipe.com for the latest white papers and business webcasts Whatis.com, the online computer dictionary