Database catalog
   HOME

TheInfoList




A database catalog of a
database In computing Computing is any goal-oriented activity requiring, benefiting from, or creating computing machinery. It includes the study and experimentation of algorithmic processes and development of both computer hardware , hardware and sof ...

database
instance consists of
metadata Metadata is "data Data (; ) are individual facts, statistics, or items of information, often numeric. In a more technical sense, data are a set of values of qualitative property, qualitative or quantity, quantitative variable (research), v ...

metadata
in which definitions of database objects such as base tables, views (virtual tables),
synonym A synonym is a word, morpheme A morpheme is the smallest meaningful lexical item in a language. A morpheme is not a word. The difference between a morpheme and a word is that a morpheme bound and free morphemes, sometimes does not stand alone ...
s, value ranges,
indexes Index may refer to: Arts, entertainment, and media Fictional entities * Index (A Certain Magical Index), Index (''A Certain Magical Index''), a character in the light novel series ''A Certain Magical Index'' * The Index, an item on a Halo (megas ...
,
users User may refer to: Ancient Egyptian roles * User (ancient Egyptian official), an ancient Egyptian nomarch (governor) of the Eighth Dynasty * Useramen, an ancient Egyptian vizier also called "User" Other uses * User (computing), a person (or s ...
, and user groups are stored. The
SQL SQL ( ''S-Q-L'', "sequel"; Structured Query Language) is a domain-specific languageA domain-specific language (DSL) is a computer languageA computer language is a method of communication with a computer A computer is a machine that can b ...

SQL
standard specifies a uniform means to access the catalog, called the
INFORMATION_SCHEMA #REDIRECT Information schemaIn relational database A relational database is a digital database based on the relational model of data, as proposed by E. F. Codd in 1970. A software system used to maintain relational databases is a relational dat ...
, but not all
databases In computing Computing is any goal-oriented activity requiring, benefiting from, or creating computing machinery. It includes the study and experimentation of algorithmic processes and development of both computer hardware , hardware and sof ...
follow this, even if they implement other aspects of the SQL standard. For an example of database-specific
metadata Metadata is "data Data (; ) are individual facts, statistics, or items of information, often numeric. In a more technical sense, data are a set of values of qualitative property, qualitative or quantity, quantitative variable (research), v ...

metadata
access methods, see
Oracle metadata {{unsourced, date=July 2012 Oracle Database Oracle Database (commonly referred to as Oracle DBMS or simply as Oracle) is a multi-model database management system In computing, a database is an organized collection of Data (computing), data ...
.


See also

*
Data dictionary A data dictionary, or metadata repositoryA metadata repository is a database created to store metadata. Metadata is information about the structures that contain the actual data. Metadata is often said to be "data about data", but this is misleadi ...

Data dictionary


References

Database theory {{database-stub