SQL is a domain-specific language used in programming and designed for managing data held in a relational database management system (RDBMS), or for stream processing in a relational data stream management system (RDSMS). It is particularly useful in handling structured data where there are relations between different entities/variables of the data. SQL offers two main advantages over older read/write APIs like ISAM or VSAM. First, it introduced the concept of accessing many records with one single command; and second, it eliminates the need to specify how to reach a record, e.g. with or without an index.
In metadata, the term data element is an atomic unit of data that has precise meaning or precise semantics. A data element has:
- An identification such as a data element name
- A clear data element definition
- One or more representation terms
- Optional enumerated values Code (metadata)
- A list of synonyms to data elements in other metadata registries Synonym ring
A representation term is a word, or a combination of words, that semantically represent the data type of a data element. A representation term is commonly referred to as a class word by those familiar with data dictionaries. ISO/IEC 11179-5:2005 defines representation term as a designation of an instance of a representation class As used in ISO/IEC 11179, the representation term is that part of a data element name that provides a semantic pointer to the underlying data type. A Representation class is a class of representations. This representation class provides a way to classify or group data elements.
A data element name is a name given to a data element in, for example, a data dictionary or metadata registry. In a formal data dictionary, there is often a requirement that no two data elements may have the same name, to allow the data element name to become an identifier, though some data dictionaries may provide ways to qualify the name in some way, for example by the application system or other context in which it occurs.
In metadata, a data element definition is a human readable phrase or sentence associated with a data element within a data dictionary that describes the meaning or semantics of a data element.
Semantic translation is the process of using semantic information to aid in the translation of data in one representation or data model to another representation or data model. Semantic translation takes advantage of semantics that associate meaning with individual data elements in one dictionary to create an equivalent meaning in a second system.
Oracle Database provides information about all of the tables, views, columns, and procedures in a database. This information about the information is known as metadata. It is stored in two locations: data dictionary tables and a metadata registry.
In a data warehouse, a measure is a property on which calculations can be made.
A representation term is a word, or a combination of words, used as part of a data element name. Representation class is sometimes used as a synonym for representation term.
The Extended Metadata Registry (XMDR) is a project proposing and testing a set of extensions to the ISO/IEC 11179 metadata registry specifications that deal with the development of improved standards and technology for storing and retrieving the semantics of data elements, terminologies, and concept structures in metadata registries.
In metadata an indicator is a Boolean value that may contain only the values true or false. The definition of an Indicator must include the meaning of a true value and should also include the meaning if the value is false.
A classification scheme is the product of arranging things into kinds of things (classes) or into groups of classes.
The Data Reference Model (DRM) is one of the five reference models of the Federal Enterprise Architecture.
METeOR, Australia’s repository for national metadata standards for health, housing and community services statistics and information. METeOR is a Metadata registry based on the 2003 version of the ISO/IEC 11179 Information technology - Metadata registries standard. METeOR was developed by the Australian Institute of Health and Welfare to store, manage and disseminate metadata in the Australian health, community services and housing assistance sectors.
A metadata standard is a requirement which is intended to establish a common understanding of the meaning or semantics of the data, to ensure correct and proper use and interpretation of the data by its owners and users. To achieve this common understanding, a number of characteristics, or attributes of the data have to be defined, also known as metadata.
The Aristotle Metadata Registry is an open-source Metadata Registry framework based on the ISO/IEC 11179 standard for Metadata Registries. It is influenced by the AIHW Meteor Metadata Registry and the Canadian Institute of Health Information Indicator Bank. Aristotle-MDR is designed to describe data holdings databases and associated structural metadata. The Aristotle Metadata Registry was publicly launched at the 2015 IASSIST Conference in Toronto. In 2016, the founders of the Aristotle Metadata Registry were hired by Data61 to continue development of the platform.
IEC Common Data Dictionary is a metadata registry based on the data model defined in IEC 61360-2/ISO 13584-42 with an enhancement of its modelling capability adopted from IEC 62656-1. The description of the data model for dictionary developers in particular for those in electrotechnical domains is given in IEC 61360-1. Currently the scope of the registry is extended to cover all ISO and IEC domains, thus it is no longer "IEC CDD", nevertheless it is hosted by IEC-CO and is maintained by IEC SC 3D with a joint working group formed between IEC SC 3D and ISO TC 184/SC4. The data model of the CDD references ISO/IEC 11179 for the identification of the registered elements. It is used to host product classifications. - This means the IEC CDD is a database providing classifications and metadata definitions for describing products. The IEC CDD is an International Standard in the form of an online database, not in the form of (e-)paper, and is given the standard number IEC 61360-4 DB. Thus the metadata registered into the database has the status of International Standard. The procedure to add a new definition or a set of definitions is based on the IEC database procedure, described in Annex SL of the IEC supplementary of the ISO/IEC directive Part 1. This process for updating the content is called a "Change Request" and when a Change Request is issued and adopted, the proposed item will become part of the International Standard, IEC 61360-4 DB, within approximately 6 months.