Default Alfresco Stores

[Muffex]

Hello everyone.

Can somebody (briefly) explain the purpose of each of the 6 default stores?

1. user/alfresoUserStore
2. system/system
3. workspace/lightWeightVersionStore
4. workspace/version2Store
5. archive/SpacesStore
6. workspace/SpacesStore

The only thing I could find was: Alfresco: some useful database queries  

This article explains:

• 5 - Document was deleted by user and is now in global trashcan
• 6 - Document is in its active life

Is this information correct? 
What about the other stores?

regards
Muffex

[abhinavmishra14 · Accepted solution]

At a high level,

user/alfrescoUserStore  --> Nodes of type usr:user live in this store. Note that nodes of type cm: person is stored in the workspace://SpacesStore

system/system --> All system specific nodes lives in this store, for example: Details related to installed modules.

workspace/lightWeightVersionStore --> Node (content+properties) version history lives in this store including node properties, this store is legacy (Before Alfresco version 3.x) store and still part of the repo it seems. 

workspace/version2Store --> Node (content+properties) version history lives in this store including node properties.

archive/SpacesStore  -->  All the deleted node (content+properties) lives in this store. Note that, its a soft delete and deleted content can be found in trashcan. 

workspace/SpacesStore --> All the wip/live node (content+properties) lives in this store.

You may considering reading this post as well: https://blog.dbi-services.com/understand-the-lifecycle-of-alfresco-nodes/

For detailed info:

https://docs.alfresco.com/content-services/latest/develop/software-architecture/

[morganp1]

Hello,

Juste a note that our blog platform changed and therefore the links above to our dbi services platform stopped working. If you are interested, the new links are:

• https://www.dbi-services.com/blog/understand-the-lifecycle-of-alfresco-nodes/
• https://www.dbi-services.com/blog/alfresco-some-useful-database-queries/

Morgan P.