Re: Definition: A Catalog vs. a Database?

My mental model:
A catalog contains metadata about a database. A database contains data.

The master database contains metadata/data.
A catalog of the master database would contain metadata about the
master database which contains data about the server.

In BOL:
Querying the SQL Server System Catalog
Metadata Visibility Configuration
master Database

John Heitmuller wrote:
Am I correct in thinking that a catalog is structurally identical to a
database in everyway? The only thing that distinguishes a catalog from
a database is that a catalog stores information about databases, not
user data. Thus, the "master" database on a server is the catalog
for that server.

This may seem like I'm picking gnats out of pepper. But, I'm
seeing the terms catalog and database used interchangeably in some
context, but not in others.

Thanks,
John

.

Relevant Pages

  • Re: Locks & FT Catalogs
    ... Director of Text Mining and Database Strategy ... Looking for a SQL Server replication book? ... in the 6 hours after that either) leaving that catalog completely unusable ... synchronise their changes from staging to live (or vice versa to roll ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Definition: A Catalog vs. a Database?
    ... These are views of the catalog ... metadata for that specific individual database. ... management of the SQL Server (for example, ...
    (microsoft.public.sqlserver)
  • Re: Cataloging program
    ... with a bar code reader that will make cataloging books ... keep them on a database, especially if I can sort that database to ... But mainly I'm looking to catalog books. ...
    (comp.sys.mac.apps)
  • Re: Metadata versioning
    ... > growing database applications as clients evolve with versions. ... to store the metadata version information. ... I created a set of classes to completely describe the metadata or schema ... catalog tables, and schema reading routines, I can move between metadata ...
    (borland.public.delphi.non-technical)
  • Re: Simple MYSQL Normalization question - input requested.
    ... I'm writing a simple web-based database application for a local ... a mail order catalog once a month of items for sale, ... time - call them Ford, Chevy, Dodge, Subaru, Mercedes, etc. ... Category3 and Category4 fields to the item database? ...
    (comp.lang.php)
Loading