Month: July 2009
July 13

Whitepaper: Current Support of XML by the “Big Three”

Today I discovered a web page that has some cool whitepapers and thesis of Mr. Martin Necasky. Besides the work he is doing regarding conceptual modeling for XML, he also wrote a book about this topic called “Conceptual Modeling for XML” in which he, among others, discusses his own conceptual model for XML called XSEM that extends the Entity-Relationship model, he and Ms Irena Mlynkova, wrote a 13 page brief discussion on “The Current Support of XML by the ‘Big Three'” (March 2009 – Oracle 11g, IBM DB2 9, and Microsoft SQL Server 2008).

Some remarks (about Oracle only of course) on this brave attempt (no seriously you can read that it isn’t copy paste work – so a lot of work in testing was probably involved in putting this to paper)…

Read the postWhitepaper: Current Support of XML by the “Big Three”
July 13

HOWTO: Do a clean XML DB installation…

Just here as a small side note, some steps to do a XMLDB clean installation without other more unnecessary functionality. Depending on using the Protocol Server or not, also take into account database parameter settings like SHARED_SERVERS (eg. value=5), JAVA_POOL (XQuery and other support), PGA_AGGREGATED_TARGET (DOM validation), SGA_TARGET or MEMORY_TARGET, LARGE_POOL (shared server). My advise would be to not use automatic memory wizards while using XML DB. Although I don’t have a good example anymore at hand, I have seen no or to late response of the database while working with statements that needed a lot of DOM validation in memory. If possible use unicode characterset for your database, AL32UTF8, to avoid future issues within your environment regarding NLS conversion issues.

Read the postHOWTO: Do a clean XML DB installation…
July 8

Ramblings 2.0

Everything is “2.0” nowadays so, why not my blog titles…? Things are going fast this year and if you’re not noticing, the things you thought you knew, are obsolete before you know it and in another blink, the world has been re-shaped again… A while ago Oracle announced there intentions to acquire Sun. Shortly after I saw the keynotes from the Google I/O Conference and thought “Wow, this Google Wave has all the ingredients to reshape the “not enterprise world” (at least not yet) but, “at least”, has the potential to directly compete with Microsoft Exchange, Lotus Domino, Oracle Beehive, etc…”. The world is shifting.

I mean, I know, or at least that is, IMHO, what I see what Oracle is doing, is taking on “the war” from the trenches, from the server room. Slowly moving from the server area, to the mid tier, to the front end, towards hardware and Open Source / OS, to application logic / Java onto your desktop and mobile. The only thing Oracle now needs, IMHO, would be a take over like something like, for instance, “Amazon”, to become a second Google. Result instant: “Oracle Docs/Apps in the Cloud” or “Oracle in the Cloud”.

Read the postRamblings 2.0