Name Bob the Warehouse Builder meets Don the DataMiner: From Creative Bookkeeping to Fortune Telling date Wed, 16 Apr 2003

Paper on the Oracle 9i Business Intelligence (prepared for the ODTUG 2003 conference and nominated for the Best Presentation Award):

The functionality offered by Oracle 9i DataWarehousing, OLAP/BI and DataMining is quite astonishing. A wide range of increasingly integrated tools gives surprising added business value to your data: Warehouse Builder, BI Beans, Oracle 9i OLAP and Oracle 9i JDeveloper Wizards for DataMining. Analyze what happened in your business – trends and exceptions to the trends- or, even more fascinating, predict what will happen. This presentation gives a complete overview, from transactional data to data mining, of how to unearth the hidden patterns of the past and the story of the future. Using 5 years of -fictional- ODTUG conference attendance data, how can you build a warehouse, analyze the favorite topics and speakers and the shifts in the popular mood and finally predict the size and composition of the audience for this year’s sessions?

Download

paper, presentation

Name Unchained Migration to Designer 9i: step by step, repeatedly and bi-directional date Mon, 21 Apr 2003

This paper was prepared for the ODTUG 2003 ConferenceStandard migration functionality in Designer 6i/9i forces you to migrate all interdependent application systems in one go – and never look back. Due to the many relationships between application systems, this typically means an all-or-nothing option for all your applications and projects.

This presentation demonstrates – using a real-world case – how you can migrate your application systems at your own convenience, one or several at a time to the workarea of your choice. It shows how you can repeatedly migrate the same application system, allowing further developments in a Designer 6.0 Repository to be added to the Designer 6i/9i Repository – allowing interrelated projects to carry on in different repositories. It even shows you how changes in the 6i/9i Repository could be replicated in the original 6.0 Repository. The presentation will touch upon distributed and replicated repositories.

Download: paper, presentation

Name Soul Searching – Browsing and Extending Oracle Designer, Repository Object Browser and Oracle SCM date Thu, 24 Apr 2003
This presentation received the award for Best Presentation during the ODTUG 2003 Conference

Understanding the model and meta-model (meta-meta data) and API of Oracle Designer and Oracle SCM is the key to analyze and report on the definitions and project data in the Repository. It is also the starting point for extending the functionality. This presentation will go further than man has gone before.

The presentation explains the model for Oracle SCM, demonstrate an event- and alert-mechanism for Oracle SCM, introduce a simple engine for calculation of project estimates and tracking of progress. It will show how you can interpret and manipulate the meta-meta data to have Designer jump through your hoops. The recent introduction of the web-based Repository Object Browser (ROB) adds valuable read-only access to Designer and the Software Configuration Manager. This presentation, by the original developer of that tool, gives an overview through demos. It will also let you in on some interesting ways to customize and extend the ROB.

Download: paper, presentation

Name Building Multilanguage Applications with Oracle9iDS TranslationHub date Mon, 02 Jun 2003

This paper was nominated for the Best Paper award for the ODTUG 2003 Conference

The demand for multilingual support is growing, especially for web applications. Typically, web applications have users all over the world which all have there own preferred language. The location of the installation does not necessarily determine the language the user wants to work in. Offering multilanguage applications on the web will improve the users satisfaction. In addition, multilingual applications can improve the productivity significantly for multinationals as well as companies in multilingual countries such as Canada, Switzerland and Belgium.

This paper will guide the reader through the steps of building a multilingual application with a focus on the translation of the user-interface-text-strings that can be performed with the new Oracle 9iDevelopmentSuite TranslationHub. Moreover, this paper will provide better insight in the various decision-making aspects when working with the Translation Hub. Various other related issues will be discussed briefly to give the reader a completed view on creating multilingual applications with the Oracle 9i Development Suite.

Download: paper, presentation

Name Using xsql to implement xml-interface for existing oltp application date Fri, 20 Jun 2003

Written for the ODTUG 2003 Conference

Opening up existing applications for integration with external parties can quite easily be done using XML and Oracle XSQL. This paper will discuss a project that developed an XML interface-for read and write access-around an existing Oracle Forms application. It describes an approach that can be generically applied to other applications, like your own. This paper describes how the XSQL-Servlet can be used in the development of an XML-interface exposing the existing Forms application’s data to external applications. Our client was looking for an automated solution based on open standards for their daily flow of freight orders and consignment notes. Orders were received from customers by facsimiles, then typed into the application by hand and sent by Reports to shipping agents. We decided to use XML and the Oracle XSQL-Servlet to build the interface. Under the covers we make use of Object Views with Instead-Of Triggers.

The paper demonstrates how we built the XML-interface around the existing application, and how you could do the same for XML-enabling your applications. To prove this we will demonstrate how we applied this approach to the creation of an XSQL based utility for viewing our PL/SQL API-documentation, stored in the Designer repository, in a web-browser.

Download: paper, presentation

Name Management Overview from ODTUG 2003 – Report from the Beach (Dutch) date Sun, 13 Jul 2003

A concise presentation (mainly in Dutch) of the highlights and most promising developments from ODTUG 2003. AMIS presented this overview in August 2003 to some of its business relations.

Download

presentation (13 Mb)

Name JHeadstart 10g – Productieve J2EE Web Applicatie ontwikkeling zonder programmeren?! date Sun, 12 Oct 2003

Article (Dutch) for the Dutch Professional Oracle Developer’s Magazine Optimize on JHeadstart. Download 

JHeadstart 10g – Productieve J2EE Web Applicatie ontwikkeling zonder programmeren?!

Name Bookreview Oracle 9iR2 Data Warehousing date Sat, 15 Nov 2003

Article (Dutch) for the Dutch Oracle User Group’s Magazine OGH Visie. This article is a book review on an introduction to the Oracle 9i Release 2 RDBMS’s features for Datawarehouses and Business Intelligence.

Download

Oracle 9iR2 Data Warehousing (Boekbespreking)

Name BI Beans – Java toolbox voor de ontwikkeling van geïntegreerde Business Intelligence componenten date Thu, 20 Nov 2003

Article on BI Beans in Optimize (in Dutch)The Optimize can be considered the leading Dutch Oracle Magazine. This bi-monthly publication covers a wide range of Oracel technology inspired subjects. The December 2003 issue features story on Oracle BI Beans, written by Lucas Jellema, Expertise Manager Application Development at AMIS.

Zoete BI Beans stillen Honger naar Business Intelligence

BI Beans – Java toolbox voor de ontwikkeling van geïntegreerde Business Intelligence componenten

Oracle heeft de afgelopen anderhalf jaar in haar productaanbod grote stappen gezet op het terrein van Data Warehouses en Business Intelligence. Sprekende voorbeelden hiervan zijn de integratie van de OLAP- en Data Mining-engines in de Oracle 9i database, de (her)lancering van Oracle Warehouse Builder, de sterk uitgebreide SQL functies voor ETL en Analytische bewerkingen in Oracle 9i en niet in het minst de BI Beans.

De Oracle BI Beans zijn Java componenten waarmee een ontwikkelaar op productieve wijze Business Intelligence functionaliteit – zoals Cross-tables en meer dan 70 soorten grafieken met ‘drilldown’ – kan inbouwen in applicaties. BI Beans kunnen worden gebruikt in Java Client en Applet applicaties, Servlet en JSP applicaties en ook (Web)Forms applicaties. In dit artikel bekijken we wat je zoal kunt met BI Beans en hoe je in slechts enkele stappen Business Intelligence functionaliteit kan ontwikkelen.

Download

Article