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 101 to 120 of 125
| Row | CODE | GLOSS_CAT_CODE | TRANSLATION | DESCRIPTION | DATE_ENTERED | DATE_UPDATED | STATUS |
|---|---|---|---|---|---|---|---|
| 101 | META_PACK | METADATA | PACKAGE | A group of related stored procedures. | 09-FEB-06 | 10-FEB-06 | C |
| 102 | META_TRIG | METADATA | TRIGGER | A stored procedure that starts (is fired) in responce to a particular event occuring within the database. | 09-FEB-06 | 10-FEB-06 | C |
| 103 | META_SYN | METADATA | SYNONYM | An alternative name for a particular database object, this name can be used to access the object in exactly the same way as the object`s true name. | 09-FEB-06 | 10-FEB-06 | C |
| 104 | META_MATVW | METADATA | MATERIALISED VIEW | A materialized view provides access to table data by storing the results of a query in a separate schema object (table) this is not refreshed every time the view is called. | 09-FEB-06 | 10-FEB-06 | C |
| 105 | META_ALERT | METADATA | ALERTS | A system of regularly scheduled SQL queries that provide the Database operators with data quality information. | 09-FEB-06 | 10-FEB-06 | C |
| 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 |
Displaying rows 101 to 120 of 125