XML
AMIS vat Oracle OpenWorld samen in speciale whitepaper
0Als sluitstuk van de jaarlijkse Oracle OpenWorld conferentie brengt AMIS een whitepaper uit. Een handzaam document waarin het volledige verhaal van Oracle OpenWorld 2012 is gebundeld.
Een team van AMIS was tijdens de conferentie in oktober nadrukkelijk aanwezig; als sponsor, deelnemer, netwerker en spreker – en als aandachtig luisteraar en analist.
Zeven Oracle-specialisten van AMIS hebben deze whitepaper samengesteld waarin de visie, plannen en aankondigingen van Oracle zijn gebundeld. In het maar liefst 47 pagina’s dik document wordt niet alleen het verhaal van Oracle samengevat, maar geeft AMIS ook haar eigen duiding en waardering van het verhaal.
De whitepaper is hier gratis te downloaden.
OOW 2012 – And was there news on the XMLDB front…?
0Just finished my Birds of a Feather XMLDB panel session in the Marriott Hotel and now looking back on a event full day. It all started of with a Keynote session with among others Mark Hurd. the most interesting bit, in my honest opinion, was the announcement of more details in Oracle 12c. I will come back later on this, as far as I am allowed being a beta participant, but hereby some shots from the Keynote session that will give you a pretty good idea on usefulness of pluggable databases in Oracle 12c.
XMLDB NewsSo with all this excitement going on about 12c, are there already some small details about new XMLDB functionality. Via a Tom Kyte presentation, Hands-on Labs and some other sessions, the following details were made available to the public. Keen on XMLDB stuff, this is what I picked up.
- XMLDB is now an integrate, mandatory part of the database
- XQuery Update facility, already available in 11.2.0.3, is now a fully supported standards in 12c and onwards
- XQuery Full Text search, is now available, in Oracle 12c
- XMLType CLOB based storage will be deprecated in Oracle 12c
As with all Oracle 12c related things at this time, Oracle will have the last word if it also More >
OOW 2012 – Oracle XML DB Hands-On Lab (HOL10055)
0I posted, as (my) tradition dictates, the Oracle agenda overview of XMLDB sessions during Oracle Open World 2012. I already signed up for the HOL10055 session but yesterday I also got a quick peek of it’s contents this year. And yes, I can promise you, it is a must go, if you are dealing with or are interested in all things XML in your Oracle database.
The hands-on lab has topics like, among others,
- Using XQuery in Oracle Database 11g Release 2
- Optimizing XML Storage and processing with XML Schema.
- Relational access to XML content
- XML access to Relational Content
… also practical items like, loading XML, how to performance optimize XML in the database, and/or partition methods useful if your dealing with enormous amounts of data. This year it covers all XML use cases, if it’s structured, semi-structured or unstructured, via the latest database XMLDB functionality like the XQuery Update Facility (2011 W3C recommendation) or unstructured data retrieval via the also new W3C 2011 recommendation, the XQuery Full-Text standard.
To give you some small insight into those two new W3C XQuery recommendation extensions:
The XQuery Update Facility XQuery-Update is an extension standard that More >
Oracle RDBMS 10GR1: solution to avoid character encoding in XML with UPDATEXML
On a recent project, I ran into a problem with an XML document, that had to be enclosed within another XML document, generated from a database query. The problem I ran into was the character encoding of the XMLElement function, which eventually was worked around with UPDATEXML.
In this blog post I would like to share with you several attempts to solve this problem, why they failed and the final solution to the problem.
Printing of official documents happened in a separate printing module. Whenever a document needed to be printed, an XML document was generated in a database query and sent to the printing module. Most of the data came from relational database tables, but pieces of standard text were supplied as XML documents by another party… and saved in our database in an XMLType column based on CLOB storage.
Our printing module expected to find these standard text XML documents within a tag in our generated XML document. Also both XML documents, our generated XML and the supplied XML, had different namespaces, this needed to maintained this way. The Oracle database version we were working with was 10.1.0.5.0.
In this post I will use a simplified version of the real XML More >
Oracle XML Training With Marco Gralike
0I was asked by Jože Senegačnik, if I would be would be interested in doing a Masterclass/Seminar in Slovenia and, yes of course, I really liked the idea. So after having a quick look in my agenda, regarding my free time, we started to set things up.
This 2 day seminar will take place the 27th & 28th of March in Ljubljana, Slovenia, at Poslovna hiša Unija, Tržaška cesta 515, 1251 Brezovica pri Ljubljani. The seminar is organized by DbProf d.o.o. in cooperation with SIOUG, the Slovenian Oracle User Group. The early bird offering will be ending on the 16.3.2011 (have a look here for more details), so have a go at it.
Be aware, there are only a few days to go (the 16th/this Friday) and then the “early bird” offer ends and the (current) room is filling up quickly…
So what can you expect (for the detailed agenda see the registration link) ? (more…)
Create a JasperReport from Oracle BPEL
0In my previous post I described how to create a Report (CDBooklet) with JasperReport in Java. Follow this link to take a look at the post ‘Using Java to create a report with the JasperReport java API’
For this new post I created a webservice wrapper around this reporting functionality and deployed it to a Weblogic application server. Here I will describe how to create a CDBooklet report with the Oracle SOA Suite 11g. First we have to determine the in- and output payload for the service. You can find a detailed description of this service in my previous post. (more…)
Recent Comments