Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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.

share|improve this question
    
Has there been any update or progress in finding an Open Source Metadata Management Solution, since you posted this in 2011? Thx, Jeff –  Jeff Jan 10 at 16:49
add comment

closed as off-topic by Mark Storey-Smith, Paul White, RolandoMySQLDBA, Michael - sqlbot, Max Vernon Jan 12 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.

3 Answers

up vote 2 down vote accepted

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.

share|improve this answer
add comment

MIKE?

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.

share|improve this answer
    
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
add comment

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.

share|improve this answer
add comment

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