Category: Data Analytics
After receiving a new, pretty powerful laptop, on Thursday and installing the Oracle BI Enterprise Edition on Friday, this weekend sees my first steps with the BI Publisher (previously …
Although bitmap indexes are already available in Oracle 8i or even before (some sources even say 7.3!!!), they are still surrounded by many myths. Time for some clearing up. …
One of the intriguing products in the Oracle Portfolio is Oracle BAM (Business Activity Monitoring). I have been trying to see it in action, learn more about and actually …
Database Performance Analysis and Tuning of queries and Database Design have never been my specialty. As of late, I have been reading a lot in this area, on Wait …
Recently I had to extract data from 5 Access databases and 4 Excel files and merge the data into an Oracle table. One method was to export the data from Access to Oracle via …
My colleague Alex Nuijten did a very fine presentation on Oracle Analytical Functions during the recent ODTUG 2006 conference in Washington DC. His paper for this conference was nominated …
Last night, the ODTUG 2006 Conference Committee announced that all handouts and presentations from this year’s (well, in fact that is last week’s) conference are available for download from …
During one of the sessions on last week’s ODTUG 2006 conference, I saw a very interesting demo by Keith Laker. He discussed the problem of having several dozens of …
Business Intelligence, Data Warehousing, ETL, OLAP, Data Mining, Management Information, Dashboards etc. were among the most frequently heard terms at this conference. Much more so than on previous occasions …
It's Showtime! Today at ODTUG 2006, Alex and I are presenting our Oracle Quiz on SQL and PL/SQL – the water is still burning. We will present our audience …
After a long delay OWB 10g R2 (previously known as Paris) has finally been released for production and can be downloaded from OTN. OWB 10g R2 will not be …
Queries that contain calls to user defined PL/SQL Functions can be performance killers. If a function call is part of the WHERE clause, depending on the execution plan it …
It is not terribly important. But since I found the solution, I thought I’d share it with you anyway. During our Oracle 7Up workshop on SQL last week we …
Query Rewrite is an increasingly more important feature of the Oracle database. Linked intimately to Materialized Views, Query Rewrite is used by the CBO to make queries leverage intermediate …
In preparation for the Oracle 7Up Workshop as well as the Oracle Quiz – The Water is Still Burning (presentation and paper) with Alex for the ODTUG 2006 conference …
Last week, my colleague Marcos guided us through the still relatively new Oracle offering called XML Publisher. During a session of our Knowledge Center on Oracle Development Tools, we …
Today I attended – and presented at – the Database Systems 2006 conference – an annual Dutch conference on Database Architecture and Technology, Enterprise Integration and Service Oriented Architectures …
We at AMIS have a fairly long tradition when it comes to having developers attend the annual ODTUG (Oracle Development Tools User Group) conference. My first conference – while …
It is not well-known how the Oracle built-in Soundex exactly works. This article explains the basics and also describes the Dutch variation of this algorithm.
Since December 2004, we participate in the Oracle Warehouse Builder beta program for 10gR2 – the Paris release. Yesterday, I downloaded the Beta 4 Release, the most recent stage …
Today I attended the workshop that Steve Adams is giving in the Netherlands this week. We were with a group of four AMIS employees. The day started in a …
Yesterday just prior to our AMIS Query on ADF Faces I was talking to Toon Koppelaars about quite something else: the end_date column in tables that contain contiguous records …
Trying to make myself useful by answering some of the questions on the OTN SQL and PL/SQL Forum, I came across this question: Group Above Report problem…not able to …
The 10gR2 or Paris release of Oracle Warehouse Builder is attracting a lot of attention. During Oracle Open World 2005 of course, and in a number of Blogs by …
Oracle’s latest database release 10g R2 does not support OWB (Oracle Warehouse Builder). All OWB’s up to and including the current version 10.1.0.3 are not certified by Oracle 10g …
I just read in a Dutch IT magazine (Computable) about the release of Bizgres 0.7. Bizgres is an open source project: The Bizgres Project (www.bizgres.org), a Greenplum-sponsored, community-supported, open …
AMIS is participating in the Oracle Warehouse Builder Paris Release Beta program. Unfortunately I have not had too much time for in depth involvement myself. However, from what I …
This article is about a very interesting Oracle tool: Warehouse Builder. A tool that is much more versatile than its name suggests. OWB can be used for diverse activities …
Put on the trail by Tom Kyte – and after many useful discussions with my colleague Andre, we will take a look in this article at implementing complex business …
If you really want to have some fun – and have your co-developers start wondering whether they are losing it altogether – you could consider spending a few minutes …
All statistics on the visits to the posts in the AMIS Technology Weblog are gathered in a MySQL database that sist underneath WordPress. We would like to do some …
As in most project the need for a representable test data set existed in a recently started one. The data was available in a small MS Access database (7 …
Analysis and functional design for regular application development has been standardised over the years. Now working on Business Intelligence (BI) projects for the last one and a half years, …
In a previous post Making up records in SQL Queries – Table Functions and 10g Model clause I discussed how you can make use of either a Table Function …
As was announced early in 2004, Oracle has just released the Oracle Business Intelligence Spreadsheet Add-In. This is an add-in for Excel. OracleBI Spreadsheet Add-In enables end users to …
Today I looked into a pre release of Oracles Warehouse Builder 10gR2 (Paris). This comprehensive tool can be used to create complex data warehoused holding data from many different …
I have some vague plans for presenting statistics using SVG and a World Map. I was thinking for example about the spread of the visitors of our Website across …
One of the Christmas presents from Oracle this year was the release of the 10g Business Intelligence tools. Most interesting among them was probably the long awaited Drake release …
This post discusses how data retrieved from a MySQL or Oracle database using the JSTL SQL tags is processed as XML document, transformed using XSL and rendered as SVG …
In this post we discuss pivoting of records in SQL - either splitting or merging records. Typically this is done using PL/SQL based Table Functioins, UNION (for splitting records) …
![Session on XML Publisher – The Successor to Oracle Reports?]({"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"http:\/\/seattletimes.nwsource.com\/ABPub\/2012\/08\/02\/2018836700.jpg","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0"} "Session on XML Publisher – The Successor to Oracle Reports?")