topic Re: Default Alfresco Stores in Alfresco Forum

Default Alfresco Stores

Muffex — Thu, 15 Jul 2021 11:36:00 GMT

Hello everyone.

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

user/alfresoUserStore
system/system
workspace/lightWeightVersionStore
workspace/version2Store
archive/SpacesStore
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

Re: Default Alfresco Stores

abhinavmishra14 — Thu, 15 Jul 2021 14:25:34 GMT

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/

Re: Default Alfresco Stores

morganp1 — Tue, 09 May 2023 06:10:03 GMT

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:

Morgan P.