Re: Difference between catalog and metadata?
From: Bob Badour <bbadour_at_pei.sympatico.ca>
Date: Wed, 22 Jul 2009 01:05:27 -0300
Message-ID: <4a668dab$0$23767$9a566e8b_at_news.aliant.net>
Date: Wed, 22 Jul 2009 01:05:27 -0300
Message-ID: <4a668dab$0$23767$9a566e8b_at_news.aliant.net>
Digital Puer wrote:
> 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?
Sounds like homework to me. Received on Wed Jul 22 2009 - 06:05:27 CEST