|
|
| (15 intermediate revisions by 2 users not shown) |
| Line 1: |
Line 1: |
| | {{GlossaryTermTemp | | {{GlossaryTermTemp |
| − | |Definition=Metadata is "data [information] that provides information about other data". | + | |SubtermOf=Data |
| | + | |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. | | 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 | + | 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." |
| − | |Sources=http://www.merriam-webster.com/dictionary/metadata, http://marciazeng.slis.kent.edu/metadatabasics/types.htm, https://en.wikipedia.org/wiki/Metadata#Definition | + | 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." |
| | + | |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/> == |
| | + | |
| | + | In the [[OpenEnergy Database|oedb]], the metadata is stored in a comment as a JSON string. |
| | + | |
| | + | [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/> |
| | + | |
| | + | Different concepts for metadata were compared, harmonized and simplyfied: |
| | + | |
| | + | *[http://frictionlessdata.io/guides/data-package/#getting-started OKFN (Frictionless / Data Package)] |
| | + | *[https://github.com/fraunhoferfokus/ogd-metadata/blob/master/OGPD_JSON_Schema.html CKAN (Frauenhofer)] |
| | + | *[http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/datapackage.json OPSD] |
| | + | *[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/> "'''title'''": "Good example title",<br/> "'''description'''": "example metadata for example data",<br/> "'''language'''": [ "eng", "ger", "fre" ],<br/> "'''spatial'''":<br/> {"location": "52.433405, 13.535666",<br/> "extent": "europe",<br/> "resolution": "100 m"},<br/> "'''temporal'''":<br/> {"reference_date": "2016-01-01",<br/> "start": "2017-01-01",<br/> "end": "2017-12-31",<br/> "resolution": "hour"},<br/> "'''sources'''": [<br/> {"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/> {"name": "", "description": "", "url": "", "license": "", "copyright": ""} ],<br/> "'''license'''":<br/> {"id": "ODbL-1.0",<br/> "name": "Open Data Commons Open Database License 1.0",<br/> "version": "1.0",<br/> "url": "[https://opendatacommons.org/licenses/odbl/1.0/ https://opendatacommons.org/licenses/odbl/1.0/]",<br/> "instruction": "You are free: To Share, To Create, To Adapt; As long as you: Attribute, Share-Alike, Keep open!",<br/> "copyright": "© Reiner Lemoine Institut"},<br/> "'''contributors'''": [<br/> {"name": "Ludee", "email": "", "date": "2016-06-16", "comment": "Create metadata"},<br/> {"name": "Ludee", "email": "", "date": "2016-11-22", "comment": "Update metadata"},<br/> {"name": "Ludee", "email": "", "date": "2016-11-22", "comment": "Update header and license"},<br/> {"name": "Ludee", "email": "", "date": "2017-03-16", "comment": "Add license to source"},<br/> {"name": "Ludee", "email": "", "date": "2017-03-28", "comment": "Add copyright to source and license"},<br/> {"name": "Ludee", "email": "", "date": "2017-05-30", "comment": "Update metadata to version 1.3"} ],<br/> "resources": [<br/> {"'''name'''": "model_draft.test_table", <br/> "'''format'''": "sql",<br/> "'''fields'''": [<br/> {"name": "id", "description": "Unique identifier", "unit": "" },<br/> {"name": "year", "description": "Reference year", "unit": "" },<br/> {"name": "value", "description": "Example value", "unit": "MW" },<br/> {"name": "geom", "description": "Geometry", "unit": "" }] }],<br/> "metadata_version": "1.3"}'; |
| | + | |
| | + | -- select description<br/>SELECT obj_description('model_draft.test_table' ::regclass) ::json; |
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;
