| Andrew Cooke | Contents | Latest | RSS | Twitter | Previous | Next

C[omp]ute

Welcome to my blog, which was once a mailing list of the same name and is still generated by mail. Please reply via the "comment" links.

Always interested in offers/projects/new ideas. Eclectic experience in fields like: numerical computing; Python web; Java enterprise; functional languages; GPGPU; SQL databases; etc. Based in Santiago, Chile; telecommute worldwide. CV; email.

Personal Projects

Lepl parser for Python.

Colorless Green.

Photography around Santiago.

SVG experiment.

Professional Portfolio

Calibration of seismometers.

Data access via web services.

Cache rewrite.

Extending OpenSSH.

Last 100 entries

SQL Performance Explained; The Little Manual of API Design; Multiple Word Sizes; CRC - Next Steps; FizzBuzz; Update on CRCs; Decent Links / Discussion Community; Automated Reasoning About LLVM Optimizations and Undefined Behavior; A Painless Guide To CRC Error Detection Algorithms; Tests in Julia; Dave Eggers: what's so funny about peace, love and Starship?; Cello - High Level C Programming; autoreconf needs tar; Will Self Goes To Heathrow; Top 5 BioInformatics Papers; Vasovagal Response; Good Food in Vina; Chilean Drug Criminals Use Subsitution Cipher; Adrenaline; Stiglitz on the Impact of Technology; Why Not; How I Am 5; Lenovo X240 OpenSuse 13.1; NSA and GCHQ - Psychological Trolls; Finite Fields in Julia (Defining Your Own Number Type); Julian Assange; Starting Qemu on OpenSuse; Noisy GAs/TMs; Venezuela; Reinstalling GRUB with EFI; Instructions For Disabling KDE Indexing; Evolving Speakers; Changing Salt Size in Simple Crypt 3.0.0; Logarithmic Map (Moved); More Info; Words Found in Voynich Manuscript; An Inventory Of 3D Space-Filling Curves; Foxes Using Magnetic Fields To Hunt; 5 Rounds RC5 No Rotation; JP Morgan and Madoff; Ori - Secure, Distributed File System; Physical Unclonable Functions (PUFs); Prejudice on Reddit; Recursion OK; Optimizing Julia Code; Cash Handouts in Brazil; Couple Nice Music Videos; It Also Works!; Adaptive Plaintext; It Works!; RC5 Without Rotation (2); 8 Years...; Attack Against Encrypted Linux Disks; Pushing Back On NSA At IETF; Summary of Experimental Ethics; Very Good Talk On Security, Snowden; Locusts are Grasshoppers!; Vagrant (OpenSuse and IDEs); Interesting Take On Mandela's Context; Haskell Cabal O(n^2) / O(n) Fix; How I Am 4; Chilean Charity Supporting Women; Doing SSH right; Festival of Urban Intervention; Neat Idea - Wormholes Provide Entanglement; And a Link....; Simple Encryption for Python 2.7; OpenSuse 13.1 Is Better!; Little Gain...; More Details on Technofull Damage; Palmrest Cracked Too....; Tecnofull (Lenovo Support) Is Fucking Useless; The Neuroscientist Who Discovered He Was a Psychopath; Interpolating Polynomials; Bottlehead Crack as Pre-amp; Ooops K702!; Bottlehead Crack, AKG K701; Breaking RC5 Without Rotation; Great post thank you; Big Balls of Mud; Phabricator - Tools for working together; Amazing Julia RC5 Code Parameterized By Word Size; Chi-Square Can Be Two-Sided; Why Do Brits Accept Surveillance?; Statistics Done Wrong; Mesas Trape from Bravo; European Report on Crypto Primitives and Protocols; Interesting Omissions; Oryx And Crake (Margaret Atwood); Music and Theory; My Arduino Programs; Elliptic Curve Crypto; Re: Licensing Interpreted Code; Licensing Interpreted Code; ASUS 1015E-DS03 OpenSuse 12.3 SSD; translating lettuce feature files into stub steps files; Re: translating lettuce feature files into stub steps files; A Tale of Two Psychiatrists; The Real Reason the Poor Go Without Bank Accounts; The Rational Choices of Crack Addicts; Forgot grouped

© 2006-2013 Andrew Cooke (site) / post authors (content).

Talk on SDSS

From: "andrew cooke" <andrew@...>

Date: Fri, 7 Apr 2006 11:37:11 -0400 (CLT)

Listened to a talk on SDSS - http://cas.sdss.org/dr4/en/ - at work
yesterday.  These are my notes:

- 35 queries
The MS guru database chap asked them for 20 queries before designing the
database.  That grew to 35 that they now repeatedly run as benchmarks
after upgrades.  I was surprised at the number (20 seems a lot, and it got
bigger).  Good way to get non-experts to talk about the data model.

- keep all versions (inc bugs)
They had a fixed set of data they wanted to put on the web.  They did
that, and then started finding ways to improve things.  Great, but old
versions must stay - people are using the data in long term projects.

- raw sql
- user tables
Got burnt very early with OODB.  They do everything in SQL.  Data
remediation.  User's have their own scratch tables.  This is a big point
of conflict with opinions in our team.

- two phase loader - chunked
- first stage no indices
- verification in sql
- parallel loading
- second stage faster once data trusted
First loading stage takes raw data and builds index-free tables.  Data are
then remediated.  Second stage moves remediated data into indexed tables.

- sql nice for //n (cpus and disks)
- as many volumes as processors
- single table scans are slowest - disk read limited
Avoid big disks.  Parallelize across disks and processors.

- 2Mb crossover (file v sql)
That's pretty big for a blob, but much less than our binary data (images).

- submission queues to channel user expectations (slow web pages bad)
Batch processing is batch processing.  Admit it and make it clear to your
users.

- spatial features surprisingly popular
- "ferris wheel" scan - sequence of filters; scan database again and again
(for cross-matching)
Lots of details about spatial indexing and searching.  2D indexing is
hard.  If you often end up doing a scan, optimize for scans.  Ferris whell
model is repeated scanning, in chunks.  Scan a bunch of queries together. 
Queue queries for a chunk; go through the datbase scanning one chunk at a
time.

Andrew

Comment on this post