[Talk-in] [datameet] How does OSM store its data

[Devdatta Tengshe]

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
various documents on EAV, its shortcomings & Strengths.

You should also evaluate if a NoSQL/Object Store database might be a better
fit for your purpose, than designing an EAV Data model to be stored in a
relational Database.


Regards,
Devdatta

On Mon, Feb 5, 2018 at 11:12 AM, Nikhil VJ <nikhil.js at gmail.com> wrote:

> Hi,
>
> I want to learn how OpenStreetmap stores and manages its data, plus how
> Overpass Turbo extracts it.
>
> I find the key-value pair system fascinating (variable fields, organic
> building up of data) and want to replicate that elsewhere. Just the data
> storing part.. don't want to generate map tiles etc.
>
> Any pointers? Any place I should ask?
>
> For those interested, here's a link to the project I have in mind:
> Crowdsourcing-Map-based-data
> <https://github.com/datameet-pune/datameet-pune.github.io/wiki/Crowdsourcing-Map-based-data>
>
> --
> Cheers,
> Nikhil VJ
> Pune, India
>
> --
> Datameet is a community of Data Science enthusiasts in India. Know more
> about us by visiting http://datameet.org
> ---
> You received this message because you are subscribed to the Google Groups
> "datameet" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to datameet+unsubscribe at googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/talk-in/attachments/20180205/dae74e62/attachment.html>