Results 1 to 5 of 5

Thread: olap

  1. #1
    Join Date
    Dec 2008
    Posts
    11

    Unanswered: olap

    i know info websphere is not for free. Now i have db2 9.5 and i want to some olap stuff. is some there where i can do olap for free.Just for learning .Please let me know
    Khasim Shaik

    Senior Informatica Developer
    Leesburg,VA

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    SQL that supports some OLAP functionality in the SQL itself is described in the SQL Reference Vol 1. This is not the same a OLAP product, but I am not sure what you need.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Dec 2008
    Posts
    11
    i am trying to do some olap like creating Star schema and doing some data mining based on that .... i hope i am clear now...Its possible using Cube Views. But now cubes views is not possible in db2 9.5( i think i am new to DB2 itself) because i have to install Design Studio which is a part of info web sphere and i am wondering is there any way i can work around!!!

    Please let me know if you want to know some more details


    Regards

    Khasim
    Khasim Shaik

    Senior Informatica Developer
    Leesburg,VA

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Check out the SQL Reference Vol 1.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  5. #5
    Join Date
    Sep 2004
    Location
    Belgium
    Posts
    1,126
    Quote Originally Posted by Marcus_A
    Check out the SQL Reference Vol 1.
    More specifically, see pages 591-596 of the DB2 9.5 for LUW version of this manual, and the examples on pages 605-611.
    You can GROUP BY:
    - grouping sets
    - rollup
    - cube
    or any combination of these (also combined with single column grouping, or grouping by expression).
    Example (from the manual):
    Code:
    SELECT MONTH(SALES_DATE) AS MONTH,
           REGION,
           SUM(SALES) AS UNITS_SOLD,
           MAX(SALES) AS BEST_SALE,
           AVG(SALES) AS AVG_UNITS_SOLD
    FROM   SALES
    GROUP BY CUBE(MONTH(SALES_DATE),REGION)
    ORDER BY MONTH, REGION
    will return summaries per month, per region, per month/region combination, and a grand total row:
    Code:
    MONTH REGION            UNITS_SOLD BEST_SALE AVG_UNITS_SOLD
    ----- -------------- ----------- ----------- --------------
        3 Manitoba        22   7 3.14
        3 Ontario-North    8   3 2.67
        3 Ontario-South   34  14 4.25
        3 Quebec          40  18 5.00
        3 -              104  18 4.00
        4 Manitoba        17   9 5.67
        4 Ontario-North    1   1 1.00
        4 Ontario-South   14   8 4.67
        4 Quebec          11   8 5.50
        4 -               43   9 4.78
       12 Manitoba         2   2 2.00
       12 Ontario-South    4   3 2.00
       12 Quebec           2   1 1.00
       12 -                8   3 1.60
        - Manitoba        41   9 3.73
        - Ontario-North    9   3 2.25
        - Ontario-South   52  14 4.00
        - Quebec          53  18 4.42
        - -              155  18 3.87
    Last edited by Peter.Vanroose; 12-29-08 at 09:55.
    --_Peter Vanroose,
    __IBM Certified Database Administrator, DB2 9 for z/OS
    __IBM Certified Application Developer
    __ABIS Training and Consulting
    __http://www.abis.be/

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •