|
|
| Line 3: |
Line 3: |
| | |Definition=1. A database schema of a database system is its structure described in a formal language supported by the database management system (DBMS). | | |Definition=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. | | 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. |
| − | |Sources=https://en.wikipedia.org/wiki/Database_schema | + | |Sources=https://en.wikipedia.org/wiki/Database_schema, https://geo-ide.noaa.gov/wiki/index.php?title=ISO_Topic_Categories |
| | }} | | }} |
| − |
| |
| − |
| |
| | == Database schema of the oedb<br/> == | | == Database schema of the oedb<br/> == |
| | | | |
| Line 58: |
Line 56: |
| | |} | | |} |
| | | | |
| − | | + | <br/> |
| | | | |
| | ==== v0.1 ==== | | ==== v0.1 ==== |
| Line 64: |
Line 62: |
| | 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 | | 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 |
| | | | |
| | + | <br/> |
| | | | |
| | == Possible categories == | | == Possible categories == |
Revision as of 09:41, 24 November 2016
Definition
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.
Abbreviation
Synonyms
Superterms
Database
Subterms
Sources
https://en.wikipedia.org/wiki/Database_schema, https://geo-ide.noaa.gov/wiki/index.php?title=ISO_Topic_Categories
Database schema of the oedb
v0.2
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
|
|
v0.1
demand -> energy_demand
economic-> economy
emission -> environment
environmental -> environment
grid -> energy_grid
model_draft
political_boundary -> boundaries
reference
scenario -> ?
social -> society
supply -> energy_supply
weather -> climatologyMeteorologyAt mosphere
workshop -> temporal example folder
Possible categories
Based on the ISO 19115 B.5.27 TopicCategoryCode:
farming
biota
boundaries
climatology
economy
elevation
environment
geoscientificInformation
health
imageryBaseMapsEarthCover
intelligenceMilitary
inlandWaters
location
oceans
planningCadastre
society
structure
transportation
utilitiesCommunication
WARNING: The case and spacing on these terms is controlled and will be invalid if altered.
(also see NOAA ISO Topic Categories)
