SUCCESSFUL DATABASE EMBEDDING IN AN ENTERPRISE APPLICATION
ORGANIZATIONA major tax solution company
CHALLENGEThe challenge was to create an enterprise installer that seamlessly installs the third party database server (Oracle® 10G R2 Enterprise Edition), does appropriate configurations, and creates the application schema. The deployment needed to be easy and seamless, working well with the application installation process and conforming to existing standards. Additionally, the database configuration should be optimized to handle exponential growth in usage and data size. And, the day-to-day administration would need to be minimal since there would be either limited DBA expertise or no on-site DBA to manage the database.
SOLUTIONA database solution was developed to embed an Oracle database with their enterprise application. This not only improved the bottom line for the company, but also added value to their customers by reducing costs, improving application performance, and removing the need to have a specialized skill set in house to manage the data and application. XTIVIA developed an installer utilizing InstallShield Multi-platform version 11 which is fully Java-compliant, thus allowing the same InstallShield project code to be utilized to create platform-specific launchers. The installer encapsulates the functionality of collecting user preferences and projected application usage in terms of transactions per day. The installer also allows users to choose the locations for database binaries, data and backups. The user can choose certain features provided by the database vendor (Oracle), making it a truly customizable, scalable and automated database installation with minimal day-to-day administration needs.
XTIVIA developed the entire product, from requirements collection to user acceptance testing. The combined utilization of Oracle 10G R2 and InstallShield is fairly unique and as such, very little information is available about it. Despite this, XTIVIA was able to deliver a high quality product with a substantial feature set, on time, using in-house talent. Some of the features made available by the installer are detailed below. The installer collects information from the end user regarding the following items:
- Location for Oracle binaries
- Location for Data
- Location for Flashback recovery area
- Features such as RMAN, ASM and OFA
- Transaction volume per day