KC IT Architecture
Automatic testing Oracle Service Bus using Hudson, maven and SoapUI
Feb 23rd
Agile software development, the principles. Principle 11: The best architectures, requirements, and designs emerge from self-organizing teams.
Dec 14th
Oracle Enhances XBRL Reporting Capabilities with UBmatrix, Inc.
Jun 27th
Oracle posted a press release about their involvement and commitment for UBMatrix XBRL technologies last Wednesday saying (among others):
"To help publicly held companies facilitate the preparation, publishing and automatic exchange of financial statements in XBRL (eXtensible Business Reporting Language), Oracle will embed UBmatrix, Inc.’s leading XBRL technology into Oracle’s Enterprise Performance Management (EPM) System, Oracle announced today."
"Oracle and UBmatrix are also working together to provide enterprise class storage and management for XBRL-based information in Oracle® Database 11g. Using Oracle Database’s XML DB feature, organizations can easily and quickly store, access and query their XBRL data."
A lot of you might ask themselves: "Who are or what is UBMatrix?" and "How does it all fit in…?"
UBMatrix is one of those small but cool companies that have an idea and drive that idea to bigger heights. Their ideas about how to deal with XBRL and how to make it more succes full are very innovative. XBRL is an open standard to exchange and/or embed business and financial related data via XML. "Nothing more and nothing less…", but applying it has a great impact to other systems, sometimes called "the ripple effect".
The setup for the Dutch Taxonomy project background is simple…
Enhancing fast queries using “Tapio-Indexes”
Jun 4th
During the years I have a lot of times encountered performance problems that ended up to be fast queries (less than 10ms) which are executed very much. In these situations the execution plans, from such queries can look like:
OPERATION OPTIONS OBJECT# NAME
-------------------- -------------------- ---------- -----------------------------------
SELECT STATEMENT .
SORT ORDER BY .
TABLE ACCESS BY INDEX ROWID 120713 XXX.TABLE_WITH_MANY_COLUMNS
INDEX RANGE SCAN 121558 XXX.INDEX_WITH_FEW_COLUMNS
In a lot of cases we deal with a query for example which is returning fewer columns than exists in the involved table like four, from an involved table having twenty columns. Although the execution plan looks already pretty “OK”, it still results in a query which is in top three most resource taking queries.
To enhance the query we can use “Fat Indexes” or nowadays better known “Tapio Indexes” (I call them like that nowadays). What are these kind of indexes…. In principle nothing really new, but for me a couple of years ago an (re)eye opener by Tapio Lahdenmaki. This Finish independent database performance consultant and instructor gave a presentation at Miracle Open World 2007 in Denmark, I attended. Tapio can present this topic in a very special way, and in my opinion “his message” should be known by all developers and dba’s.
Schrijf je in voor de ODTUG Sneak Preview op 15 juni 2009!
May 26th
Op maandag 15 juni 2009, een week voordat in Monterey de ODTUG 2009 plaats vindt, heb je de mogelijkheid om alvast te horen wat negen sprekers in de VS gaan presenteren, onder hen twee Oracle Aces en twee Oracle ACE directors.
- Aino Andriessen (AMIS Services) – ADF Development: More tales from the Trenches
- Lonneke Dikmans (Approach Alliance) – Top Ten Tips: Best Practices for Designing Services, Events, and Business Processes
- Olivier Dupont (iAdvise) – APEX at the Belgium airport
- Dimitri Gielis (APEX Evangelists) – Mastering an APEX page
- Roel Hartman (Logica) – How to integrate APEX and Oracle Forms?
- Lucas Jellema (AMIS Services) - Truth and Dare—The Story of How an Oracle Classic Stronghold Successfully Embraced SOA
- Toon Koppelaars (Rulegen) – Fat databases: A layered approach
- Ronald van Luttikhuizen (Approach Alliance) – Customer case: Implementing SOA in a database-centric environment
- Alex Nuijten (AMIS Services) – SQL Holmes – The case of the missing performance
In drie rondes kan steeds een keuze worden gemaakt uit drie presentaties over een aantal uiteenlopende onderwerpen, onder andere APEX, ADF, SOA en de database.
Dit jaar staat er zelfs één presentatie geprogrammeerd (van Dimitri Gielis) die exclusief op de ODTUG Sneak Preview bij te wonen is en uiteindelijk niet op de ODTUG te zien zal zijn.
Het is mogelijk om gratis deel te nemen aan deze unieke ODTUG Sneak Preview (aanmeldingsformulier)!!! Maar schrijf je snel in, want vol is vol!!!
De locatie van de Sneak Preview is het AMIS kantoor in Nieuwegein. De toegang tot de ODTUG Sneak Preview, het diner en de verfrissingen zijn gratis. Meer informatie over de presentaties vind je in de activiteitenagenda.
AMIS Query 18 Mei – Een Terugblik op Hotsos 2009
Apr 22nd
Marco
Session announcement: Oracle Service Bus (25 feb 2009)
Feb 23rd
Just wanted to draw your attention to a "Knowledge Center" session at AMIS this wednessday (25 feb 2009, starting at 16:30). It concerns the new Oracle Service Bus (previously the BEA Aqualogic Service Bus), and will be presented by former collegue Jeroen van Wilgenburg, now working at Xebia. Jeroen has worked with the OSB on his current project, so he will be able to give us real-life experiences, not just a "summary of features"! For more information, and information on how to register, take a look at the AMIS Agenda: http://www.amis.nl/activiteiten.php?id=681&preview=&draft=
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 »
AMIS Query – Preview Session Oracle Open World 2008
Aug 25th
We try to do our best, so some extra practice never hurts. If we think such an event or session can be interesting for our Dutch peers, we call it an AMIS Query. An AMIS Query is an in house event; one or more presentations from our AMIS colleagues or outside specialists from other companies. Everyone can attend and AMIS Query, at least, as long as we can logistically can manage it. Drinks and a dinner are provided during these sessions.
We asked the other Dutch Oracle Open World presenters if they also were interested in such an event and this resulted in the following impressive list:
- Steven Davelaar, Oracle Consulting, Nederland – Oracle JHeadstart R11: Unprecedented Productivity in Developing Best-Practice Fusion Web Applications
- Douwe Pieter van den Bos, Caesar Groep B.V., Technology Manager - Designer2APEX: Migrate Your Forms UIs to Oracle Application Express
- Roel Hartman, Logica – Developing a Real-World Logistic Application with Oracle Application Express
- Ronald van Luttikhuizen en Lonneke Dikmans, Approach Alliance - BEA AquaLogic Versus Oracle Fusion Middleware Shootout
- John Copier, IT-Eye – ESB Central: Applying SOA to Master Data Management in the Dutch Public Sector
- Lucas Jellema, AMIS – Optimal Use of Oracle Database 10g and Oracle Database 11g for Modern Application Development
- Peter Ebell & Lucas Jellema, AMIS – Did We Spoil the End User? Building Personalization into JavaServer Faces Technology-Based Applications
- Gerwin Hendriksen, AMIS – Jumping The GAPP
- Marco Gralike, AMIS – Real World Experience with Oracle XML Database 11g: An Oracle ACE’s Perspective
- Marco Gralike, AMIS – XMLDB: Building Blocks and Best Practices
- Frits Hoogland, Interaccess – Automatic Storage Management
We are still hoping for some extra presentations / presenters to be added on the list. Not everyone from the Dutch presenters could be reached yet, because of the holiday season. So expect one or two presentations to be added on this list. The presentations will be given in multiple session tracks, this because of the amount of participants and time restraints. If needed, we will cut down the AMIS presentations to a total of 3 sessions.
Interested in this all OOW 2K8 Dutch preview event?
- An overview in Dutch can be found here: Donderdag 11 september: Preview sessie Oracle Open World 2008
- And if you are interested in attending then please register here: Aanmelden evenement
We hope to see you there and / or during Oracle Open World.
Marco
The influence of the experience economy on IT architecture
Jul 23rd
AMIS is puting more and more emphasis on IT architecture. That is one of the reasons why I am doing my Masters in IT architecture and why AMIS is starting a knowledge center about IT architecture. The following paper is written for one of the masterclasses (Applying Architecture) that I have followed so far.
Introduction
Companies that are able to provide their customers an experience by providing emotionally and psychologically gratifying products perform well in the currently very competitive marketplace (Free, 2006). Companies like Apple, Disney and Starbucks are able to sell their products based on an added user experience. Customers are willing to pay more for products largely based on the emotions that these products raise to their buyers. Maybe Apple is one of the most well known companies that excel in delivering an added experience with their products. Apple customers identify themselves with the companies’ products. They want to show that they are different (European Centre for the Experience Economy, 2005).
This paper describes how the experience economy influences the role of an IT architect.
Read the rest of this entry »

