Weblog for the AMIS Technology corner
Posts tagged Database
AMIS Query – Verslag van Oracle Open World 2009 – dinsdag 27 oktober (uitnodiging)
Oct 23rd
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 en Oracle engineers op de demo-grounds de nieuwste snufjes. Ca. 40.000 bezoekers waren aanwezig in het hart van San Francisco om zich vijf dagen lang te laten overvoeren met Oracle weetjes.
Als je er bij was vind je het misschien leuk nog eens herinneringen op te halen en ervaringen te bespreken. Als je er niet bij was ben je misschien geinteresseerd in de belangrijkste aankondigingen, de mooiste demo’s en wetenswaardigste feiten. Dat kan, aanstaande dinsdag op de AMIS Query – Verslag van Oracle Open World 2009. In deze (gratis) sessie doet de AMIS-delegatie naar OOW (Marco Gralike, Peter Ebell en Lucas Jellema) verslag van de conferentie. Je bent van harte welkom om daarbij aanwezig te zijn. Vanaf 17.30 serveren wij een diner, om 18.30 start de sessie die duurt tot pakweg 21.00 uur. Om je aan te melden, ga naar: registreren AMIS Query OOW 2009.
In deze sessie komen onder andere de volgende onderwerpen aan bod:
SOA & SOA Suite for Oracle Database Professionals – seminars in Perth and Melbourne and Singapore (November 2009)
Oct 20th
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 or a Database Developer, SOA is unavoidable in the coming period. But what (exactly) is it? And how does it impact – positively or negatively – the work and lives of database professionals? What can a database professional do to work well with SOA and the SOA technology once that starts being implemented in her or his organization?
What is at the heart of Oracle SOA Suite 11g: composite applications, BPEL PM, and the mediator. The session shows how SOA services can be leveraged from the database, from triggers, PL/SQL units, or even SQL and how the database can publish events to the event delivery network. It covers how the SOA infrastructure can access the database, primarily using Oracle Database and Oracle Advanced Queueing adapter and how database developers can help in doing so efficiently. It ends with hints for applying SOA concepts to "normal" database development.
The seminar has a lot of acronyms (to ensure you can converse with the architects) and even more demonstrations, both in SQL*Plus, the browser as well as the SOA Suite 11g design time and run time. You will see in a very practical manner what this talk of Services really is all about. What you can do with services, what the SOA guys will do with your database and how you can improve your database design and PL/SQL code using the same principles that guide SOA design.
We will discuss database features such as packages and views, Advanced Queues, Native Database WebServices, dbms_epg and XML DB and hook the database into the middle tier. After this session, you will no longer produce a blank stare when SOA is discussed – au contraire, you will be able to participate in the discussions, the design and planning and the implementation of SOA initiatives.
Details
Perth – Tuesday 10th November, Melbourne – Monday 16th November (as part of the AUSOUG with 20:20 Foresight National Conference series). See for details on date, time, venue and registration for Perth and Melbourne: http://www.ausoug.org.au/2020/.
The seminar in Singapore is on Friday 20th November (part of the Oracle University Celebrity Specials). Details on the Oracle University Celebrity Specials in Singapore: http://www.oracle.com/education/apac/sg_lucas.html.
OOW 2009: The killer feature of Oracle Database 11gR2 – Edition Based Redefinition (or database object versioning)
Oct 13th
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 tables!) can have different implementations/incarnations/versions in various editions. The object versions are all in the same schema – they only differ in the Edition they are created in.
The Edition Based Redefinition has us create Editions in the database – cross database object spaces where new versions of existing database objects can be created – and others can just be inherited from previous editions. We can construct an Edition in isolation – no one is impacted by us creating new objects and versions of objects; objects can be invalid in that edition and no one will know anything about it. Only once the edition is complete, valid and tested can we make it available to new user sessions to work against. Using a simple alter session set edition statement, sessions can specify which edition they want to run against. That is: after the user has been granted access to that particular edition.
There are some mechanics that you should know about of course.
OOW 2009: Introducing SOA and Oracle SOA Suite 11g for Database Professionals
Oct 11th
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 SOA (Service Oriented Architecture) as well as the Oracle SOA Suite 11g to an audience of database professionals. Whether DBA or Database Developer, SOA is unavoidable. But what (exactly) is it? And how does it impact – positively or negatively – the work and lives of database professionals? What can a database professional do to work well with SOA and the SOA technology once that starts being implemented in her or his organization?
Introducing Oracle 11gR2 Edition Based Redefinition or: On Parallel Application Universes
Sep 24th
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 –
What You Always Wanted to Know (but never dared to ask about…)
Sep 23rd
For "What you always wanted to know, but never dared to ask about Oracle 11g Release 2…", come and attend our technical session on 29th of September during the "AMIS Query – Technical Introduction of Oracle Database 11g Release 2".
As said on the (dutch) invite: :"We will be organizing on Tuesday the 29th of September an AMIS Query session were will be sharing our first experiences with the new release. Not so much in marketing terms but from the practical viewpoint and their advantages".
See here for more info and how to attend (for free): AMIS Query – Technical Introduction of Oracle Database 11g Release 2
Seminar: SOA for Database Professionals (April 3rd, The Netherlands)
Mar 19th
On Friday April 3rd, I will be presenting a seminar titled "SOA for Database Professionals" – in De Meern, The Netherlands. For more details and registration, go to this link. This seminar explains the concepts of SOA and their relevance to Oracle Database professionals – both DBA and Developer – as well as main benefits database professionals can derive from SOA concepts and SOA technology. The seminar will host a lot of demos – introducing special SOA, XML and service related functions in the Oracle Database as well as the key components in the Oracle SOA Suite.
The main objectives are:
- Understand what the relationship between SOA and the Oracle Database is or can be.
- See what BPEL can do for you and also what you can do for BPEL.
- Start to regard SOA (BPEL & ESB) as an opportunity to benefit from rather than a threat.
- Get started in working with WebServices BPEL and ESB (where to begin).
Oracle Data Mining meets performance method “GAPP”
Sep 29th
Sunday 21 September 2008 at Oracle Open World, I had the opportunity to present my method "GAPP" once more (HOTSOS 2008 and Planboard may 2008). This time I also mentioned how the method can be used with Service Oriented Architectures (SOA). For people not knowing what "GAPP" is all about I give a small introduction to the method. I also like to tell you why I started with “GAPP” in the first place and what the added value is of the method above other methods.
"GAPP" means General Approach Performance Profiling and can be used to find out where in your architecture the most wait time variance can be explained from your business process. "GAPP" makes it possible with very little data, in higly complex technical infrastructures, still be able to find the performance bottlenecks for a specific business process. The nice thing about the method is that it is not only able to pinpoint a bottleneck which is already there, it is also able to pinpoint a future bottleneck in a normal running system. This is something what only "GAPP" can do.
What makes “GAPP” special:
- The method can analyse the full infrastructure, so from front-end to back-end
- The method is not focussing on one piece of the infrastructure, like only the database
- The method is able to predict how the response time of a business process will react on changes in involved factors
- The method is able to predict when a certain bottleneck will evolve to a real problem
Extreme performance introduced by patchset 11.1.0.7 smart scan
Sep 25th
Larry yesterday did his keynote here at Oracle Open World introducing the "Oracle(R) Exadata Storage Server". This morning I attended a session about the technical details behind the server. In principal the server works with 8 nodes running RAC on Oracle Enterprise Linux 5. For the storage management ASM is used and since 11.1.0.7 smart scan has been introduced. Smart scan has been designed for very big data sources used in queries, like in Data Warehouses, where tables from tera bytes are common. In principle the following is accomplished using smart scan:
Read the rest of this entry »
OOW Presentation: Optimal Use of Oracle Database 10g and Oracle Database 11g for Modern Application Development
Sep 23rd
I just completed my second presentation here at Oracle Open World. It discusses Application Development inside and with the Database, introducing and discussing quite a few trends, concepts, best practices and new or rediscovered database features. It was nice presentation to prepare and to present: fun stuff, useful too and a very receptive audience. I promised the audience to make the presentation and the demo scripts available on the weblog within the hour, so here it is. I would like to thank everyone who attended the presentation – I really appreciated the interest shown and the feedback given afterwards. 
Read the rest of this entry »
