Difference between catalog and metadata?
Date: Tue, 21 Jul 2009 17:22:00 -0700 (PDT)
I'm doing a little research into database metadata for various products like DB2, Oracle, SQL Server, and MySQL. I want to learn about where information on tables and views are stored.
What is the difference between the system catalog and metadata? Is one a superset of the other?
Which one of them contains logical and physical information on the tables and views (e.g. how they are partitioned, the schemas, etc.)?
Is there a SQL / ANSI standard on what information should be stored in the catalog / metadata? Received on Tue Jul 21 2009 - 19:22:00 CDT