Database catalog
A database catalog of a database instance consists of metadata in which definitions of database objects such as base tables, views (virtual tables), synonyms, value ranges, indexes, users, and user groups are stored.[1][2] It is an architecture product that documents the database's content and data quality.[3]
Standards
The SQL standard specifies a uniform means to access the catalog, called the INFORMATION_SCHEMA, but not all databases follow this, even if they implement other aspects of the SQL standard. For an example of database-specific metadata access methods, see Oracle metadata.
See also
- Data dictionary
- Data lineage
- Data Catalog Vocabulary, a W3C standard for metadata
- Metadata registry, central location where metadata definitions are stored and maintained
- Metadata repository, a database created to store metadata
References
- ^ Paul C. Tinnirello (1999). Systems Development Handbook. CRC Press. ISBN 0-8493-9822-3.
- ^ CREATE VIEW (Transact-SQL) in SQL Server 2008 Books Online, Microsoft Corporation
- ^ "Databasekatalog | QualiWare Center of Excellence". Retrieved 2024-09-28.
 | This database-related article is a stub. You can help Wik.ipedia.Pro by expanding it. |
See what we do next...
OR
By submitting your email or phone number, you're giving mschf permission to send you email and/or recurring marketing texts. Data rates may apply. Text stop to cancel, help for help.
Success: You're subscribed now !