Splice Machine Alleviates the Headache of Migrating from Oracle
January 23, 2017
Big Data has exploded in recent years. As a result, many businesses have come to a crossroads: invest more to scale up their legacy Oracle system, or make the move to another RDBMS to be able to increase the functionality and capabilities of their business.
As one of the first relational database systems on the market, the Oracle RDBMS, has led the database industry for decades. Businesses built their entire IT system around the database and hired employees for their Oracle specializations, which furthered the Company’s hold on the industry and made it seem like a near impossible feat for businesses to switch databases. But over time, as Big Data has grown, Oracle has become cost prohibitive for many businesses.
There are four primary reasons to migrate Oracle-based applications to a scale-out architecture:
- To achieve scalability and elasticity
- The ability to configure the right amount of capacity to accommodate fluctuating workloads presents a number of opportunities for innovation
- To reduce costs
- Moving applications off of Oracle can also help reduce costs. This is particularly true for organizations that experience strong data growth, since organizations find that attempting to scale up with Oracle is cost-prohibitive
- To use open source tools to build big data apps
- By moving apps into an open source environment, organizations gain access to the enormous momentum and innovation of open source
- To embrace the new capabilities of data
- Machine learning and artificial intelligence offer increasingly compelling use cases. But machine learning libraries require data at scale, and Oracle makes keeping historical data cost prohibitive
This all sounds good in theory, but if businesses seeking these benefits could plausibly migrate from Oracle, why haven’t they already?
Because back when Oracle came about, businesses had to use this service if they were looking for an RDBMS. As time went on, these businesses invested heavily in both Oracle infrastructure and trained personnel. After investing so heavily into one company, it became difficult to justify a switch, especially when the alternative is not guaranteed to work. Due to the singularity of Oracle’s platform, many competitors through the years were not able to create a platform that directly supported the work being done in PL/SQL through Oracle’s platforms. With PL/SQL being such an old language, the systems must be semantically equivalent and have the same set of operations as the Oracle database to plausibly and successfully migrate applications. Otherwise, every line of PL/SQL must be re-written while being transferred. This creates a new set of headaches with additional system testing and debugging after the PL/SQL re-write.
With the launch of Splice Machine’s PL/SQL support, businesses can now move legacy applications off of Oracle, even if they have been unchanged for years, and can benefit from modern capabilities that are best delivered on a scale-out architecture. This new addition will reduce the migrating cost as well as increase overall savings by using a modern scale-out database. Users will also benefit from reduced ETL lag with Splice Machine’s support of both transactional and analytical workloads. Splice Machine is the only Hadoop-based solution to complete both the TPC-C (transactional) and TPC-H (analytical) test suites, and is the only database to demonstrate running both of these workloads concurrently, offering an architectural foundation for operational and analytical applications in a single platform.
The migration process from Oracle has historically been difficult, but Splice Machine has challenged the industry by offering a cost-effective alternative to Oracle with a simplified migration process. To learn more about the Oracle migration process, view our Oracle Offloading resources: CITO Research’s whitepaper and our webinar with Ovum’s Tony Baer.