Skip Headers

Oracle9i OLAP Developer's Guide to the OLAP API
Release 2 (9.2)

Part Number A95297-01
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback

Go to previous page Go to beginning of chapter Go to next page

Introduction to the OLAP API, 5 of 6


Developing an OLAP API Application

As an application developer, you perform the following steps to create an OLAP API application:

  1. Decide on general design issues.
  2. Decide on requirements for end-user queries.
  3. Design OLAP API Template objects that create end-user queries. This is an optional step.
  4. Write and test the Java code for the application.
  5. Deploy the application to users.

The rest of this topic presents a general description of each step.

Step 1: Decide on General Design Issues

Consider broad questions such as the following:

Step 2: Decide on Requirements for End-User Queries

Specify, in as much detail as possible, the nature of the queries that the end user will be able to make. Because the OLAP API makes it possible to define queries in a step-by-step process, it is also important to decide on the query modification capabilities that the application will offer the user. Consider questions such as the following:

Planning the end-user queries is a crucial step in the application design process, so you should complete it as thoroughly as possible. Ideally, you should create an end-user query model that identifies all the conceptual query objects with which the application user interface will deal. This strategy takes advantage of the strengths of object-oriented design, and it allows for a clear correspondence between user interface objects and OLAP API objects.

The following are examples of conceptual query objects for an application user interface:

Each of these conceptual query objects can be represented by an OLAP API Template object.

Step 3: Design OLAP API Template Objects That Create End-User Queries

An optional step in implementing an OLAP API application is designing Template objects. This step is recommended because, the use of Template objects offers the following benefits:

For a more detailed example of how Template objects mirror the query-building aspects of an application's user interface, imagine an application that allows the user to create a three-dimensioned cube of data through the following steps:

  1. Choose a measure whose data will be in the cube.
  2. Select the values for each dimension that will provide structure to the cube.
  3. Specify the placement of the dimensions on the three edges of the cube.

As the application developer for this interface, you would design a Template subclass for each of the following objects: dimension, dimension selection, edge, and cube. As part of the design, you would specify methods on the Template subclasses that allow you to combine objects as needed. For example, the edge Template class might have an addDimension method, and the cube Template class might have an addEdge method. Once you have implemented the dimension, dimension selection, edge, and cube Template classes, you can use them again and again in your application. They are basic building blocks in your application's code for querying and manipulating data.

In this stage of the application design process, you should make detailed specifications for each Template in the application. For information about designing Template objects, see Chapter 10, "Creating Dynamic Queries".

Step 4: Write and Test the Java Code for the Application

Up to this step, you have not written any Java code. You have considered questions about the design of your application, and you have made detailed specifications for the Template objects that your application will include. Now you must do the following to implement the application:

  1. Set up the OLAP API client software on your development computer, as described in Appendix A, "Setting Up the Development Environment". If you are designing a three-tiered application, the development computer (from the OLAP API point of view) is the middle-tier computer.
  2. Identify the data store that you will use for developing and testing the application. Ensure that the data is structured as a star or snowflake schema in an Oracle data warehouse, and ensure that the OLAP management feature in Oracle Enterprise Manager has provided the metadata.
  3. Write the Java classes for your application, importing the OLAP API classes as needed. Among the Java classes that you write, include the Template classes that you designed.
  4. Test your application using the test data store.

For information about coding an application that uses the OLAP API, see the subsequent chapters of this guide and the OLAP API Javadoc. See "Tasks That an OLAP API Application Performs" for a description of the tasks that an application typically performs.

Step 5: Deploy the Application to users

Keep the following in mind when you deploy your application:


Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 2000, 2002 Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback