How to parse CNC?

Question

CMS

The topic is beaten, there are many implementations on the Internet, but they are not quite suitable for me. I would like to hear people's opinions and options. In general, the essence of the problem: there are links, for example:
country/russia - leads to a static page;
country/russia/hotels - leads to a dynamic page with products;
country/russia/hotels/about - leads to a static page.
How can this thing be parsed? Parsing through slashes is not an option, because. these are not modules / handlers, but simply an alias invented by the user. There is an option to move the url to a separate table, but each time you will have to additionally access this table. You can store urls in files, this is the best option in my opinion. What do you think? :)

Answer 1

0. Forget about CNC.
1. Get familiar with routing.

Answer 2

What's the problem with accessing a small table once with a unique key?
Especially if it's all custom aliases.
If this is user input, then where are you going to store it, except for the database?