Hello. I can not understand how to approach the training task. There is a task:

Create a data analysis system using Oracle Express , consisting of a multidimensional database, loading procedures and a user application.

For dimensions, determine the list of hierarchies and levels of detail. For indicators - a list of measurements by which it is indexed, as well as the division of measurements into dense and sparse.

Multidimensional database should contain 2-3 indicators, indexed by 4-6 measurements each. Based on the MDB, create a custom application consisting of 4-5 reports of various types.

I understand that you need to do this:

  1. Install Oracle Express (is this ?)

  2. Come up with a structure (OLAP-cube). For example, such ( star ): alt text

  3. Create ordinary relational database

     CREATE TABLE ... ALTER TABLE ... CREATE SEQUENCE ...

    And fill with, let's say

     INSERT INTO

    There will be a normal relational base.

  4. Then create an application, for example, in Java + JDBC (the only thing I had to deal with). The application will show summary tables for several indicators.

Do I understand the task correctly? Or should this cube be created somehow differently? The following part of the task is still not clear:

Multidimensional database should contain 2-3 indicators, indexed by 4-6 measurements each.

In the picture example we have 4 dimensions, right? And what is there an indicator? One last thing: what is the boot procedure?

    2 answers 2

    The answer was found, if anyone is interested (and next year it will definitely be interesting again for some students).

    It turned out that the task should be carried out as follows: the first three points from the question are correct. And the fourth point is to create a multidimensional database (MDB) on the basis of relational (RBD). To do this, you need to find the Orkal in the “warehouse” , - Oracle® Express Release 6.3.4.0 Media Pack (download both client and server parts).

    It is important to know that Oracle Express is stable ONLY on WindowsXP, 32 bits. Even when running on 32-bit Windows Vista, when you try to connect Oracle Express Administrator to Personal Express 3.2.x, an exception is raised indicating XPHEAP.dll. Apparently, this "heap" is not backward compatible. In general, the application offers either to close it, or to debug it, and it closes!

    My example.

    OLAP-cube with four dimensions in the shape of a star. Theme "Airline". For the fact accepted airline flights. 4 measurements: departure airport, destination airport, whether the flight is a charter and date (flight time, year). Two indicators: the number of flights and the number of tickets sold.

    Cube structure in Oracle Express Administrator: alt text

    Filling a cube is best done using a special program in Oracle Express Language, because it is not possible through the user interface. Connect:

     sql.dbms='oracle' sqlmessages = yes sql connect 'system/123@xe' - это логин и пароль к РБД

    The rest of the commands are described here . After that you should get a report. The standard chart in the report looks like this:

    alt text

      Pay attention to tsiferki 1, 2, 3

      • Oracle is generally needed, but thanks for that. - angry