I'm developing an application on top of filenet.
Anyone know HOW the content manager stores properties metadata (class-default & userdefined) on database?
There is a table for each class? There is one big table? The properties are mapped on multipurpose columns or a tablecolumn is created for every added property?
As a developer I don't have access to database to verify my hypothesis, but I have to design the data model for my application.
Any help will be very appreciated!
This topic has been locked.
2 replies Latest Post - 2013-01-23T22:39:01Z by cwoliveira
Pinned topic Filenet Metadata Storing Strategy
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2013-01-23T22:39:01Z at 2013-01-23T22:39:01Z by cwoliveira
RuthHildebrand-Lund 270000E6V819 PostsACCEPTED ANSWER
Re: Filenet Metadata Storing Strategy2013-01-23T22:05:24Z in response to SystemAdminAn object store is made up of several tables. Details about the database schema are in ecm_help → Developing IBM FileNet P8 Applications →
Content Engine Development → Content Engine Java and .NET Developer’s Guide → Reference → Database Reference → Database table schemas. The link to the 5.1 version of the information is http://pic.dhe.ibm.com/infocenter/p8docs/v5r1m0/index.jsp?topic=%2Fcom.ibm.p8.ce.dev.ce.doc%2Fdatabase_table_schemas.htm.
The metadata for the documents is stored in the DocVersion table, with one row for each document.
cwoliveira 270003P29729 PostsACCEPTED ANSWER
Re: Filenet Metadata Storing Strategy2013-01-23T22:39:01Z in response to SystemAdminHi,
You can take a look on this redbook. It contains sample use cases for repository design.
IBM FileNet Content Manager Implementation Best Practices and Recommendations
Also they are a couple references about Classes and Properties concepts on Content Engine. To explore physical database schema is good as reference and DBA tasks such as tuning, but it should not be your primary reference to design the solution.
Administering IBM FileNet P8 > Administering Content Engine > Classes - Concepts:
Administering IBM FileNet P8 > Administering Content Engine > Properties - Concepts: