From your description so far it's not clear how categories map to the database. With a good mapping the code to resolve a path to a database row or set of rows should be fairly compact. Perhaps you could show us a small sample of the parsing and rendering code and tell us a little about how the database is structured?