Hey Nikhil,
OSM uses a PostgreSQL database as the main data store, along with PostGIS
extension for geometries. The tags are stored in key and value columns and
uses hstore, which makes it easy to add new ones without having to modify
the table schema. You can read about the database schema and
Hi Nikhil,
The Database design has been documented here:
https://wiki.openstreetmap.org/wiki/Database
This is, at its essence, a modified EAV Model(
https://en.wikipedia.org/wiki/Entity–attribute–value_model). A good place
to start researching for these kinds of database design, is to look at
