1

I would like to get metadata for all (or as many as possible) databases that are available online. It does not have to be an open database. It is only the metadata that is important for me. The data I am interested in are e.g.:

  • Number of tables
  • Number of relations
  • Number of rows in each table (or average for whole database)

Is there a place that gathers such information?

closed as too broad by philshem, Mark Silverberg, Joe Germuska, jknappen, Jeanne Holm Mar 25 '16 at 21:29

Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.

  • I'm thinking this might be a bit broad ... at the very least, you have to define what a 'database' is, because not all are relational & built around tables. Even for something like mysql, what they call a 'database', Oracle would consider to be a 'schema', so would an Oracle server running 4 SIDs with 6 schemas each be 1, 4 or 24 'databases' ? – Joe Mar 21 '16 at 14:48
  • Now, if those 4 SIDs are because I have production, development, test/QA, and a daily snapshot (for backups or for long-running reports), would that change your answer? What about if they were running on 4 different systems? What if it was 4 virtual systems, but the same physical hardware? Now, you might argue that you didn't ask about number of databases, but this is inversely related to the number of tables in a given database. – Joe Mar 21 '16 at 14:53

Browse other questions tagged or ask your own question.