In what Database do relations belong


Im new to OSM and I am programming a java SaxParser for entering nodes, ways etc from a osm file in a database.
I found the Database structures on the OSM Wiki but I dont understand in which database the Relations are stored (nodes, ways, segments have their own databases but relations and members dont).
Can someone tell me where do I find the osm database structure for Relations and Members Information to store in?


I don’t know what you’re planning to do with that database, but maybe you’re solution is already created by means of Osmosis. Osmosis can populate a MySQL or PostgreSQL database using it’s own database scheme. It can apply planet change files and much more.

Yes I know but Im trying to do it myself.

I just found this on the Wiki page

Can you please tell me where I can find the newest XML Schemas or the newest Database structures because this Structures here are from September 17, 2007?


The current XML schema is documented here

The api server software itself will always have the most upto date information on the database schema it is using.

Your database schema should be influenced by what you want to do with the data. If you don’t want to do the same things the api server does its schema may not be appropriate for your application.