JCR - SQL Vs NOSQL | Community
Skip to main content
Level 8
February 3, 2025
Solved

JCR - SQL Vs NOSQL

  • February 3, 2025
  • 1 reply
  • 537 views

Hi all,

 

JCR is not a database, therefore whether it is SQL DB or NONSQL DB does not arise.

But Solr is a blazing fast, open source NoSQL Database Search engine and can access JCR.

 

How is it possible as JCR is not a NONSQL database?

Does it mean that Solr works on non data bases also?

 

Appreciate all your responses.

 

Thanks,

RK.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by daniel-strmecki

Hi @nsvsrk 

AEM's JCR (Java Content Repository) is implemented via Apache Jackrabbit Oak, and is considered a type of NoSQL database. It is a hierarchical, document-oriented content repository designed to store structured and unstructured content like web pages, assets, and metadata.

While JCR handles content storage, Solr (or Lucene in embedded setups) is used for full-text search and indexing. AEM uses Oak’s indexing mechanism to determine what content should be indexed. When a query is made (SQL2, XPath, etc.), AEM checks the Oak index definitions to decide whether to query Solr or JCR directly.

 

Hope this helps,

Daniel

1 reply

daniel-strmecki
Community Advisor and Adobe Champion
daniel-strmeckiCommunity Advisor and Adobe ChampionAccepted solution
Community Advisor and Adobe Champion
February 3, 2025

Hi @nsvsrk 

AEM's JCR (Java Content Repository) is implemented via Apache Jackrabbit Oak, and is considered a type of NoSQL database. It is a hierarchical, document-oriented content repository designed to store structured and unstructured content like web pages, assets, and metadata.

While JCR handles content storage, Solr (or Lucene in embedded setups) is used for full-text search and indexing. AEM uses Oak’s indexing mechanism to determine what content should be indexed. When a query is made (SQL2, XPath, etc.), AEM checks the Oak index definitions to decide whether to query Solr or JCR directly.

 

Hope this helps,

Daniel