Warning: jsMath requires JavaScript to process the mathematics on this page.
If your browser supports JavaScript, be sure it is enabled.

View source

From QED

for MG/Data and Analysis/Data Documentation

Jump to: navigation, search

You can view and copy the source of this page:

{{MG/Data Documentation/Navigation}}
== '''Mapping Globalization Database Documentation''' ==

'''Database Architecture'''

The data associated with the Mapping Globalization project is housed in a database that allows for easy querying and access.  Here's a behind-the-scenes look at the the Mapping Globalization project's database architecture.
[[Image:MG_Schema640_480.JPG]]

Each white box in the schematic represents an individual table that contains data, each connected to  other tables in a relational database structure.

The grouped WTA tables (<b>wtathresholds, wtaports, wtacommodities,</b> and <b>wtacountries</b>) correspond to the <b>W</b>orld <b>T</b>rada <b>A</b>nalyzer developed by Statistics Canada.  These tables house select trade information between countries for several target years.

The other tables (<b>mgcountry</b> and <b>mgcountry_year</b>) are primarily used to house the "linking" information for the <b>M</b>apping <b>G</b>lobalization database, the key fields relate one table to another.  These key fields are used to link current tables shown here and will be used to link tables designated for future inclusion, making it easy to expand and enhance this database. <br><br> Secondarily, <b>mgcountry</b> and <b>mgcountry_year</b> contain other important information such as a country's land use and a country's alternate names.


'''Data Type'''

* '''World Trade Analyzer (WTA)'''
**[[MG/Data and Analysis/Data Documentation/Trade WTA Source|Source]]
**[[MG/Data and Analysis/Data Documentation/Trade WTA Structure|Structure]]

* '''Mapping Globalization (MG) Country'''
**[[MG/Data and Analysis/Data Documentation/Country Source|Source]]
**[[MG/Data and Analysis/Data Documentation/Country Structure|Structure]]

Templates used on this page: