Introducing Oracle 11gR2 Edition Based Redefinition or: On Parallel Application Universes
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 parallel to the existing one, in the same schema and using the same database objects; only the new (modified) objects live in another dimension and do not impact the existing objects. Once the entire set of new and changed objects has been created and recompiled, the database administrator can start routing new sessions to the new release; existing sessions can continue to run against the original set of objects – and new sessions if so desired can also run against the orginal set.
A set of object versions – mutually consistent and interdependent – which in software engineering terms would be duped a release or stripe and in Oracle Software Configuration Manager (Designer) terms a configuration is called an edition in 11gR2 lingo. An Edition is a combination of new objects, new versions of objects and inherited pre-existing versions that together make up a meaningful set that forms the state of the database for a longer or shorter period of time. Releases of applications will typically target a specific Edition in the database.
I had been invited to present on Edition Based Redefinition during yesterday’s launch event for Oracle 11gR2 in The Netherlands. Being the only non-Oracle staff speaker in the presence of (S)VPs was nice and my subject made it possible to tell one of the more interesting stories of the day – which was nice too. Below you will find the presentation I showed the audience yesterday. I will blog later on about the demo I showed – a simple SQL*Plus based demonstration of the multi-dimension world that EBR invites us into.
If you are interested to learn more –
and get some hands-on feel for this spectacular database facility – then join us next week (Tuesday 29th September) for the AMIS Query on Oracle Database 11gR2 (in Nieuwegein, in Dutch, free!). For details and to register, see: AMIS Query – 29 September 2009 – Introducing 11gR2.
Oracle 11gR2 On Line Documentation on Edition Based Redefinition.
- My first steps with Oracle BI Publisher Enterprise Edition 10.1.3.2: create a report based on the OraBlogs rss-feed
- Oracle RDBMS 11gR2 – LISTAGG – New aggregation operator for creating (comma) delimited strings
- Oracle Database 11gR2 – New analytical function NTH_VALUE
- Creating an ADF application based on PL/SQL API – part one: reading data as a Collection of SQL Type Objects
- Oracle RDBMS 11gR2 – alter or replace user defined types even when there are dependencies
- Automatic deployment .ear file to Oracle Application Server 10.1.3 (OAS) with Ant tasks
- On the Integrity of Data
- How Oracle Database uses internal locks to make statement level constraint validation robust at the transaction level
- Kom kennismaken met AMIS en doe mee met uitdagende projecten
- OOW 2012: The Very Very Latest in Database Development (CON4792)
- OOW 2012 – Larry Ellison’s Keynote Announcements: Exa, Cloud, Database
- Oracle RDBMS 10GR1: solution to avoid character encoding in XML with UPDATEXML
- Dinsdag 18 september: Oracle Open World & JavaOne 2012 Preview mini-conferenties – 12 presentaties op 1 avond
- Refresh resource bundle from within the ADF application – to absorb changes in database backed bundles
- Adding customization (or context sensitivity) to boilerplate text from database backed resource bundles in ADF applications