Published on 25 Nov 2008
Validated on 10 May 2012
"We have seen at least a tenfold performance improvement after migrating to DB2 9. pureXML technology is truly a landmark development by IBM." - — Dr. A. Prabhakar, Managing Director, EnterpriseFlow
Integrated Data Management, Enterprise Resource Planning, Leveraging Information
IBM Business Partner:
EnterpriseFlow provides business solutions for the small-and-medium sized business (SMB) sector and focuses on developing solutions for the enterprise resource planning (ERP) product industry.
EnterpriseFlow needed a solution that was afordable and supported a diverse range of ERP-specific applications regired by small to medicum business organizations.
EnterpriseFlow ported it's solution from Tomcat/Derby to license-free IBM WebSphere Application Server Community Edition and IBM DB2 Express-C 9 database, the number of tables has shrunk by more than two-thirds (to approximately 60 tables).
Ability to represent complex BPOs as XML documents and to store, manage and query them effectively; Reduced cost and labor for implementing ERP applications as it requires no code change for customization and extension to BPOs; Ability to offer low-price ERP applications with DB2 Express-C license and subscription option
Bangalore, Karnataka, India
• IBM DB2® Express-C 9
• IBM WebSphere® Application Server Community Edition
For more information, visit: www.ibm.com/db2
“We have seen at least a tenfold performance improvement after migrating to DB2 9. pureXML technology is truly a landmark development by IBM.”
— Dr. A. Prabhakar, Managing Director, EnterpriseFlow
Started in late 2006 and primarily based in India, EnterpriseFlow provides business solutions for the small-and-medium sized business (SMB) sector and focuses on developing solutions for the enterprise resource planning (ERP) product industry. Its EnterpriseFlow Application Suite is a business process management (BPM) and workflow management (WFM) system.
One of the considerations in offering a product to the SMB sector is affordability. With this in mind, EnterpriseFlow initially used open-source tools—Apache’s Tomcat and Derby—as the Web application server and relational database management system (RDBMS), respectively. However, customers became concerned about support issues associated with these offerings.
EnterpriseFlow needs to support a diverse range of ERP-specific applications required by general business organizations. Each of these modules has different business object templates. It is therefore difficult to store, link, manage and access these objects by different modules.
Furthermore, easy customizability and extensibility, especially in terms of being able to develop custom business processes unique to each organization, are crucial requirements of the ERP software solution. And as business processes are continuously evolving, a BPM system must have the necessary flexibility to rapidly adapt to these changes.
EnterpriseFlow ported its application suite from Tomcat/Derby to license-free IBM WebSphere Application Server Community Edition and IBM DB2 Express-C 9 database—the free version of the lightweight IBM DB2 database for SMBs—along with low-price global support subscriptions. Although the software had to be substantially rewritten to take full advantage of XML support in DB2 9, EnterpriseFlow developers decided to migrate due to the substantial advantages they expected to derive from DB2 pureXML™. These included significant gains in performance, ease of developing future product enhancements, and improved flexibility and agility in adapting to business process changes for the application.
Initially, the EnterpriseFlow application shredded and stored its XML-based business process objects (BPOs) in approximately 200 tables in a Derby database. Maintaining this database schema and querying BPOs shredded across these schemas was difficult. It was also difficult and time consuming to modify these tables when the BPO model was changed since it required code changes.
After porting to DB2 9, the number of tables has shrunk by more than two-thirds (to approximately 60 tables). The native XML support in DB2 9 enables the BPO XML representations to be stored directly in the database and avoids the complexity, inflexibility and cumbersome nature of shredding.
In the EnterpriseFlow Application Suite, business process objects are modeled as XML files, and these BPOs are associated with different entities in various ERP applications. With the capability of DB2 9 to support multiple XML schemas in an XML type column, different XML representations of BPOs from different ERP applications can be stored in the same column in a DB2 table regardless of the associated attributes for each BPO. Also, with this support, users can easily develop custom business processes unique to their organizations or develop an extension to EnterpriseFlow’s BPOs.
“We have seen at least a tenfold performance improvement after migrating to
DB2 9,” says Dr. A. Prabhakar, managing director of EnterpriseFlow. “pureXML technology is truly a landmark development by IBM.”
• Ability to represent complex BPOs as XML documents and to store, manage and query them effectively
• Reduced cost and labor for implementing ERP applications as it requires no code change for customization and extension to BPOs
• Ability to offer low-price ERP applications with DB2 Express-C license and subscription option
© Copyright IBM Corporation 2008 IBM Corporation Software Group Route 100 Somers, NY 10589 U.S.A. Produced in the United States of America October 2008 All Rights Reserved IBM, the IBM logo, ibm.com, DB2, pureXML and WebSphere are trademarks of International Business Machines Corporation, registered in many jurisdictions worldwide. A current list of IBM trademarks is available on the Web at “Copyright and trademark information” at www.ibm.com/legal/copytrade.shtml Other company, product, or service names may be trademarks or service marks of others. The information contained in this documentation is provided for informational purposes only. While efforts were made to verify the completeness and accuracy of the information contained in this documentation, it is provided “as is” without warranty of any kind, express or implied. In addition, this information is based on IBM’s current product plans and strategy, which are subject to change by IBM without notice. IBM shall not be responsible for any damages arising out of the use of, or otherwise related to, this documentation or any other documentation. Nothing contained in this documentation is intended to, nor shall have the effect of, creating any warranties or representations from IBM (or its suppliers or licensors), or altering the terms and conditions of the applicable license agreement governing the use of IBM software.