Relative advantages of a file store and a data store

You must decide whether to use a file store or a data store for your messaging engine, by considering the advantages of each type.

Using a file store rather than a data store for your messaging engine can have several advantages:
Better performance
To achieve best performance using a data store, you often have to use a separate remote database server. With file store you can achieve even better performance without having to use a separate remote database server.
Low administration requirements
The file store combines high throughput with little or no administration. This makes it suitable for those who do not want to worry about where the messaging engine is storing its recoverable data. File store improves on the throughput, and scalability of Apache Derby.
Lower deployment costs
Use of data store might require database administration to configure and manage your messaging engines. File store can be used in environments without a database server.

Some organizations prefer to use data store because it uses their existing resources more effectively. For example, this might be the case for a company with a strong team of database specialists, or a stable database infrastructure.

If there is a transient connectivity loss to the file system, the application server must be restarted once the connectivity to the file system is restored. Whereas, in the case of the data store, the messaging engine can recover from the database itself. In such situations, the data store will be a preferred high availability option than the file store system.

[IBM i] Data store has the following technical advantage over file store: with data store, some Java EE applications can share JDBC connections and benefit from one-phase commit optimization. For more information see Sharing connections to benefit from one-phase commit optimization. File store does not support this optimization.

Data stored in both data store and file store benefit from security features provided by WebSphere® Application Server when accessed using the WebSphere Application Server APIs, that is when using JMS messaging. Further security features are available depending on the type of message store you use. For more details see File stores and Data stores.

Both file store and data store offer high availability capabilities. For more details see Message store high availability.

Concept topic    

Terms and conditions for information centers | Feedback

Last updated: April 18, 2014 05:01 AM CDT
http://www14.software.ibm.com/webapp/wsbroker/redirect?version=phil&product=was-nd-iseries&topic=cjm0001_
File name: cjm0001_.html