topic Re: where are stored the values of a property ? in Alfresco Archive

where are stored the values of a property ?

aznk — Wed, 31 Jan 2007 16:18:49 GMT

Hi,I know that nodes are stored in a database (mysql in my case), but I couldn't find where the property values are stored, even by browsing the database tables, node browser or alf_data directories. All I could find was only node ID (such as 083afe5c-b069-11db-88a1-cfe3e3c891f3), even in the table

Re: where are stored the values of a property ?

aznk — Thu, 01 Feb 2007 10:02:54 GMT

I was that we could configure properties as follows :

<index enabled="true">
                 <atomic>true</atomic>
                 <stored>false</stored>
                 <tokenised>true</tokenised>
              </index>‍‍‍‍‍

and that the "stored" tag means "If true, the property value is stored in the index and may be obtained via the lucene low level query API." according to the wiki : http://wiki.alfresco.com/wiki/Full-Text_Search_Configuration
but what is "lucene low level query API" ? Is it the xpath Nodeservice ? Does it mean that in a way or another (database/node browser/api/query), we could see/access the actual property value ?

Re: where are stored the values of a property ?

aznk — Fri, 02 Feb 2007 10:07:28 GMT

I've managed to get the object in mySQL by matching the db_id from the node browser. The problem is that the values are stored as serializable ArrayList. I need to perform a query like this :

SELECT COUNT(tag) AS tagCount, tag
FROM tblblogtags
GROUP BY tag‍‍‍

that's why I needed raw access to these values.
What's the best way to process these values ? Of course I could use the jcr but I would to iterate over all lists and this would have performance issues. The sql select/count/group by is more efficient. Would that be a bad idea to create a separate table for these values in order to perform my query on them ?
Thanks for your answer.