Imagine the following situation…
Since a few years your business has been investing in centralizing valuable business information. After some research in the market you have found the Oracle database to be the best fit for your requirements.
Using the free Oracle Application Express (APEX) framework, helping you to rapidly develop the web-applications needed to support both internal and external users, was a premium. Making this installation available based on the Oracle Standard Edition One database, you have created this solution against the lowest possible investment!
- Medium Oracle Sun Server X4-2 with 2 x 8 core CPU’s at € 19,500 *
- 2 Oracle Database Standard Edition One licenses at € 11,200
As many great projects go, the use and the number of APEX applications is growing. With the addition of ready to use applications to inspire you, many cool plug-ins to ever increase the usability and integration possibilities you get caught up in the data growth dogma!
With an ever increasing user population and expansion of data-reporting for ever faster business reporting your initial system is starting to fail, showing ever more frequent performance lags or system unavailability. These problems form a risk for your business, a risk you need to eliminate as soon as possible!
The standard advise here would be to upgrade your environment, the standard advise here would be to upgrade to a bigger machine and to an Enterprise Edition database. This is what your investment would be then…
- Medium Oracle Sun Server X2-4 with 4 x 10 core CPU’s at € 42,500
- (40 cores x 0,5 core-factor **) 20 Oracle Database Enterprise Edition licenses at € 914,800
Without rendering your application infrastructure worthless by the required investment, a more reasonable step would be to migrate to Oracle Database Standard Edition.
- Medium Oracle Sun Server X2-4 with 4 x 10 core CPU’s at € 42,500
- 4 Oracle Database Standard Edition licenses at € 67,400
Still requiring a total investment of more than a hundred thousand Euro and leaving you with the old server and licenses to be decommissioned.
In many implementations, not data entry but data-mining or information aggregation are the costly processes. So probably this will be true in this situation too. With a little investigation it is possible to separate a number of functions that will only query data and not necessarily modify data. Especially in this situation you can also increase your application performance by moving these specific processes to a new environment.
But… how…
The information in the new environment needs to be real-time consistent with the “production” or primary environment. Here we introduce a real-time data replication solution like Dbvisit Replicate which will create just this real-time consistent query environment for you! This makes for the following investment:
- Medium Oracle Sun Server X4-2 with 2 x 8 core CPU’s at € 19,500
- 2 Oracle Database Standard Edition One licenses at € 11,200
- 4 Dbvisit Replicate XTD at € 16,180
With this installation you add another € 50 k. of licensing in stead of € 100 k. with the Standard Edition migration. With this choice, you separate your time-critical data-entry process from the query environment, making sure a mis-fired query will not influence the availability of your data-entry process environment, which is a cool extra advantage!
* All prices are based on list-prices, excluding VAT and including 1 year of support.
** Based on the Oracle Processor Core Factor Table.