Filenet-API Training

1. If 10 TB of data is stored in an ObjectStore, the retrieval speed is very slow. How can I increase the retrieval speed of the filenet system?

A: In filenet, a lifecycle policy is defined for the document. When the document expires, it is automatically moved to the next ObjectStore to retrieve only frequently-used documents, improving the retrieval speed.

2. What fields can filenet be applied to, including potential application fields?

Answer: The housing provident fund, the Judicial Bureau, the leasing logistics industry in the Far East, nuclear power, electricity, and so on. filenet mainly solves the problem of slow transmission rate of paper documents. Through online process audit, the office efficiency can be greatly improved.

3. Does filenet store real entities or indexes?

Answer: storage Index

4. What is the difference between the type collaborative and exclusive of checkout in filenet?

Collaborative is a collaboration that allows multiple people to perform checkout operations to facilitate cooperative development, but it is prone to version conflicts. Exclusive does not allow other users to perform the checkout operation after a user performs the checkout operation.

5. What are the principles of the software development and creation class?

A: Generally, classes are created based on services or functions. You can create packages by business hierarchy. This is a common method. For example, the shared class is placed in the util package, the exception class is placed in the exception package, and the core class is placed in the core package.

6. Why does filenet use classes to manage data without using attribute fields to store data?

Class can be inherited and scalable. When requirements change, attribute fields (tables) are used to batch operate all data, greatly reducing the scalability of the system.

7. What is the role of LDAP?

LDAP is a Lightweight Directory Access Protocol. It stores directories in a tree and has high query efficiency. LDAP is used to facilitate user management. For example, there are 40 million employees in IBM and their employees are stored in LDAP mode. In this way, each user does not have any interaction with the user at the upper level, and deletion and other operations will not affect other users.

8. What is the role of defining variables using static?

Share a finger to ensure the uniqueness of the value.

9. What is the difference between fetchinstance and getinstance?

Fetchinstance needs to interact with the server. Every time data is obtained, a connection must be established with the server.

Getinstance obtains data from the local (cache) and does not interact with the server. This provides better performance.

10. When creating a document, what is the purpose of selecting reference?

When you select reference, the created object is stored locally and not submitted to the ObjectStore by adding a link to the original file storage location.

11. What is the role of sqlobject. setmaxrecords?

Because users do not need to know all the retrieved content, a lot of content is useless for all the retrieval results. Retrieving all the result sets will reduce the system performance. Setting setmaxrecords can increase the service response rate, which is already used in the SQL Server 2008 Enterprise Manager.

12. What should I pay attention to in composite queries? How can I improve the performance of composite queries?

-- Indexes and joint indexes should be created based on the queried fields.

-- The queried field should exactly match the index

-- Replace in and not in with exist and not exist.

-- The nesting of query conditions should not be too many. The nesting should be changed to from a, B, c

-- In like fuzzy query, the first priority should be avoided as %

-- Change the correlated subquery to non-correlated subquery.

-- The maximum number of records should be filtered out at the beginning of the query, and the conditions with more filtering content should be written in the first place (Oracle should be written in the last place)

-- Use left join to improve system performance

-- Where conditions should be relatively simple

-- Avoid using select *. Specify the fields to be retrieved.

-- When searching, you should add iscurrentversion to query only the content of the current version. All developers are using this document.

13. What is the role of auditdefinition. set_auditsuccess (Boolean. valueof (true?

Generally, for frequently-used operations, only the failed operations are audited. If successful operations are filtered out, successful operations can also be audited.

14. Why batch operations?

-- Transaction needs

-- Reduce repetitive operations, such as importing data to each table. Batch operations can reduce repeated operations.

-- Reduces connections to databases and improves system performance.