Is there an Open Source Metadata Management Solution? I'd like to create a Metadata Repository that will hold the details of the metadata of database schemas, tables and data items of hundreds of Enterprise databases.

I'm especially interested in something that can automatically query the schema data of the databases to be able to track changes in the metadata related to tables. i.e. changes to column data sizes, tables and columns added etc.

closed as off-topic by Mark Storey-Smith, Paul White, RolandoMySQLDBA, Michael - sqlbot, Max Vernon Jan 12 '14 at 22:00

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Shopping list question - questions about which tool, library, product or resource you should use are off-topic here because they quickly become obsolete and often are just about the preferences of the answerer. If you have an issue with or a question about a specific tool, please revise your question to conform to that scope." – Mark Storey-Smith, Paul White, RolandoMySQLDBA, Michael - sqlbot, Max Vernon
If this question can be reworded to fit the rules in the help center, please edit the question.

  • Has there been any update or progress in finding an Open Source Metadata Management Solution, since you posted this in 2011? Thx, Jeff – user32709 Jan 10 '14 at 16:49
  • 1
    This is an old question, but I've been working on an open-source metadata management system called the Aristotle Metadata Registry. Its open-source, relatively modern and based on existing government big data management platforms. Worth a look. – user99984 Jul 13 '16 at 5:24

I'm not aware of any open-source tool that would scale to 'hundreds of enterprise databases.' The closest things that come to mind are:

  • Dia has a basic modelling engine that could be used to create UML models. However, I think you would have to write a lot of glue to get the models into Dia in the first place.

  • Eclipse Modelling Framework (EMF) has modelling features and also a model diff/merge tool, which might get you somewhere towards your change tracking requirement. However, I think you would still have to write an awful lot of glue to make this work.

Beyond that, you're probably up for a commercial repository tool like Powerdesigner, Erwin or Embarcadero. If you're actually working for an outfit that has 'hundreds of enterprise databases' on the books there's a chance they might have something like this on the books already.



What is MIKE2.0?

MIKE2.0 which stands for Method for an Integrated Knowledge Environment, is an open source methodology for Enterprise Information Management that provides a framework for information development . The MIKE2.0 Methodology is part of the overall Open Methodology Framework.

  • Thank you! This is very interesting. Though it doesn't suggest a particular Open Source Metadata Management tool, it does define many best practices. Thanks for pointing it out. – Stuart Woodward Jun 20 '12 at 5:32

How about Pentaho Metadata Editor?

A Conceptual Overview of the Pentaho Metadata Editor

Pentaho Metadata Editor documentation

Another option would be to use a tool like liquibase to manage all database schema changes and keep those changes in git source control.

PostgreSQL has a "comment" feature which lets you add comments to database objects, which you could use to help analysts understand things. For example, we put Javadoc style comments in PG comments, and generate docs based on that.

Not the answer you're looking for? Browse other questions tagged or ask your own question.