Vocabularies — view dictionary terms
DIC_META_GLOSSARY (125 rows)
Dictionary table of terms available to applications as Glossary Entries. This is designed for use within the Technical Metadata application but could be adopted for use in other applications.
Displaying rows 106 to 125 of 125
Row | CODE | GLOSS_CAT_CODE | TRANSLATION | DESCRIPTION | DATE_ENTERED | DATE_UPDATED | STATUS |
---|---|---|---|---|---|---|---|
106 | META_SCHEM | METADATA | SCHEMA | Collection of database objects, including logical structures such as tables, views, sequences, stored procedures, synonyms, indexes, clusters, and database links. A schema has the name of the user who controls it. | 09-FEB-06 | 10-FEB-06 | C |
107 | META_DOC | METADATA | DOCUMENTATION | Detailed and exaustive technical specifications of a database structure and the component objects. | 09-FEB-06 | 10-FEB-06 | C |
108 | META_USER | METADATA | USER | A person or group who is assigned a username in order to access a database or more generally a person who accesses an application. | 09-FEB-06 | 10-FEB-06 | C |
109 | META_ORACL | METADATA | ORACLE | The Software firm Oracle who primarily produce database software or the same name. | 09-FEB-06 | 10-FEB-06 | C |
110 | META_DEV | METADATA | DEVELOPMENT | The process of producing or refining an application. | 09-FEB-06 | 10-FEB-06 | C |
111 | META_COFUN | METADATA | CO-FUNDED | A project that attracts funding from both the Science Budget and Commercial Contracts. | 10-FEB-06 | 10-FEB-06 | C |
112 | META_COMM | METADATA | COMMERCIAL | (CR) A project that is funded at BGS from an external source usually on an agreed contract. | 10-FEB-06 | 10-FEB-06 | C |
113 | META_SCBUD | METADATA | SCIENCE BUDGET | Refers to the funding assigned to BGS by NERC annually and any project funded from this resource, | 10-FEB-06 | 10-FEB-06 | C |
114 | META_THEMA | METADATA | THEMATIC | A Thematic project is a co-operatively funded project that is interdisciplinary and multidisciplinary in nature. It crosses across areas of common interest with the aim of stimulating academic, and industrial research and exploration. These projects will often involve several NERC bodies, companies and universities. | 10-FEB-06 | 10-FEB-06 | C |
115 | META_LEGA | METADATA | LEGACY | Data projects or databanks which are no longer in day to day use but are retained for historical purposes. | 10-FEB-06 | 10-FEB-06 | C |
116 | META_ERD | METADATA | ENTITY RELATIONSHIP DIAGRAM | A Diagram that visually represents a set of database objects (tables) and the interelationships between them. | 10-FEB-06 | 10-FEB-06 | C |
117 | META_COL | METADATA | COLUMNS | Also known as fields, this refers to the individual data records within a table or view. They are individual data entries of the same type within a database table. | 10-FEB-06 | 10-FEB-06 | C |
118 | META_DEP | METADATA | DEPENDANT OBJECTS | Objects such as Views or triggers etc. which draw data from a table or modify a table are dependant on that table. | 10-FEB-06 | 10-FEB-06 | C |
119 | META_DEP1 | METADATA | DEPENDANCIES | The dependancies of a database object refers to all the other objects upon which the object in question references or draws data from. | 10-FEB-06 | 10-FEB-06 | C |
120 | META_GRANT | METADATA | GRANTS | The specific actions that a given user may perform upon a given database object (e.g. tables), also known as privileges. In oracle, the GRANT statement is used to give access to a user on a specific object. | 10-FEB-06 | 11-APR-06 | C |
121 | META_PRIVS | METADATA | PRIVILEGES | The specific actions that a given user may preform upon a given database object, also known as grants (e.g. INSERT, UPDATE, DELETE, SELECT). | 10-FEB-06 | 11-APR-06 | C |
122 | META_REMOT | METADATA | REMOTE TABLE | The database table joined by a foreign key which contains the data that limits the number of possible entries within the table upon which the Foreign Key rests. | 10-FEB-06 | 10-FEB-06 | C |
123 | META_CONST | METADATA | CONSTRAINT | A database object that in some way reduces the set of possible entries in a particular field or column, This may be a Key or Check constraint. | 10-FEB-06 | 10-FEB-06 | C |
124 | META_CHECK | METADATA | CHECK CONSTRAINT | A constraint that limits data within a field or column without referencing other database tables or entries. Often used to ensure data integrity. | 10-FEB-06 | 10-FEB-06 | C |
125 | META_GUIDE | METADATA | GUIDELINES | A set of procedures that provide a recommended working practice to cover the majority of cases. | 10-FEB-06 | 10-FEB-06 | C |
Displaying rows 106 to 125 of 125