• André Wagener

5 things you probably didn't know about Oracle Database

The field of enterprise software development is transforming from the database tier to the application tier. The main reason for such a change is the need for portable devices, software, and applications. Every business is now looking for options that enable modern applications to work efficiently on different operating systems, mobile devices, and desktop. Also, to support interfaces with various upstream and downstream systems and to connect with multiple databases.

Java is undoubtedly the most portable programming language but the concept of database is not recent. The databases have been modified and adopted as per the needs of enterprise architecture with many latest features. Similarly, Oracle Database has been transformed over the years with useful real life application features to perform practical tasks that can impact daily operations. The following five features are the most prominent and meaningful.

XML In Database

To build XML reports based on complex structures, developers prefer Java and XPath. XML is part of the Oracle database since 8i and 11g versions that fully support an integral part of databases and are also in compliance with W3C standards. It allows developers to create and store XMLType data in tables and use SQL syntax to convert text to DOM and vice versa. The database can also store XSD schema for validation. An XML DB repository can be created inside the database, transferring XML files through protocols such as HTTP, FTP, or WebDav.

Microsoft Active Directory

Oracle Database 18c allows authorized users to integrate with Microsoft’s Active Directory without any intermediate directories. Before this version of Oracle DB, to achieve integration, an intermediary software was required, such as Oracle Enterprise User Security. This new feature is called Centrally Managed Users (CMU) and allows users to manage and access Active Directory through Oracle Database.

Communication Via HTTP(s)

Oracle Database supports PL/SQL languages, which make sending and receiving data by HTTP protocol much simpler. UTL_HTTP package supplied by Oracle allows users to create robust data demanding interfaces between databases. An HTTP session is formed by creating a BEGIN_REQUEST function, allowing multiple configuration sets including authentication, headers, and cookies support. The WRITE_TEXT function allows users to push text into the HTTP request body and READ_TEXT allows the user to read the data responses of HTTP.

Automatic In-Memory

Oracle introduced In-Memory in version 12c to expedite performance by storing database segments that are columnar-compressed into memory. Oracle developed In-Memory by creating Automatic In-Memory (AIM), which works to build a heat map of the in-memory that allows objects to have a room that can be accessed more frequently.

SQL Cancel

In previous versions, when Oracle was required to cancel the SQL query, the ongoing session running SQL had to be killed. It was necessary to remove the session from the database and a new connection was needed to be initiated. With Oracle 18c, this problem is resolved, as now the SQL statement can cancel and rollback itself.

Like this information? Follow our blog and LinkedIn pages for more!