How to bring data from OSM to normal forms?

Question

PostgreSQL

So I downloaded the map of the region from the site data.nextgis.com , looked at them through QGIS, uploaded it to POSTGIS and I had a logical question (it seems to me), the database is redundant to the point of impossibility.
The first thing that came to my mind was to create tables for entities, go through the layers and scatter everything into these tables. But I feel like it won't work in QGIS or anywhere else (maybe I'm wrong).
Perhaps the question has nothing to do with reality, if so, then you just have to put up with it)
PS Raising the entire OSM database is not possible, and there is no need. It is possible to use your cards and there is no need, in fact you need to be able to enter the address and get hints at the address (have a drop-down list so that you do not enter the same data every time). Bind an address to an object and have all the data about the address (geom, street, house number, number of floors, etc.)
Thank you all in advance!

Answer 1

there are a lot of things in the OSM database, necessary, unnecessary ... you can enter any data, this is not limited by any rules (well, except for the basic recommendation that this object should exist in reality).
so it's a mess. and in its pure form for practical use, it is not prepared.
you take - you clean/remake/index for yourself - you use it.
option 2: use the nominatem online geocoding service.
for drop down lists do your bike.

Answer 2

OSM is raw data - it just needs to be accepted as fact. For the end user, they need to be "cooked".
In your case, I would not take shapes, but directly drive them into the database from pbf via osm2pgsql. And then you have the geometry of the house and the address: street + house; and you get the binding by geometric nesting in the polygon of a settlement, settlement, region, etc. But we must be prepared that in the vast majority of villages there is no addressing.