How does AEM Look Up Page Path in the Database?

[aemUser2345]

If I have a page path of /content/country/us/oregon/portland/homepage, how does AEM look up this path? I know AEM JCR database is No SQL, so there won't be any primary key or foreign key involved. 

[Harwinder-singh]

@aemUser2345  On a high level , the URL is decomposed into individual parts and based on that a mapping to a resource in the JAVA content repository is done.

For a detailed look at this url resolution, check out the below links :

https://sling.apache.org/documentation/the-sling-engine/url-decomposition.html

https://medium.com/@techzette2/sling-resource-resolution-aem-a72fabc07a59

https://www.aemcq5tutorials.com/tutorials/sling-resource-resolution-aem/

[sherinregi · Accepted solution]

@aemUser2345 

The below picture explains clearly on how URL lookup is done and the content is delivered. 

Ref URL: https://www.aemcq5tutorials.com/tutorials/sling-resource-resolution-aem/