|
|
| Line 5: |
Line 5: |
| | |Sources=https://en.wikipedia.org/wiki/Database_schema | | |Sources=https://en.wikipedia.org/wiki/Database_schema |
| | }} | | }} |
| − | == Database schema of the oedb ==
| |
| | | | |
| − | The schemas are used to structure data tables. It it based on the [https://www.geoportal.de/SharedDocs/Downloads/DE/GDI-DE/Deutsche_Uebersetzung_der_ISO-Felder.pdf?__blob=publicationFile ISO 19115]B.5.27 TopicCategoryCode:
| + | == Database schema of the oedb<br/> == |
| | | | |
| − | farming
| + | The schemas are used to structure data tables.<br/> |
| | | | |
| − | biota
| + | v0.2<br/> |
| | | | |
| − | boundaries | + | {| style="width: 100%" cellspacing="1" cellpadding="1" border="1" |
| | + | |- |
| | + | | style="width: 101px" | '''ISO 19115 code<br/>''' |
| | + | | style="width: 114px" | '''Schema name<br/>''' |
| | + | | style="width: 531px" | '''Definition<br/>''' |
| | + | |- |
| | + | | style="width: 101px" | 003<br/> |
| | + | | style="width: 114px" | boundaries |
| | + | | style="width: 531px" | legal land descriptions Examples: political and administrative boundaries<br/> |
| | + | |- |
| | + | | style="width: 101px" | 004<br/> |
| | + | | style="width: 114px" | climat |
| | + | | style="width: 531px" | processes and phenomena of the atmosphere. Examples: cloud cover, weather, climate, atmospheric conditions, climate change, precipitation<br/> |
| | + | |- |
| | + | | style="width: 101px" | 005<br/> |
| | + | | style="width: 114px" | economy |
| | + | | style="width: 531px" | economic activities, conditions and employment. Examples: production, labour, revenue, commerce, industry, tourism and ecotourism, forestry, fisheries, commercial or subsistence hunting, exploration and exploitation of resources such as minerals, oil and gas<br/> |
| | + | |- |
| | + | | style="width: 101px" | <br/> |
| | + | | style="width: 114px" | energy_demand |
| | + | | style="width: 531px" | <br/> |
| | + | |- |
| | + | | style="width: 101px" | <br/> |
| | + | | style="width: 114px" | energy_grid<br/> |
| | + | | style="width: 531px" | <br/> |
| | + | |- |
| | + | | style="width: 101px" | <br/> |
| | + | | style="width: 114px" | energy_supply<br/> |
| | + | | style="width: 531px" | <br/> |
| | + | |- |
| | + | | style="width: 101px" | 007<br/> |
| | + | | style="width: 114px" | environment<br/> |
| | + | | style="width: 531px" | environmental resources, protection and conservation Examples: environmental pollution, waste storage and treatment, environmental impact assessment, monitoring environmental risk, nature reserves, landscape<br/> |
| | + | |- |
| | + | | style="width: 101px" | 016<br/> |
| | + | | style="width: 114px" | society<br/> |
| | + | | style="width: 531px" | characteristics of society and cultures Examples: settlements, anthropology, archaeology, education, traditional beliefs, manners and customs, demographic data, recreational areas and activities, social impact assessments, crime and justice, census information<br/> |
| | + | |- |
| | + | | style="width: 101px" | <br/> |
| | + | | style="width: 114px" | model_draft<br/> |
| | + | | style="width: 531px" | <br/> |
| | + | |- |
| | + | | style="width: 101px" | <br/> |
| | + | | style="width: 114px" | reference<br/> |
| | + | | style="width: 531px" | <br/> |
| | + | |} |
| | | | |
| − | climatology
| + | boundaries<br/>climat<br/>economy<br/>energy_demand<br/>energy_grid<br/>energy_supply<br/>environment<br/>environment<br/>model_draft<br/>reference<br/>society<br/> |
| | | | |
| − | economy
| + | <br/> |
| | | | |
| − | elevation
| + | <br/> |
| | | | |
| − | environment
| + | v0.1 |
| | | | |
| − | geoscientificInformation
| + | demand -> '''energy_demand'''<br/>economic-> '''economy'''<br/>emission -> '''environment'''<br/>environmental -> '''environment'''<br/>grid -> '''energy_grid'''<br/>'''model_draft'''<br/>political_boundary -> '''boundaries'''<br/>'''reference'''<br/>scenario -> ?<br/>social -> '''society'''<br/>supply -> '''energy_supply'''<br/>weather -> '''climat'''ologyMeteorologyAt mosphere<br/>workshop -> temporal example folder |
| | | | |
| − | health
| + | <br/> |
| | | | |
| − | imageryBaseMapsEarthCover
| + | == Possible categories == |
| | | | |
| − | intelligenceMilitary
| + | Based on the [https://www.geoportal.de/SharedDocs/Downloads/DE/GDI-DE/Deutsche_Uebersetzung_der_ISO-Felder.pdf?__blob=publicationFile ISO 19115] B.5.27 TopicCategoryCode: |
| | | | |
| − | inlandWaters | + | farming<br/>biota<br/>'''boundaries'''<br/>'''climatology'''<br/>'''economy'''<br/>'''elevation'''<br/>'''environment'''<br/>geoscientificInformation<br/>health<br/>imageryBaseMapsEarthCover<br/>intelligenceMilitary<br/>inlandWaters<br/>location<br/>oceans<br/>planningCadastre<br/>'''society'''<br/>'''structure'''<br/>'''transportation'''<br/>utilitiesCommunication |
| | | | |
| − | location
| + | WARNING: The case and spacing on these terms is controlled and will be invalid if altered.<br/>(also see [https://geo-ide.noaa.gov/wiki/index.php?title=ISO_Topic_Categories NOAA ISO Topic Categories]) |
| − | | + | |
| − | oceans
| + | |
| − | | + | |
| − | planningCadastre
| + | |
| − | | + | |
| − | society
| + | |
| − | | + | |
| − | structure
| + | |
| − | | + | |
| − | transportation
| + | |
| − | | + | |
| − | utilitiesCommunication
| + | |
1. A database schema of a database system is its structure described in a formal language supported by the database management system (DBMS).
2. The formal definition of a database schema is a set of formulas (sentences) called integrity constraints imposed on a database. These integrity constraints ensure compatibility between parts of the schema. All constraints are expressible in the same language.
The schemas are used to structure data tables.
ISO 19115 code
|
Schema name
|
Definition
|
003
|
boundaries
|
legal land descriptions Examples: political and administrative boundaries
|
004
|
climat
|
processes and phenomena of the atmosphere. Examples: cloud cover, weather, climate, atmospheric conditions, climate change, precipitation
|
005
|
economy
|
economic activities, conditions and employment. Examples: production, labour, revenue, commerce, industry, tourism and ecotourism, forestry, fisheries, commercial or subsistence hunting, exploration and exploitation of resources such as minerals, oil and gas
|
|
energy_demand
|
|
|
energy_grid
|
|
|
energy_supply
|
|
007
|
environment
|
environmental resources, protection and conservation Examples: environmental pollution, waste storage and treatment, environmental impact assessment, monitoring environmental risk, nature reserves, landscape
|
016
|
society
|
characteristics of society and cultures Examples: settlements, anthropology, archaeology, education, traditional beliefs, manners and customs, demographic data, recreational areas and activities, social impact assessments, crime and justice, census information
|
|
model_draft
|
|
|
reference
|
|
WARNING: The case and spacing on these terms is controlled and will be invalid if altered.
(also see NOAA ISO Topic Categories)
