Amis Blog

Last Tuesday we did a Preview of the upcoming OPP (Oracle PL/SQL Programming) Conference which will be held in Atlanta, Georgia soon. This preview took place in our office in Nieuwegein, The Netherlands. About 17 people attended this free preview. At regular intervals we do free "Knowledge Center" presentations. Keep a close eye on our Agenda [...]

  Vorige week was in San Francisco het hoogtepunt van het Oracle jaar: Oracle Open World 2009, de grootste IT conferentie ter wereld. Tijdens deze conferentie ontvouwde Oracle haar strategie en visie voor de komende periode, lieten product managers de nabije toekomst zien van bestaande en nieuwe producten, deelden honderden specialisten hun ervaringen en toonden leveranciers [...]

Next month, I will visit Australia and Singapore to present on SOA and the Oracle SOA Suite - to Oracle database developers. In this one-day-long seminar, I introduce the key concepts and objectives of SOA (Service Oriented Architecture) as well as the Oracle SOA Suite 11g to an audience of database professionals. Whether you are a DBA [...]

Maandag 26 oktober start bij AMIS de vijf-daagse ADF 11g training (ontwikkeld in samenwerking met Chris Muir van SAGE - Perth, Australië). Tijdens deze training zullen Luc Bors en Lucas Jellema deelnemers ‘ADF enablen’ - op weg helpen met dit strategische ontwikkelplatform van Oracle. "ADF 11g is the cornerstone of Oracle Fusion Applications - and most [...]

  One of the sessions I am (co-)presenting at Oracle Open World 2009 is on ‘applying the concepts of SOA to and achieving the SOA objectives with User Interfaces’. What goes for SOA and typical programmatic (web)services can be applied to User Interface components to a large extent. Decoupling - cross location, cross technology, cross development [...]

  James Gosling, the "father of Java", is the hero, the star, the god of many Java conferences such as JavaOne. I have seen the adoration and worship, as recently as four months ago at JavaOne 2009. Yesterday I witnessed a performance by James Gosling in a very different setting. At Oracle Open World (at least [...]

  Today I presented on what is possibly the hottest story on the Oracle Database 11gR2 release: Edition Based Redefinition (EBR). EBR allows us to add a whole new dimension to the database - the Edition (that complements the existing dimensions of schema and object type). Every database object (well, almost every database object - not [...]

Oracle Database 11g Release 2 introduces a new feature called Recursive Subquery Factoring. My collegue Lucas sees it as a substitute for Connect By based hierarchical querying, Oracle RDBMS 11gR2 - new style hierarchical querying using Recursive Subquery Factoring. When I first was thinking about a pratical use for this feature I couldn’t come up [...]

  Last Friday I attended a product briefing at Oracle HQ that prepared me for today’s Oracle Open World 2009 keynote presentation by Ted Farrell on development tools and middleware. Oracle will soon (some time November?) release what it calls Patch Set 1 for the Fusion Middleware 11g stack and this article goes into the new [...]

  It will be my last presentation at Oracle Open World 2009 - how to turn any ADF application into a SaaS application - an application suitable for deployment ‘on the cloud - available to users from different organizations’. One of my statements is that most if not all applications benefit from applying those same SaaS [...]

My OpenWorld 2009 started out this morning with a keynote by Tom Kyte named "What Are We Still Doing Wrong?". A lighthearted presentation with lots of funny examples of bad coding practises. After that, things heated up with an "OSB Deep Dive", presented in her usual inspired - and inspiring - fashion by Deb Ayers, who clearly [...]

  This article is about APEX - some of my initial impressions from the pending (deep into 2010) APEX 4.0 release. And the title is in no way meant to be ironic, contrary perhaps to popular belief. Yesterday I saw a presentation/demonstration by Mike Hichwa and David Peake from the APEX team and it provided me [...]

  The Oracle Open World 2009 conference is almost underway. On Monday 12th October I will do two presentations, and I am done preparing the first one of them (the one that has actually sold one - probably scheduled in a small room).This presentation is one in which I introduce the key concepts and objectives of [...]

  Tomorrow morning I will travel to San Francisco (well, first to Redwood Shores) for this year’s of Oracle Open World - the largest Oracle party in the world. It is my fourth attendance in a row - and it is going to be the busiest by far. For starters, I am presenting five sessions (don’t [...]

  While looking into the XML functionality in JDeveloper 11g, I came across a feature that was added in the 11.1.1.1.0 release - July 2009: [Create] XML Schema from XML Document. Functionality previously found in commercial products such as XMLSpy, that enables us to make a head start with the development of XML Schema Definitions by using an existing [...]

  A few months ago I came across a relatively new book: Processing XML Documents with Oracle JDeveloper 11g by Deepak Vohra (370 pages, Packt Publishing, ISBN 978-1-847196-66-8, February 2009). It is an interesting mix of topics, all having to do with XML and most directly related to JDeveloper. The topcis and chapters do not at [...]

Its time to enlist. It really is. At least regarding the XMLDB related sessions and presentations during Oracle Open World 2009. As far as I have seen today, the hands-on workshop has almost no seats left and more than half already enlisted for my XMLDB New Features and XMLDB Performance related presentation. Oracle Open World doesn't have much XMLDB related sessions, until now from the 1800+ sessions, I only counted a dozen or so. If you want to have a peak of the ones I found, have a look at the following Oracle OTN XMLDB Forum thread. Oracle Open World 2009: XMLDB Presentations and Related Workshops I enlisted for most, as long as they didn't interfere with my presentation schedule, if not only that I am very anxious about Mark Drake's presentations about Google API mashups etc combined with the XMLDB functionality in the database and the, probably extended version of how to build an APEX content management system based on the versioning and filler capabilities of the XMLDB Repository. During OOW 2008, Carl Backstrom, helped and co-presented this APEX/XMLDB joined venture and, alas, this demo app of the XFILES light weight XMLDB CMS, never (at least yet AFAIK) hit the apex.oracle.com demogrounds or the OTN XMLDB main pages. read more...

  Oracle Database 11g Release 2 introduces the successor to the good old Connect By based hierarchical querying, called Recursive Subquery Factoring. The basics are described in a previous article: http://technology.amis.nl/blog/6104/oracle-rdbms-11gr2-goodbye-connect-by-or-the-end-of-hierarchical-querying-as-we-know-it. This article will show some additional examples of using this recursive subquery factoring syntax. The essence of this recursiveness: the subquery consists of two queries unioned [...]

After installing the Oracle SOA suite 11g, you will notice that you have to enter username and password  for each managed server during startup and shutdown. This in contrary to the administration server where you don’t need to enter username and password at startup. I was wondering if there was an easy way of skipping [...]

 One of the most spectacular new facilities in Release 2 of the Oracle 11g Database is called Edition Based Redefinition - not a name perhaps that suggests any spectacle. EBR (Edition Based Redefinition) is a mechanism that allows on line application upgrade with no planned downtime. In short, the new release is built up in [...]