A Database for Every Occasion

Types of Databases

. . . For Every Occasion

Relational Sports league

NoSQL Epic party

File-based Camping

Relational Databases

ID Name Position

1 Harry Potter Seeker

2 Ginny Weasley Chaser

3 Draco Malfoy Seeker

ID Name Colors

1 Gryffindor Red and gold

2 Slytherin Green and silver

TeamID PlayerID

1 1

1 2

2 3

Player

Team

Team_Players

Relational Databases

✔ Static schema ✔ Consistent, reliable transactions ✔ Accuracy ✔ Complex SQL querying ✔ Control security for each table

NoSQL Databases

{

ID:1,

Title:"BilboBaggins’EleventyFirstBirthdayParty",

Location:Shire,

FireworksDisplay:{

Name:"GandalftheWizard",

Time:"halfpastsix",

}

}

NoSQL Databases

✔ Agile schema ✔ High data volumes ✔ Fast transactions ✔ Scalable ✔ Access via APIs

File-Based Databases

File-Based Databases

✔ Simple ✔ Shareable ✔ Tiny ✔ Extensible

Let’s Build an App Wildlife surveying

Bald Eagle Survey A team of wildlife surveyors needs to assess eagle habitat.

Which database to use?

OGC GeoPackage •  Free and open source •  Standards-based •  Platform-independent •  Portable •  Compact

Supports raster and vector all in a SQLite Database! http://www.geopackage.org/

Step 1: Build Database using Existing Data

Over to FME

Step 2: Collect Data

Going Mobile

Place your screenshot here

http://ngageoint.github.io/geopackage-mapcache-android/

Final Step: Merge all Updates into Master

FME Tips: 1.  Detect updates 2.  fme_db_operation 3.  Unique ID field

Over to FME

Story: Field Data Collection and Maintenance

Step 1: Field Data Collection

Step 2: Transform AGOL to Excel & File Geodatabase

Esri Survey123

Initial Import + Transform: AGOL > File GDB

Iterative Import + Transform: File GDB > File GDB + Excel

Step 3: Cyclical Quality Control

✅

Result: Master data repository + Excel / Power BI

Summary

•  Choose the right database for the occasion –  Pros and cons to relational,

NoSQL, and file-based databases •  Update master database using

UpdateDetector, fme_db_operation, and a unique ID

Questions?

Learn more:

knowledge.safe.com Tutorial: Updating Databases

NoSQL blogs + webinar

safe.com/nosql