Databases

Commonly used databases include Microsoft access, postgis and MySQL

Once installed a very useful php based web front end can be added (Php must be installed at least but a full LAMP server is recommended). PhpMyAdmin allows a user friendly way of maintaining the database including allowed other people to add, amend, update and delete data depending on the privileges the administrator sets.

pgAdmin

Once setup a MySQL database can be connected to a GRASS GIS mapset, firstly make sure the map is in the PERMANENT mapset. It will be copied into a mapset which is linked to the database, when it is copied the attribute data gets put into the database as a new table.

mysql -h localhost -p
db.conect driver=mysql database=“host=localhost,dbname=dbname”
db.login user=username
db.connect -p
g.copy vect=mapname@PERMANENT,newmapname

Any editing of the database name or table names should be done from within GRASS GIS using:

db.rename

Other useful Modules include the db.* and v.db.* press the tab button twice after the '.' to get a list of them

The DWH Wiki offers some information on data warehousing. Writing help