Oracle

Oracle

Oracle is the world’s most popular database in enterprise market. It’s designed for true distributed computing and handles the most complex and demanding needs.

We support Oracle directly in our products! You don't need separate drivers and can immediately connect to your database (with or even without OCI).

Original Oracle database was created by Software Development Laboratories consultancy in 1977. Bob Miner was the lead engineer in the early days, programming the majority of Oracle version 3 by himself. Oracle was the first database to take advantage of relational algebra and theory of relational databases described by IBM’s Edgar F. Codd. As IBM was slow to realize Codd idea’s potential, small SDL was able to come to market with its relational SQL database product before IBM. SDL changed name to Oracle Systems Corporation in 1982, then in 1995 it became Oracle Corporation.

Oracle introduced a lot of firsts in the database world. In 1985 Oracle 5 worked in now-standard client/server mode. In 1988 PL/SQL was introduced, Oracle’s extension to standard SQL query language. Starting with Oracle 8i, Oracle supports web-scale and Internet technology. Today Oracle provides large database clusters, in-memory databases, data warehousing, business intelligence, distributed key/value NoSQL database and cloud services. Oracle acquired Sun Corporation and with it MySQL database, much to the chagrin of MySQL author who in turn left MySQL AB corporation and spun off MariaDB project, compatible with MySQL, but fully open-source.

Main Oracle competitor is Microsoft SQL Server.

All our products support Oracle database directly.

Export your Oracle database

It may make sense to migrate your data away from Oracle. You may want to do it permanently or just need to share your tables with a collague in a different format.

We will copy all your tables with their data and apply indexing and relationships exactly as they are in your current Oracle database. In a nutshell, you get exactly the same database in another database engine. Each time you run the migration, we will copy all the tables again. Of course, we have a built-in scheduler, so you can run this overnight and have a fresh database copy in the morning.

Take a look at the quick tutorials below to see how it's done.

© 2020 Spectral Core Ltd. All rights reserved.