Database catalog

Database catalog

The 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]

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.

References

  1. ^ Paul C. Tinnirello (1999). Systems Development Handbook. CRC Press. ISBN 0849398223. 
  2. ^ CREATE VIEW (Transact-SQL) in SQL Server 2008 Books Online, Microsoft Corporation, http://msdn.microsoft.com/en-us/library/ms187956.aspx 



Wikimedia Foundation. 2010.

Игры ⚽ Поможем решить контрольную работу

Look at other dictionaries:

  • Catalog — A catalog or catalogue is an organized, detailed, descriptive list of items arranged systematically. It may also refer to a list of items enumerated with a specific numbering scheme. The word comes from the Hesiodic Catalogue of Women or Eoiae .… …   Wikipedia

  • Database Console Commands (Transact-SQL) — The Database Console Commands (DBCC) are a series of statements in Transact SQL programming language to check the physical and logical consistency of a Microsoft SQL Server database.[1] These commands are also used to fix existing issues.[1] They …   Wikipedia

  • Database — A database is an organized collection of data for one or more purposes, usually in digital form. The data are typically organized to model relevant aspects of reality (for example, the availability of rooms in hotels), in a way that supports… …   Wikipedia

  • Database refactoring — A database refactoring is a simple change to a database schema that improves its design while retaining both its behavioral and informational semantics. A database refactoring is conceptually more difficult than a code refactoring; code… …   Wikipedia

  • Database publishing — For the company formerly known as Database Publications, see Europress. Database publishing is an area of automated media production in which specialized techniques are used to generate paginated documents from source data residing in traditional …   Wikipedia

  • Catalog of Stellar Identifications — The Catalog of Stellar Identifications (CSI) is a star catalog which was constructed to facilitate cross referencing between different star catalogs. It contains designations and basic data for, as of 1983, approximately 440,000 stars, and was… …   Wikipedia

  • Catalog of Principal Galaxies — Catalogue of Principal Galaxies Sommaire 1 Catalogue original 2 Catalogue à jour 3 Voir aussi 3.1 Articles connexes 3.2 …   Wikipédia en Français

  • CSA (database company) — CSA Illumina (formerly Cambridge Scientific Abstracts) is a provider of online databases, based in Ann Arbor, Michigan.[1] It is now a division of ProQuest, which in turn is now a subsidiary of the Cambridge Information Group.[2] The company… …   Wikipedia

  • Ingres (database) — Ingres Ingres Corporation logo Developer(s) Actian Corporation Stable release Ingres Database 10 / October 12, 2010; 13 months ago (2010 10 12) …   Wikipedia

  • CAB Direct (database) — Global Health redirects here. For other uses, see Global health. CAB Abstracts Producer CABI (United Kingdom) History 1973 to present Languages Fifty languages, English abstracts Access Providers Datastar, Dial …   Wikipedia

Share the article and excerpts

Direct link
Do a right-click on the link above
and select “Copy Link”