Oracle BI Suite seminar Utrecht
Last Wednesday I visited the Oracle BI seminar in Utrecht. Underneath you find a brief description of the highlights. First of all Wouter van der Brugghen presented the Oracle BI …
Category: Data Analytics
My first steps with Oracle BI Publisher Enterprise Edition 10.1.3.2: create a report based on the OraBlogs rss-feed
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 …
Myths on bitmap indexes
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. …
Oracle BAM with a Bang – Business Activity Monitoring 10.1.3.1 available on OTN
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 …
Testing Knowledge of Database Performance – Is this a good Execution Plan?
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 …
Using an Oracle database link to connect to Excel
August 4, 2006
Data Warehousing & BI, Database, Databases, Development Tools, Oracle, PL/SQL
5 Comments
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 …
One Analytic Function can do more than a thousand lines of code…
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 …
ODTUG 2006 Conference Handouts/Presentations available
June 30, 2006
Data Warehousing & BI, Database, Development Tools, IT, Java, Oracle, Oracle WebLogic Server, PL/SQL
No Comments
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 …
Oracle Data Mining – from SQL and PL/SQL
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 …
Oracle Business Intelligence – news and strategy (from ODTUG 2006)
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 …
The minimum number of statements required for Inserting Records from Two Source Tables into Four Target Tables – Introducing Multi Table Insert
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 …
The long awaited Oracle Warehouse Builder 10g R2 is now available
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 …
Smart denormalization and Enhanced PL/SQL Function Call performance – Comparing Function Based Index and Materialized Views
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 …
The Next Value – How much higher is my salary than the next in (Dense) Rank – Oracle Analytical Functions
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 …
Cost Based Optimizing through time travel? – the value of meta-data for enabling Query Rewrite
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 …
Aggregating in SQL across multiple levels and along several dimensions using ROLLUP and GROUPING SETS
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 …
Session on XML Publisher – The Successor to Oracle Reports?
April 2, 2006
Data Warehousing & BI, Development Tools, IT, Java, Oracle, Oracle E-Business Suite, PL/SQL
6 Comments
![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?")
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 …
Database Systems 2006 – Conference on Service Oriented Architectures
March 28, 2006
Data Warehousing & BI, Database, Databases, IT, Java, Oracle, Oracle WebLogic Server, SOA
No Comments
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 …
ODTUG 2006 Kaleidoscope (Washington) – We are on our way… – AMIS does 9 presentations!
March 28, 2006
AMIS, Data Warehousing & BI, Database, IT, Java, Oracle, Oracle WebLogic Server, PL/SQL
No Comments
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 …
Ever wondered how Soundex works?
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.
Oracle Warehouse Builder 10gR2 Beta 4 – Paris is drawing closer…
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 …
Steve Adams is in town – Oracle with a calculator
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 …
Death of the End Date – How LAG and LEAD help fight redundancy
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 …
Summary results for all dates, including the ones that I do not have data for – example of using Partition Outer Join – Oracle10g SQL Feature
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 …
Data Profiling with Oracle Warehouse Builder 10gR2 (article in Dutch)
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 10g R2 does not support Oracle Warehouse Builder.
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 …
Bizgres 0.7 Released – Open Source platform for Business Intelligence and ETL
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 …
Oracle Warehouse Builder – 10gR2 Paris release – Even if you do not build warehouses…
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 …
Oracle Warehouse Builder 10g Paris Release … Oh ja, ook voor Data Warehouses! (article on the OWB 10gR2 Paris Release)
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 …
Introducing Materialized Views as mechanism for Business Rule implementation (complex declarative constraints)
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 …
How to drive your colleagues nuts – dbms_advanced_rewrite (Oracle 10g)
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 …
Migration from MySQL to Oracle – using Oracle Migration Workbench
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 …
Oracle Warehouse Builder 10gR2 (beta), a first impression
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 …
Model driven Design of ETL functions
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, …
Courtesy of Tom Kyte: Generating rows in SQL with the CUBE statement – no dummy table or table function required
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 …
Oracle Business Intelligence Spreadsheet Add-In Available for Download
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 …
Paris for the Designer
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 …
SVG (Scalable Vector Graphics) and Maps of the World
January 12, 2005
Data Warehousing & BI, IT, Java, Oracle, Oracle WebLogic Server, Web HTML5 CSS3
No Comments
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 …
Oracle 10g Discoverer Drake available for download
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 …
Generating SVG Graphics in JSPs using JSTL & XSL(T) – from MySQL to Bar Chart and Pie Chart
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 …