Tag Archives: SQL

GHCN Database Pondering A Redo

Which is better, one BIG table or two smaller ones? Decisions and questions on GHCN handling. Continue reading

Posted in NCDC - GHCN Issues, Tech Bits | Tagged , , | 56 Comments

Updated GHCN Load Scripts & Reduced Warnings

And inproved version of the MariaDB / MySQL database and data loading scripts, with run times and discussion. Many warnings removed and one data loading bug fixed. Continue reading

Posted in NCDC - GHCN Issues, Tech Bits | Tagged , , , , | 12 Comments

GHCN v4 Adding Statistics & Anomaly Tables

I create the anomaly and statistics tables for GHCN v4. Continue reading

Posted in NCDC - GHCN Issues, Tech Bits | Tagged , , , , , | 22 Comments

Procedural Languages, MySQL, Massively Parallel, and Climate Modeling

A Modest Suggestion of a different way to build an iterative computer model of geographic climate cells using MySQL as the grid defining data store and as the “flow of control” “lock” in parallel processing, plus an interesting video about the very old roots of “modern” programming concepts. Continue reading

Posted in GCM, NCDC - GHCN Issues, Tech Bits | Tagged , , , , , , | 7 Comments