Here are some quick thoughts on this.
First, a nitpick: if you start with a set , then points do of course give prime ideals of (kernels of Boolean ring maps ). But if is infinite, then by the axiom of choice, there are other prime ideals too: namely, maximal ideals containing the prime ideal consisting of finite subsets of . These are in bijection with nonprincipal ultrafilters on , which can be considered “ideal points at infinity” that are adjoined to to form its Stone-Cech compactification.
But we can get precisely if we change the language, to include arbitrary joins instead of just finite ones. Then an “ideal” of would be defined to be closed under arbitrary joins (and would be a submodule of under the meet operation); the prime ideals in that case do correspond to points of . In other words, work in the category of (Boolean) locales, not just (Boolean) rings.
Actually, this is not just a nitpick; I think the change in point of view is important. The idea is that the concept of Grothendieck topos is a categorification of the concept of locale. The analogue of locale map (one which preserves arbitrary joins and finite meets) would be a functor which preserves arbitrary colimits and finite limits, i.e., the left adjoint part of a geometric morphism.
So, for example, suppose we start with a topological space . Under a fairly mild assumption (that is sober), those functors
which preserve colimits and finite limits correspond exactly to points of ; the corresponding “evaluation” functor sends a sheaf to its stalk at (or its fiber, restricting to locally constant sheaves as you mention).
So a first answer to how to characterize these fiber functors is to say they’re the cocontinuous finitely continuous ones to .
The analogue to ‘ideal’ is less clear-cut. In ring theory, the notion of ideal is a simplification of an appropriate notion of congruence relation, a simplification which is possible because of the presence of additive inverses (i.e., we say is congruent to modulo if ). Since such congruence relations are kernel pairs of ring maps , one could categorify that by taking the kernel pair = weak pullback of a left exact left adjoint against itself:
This kind of thing is studied by the topos theorists, especially in conjunction with descent theory, starting with the Joyal-Tierney monograph An Extension of the Galois Theory of Grothendieck. (I would have to reread that monograph to remind myself of the precise way in which all this is connected with Grothendieck’s Galois theory, and anyway the explanation wouldn’t fit in the margin here.)
In a rather different direction, Steve Awodey in his thesis pursued the following analogy: just as a commutative ring can be reconstituted as the ring of global sections of a sheaf of local rings on its space of prime ideals, so in the 2-category of elementary toposes and logical morphisms, a small topos could be reconstituted by taking global sections of a sheaf [or actually stack] of [“hyper”]local toposes over a certain site. The first such site is relatively tautological: it is the category itself equipped with the finite covering topology. The second is more sophisticated: the site is a certain topological space! Awodey goes on to give some interesting applications to higher-order logic, but as I say this direction would seem to be a little different to the one you want to go in.
Re: A Question or Two
Here are some quick thoughts on this.
First, a nitpick: if you start with a set , then points do of course give prime ideals of (kernels of Boolean ring maps ). But if is infinite, then by the axiom of choice, there are other prime ideals too: namely, maximal ideals containing the prime ideal consisting of finite subsets of . These are in bijection with nonprincipal ultrafilters on , which can be considered “ideal points at infinity” that are adjoined to to form its Stone-Cech compactification.
But we can get precisely if we change the language, to include arbitrary joins instead of just finite ones. Then an “ideal” of would be defined to be closed under arbitrary joins (and would be a submodule of under the meet operation); the prime ideals in that case do correspond to points of . In other words, work in the category of (Boolean) locales, not just (Boolean) rings.
Actually, this is not just a nitpick; I think the change in point of view is important. The idea is that the concept of Grothendieck topos is a categorification of the concept of locale. The analogue of locale map (one which preserves arbitrary joins and finite meets) would be a functor which preserves arbitrary colimits and finite limits, i.e., the left adjoint part of a geometric morphism.
So, for example, suppose we start with a topological space . Under a fairly mild assumption (that is sober), those functors
which preserve colimits and finite limits correspond exactly to points of ; the corresponding “evaluation” functor sends a sheaf to its stalk at (or its fiber, restricting to locally constant sheaves as you mention).
So a first answer to how to characterize these fiber functors is to say they’re the cocontinuous finitely continuous ones to .
The analogue to ‘ideal’ is less clear-cut. In ring theory, the notion of ideal is a simplification of an appropriate notion of congruence relation, a simplification which is possible because of the presence of additive inverses (i.e., we say is congruent to modulo if ). Since such congruence relations are kernel pairs of ring maps , one could categorify that by taking the kernel pair = weak pullback of a left exact left adjoint against itself:
This kind of thing is studied by the topos theorists, especially in conjunction with descent theory, starting with the Joyal-Tierney monograph An Extension of the Galois Theory of Grothendieck. (I would have to reread that monograph to remind myself of the precise way in which all this is connected with Grothendieck’s Galois theory, and anyway the explanation wouldn’t fit in the margin here.)
In a rather different direction, Steve Awodey in his thesis pursued the following analogy: just as a commutative ring can be reconstituted as the ring of global sections of a sheaf of local rings on its space of prime ideals, so in the 2-category of elementary toposes and logical morphisms, a small topos could be reconstituted by taking global sections of a sheaf [or actually stack] of [“hyper”]local toposes over a certain site. The first such site is relatively tautological: it is the category itself equipped with the finite covering topology. The second is more sophisticated: the site is a certain topological space! Awodey goes on to give some interesting applications to higher-order logic, but as I say this direction would seem to be a little different to the one you want to go in.