I've got too many views in my GIS database. I'm starting to wonder if the database isn't the right place to store queries. Any tips?
How are things done in the non-GIS world? I'm starting to get the impression that people don't create many database views. Instead, logic is usually stored at the application level. Is that your experience?
(ArcMap/Enterprise 10.7.1, ArcGIS Pro 2.6.8, Oracle 18c, SDE.ST_GEOMETRY)
In my case:
I built and maintain my geodatabase, my colleagues don't know its structure. It's in third normal form, so information about a single object has to be collected from multiple tables. This is impossible without knowing the database structure.
It has to be easy for my colleagues to get the information they want. It has to be easy for me to republish services.
That means:
I don't have to interface with non-GIS software, so I can't tell you what's best practices there.