There's also the rendering database (PostGIS), which contains a subset of the current data, with freeform tags moved into Postgres columns, and with PostGIS geometries created from the raw OSM geodata. This is continually updated from the diffs of the core database. It's used by Mapnik (rendering code) to create the images you see on osm.org.
The proposed change is to add an hstore column to the rendering database, which will be populated with all the tags for each object from the core OSM database. This will require a complete reimport of the data.
https://wiki.openstreetmap.org/wiki/UMap
If you want to do more complicated things, try leaflet, http://leafletjs.com/
You are free to make a local map with OSM data, and then, in your browser, or GIS software of choice, overlay anything else you want on it.
> In the longer term there is the option to repopulate the database used by the Standard map style so that it has access to all OpenStreetMap data tags, not just a limited few.
How does a map 'style' repopulate the database? I get that not all tags can be displayed (e.g. many businesses have a website, but you don't display that unless you want to view the business's details) so why would a map need "access" to all data tags?
I have to be reading it wrong, but I don't see how.