We are faced with a challenge to our project where we have way too much business metadata we want to store for each record/document in P8. The decision has been made to externalize all the business data outside in a SQL DB. By using the Document ID that P8 stores for each record/document will be stored in the SQL DB as a foreign key. So all the application searches will go against the SQL DB and use the Document ID to retrieve the document from FileNet. I am sure this works and seem like a perfect solution to speed up the searches and indexing scheme on the metadata.
Question is, can we externalize the Document ID that FileNet generates for the record/document? Is this a best practice? Is this safe if ever the FileNet ObjectStore is upgraded from one version to the other or what ever?
Any help will be greatly appreciated.
Pinned topic !!!! Urgent Help on Metadata Design Decisions !!!!
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2009-12-01T16:57:46Z at 2009-12-01T16:57:46Z by Sr1n1L
Re: !!!! Urgent Help on Metadata Design Decisions !!!!2009-11-30T17:28:41ZThis is the accepted answer. This is the accepted answer.I am really shocked to see that there are no replies .... not even some IBM representation or monitoring for that big of a service company....
Still looking for some answers please!!!!
SystemAdmin 110000D4XK40 Posts
Re: !!!! Urgent Help on Metadata Design Decisions !!!!2009-12-01T15:49:31ZThis is the accepted answer. This is the accepted answer.
- Sr1n1L 270002FDUH
I did something like that in Content Services (few years ago) because Content Service metadata model is not that flexible as P8 metadata model. Regarding you concern about externalize the metadata to another database, from my point of view, is ok if you use a custom application who know how to deal this situation.
For sure ... this is not a best practice, and will not speed up your searches. Will speed up the SQL search (may be) but if you need to apply security filters (authorization) on search results ... overall you will obtain a poor performance.
I have two suggestions for you:
1. keep in P8 all valuable metadata (all metadata for which you will perform searches) and "move" the other metadata in another SQL DB.
2. keep all valuable metadata (all metadata for which you will perform searches) on main document class, and use custom object classes to model the other metadata, and properties of type "object" to "link" custom object instances to document/record
Re: !!!! Urgent Help on Metadata Design Decisions !!!!2009-12-01T16:57:46ZThis is the accepted answer. This is the accepted answer.
- SystemAdmin 110000D4XK