Oracle

Oracle
Database background

Oracle is the world’s most popular database in the enterprise market. It is designed for true distributed computing and is capable of handling complex and demanding workloads.

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).

The original Oracle database was created by the Software Development Laboratories consultancy in 1977. Bob Miner was the lead engineer in the early days and programmed the majority of Oracle version 3 himself. Oracle was the first database to fully take advantage of relational algebra and the theory of relational databases described by IBM’s Edgar F. Codd.

As IBM was slow to commercialize Codd’s ideas, the smaller SDL company was able to bring a relational SQL database product to market before IBM. In 1982 the company changed its name to Oracle Systems Corporation, and in 1995 it became Oracle Corporation.

Oracle introduced many innovations in the database industry. In 1985 Oracle version 5 supported the now standard client/server architecture. In 1988 PL/SQL was introduced as Oracle’s procedural extension to the SQL query language.

Starting with Oracle 8i, the database added support for web-scale and Internet technologies. Today Oracle offers a wide range of data solutions including large database clusters, in-memory databases, data warehousing systems, business intelligence tools, distributed key/value NoSQL databases, and cloud services.

Oracle also acquired Sun Microsystems, which included ownership of the MySQL database. This acquisition led to controversy among MySQL’s original developers, one of whom left and created the MariaDB project as a fully open-source fork compatible with MySQL.

Oracle’s primary competitor in the enterprise database market is Microsoft SQL Server.

Oracle data types we support

DECIMAL:
binary_doublebinary_floatfloat (real)number (integer, int, smallint, numeric, dec, decimal)
TEXT:
charclobncharnclobnvarchar2varchar2
DATE/TIME:
datetimestamp
LARGE OBJECTS:
blobclobnclobsdo_geometryxmltype
OTHER:
anydataarraybfileinterval day to second (interval day)interval year to month (interval year)longlong rawrawrowidurowid