IBM Sterling Ideas

formerly Watson Supply Chain

Submit new product ideas for Watson Supply Chain solutions. Before you submit, please review existing ideas; if an idea close to yours already exists, it's better to add comments or vote on the existing idea. We will review your ideas and use them to help prioritize our product development. Best of all, the portal will automatically update you when the status of your idea has been changed. Order Management, Store Engagement, Watson Order Optimizer, Inventory Visibility, CPQ and Call Center are now part of Watson Supply Chain

Connect with IBM experts and your peers on the Supply Chain Collaboration Community and the Order Management Interest Group

Submit ideas for other Watson Customer Engagement Products:

Watson Marketing
Watson Campaign Automation
Watson Commerce

Replace LOBs with SecureFiles on Oracle

Current Situation:

The current implemntation of IBM SI is using Oracle LOB Datatypes to store payload as well as metainformation like process data. The storage management of LOB datatypes by Oracle is not reorganization free. To avoid DB-lock situations this redefinition run's practicaly can only be done while all SI Servers are down.

In high volume environments like ours this contradicts with typical 24/7 requirements.

Oracle Solution SecureFiles:

Oracle noticed the demand for enhanced Lob management and introduced SecureFile Datatypes with Oracle version 11.1 to replace the former Lob approach completly.

The scope of this enhancement is

- Improve performance of read/write activities
- Hazard free physical organization with no need for redefinition runs
- Add capabilities like compression, deduplication and encryption

According to various DBA Exchange portals, the day-to-day experience with SecureFiles is positive. Promises are met and the concept is proven to be stable.

References

http://www.oracle.com/technetwork/database/performance/securefilesperformancepaper-130360.pdf
http://joordsblog.vandenoord.eu/2010/02/oracle-securefile-and-options.html
http://docs.oracle.com/cd/B28359_01/appdev.111/b28393/adlob_smart.htm
  • Avatar32.5fb70cce7410889e661286fd7f1897de Guest
  • Dec 19 2017
  • Uncommitted Candidate
How will this idea be used?
What is your industry?
What is the idea priority? High
DeveloperWorks ID DW_ID38470
RTC ID RTC_ID394740
Link to original RFE http://www.ibm.com/developerworks/rfe/execute?use_case=viewRfe&CR_ID=38470
  • Attach files