Presentations - 2003

You must have an Adobe Acrobat compatible reader installed to view our presentations. If you would like to have a copy of a paper or presentation we have given that has not yet been posted, please send an e-mail to papers@vlamis.com with the name of the conference and the year you need. Links to presentations will open in a new window.

IOUG Live! 2003

Website

University Class - Getting Business Intelligence Out of Your Data Warehouse-The Short Course

Presented by Chris Claterbos

This class will present the new technologies that were introduced with Oracle9i and 9i Internet Developers Suite (9iDS). These include, analytical functions in the relational database, OLAP Services, 9i Oracle Warehouse Builder (OWB), Java OLAP API, and BI Beans. Attendees will see how to use Oracle9i, OLAP Services, 9i OWB, JDeveloper 9i and BI Beans to build an OLAP aware warehouse and then develop simple and complex applications to view the warehouse data. A comparison between thick and thin client applications will also be discussed. The outline consists of:

  1. Technology Overview
  2. OLAP using the relational engine - An Intro to 9i OLAP
  3. Using OWB 9i to Design and Populate the Warehouse
  4. Analytic Workspace or Relational which is best?
  5. BI Applications - what are our options?
  6. Programming with BI Beans - The Basics
  7. Building Custom Applications
  8. Debugging and Deploying you application
  9. Wrapping it all up - Q&A

The attendees will be shown how to start building OLAP warehouses and developing applications using BI Beans and JDeveloper. A sample datamart will be build and an application will be built to access this data during the class and all attendees will have access to the resulting application code.

Developing Applications with Business Intelligence Beans and Oracle9i JDeveloper- Our Experience

Presented by Chris Claterbos

This presentation will detail the processes and the experiences that Vlamis Software had during the process of developing a commercial BI Application built using JDeveloper 9i and BI Beans. Attendees will see how to use Oracle9i, OLAP Service, JDeveloper 9i and BI Beans to develop simple and complex applications. A comparison between thick and thin client applications will also be discussed. The attendees will be shown how to start developing applications using BI Beans and JDeveloper. An actual application will be presented. The experiences of the development process will be presented along with tips and techniques.

Migrating Applications and Data to Oracle9i OLAP - Case Studies

Presented by Dan Vlamis

With the introduction of Oracle9i and BI Beans, the landscape for development of BI applications has changed. This leaves clients with existing Express-based applications asking "How do we move our applications and data?" and "Do we store our OLAP data in RDBMS tables or analytic workspaces?". This presentation will address the issues involved in converting and migrating these types of applications over to the new technology. Case studies will be presented and used throughout the presentation.

Topics Include:

  • Overview of the Oracle9i and BI Beans Architecture
  • Data Migration Issues
  • What Can and Cannot Be Migrated/Converted
  • Conversion vs. New Development - Which is Best or Possible
  • Development Process (steps)
  • Tips and Techniques
  • Design and Implementation Issues

Using Oracle Warehouse Builder 9i and Oracle 9i to create OLAP ready Warehouses

Presented by Chris Claterbos

With the use of the new features found in Oracle's Warehouse Builder(OWB) 9i and Oracle9i we can now design, construct and load a data warehouse that is fully OLAP ready. This presentation will introduce the attendee to OWB 9i and Oracle 9iOLAP and how to design and construct an Oracle9i database that can be used for OLAP analysis and presentation. The new OWB API will also be presented as well as the new OLAP migration wizards. Implementation and design issues will also be addressed. A step-by-step guide will be presented with the end result being a completed OLAP ready datamart. A complete End-to-End demonstration will be presented.

KCOUG Fall Conference

 

Oracle's Business Intelligence Technologies

Presented by Dan Vlamis

Are you considering building a business intelligence/data warehousing solution? Are you experiencing integration pain from a "best of breed" solution or a metadata mess? Who has the latest data? What impact will this change have? How can you turn your queries into reports? How do you take advantage of the latest Oracle Database features? This technical session will discuss Oracle's business intelligence components (Warehouse Builder, Discoverer, BI Beans, Reports, and Portal). Incorporated in this "survey" of the Oracle BI stack will be demonstrations of some of these products. It concludes with a review of the advantages of an integrated approach. This information has been updated to include the latest information released at OracleWorld in September on future releases such as Oracle Database 10g and OracleAS Discoverer 10g.

ODTUG 2003

Website

An End-to-End Solution Using OWB and JDeveloper to Analyze Your Data Warehouse

Presented by Dan Vlamis

This presentation will produce an actual, completed, OLAP-ready datamart, with a working BI application. It will include the new OWB API and new OLAP migration wizards, with a step-by-step guide addressing implementation and design issues as well as how to use OLAP Service, JDeveloper 9i, and BI Beans to develop simple and complex applications. Tips on the development of a commercial BI Application built using JDeveloper 9i and BI Beans will also be presented.

Effectively Using 9i OLAP in Business Intelligence Applications

Presented by Dan Vlamis

This presentation will describe the components of Oracle9i LOAP. Armed with information answering "What is an analytic workspace?" and "What metadata is required to support the Java OLAP API and BI Beans?", a designer will be able to design a data warehouse or data mart for use by a business intelligence application. In addition, a manager will understand what options are possible and how to gain maximum value from a data warehouse or data mart.

OracleWorld 2003

Website

Using Oracle Warehouse Builder to Create OLAP Warehouses

Presented by Dan Vlamis and Chris Claterbos

With the use of the new features found in Oracle's Warehouse Builder(OWB) 9i and Oracle 9i we can now design, construct and load a data warehouse that is fully OLAP ready. This presentation will introduce the attendee to OWB 9i and Oracle 9i OLAP and how to design and construct an Oracle 9i database that can be used for OLAP analysis and presentation. The new OWB API will also be presented as well as the new OLAP migration wizards. Implementation and design issues will also be addressed. A step-by-step guide will be presented with the end result being a completed OLAP based datamart. A complete End-to-End demonstration will be presented.

Outline:

  1. New Features of OWB
  2. Overview of OLAP features of Oracle 9i
  3. Designing a Multidimensional Database with OWB
  4. Designing the Datamart
  5. Updating the 9i Metadata
  6. Loading and Viewing Data
  7. Managing with OEM and AW Manager
  8. Using the OWB 9i API
  9. Issues with Design and Implementation
  10. Viewing the Data