Hitachi Vantara Pentaho Community Forums
Results 1 to 11 of 11

Thread: Metadata

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Join Date
    Jul 2005
    Posts
    6

    Default Metadata

    Hi,

    I've had a skim over the roadmap and everything, and am currently using some of the tools that are targeted for this project.

    My only concern is, I havent seen any common metadata layer ?

    It's pertenant in my mind, as I'm currently maintaning a SAS Metadata server, Webfocus metadata and Cognos metadata and it made me realise that there arent any good open source metadata servers out there.

    Certainly nothing that covers business and technical metadata, or anything that has the scope for an whole-of-enterprise setup ... well, I should say, not that I know of.

    With all the tools we're looking at in Pentaho, a metadata layer would be essential in tying it all together.

    Food for thought.

    Tim.

  2. #2
    Join Date
    Jul 2005
    Posts
    10

    Default Re:Metadata

    This is interesting and I have been thinking of it too. Maybe in a slightly different way.

    I think the reason that there is no OSS Metadata layer is because there was no need. There was nothing like Pentaho. Parts and pieces but no combined tool.

    In the reporting world (BIRT, JasperReports and such) mapping could be done via a domain layer (JDO, Hibernate, EJBs, etc). This is also done with applications (ie OLTP) It would be nice if this could be reused in the other areas such as ETL and Analysis. I had suggested this in the Mondrian forums but only got negative responses.

    I've seen a little of what COGNOS has but I think it is very data centric and probably isn't for everything in the enterprise (I could be wrong - these are just my thoughts).

    I would like to see this worked out so there is little duplication of effort but works well for the different "stacks" (ie ETL, Reporting, OLTP, ...).

    I definitely think this is something that would be useful in Pentaho. I would love to hear others' thoughts .

  3. #3
    Join Date
    Jun 2005
    Posts
    144

    Default Re:Metadata

    There is already a good "base" for this in the Common Warehouse Metamodel. I believe Mondrian uses parts of this as well, however I've never looked that closely.

    I think that CWM is "broad" enough that there is much ambiguity in using it between products. The OSS community could really bring the standard into usefulness by using it as the basis for it's BI/DW/ETL metadata repository...

    Anyhow... something to mull... I believe the OMG also has Java classes that implement the model, but I'm not sure about that either...

    Nick

  4. #4
    Join Date
    Jul 2005
    Posts
    10

    Default Re:Metadata

    Sounds like a good idea.

    I had not seen that in Mondrian. I'll have to dig for it.

    Did a quick google and it looks like JOLAP "uses the CWM OLAP metamodel". On the down side, JOLAP (sadly) seems to be going no where. I've not heard anything new about it lately. Anything I find is old news. Mondrian does support JOLAP, somewhat, and that might be the connection to CWM.

  5. #5

    Default Re:Metadata

    Mondrian does use CWM as part of its JOLAP implementation - I think that is part of the JOLAP spec. Given that JOLAP does appear to be going nowhere, the JOLAP API in Mondrian has not been used by the Mondrian community.


    Sherman

  6. #6
    Join Date
    Jul 2005
    Posts
    10

    Default Re:Metadata

    Maybe this project will give more exposure to Mondrian/JPivot and thus get the big vendors to start moving on JOLAP again.

    That or look for IBM or Oracle to buy the main company behind Mondrian and/or JPivot.

  7. #7
    Join Date
    Jul 2005
    Posts
    6

    Default Re:Metadata

    Keep in mind, that metadata should go ALOT further than OLAP, Id really love to see Octopus extended to support a metadata layer in ETL, and Jasper utilizing this also.

    Maybe I'm a dreamer, but when I think of a integrated platform, I really think of common threads between naming conventions, or business terms for things. In our business we have different business units that would give you a different definition of a "Standard Claim", this is where the power of a COMMON metadata layer is.

    Even if JOLAP were ramped up, I dont think this will support a common metadata layer/repository for all the reporting components in the pentaho platform.

    (I should note, I have not used JOLAP, so am speculating about its use).

  8. #8
    Join Date
    Nov 1999
    Posts
    9,729

    Default Re:Metadata

    Well Tim, you have been heard.
    Check out "Pentaho metadata" & if you have questions join us on the forum with the same name.

    Matt

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.