All that is not covered by the Oracle Database…
The new ready to download Oracle XBRL Extension is a “no cost option” on top of the latest Oracle Database 188.8.131.52.0 release. With this added functionality you will get a database environment that contains
- One or more back-end XBRL repositories based on Oracle Database, which provide XBRL storage and query-ability with a set of XBRL-specific services
- An external XBRL processing engine (XPE)
The XBRL Extension to Oracle XMLÂ DB integrates easily with Oracle Business Intelligence Suite Enterprise Edition (OBIEE) for analytics and with interactive development environments (IDEs) and design tools for creating and editing XBRL taxonomies.
Architecture of XBRL Extension to Oracle XMLÂ DB
There is a generic “patch” (patch 10411201), p10411201_112020_generic.zip, which can be downloaded from http://support.oracle.com and installed to be used on top of the Oracle 184.108.40.206.0 XML DB.Â In addition, there are also two platform-specific patches (currently only available for Linux-x86-64 and Solaris-64 platforms):
For the Linux-x86 64 bit platform:
For the Solaris 64 bitMore >
One of the requirements at my current project is to have one ADF table display data from different database tables. That is, depending on criteria entered by the user, the query behind the view object needs to change. All in all 12 different database tables are involved in this story. This requirement is based on functionally in the original (oracle forms) application. This forms application used the set_block_property built-in:set_block_property('<blockName>, query_data_source_name, <datasource>);
I was able to reproduce this behavior in an ADF application. In this post I explain how I did this (more…)
In preparation for our Oracle Open World session ‘Xenogenetics for PL/SQ – Infusing with Java Best Practices and Design Patterns’ – I have been doing a little work on Advanced Queuing in the Oracle RDBMS, as well as on Java Stored Procedures. The objective of this presentation is to bring best practices, design patterns as well as new functionality to the world of PL/SQL from other worlds, such as Java. Interaction between database applications and the rest of the world is an important part of that. And such interaction, especially when we have a need for decoupled interaction, which we frequently should have, Advanced Queues will be used at the database end to support that interaction.
The concept of queuing – and more generally: messaging – has its Java counterpart in JMS, the Java Message Service. The question I then asked myself is: how exactly can I map AQ to JMS and how can I link the two worlds. How can I expose the AQ Queue or Topic in the RDBMS as a JMS Queue or Topic? And how can I consume messages from JMS into the database, possibly to AQ?
One of my reasons for making the connection between AQ and JMS has to do with another presentation at OOW I will deliver, More >
Back in 2004 when we started with the AMIS Technology Blog, my main objective was to record the things I infrequently do in order to have notes describing the steps to go through whenever I needed to do the thing again. I was own primary audience, so to say. Over the years, the articles have increased in complexity and sometimes in absurdity too. This one is back to that original intention. This article is not fancy at all – even though it touches upon a powerful (and underrated) subject: the Advanced Queue in the Oracle RDBMS. For the 1000s of database developers and architects that make frequent use of AQ, I am not going to add anything: this article merely shows the steps for creating an Advanced Queue, how to register a listener on the queue and how to publish a message on the queue. That is not fancy at all, obviously.
What is extremely fancy and powerful – and not nearly used enough – is the architectural pattern that AQ allows us to introduce. Queues are a key concept for achieving decoupling. Decoupling itself is like the holy grail of architects – because it allows agility and reuse. Through a Queue, a publisher (or discoverer) of events can make them available to More >
Donderdag as. is de AMIS Query van Doug Burns over SQL Tuning, gebruikmakend van de Oracle Enterprise Manager (Tuning en Diagnostics pack). Misschien verwachten velen een hoog “DBA” gehalte, maar niets is minder waar…
Deze presentatie bevat bijna geen enkele slides en is echt een aanrader om bij te wonen. Het gaat over kleuren, indelingen, interpretaties van grafieken en er zit een goeie scheut droge Schotse humor in deze presentatie verwerkt. Waarschijnlijk zal Doug ook nog de Real Time SQL Monitoring tool in kleur en geur uitleggen.
Met andere woorden geen moeilijke “DBA” achtige presentaties, maar stof om over na te denken als het gaat over SQL Tuning en de tooling, De Oracle Enterprise Manager (de bij de database meegeleverde DB Console) in dit geval de Oracle 11gR2 variant, die Oracle hiervoor steeds meer navoren drukt op alle mogelijke tiers waar zich Oracle en andere software bevind.
Voor extra info over Real Time SQL Monitoring zie ook de volgende blogpost: Real Time SQL Monitoring
Het is nog mogelijk om je aan te melden (zodat we o.a. een inschatting hebben t.a.v. de hoeveelheid eten) voor deze AMIS Query op Donderdag 17e Juni om 18:00 uur via: