Metadata

Latest revision as of 11:34, 11 September 2018

[edit] Definition

1. Metadata is data (information) that provides information about other data.

2. Three distinct types of metadata exist: structural metadata, descriptive metadata, and administrative metadata.

3. Metadata means "data about data". Although the "meta" prefix (from the Greek preposition and prefix μετά-) means "after" or "beyond", it is used to mean "about" in epistemology. Metadata is defined as the data providing information about one or more aspects of the data; it is used to summarize basic information about data which can make tracking and working with specific data easier. Some examples include: Means of creation of the data, Purpose of the data, Time and date of creation, Creator or author of the data, Location on a computer network where the data was created, Standards used, File size.

4. "metadata describes a resource for purposes such as discovery and identification. It can include elements such as title, abstract, author, and keywords."

5. "Metadata summarizes basic information about data, which can make finding and working with particular instances of data easier. For example, author, date created and date modified and file size are examples of very basic document metadata. Having the abilty to filter through that metadata makes it much easier for someone to locate a specific document."

[edit] Abbreviation

[edit] Synonyms

[edit] Superterms

Data

[edit] Subterms

[edit] Sources

String representation "http://www.merr … n/metadata (5.)" is too long.

[edit] Metadata in oedb

In the oedb, the metadata is stored in a comment as a JSON string.

The SQL example is on GitHub.

There is a current development of a new OEP metadata version.

Different concepts for metadata were compared, harmonized and simplyfied:

-- metadata description
COMMENT ON TABLE model_draft.test_table IS '{
   "title": "Good example title",
   "description": "example metadata for example data",
   "language": [ "eng", "ger", "fre" ],
   "spatial":
       {"location": "52.433405, 13.535666",
        "extent": "europe",
       "resolution": "100 m"},
   "temporal":
       {"reference_date": "2016-01-01",
        "start": "2017-01-01",
       "end": "2017-12-31",
       "resolution": "hour"},
   "sources": [
       {"name": "eGo dataprocessing", "description": "", "url": "https://github.com/openego/data_processing", "license": "GNU Affero General Public License Version 3 (AGPL-3.0)", "copyright": "© Reiner Lemoine Institut"},
       {"name": "", "description": "", "url": "", "license": "", "copyright": ""} ],
   "license":
       {"id": "ODbL-1.0",
       "name": "Open Data Commons Open Database License 1.0",
       "version": "1.0",
       "url": "https://opendatacommons.org/licenses/odbl/1.0/",
       "instruction": "You are free: To Share, To Create, To Adapt; As long as you: Attribute, Share-Alike, Keep open!",
       "copyright": "© Reiner Lemoine Institut"},
   "contributors": [
       {"name": "Ludee", "email": "", "date": "2016-06-16", "comment": "Create metadata"},
       {"name": "Ludee", "email": "", "date": "2016-11-22", "comment": "Update metadata"},
       {"name": "Ludee", "email": "", "date": "2016-11-22", "comment": "Update header and license"},
       {"name": "Ludee", "email": "", "date": "2017-03-16", "comment": "Add license to source"},
       {"name": "Ludee", "email": "", "date": "2017-03-28", "comment": "Add copyright to source and license"},
       {"name": "Ludee", "email": "", "date": "2017-05-30", "comment": "Update metadata to version 1.3"} ],
   "resources": [
       {"name": "model_draft.test_table",
       "format": "sql",
       "fields": [
           {"name": "id", "description": "Unique identifier", "unit": "" },
           {"name": "year", "description": "Reference year", "unit": "" },
           {"name": "value", "description": "Example value", "unit": "MW" },
           {"name": "geom", "description": "Geometry", "unit": "" }] }],
   "metadata_version": "1.3"}';

-- select description
SELECT obj_description('model_draft.test_table' ::regclass) ::json;

@@ Line 1: / Line 1: @@
 {{GlossaryTermTemp
+|SubtermOf=Data
 |Definition=1. Metadata is data (information) that provides information about other data.
 . Three distinct types of metadata exist: structural metadata, descriptive metadata, and administrative metadata.
-. Metadata means "data about data". Although the "meta" prefix (from the Greek preposition and prefix μετά-) means "after" or "beyond", it is used to mean "about" in epistemology. Metadata is defined as the data providing information about one or more aspects of the data; it is used to summarize basic information about data which can make tracking and working with specific data easier. Some examples include: Means of creation of the data, Purpose of the data, Time and date of creation, Creator or author of the data, Location on a computer network where the data was created, Standards used, File size
+. Metadata means "data about data". Although the "meta" prefix (from the Greek preposition and prefix μετά-) means "after" or "beyond", it is used to mean "about" in epistemology. Metadata is defined as the data providing information about one or more aspects of the data; it is used to summarize basic information about data which can make tracking and working with specific data easier. Some examples include: Means of creation of the data, Purpose of the data, Time and date of creation, Creator or author of the data, Location on a computer network where the data was created, Standards used, File size.
-|Sources=http://www.merriam-webster.com/dictionary/metadata, http://marciazeng.slis.kent.edu/metadatabasics/types.htm, https://en.wikipedia.org/wiki/Metadata#Definition
+. "metadata describes a resource for purposes such as discovery and  identification. It can include elements such as title, abstract, author,  and keywords."
+. "Metadata summarizes basic information about data, which can make finding  and working with particular instances of data easier. For example, author, date created and date modified and file size  are examples of very basic document metadata.  Having the abilty to  filter through that metadata makes it much easier for someone to locate a  specific document."
+|Sources=http://www.merriam-webster.com/dictionary/metadata(1.); http://marciazeng.slis.kent.edu/metadatabasics/types.htm (2.); https://en.wikipedia.org/wiki/Metadata#Definition (3.); https://en.wikipedia.org/wiki/Metadata (4.); http://whatis.techtarget.com/definition/metadata (5.)
 }}
 == Metadata in oedb<br/> ==
@@ Line 17: / Line 14: @@
 [https://github.com/openego/data_processing/blob/dev/documentation/metadata_on_table_example.sql The SQL example is on GitHub.]
+[https://github.com/OpenEnergyPlatform/organisation/issues/10 There is a current development of a new OEP metadata version.]
 <br/>
@@ Line 27: / Line 26: @@
 *[http://inspire.ec.europa.eu/documents/Metadata/MD_IR_and_ISO_20131029.pdf INSPIRE]<br/>
-<br/>-- metadata description<br/>COMMENT ON TABLE model_draft.test_table IS '{<br/>&nbsp;&nbsp; "'''title'''": "Good example title",<br/>&nbsp;&nbsp; "'''description'''": "example metadata for example data",<br/>&nbsp;&nbsp; "'''language'''": [ "eng", "ger", "fre" ],<br/>&nbsp;&nbsp; "'''spatial'''": <br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"location": "52.433405, 13.535666",<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "extent": "europe",<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;"resolution": "100 m"},<br/>&nbsp;&nbsp; "'''temporal'''": <br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"reference_date": "2016-01-01",<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "start": "2017-01-01",<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;"end": "2017-12-31",<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;"resolution": "hour"},<br/>&nbsp;&nbsp; "'''sources'''": [<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"name": "eGo dataprocessing", "description": "", "url": "[https://github.com/openego/data_processing https://github.com/openego/data_processing]", "license": "GNU Affero General Public License Version 3 (AGPL-3.0)", "copyright": "© Reiner Lemoine Institut"},<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"name": "", "description": "", "url": "", "license": "", "copyright": ""} ],<br/>&nbsp;&nbsp; "'''license'''": <br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"id": "ODbL-1.0",<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;"name": "Open Data Commons Open Database License 1.0",<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;"version": "1.0",<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;"url": "[https://opendatacommons.org/licenses/odbl/1.0/ https://opendatacommons.org/licenses/odbl/1.0/]",<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;"instruction": "You are free: To Share, To Create, To Adapt; As long as you: Attribute, Share-Alike, Keep open!",<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;"copyright": "© Reiner Lemoine Institut"},<br/>&nbsp;&nbsp; &nbsp;"'''contributors'''": [<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"name": "Ludee", "email": "", "date": "2016-06-16", "comment": "Create metadata"},<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"name": "Ludee", "email": "", "date": "2016-11-22", "comment": "Update metadata"},<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"name": "Ludee", "email": "", "date": "2016-11-22", "comment": "Update header and license"},<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"name": "Ludee", "email": "", "date": "2017-03-16", "comment": "Add license to source"},<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"name": "Ludee", "email": "", "date": "2017-03-28", "comment": "Add copyright to source and license"},<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"name": "Ludee", "email": "", "date": "2017-05-30", "comment": "Update metadata to version 1.3"} ],<br/>&nbsp;&nbsp; &nbsp;"resources": [<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"'''name'''": "model_draft.test_table",&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;"'''format'''": "sql",<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;"'''fields'''": [<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"name": "id", "description": "Unique identifier", "unit": "" },<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"name": "year", "description": "Reference year", "unit": "" },<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"name": "value", "description": "Example value", "unit": "MW" },<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"name": "geom", "description": "Geometry", "unit": "" }] }],<br/>&nbsp;&nbsp; &nbsp;"metadata_version": "1.3"}';
+<br/>-- metadata description<br/>COMMENT ON TABLE model_draft.test_table IS '{<br/>&nbsp;&nbsp; "'''title'''": "Good example title",<br/>&nbsp;&nbsp; "'''description'''": "example metadata for example data",<br/>&nbsp;&nbsp; "'''language'''": [ "eng", "ger", "fre" ],<br/>&nbsp;&nbsp; "'''spatial'''":<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"location": "52.433405, 13.535666",<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "extent": "europe",<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;"resolution": "100 m"},<br/>&nbsp;&nbsp; "'''temporal'''":<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"reference_date": "2016-01-01",<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "start": "2017-01-01",<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;"end": "2017-12-31",<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;"resolution": "hour"},<br/>&nbsp;&nbsp; "'''sources'''": [<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"name": "eGo dataprocessing", "description": "", "url": "[https://github.com/openego/data_processing https://github.com/openego/data_processing]", "license": "GNU Affero General Public License Version 3 (AGPL-3.0)", "copyright": "© Reiner Lemoine Institut"},<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"name": "", "description": "", "url": "", "license": "", "copyright": ""} ],<br/>&nbsp;&nbsp; "'''license'''":<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"id": "ODbL-1.0",<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;"name": "Open Data Commons Open Database License 1.0",<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;"version": "1.0",<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;"url": "[https://opendatacommons.org/licenses/odbl/1.0/ https://opendatacommons.org/licenses/odbl/1.0/]",<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;"instruction": "You are free: To Share, To Create, To Adapt; As long as you: Attribute, Share-Alike, Keep open!",<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;"copyright": "© Reiner Lemoine Institut"},<br/>&nbsp;&nbsp; &nbsp;"'''contributors'''": [<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"name": "Ludee", "email": "", "date": "2016-06-16", "comment": "Create metadata"},<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"name": "Ludee", "email": "", "date": "2016-11-22", "comment": "Update metadata"},<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"name": "Ludee", "email": "", "date": "2016-11-22", "comment": "Update header and license"},<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"name": "Ludee", "email": "", "date": "2017-03-16", "comment": "Add license to source"},<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"name": "Ludee", "email": "", "date": "2017-03-28", "comment": "Add copyright to source and license"},<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"name": "Ludee", "email": "", "date": "2017-05-30", "comment": "Update metadata to version 1.3"} ],<br/>&nbsp;&nbsp; &nbsp;"resources": [<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"'''name'''": "model_draft.test_table",&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;"'''format'''": "sql",<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;"'''fields'''": [<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"name": "id", "description": "Unique identifier", "unit": "" },<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"name": "year", "description": "Reference year", "unit": "" },<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"name": "value", "description": "Example value", "unit": "MW" },<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"name": "geom", "description": "Geometry", "unit": "" }] }],<br/>&nbsp;&nbsp; &nbsp;"metadata_version": "1.3"}';
 -- select description<br/>SELECT obj_description('model_draft.test_table'&nbsp;::regclass)&nbsp;::json;

About

Help

Search

Navigation

Search

Interaction

Toolbox

Namespaces

Variants

Views

Actions

Metadata

Latest revision as of 11:34, 11 September 2018

Contents

[edit] Definition

[edit] Abbreviation

[edit] Synonyms

[edit] Superterms

[edit] Subterms

[edit] Sources

[edit] Metadata in oedb

Log in / create account

About

Help

Search

Navigation

Search

Interaction

Toolbox

Namespaces

Variants

Views

Actions

Metadata

Latest revision as of 11:34, 11 September 2018

Contents

[edit] Definition

[edit] Abbreviation

[edit] Synonyms

[edit] Superterms

[edit] Subterms

[edit] Sources

[edit] Metadata in oedb