The New GIS User: Poor Understanding of a Relational Database

Those new to #GIS that have some #geo #database experience and minimal interaction with the inner workings of a #relational #database can be at a disadvantage when landing that first #GISjob . Really good academic #GISPrograms will typically teach these principle over 2 hours for the duration of a course, and typically seem insignificant. In fact, there are many hours dealing with the ins and outs of not just creating a database, but maintain them.




Here are a few things to consider when working with relational databases;
1. Cardinality principles are essential
2. Have an understanding of the relational database #field #types and what they can hold as well as what the use is if you need to complete #spatial #analysis or #calculations
3. MS Access is a #single-user #database #system. This means that a personal #geodatabase (PGD) can not be used by another application as the same time you have it in use. There are limits to the size of the PGD as well, only 2GB is allowed. When working with #big #data, it is better to run with a File Geodatabase.

www.redearthgeospatial.com

www.facebook.com/RedEarthGeo

@RedEarthGeo