topic Re: tables on user & group profile in Alfresco Archive

tables on user & group profile

andy2_0 — Sat, 07 Dec 2013 15:48:26 GMT

Hi Anybody please help tell me which table is used to store the user & group information in alfresco share?I can't find it. Thanks!

Re: tables on user & group profile

mrogers — Sat, 07 Dec 2013 21:39:31 GMT

It doesn't exist. There is no persistence in share at all.

In the alfresco repo, there's no user and group table either, the repo works with nodes and properties. User and groups are types of authorities.

Re: tables on user & group profile

andy2_0 — Sun, 08 Dec 2013 11:55:31 GMT

Hi mrogers, thanks for prompt response!

Here come more questions:

(1) According to my understanding, most the of the objects are content-centric in alfresco. In the repository we can find the foler/document about wiki, discussion, blog, datalist and so on. So I can understand that user/group records are processed as a zero-size document with the specific metadata. But why I can't find them in the repository? You said that user and groups are types of authorities, what is the authority object? it's an aspect, or a kind of node? Where can I find more information about it?

(2) As I know, alfresco uses alf_node to store the node information, and uses alf_node_properties to store the metadata information. After studied the table of alf_node_properties, we will find that one document will have tens of metadata records in alf_node_properties. If the number of document grows fast, the size of alf_node_properties will increase very fast. How do you solve the performance issue?

(3) We are going to develop a project management system based on alfresco, we need to manage many kinds of records (here the record means a row of a table in RDBMS). We want to treat these records as the datalist (event, issue…) in alfresco, wonder if this is a correct decision, and wonder if there are better solution for us (actually we have another to-be-proved solution, please see post - forums.alfresco.com/forum/developer-discussions/alfresco-share-development/can-iframe-be-used-alfresco-share-integrate). And we are concerning on the performance as I mentioned in item (2).

Thanks for your time and comments, really appreciate your help!

Re: tables on user & group profile

mrogers — Sun, 08 Dec 2013 20:39:00 GMT

Your question was about tables.    Yes of course you can find information about authorities in alfresco, there are many apis to find information but direct database access is not recommended.

Values are not duplicated in the prop value table, that's part of the solution in making alfresco perform.   And perform it does, you should not need to worry about private implementation details.

How to model your records in alfresco depends upon what you want to do with them.   There are several options but they should be driven by your business cases.

Re: tables on user & group profile

andy2_0 — Mon, 09 Dec 2013 15:55:07 GMT

Thanks, Mrogers.

I found the people and authorities (group) in sys:system node finally.

For the "values are not duplicated in the prop value table", though I don't understand how it is implemented, I need not worry about alfresco performance.

Again thanks!