Hitachi Vantara Pentaho Community Forums
Results 1 to 16 of 16

Thread: [Mondrian] Parallelization of MDX queries in mondrian using OpenCL

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Abhishek Sharma Guest

    Default [Mondrian] Parallelization of MDX queries in mondrian using OpenCL

    Hello all,

    With opencl in current picture of parallel computing, is it possible
    (even more, is it feasible in the first case) to optimize the
    performance of cube and roll operations in MySQL using opencl?? Kindly
    respond to this.

    Thank You.

    --
    Abhishek Sharma
    B-Tech Information Technology
    Indian Institute of Information Technology Allahabad
    _______________________________________________
    Mondrian mailing list
    Mondrian (AT) pentaho (DOT) org
    http://lists.pentaho.org/mailman/listinfo/mondrian

  2. #2
    Abhishek Sharma Guest

    Default [Mondrian] Re: Parallelization of MDX queries in mondrian usingOpenCL

    Hello all,

    With opencl in current picture of parallel computing, is it possible
    (even more, is it feasible in the first case) to optimize the
    performance of MDX queries on cubes using opencl?? Kindly
    respond to this.

    Thank You.


    --
    Abhishek Sharma
    B-Tech Information Technology
    Indian Institute of Information Technology Allahabad
    _______________________________________________
    Mondrian mailing list
    Mondrian (AT) pentaho (DOT) org
    http://lists.pentaho.org/mailman/listinfo/mondrian

  3. #3
    Julian Hyde Guest

    Default RE: [Mondrian] Parallelization of MDX queries in mondrian using OpenCL

    > Abhishek Sharma wrote:
    >
    > With opencl in current picture of parallel computing, is it possible
    > (even more, is it feasible in the first case) to optimize the
    > performance of cube and roll operations in MySQL using opencl?? Kindly
    > respond to this.


    Is your question about Mondrian or MySQL?

    Mondrian is implemented in Java, so opencl is not an option.

    Julian

    _______________________________________________
    Mondrian mailing list
    Mondrian (AT) pentaho (DOT) org
    http://lists.pentaho.org/mailman/listinfo/mondrian

  4. #4
    Abhishek Sharma Guest

    Default Re: [Mondrian] Parallelization of MDX queries in mondrian using OpenCL

    No its about Mondrian only, sorry for the previous error. Plus we do
    have opencl bindings for java available as well known as JOCL. So with
    this scene in front of us, I repost my question, is it possible to
    parallelize MDX queries in mondrian using OpenCL??

    Regards,

    Abhishek Sharma
    B-Tech Information Technology
    Indian Institute of Information Technology Allahabad
    _______________________________________________
    Mondrian mailing list
    Mondrian (AT) pentaho (DOT) org
    http://lists.pentaho.org/mailman/listinfo/mondrian

  5. #5
    Julian Hyde Guest

    Default RE: [Mondrian] Parallelization of MDX queries in mondrian using OpenCL

    > Abhishek Sharma wrote:
    >
    > No its about Mondrian only, sorry for the previous error. Plus we do
    > have opencl bindings for java available as well known as JOCL. So with
    > this scene in front of us, I repost my question, is it possible to
    > parallelize MDX queries in mondrian using OpenCL??


    Clearly it doesn't work at present. We have no OpenCL support whatsoever.

    If would be possible to implement certain MDX functions in OpenCL, and
    create Java wrappers for them using JOCL. That would be an interesting
    project. I would tend to focus on the MDX functions/operators that tend to
    be performance-intensive, such as Filter, Order, TopCount/BottomCount,
    Crossjoin.

    See http://jira.pentaho.com/browse/MONDRIAN-874 for a discussion of
    parallelism. Many of the issues raised in that bug would relate to an OpenCL
    implementation.

    Julian

    _______________________________________________
    Mondrian mailing list
    Mondrian (AT) pentaho (DOT) org
    http://lists.pentaho.org/mailman/listinfo/mondrian

  6. #6
    Abhishek Sharma Guest

    Default Re: [Mondrian] Parallelization of MDX queries in mondrian using OpenCL

    Thanks

    --
    Abhishek Sharma
    B-Tech Information Technology
    Indian Institute of Information Technology Allahabad
    _______________________________________________
    Mondrian mailing list
    Mondrian (AT) pentaho (DOT) org
    http://lists.pentaho.org/mailman/listinfo/mondrian

  7. #7
    Abhishek Sharma Guest

    Default Re: [Mondrian] Parallelization of MDX queries in mondrian using OpenCL

    One more thing I wanted to confirm from you Julian is that - In SSAS
    provided by Microsoft (which I currently use for BI) the cube is a
    separate storage of data which is created out of the RDBMS (i.e
    created about dimensions and facts of course). But I don't think its
    the same in Pentaho mondrian, right?? There we are directly using the
    data and agreegating it in runtime, right?? If not please correct me
    wherever i am wrong. Thanks



    --
    Abhishek Sharma
    B-Tech Information Technology
    Indian Institute of Information Technology Allahabad
    _______________________________________________
    Mondrian mailing list
    Mondrian (AT) pentaho (DOT) org
    http://lists.pentaho.org/mailman/listinfo/mondrian

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.