Tag Archives: SQL

GHCN Database Pondering A Redo

Posted on 1 August 2019 by E.M.Smith

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

Posted on 14 May 2019 by E.M.Smith

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

Posted on 24 March 2019 by E.M.Smith

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

Posted on 23 January 2019 by E.M.Smith

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