Extended metadata

We tried to make OpenKM as intuitive as possible, but an advice is always welcome.
Forum rules
Please, before asking something see the documentation wiki or use the search feature of the forum. And remember we don't have a crystal ball or mental readers, so if you post about an issue tell us which OpenKM are you using and also the browser and operating system version. For more info read How to Report Bugs Effectively.
Post Reply
soltanivahid
Senior Boarder
Senior Boarder
Posts: 65
Joined: Thu Jan 04, 2018 8:22 pm

Extended metadata

Post by soltanivahid » Fri Jan 11, 2019 2:17 pm

Hello i want to have a extended form in meta data, many field verticaly and horizentaly!
What is your recomendation.
Thank you

jllort
Moderator
Moderator
Posts: 10552
Joined: Fri Dec 21, 2007 11:23 am
Location: Sineu - ( Illes Balears ) - Spain
Contact:

Re: Extended metadata

Post by jllort » Sat Jan 19, 2019 11:42 am

The horizontal an vertical widget for metadata are only implemented in professional version, currently we have not yet copyed these widgets into community edition.

soltanivahid
Senior Boarder
Senior Boarder
Posts: 65
Joined: Thu Jan 04, 2018 8:22 pm

Re: Extended metadata

Post by soltanivahid » Wed Jan 23, 2019 4:27 am

One more related question
Is it okey to store all metatable in one table when we have many metadata and large repository? Thank you.

jllort
Moderator
Moderator
Posts: 10552
Joined: Fri Dec 21, 2007 11:23 am
Location: Sineu - ( Illes Balears ) - Spain
Contact:

Re: Extended metadata

Post by jllort » Fri Jan 25, 2019 7:59 pm

About what amount of data are talking about? number files what will have metadata and number of fields for the metadata groups.

soltanivahid
Senior Boarder
Senior Boarder
Posts: 65
Joined: Thu Jan 04, 2018 8:22 pm

Re: Extended metadata

Post by soltanivahid » Tue Jan 29, 2019 1:12 pm

I mean large number of files that have metadata.

jllort
Moderator
Moderator
Posts: 10552
Joined: Fri Dec 21, 2007 11:23 am
Location: Sineu - ( Illes Balears ) - Spain
Contact:

Re: Extended metadata

Post by jllort » Wed Jan 30, 2019 7:35 pm

Are talking about thousands, or millions. Also, it is interesting to know how many fields you consider will have them in the metadata groups.

In OpenKM professional version 7 we have changed the way on how we are storing metadata, the new database structure might prevent possible performance issue. However, we have customers with large repositories and millions of metadata fields ( I'm talking about 70 million and more into that table without performance issues. If indexes are well set and database has a good configuration the current configuration should not be problematic, really if you analyze the query what it is done in this table, always we are selecting and specific group with a specific UUID, that should be quick because there is a pair of keys indexed ).

The new database configuration in version 7 should provide better performance and some advantages when making queries by metadata values, for both reason we decided to change it, anyway community version current structure is well tested and should not have these issue.

I do not know the number of records you have in mind and the number of metadata, in case of large repositories I suggest consider professional edition. Always you will be able to promote a community edition to professional in the future, but always it is better starting in the right direction from he beginning.

soltanivahid
Senior Boarder
Senior Boarder
Posts: 65
Joined: Thu Jan 04, 2018 8:22 pm

Re: Extended metadata

Post by soltanivahid » Thu Apr 11, 2019 8:31 pm

I have 5000folder that half if them have one metadata that contain 60field, and the rest another metadata with 50field.

jllort
Moderator
Moderator
Posts: 10552
Joined: Fri Dec 21, 2007 11:23 am
Location: Sineu - ( Illes Balears ) - Spain
Contact:

Re: Extended metadata

Post by jllort » Sat Apr 13, 2019 8:42 am

5000 nodes are not much. But you are not talking about files.

Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest