That's the Archimedes' Screw Pump.
Good for lifting water up heights, but sucks for pressure unless it was used to raise water up some height to a gravity feed reservoir.
What you really want to be looking at is the "Quimby Screw Pump", variants of which are what's typically used in hydraulics and the like.
Basically it's two screw/rotors meshing side by side creating two "pockets" that move along. The meshing prevents back-flow down the screws allowing for fairly stupendous pressures to be reached (~5000PSI). I once saw a plexiglass cased "demo" version of one that was about 20cm long.
A really nice little intro web page on pumps can be found here:
http://www.animatedsoftware.com/pumpglos/pumpglos.htm