Databases
All that is not covered by the Oracle Database…
The Knight's Challenge – Recursive SQL Queries make a move on the Chess board
3In my quest to position ‘connect by’ (and its 11g successor, Recursive Subquery) as mechanism for recursive queries rather than just an hierarchical query facility, I stumbled across a simple, fairly meaningless challenge to take on: a knight on a chess board – and the question of finding its way from one square to another. Recursive querying in general consists of two elements:
- the initial situation, the starting point (the n=1 step)
- the algoritm to get from one stage to the next (the n to n+1 step)
A third, mandatory, element is the termination of the query: when is the journey complete, what is the maximum value for n or what is the exit condition. (more…)
Wat kan je als Forms of database ontwikkelaar met Oracle Database Release 11g?
0Een upgrade naar de nieuwste versie van de Oracle Database vindt zelden plaats op initiatief van het applicatie-ontwikkelteam. Upgrades worden meestal gedaan in verband met support-regelingen, op verzoek van de DBAs of omdat het gewoon wel weer eens tijd is – maar vrijwel nooit omdat de PL/SQL ontwikkelaars in de organisatie gebruik willen maken van een bepaald nieuw feature. Niet zelden worden dan ook de ontwikkelaars enigszins overvallen door de nieuwe database versie, of nemen ze die vooral ter kennisgeving aan. En dat is eigenlijk jammer.
Veel organisaties zijn recent overgegaan naar Oracle Database 11g Release 1 of zelfs al 2, of zijn daar op dit moment mee bezig. En dat is dus een goed moment voor de database, Forms en APEX ontwikkelaars (en andere ontwikkelaars die van de database gebruikmaken, zoals .NET en Java ontwikkelaars) in deze organisaties om te leren wat er in 11g op het gebied van PL/SQL, SQL en database applicaties verbeterd en toegevoegd is.
AMIS organiseert op donderdag 24 februari een een-daags seminar onder de titel “Masterclass: Oracle 11g for Database Developers” waarin precies dat onderwerp centraal staat. Oracle ACE Director Alex Nuijten laat in een More >
Database Transaction Recorder – Adding Who to When and What to make Flashback take over from Journalling tables
2In previous articles, I have suggested that the arrival of the Flashback Data Archive in Oracle RDBMS 11g allowed us to finally say goodbye to journalling tables. Keeping track of all changes and previous states of our records in our own dedicated tables is no longer required, was my statement (for example in http://technology.amis.nl/blog/2453/oracle-11g-total-recall-flashback-in-the-hands-of-database-designers-and-application-developers-at-last-and-the-end-of-journalling-tables). Not only would using Flashback Data Archives require less programming, it improves performance for DML operations substantially and also provides a lot of functionality at our fingertips, as Flashback Queries easily incorporate historical records in straightforward SQL queries and using dbms_flashback we can even turn back time and regard all data as it was back then, using the same application and all the same queries.
In the not too distant past, Flashback knew quite a long list of limitations that made it almost impossible to make any changes to a table definition and still retain the historical data. With recent improvements in 11gR2, most of these limitations have been removed and DDL such as More >
Oracle XBRL Extension Ready for Download
0The new ready to download Oracle XBRL Extension is a “no cost option” on top of the latest Oracle Database 11.2.0.2.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
Oracle XBRL Extension architecture
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 11.2.0.2.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:
- p10074437_112020_Linux-x86-64.zip
- p10232225_112020_Linux-x86-64.zip
For the Solaris 64 bit
More >
Masterclass for Java Developers – Make that Database Work for You! 17th December 2010
3Really getting the most out of your database. That would be nice, given wat databases can do (and what you may have paid for them).
Few serious Java Applications are completely devoid of interaction of some kind with a database.
However, most ORM and  Java Persistency frameworks do their utmost to hide the database and all it can do from the Java application and very few Java developers can truly leverage the full capabilities of the database their application works with. For all intents and purposes, the database in many cases is still nothing more than a flat storage cabinet.
On 17th December I will present a Masterclass that demonstrates how Java applications can benefit from the functionality on offer from underlying databases in a way that does not impact the application architecture, introduces breaches of open standards or creates undesirable coupling. Using plain JDBC, JPA frameworks and alternative interaction channels – for example http-based RESTful interaction – this seminar demonstrates through many examples how [Java] applications can become better performing, more elegantly designed and more productively developed as well as more scalable and robust.
ADF 11g : Change a Viewobjects’ Query on the Fly
1One 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…)
Recent Comments