Multimedia Database

Multimedia database is the collection of interrelated multimedia data that includes text, graphics (sketches, drawings), images, animations, video, audio etc and have vast amounts of multisource multimedia data. The framework that manages different types of multimedia data which can be stored, delivered and utilized in different ways is...

Continue reading

Oracle Database Clusters

• 
• 

PrevNext

Overview of ClustersClusters are an optional method of storing table data. A cluster is a group of tables that share the same data blocks because they share common columns and are often used together. For example, the employees and departments table share the department_id column. When you cluster...

Continue reading

How to insert an image in to Oracle database using Java program?

• 
• 

PrevNext

To hold an image in Oracle database generally blob type is used. Therefore, make sure that you have a table created with a blob datatype as:Name Null? Type----------------------------------------- -------- ----------------------------NAME VARCHAR2(255)IMAGE BLOBTo insert an image in to Oracle database, follow the steps given below:Step 1: Connect to the...

Continue reading

Oracle Database client libraries for Java now on Maven Central

Oracle has published its Oracle Database JDBC client libraries on Maven Central. From now on you can find Oracle Database related jar files under the com.oracle.database group id. You will find all libraries from version 11.2.0.4 (e.g. ojdbc6) to 19.3.0 (e.g. ojdbc10). Going forward, Oracle will use Maven...

Continue reading

Persistent Memory Primer

• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 

PrevNext

The introduction of Persistent Memory (PMEM) marks the beginning of a revolution in the computing industry. There has always been a separation between system memory where the contents are ephemeral and byte addressable, and storage where the data is persistent and block oriented. Persistent Memory (such as Intel...

Continue reading

File Handling From PL/SQL

Using a Java stored procedure it is possible to manipulate operating system files from PL/SQL. ◉ Create the Java Stored Procedure First we need to create the Java class to perform all file manipulation using the Java File Class. CREATE OR REPLACE AND COMPILE JAVA SOURCE NAMED "FileHandler"...

Continue reading

PDB Point-in-Time Recovery and Flashback in Oracle 20c

The most significant point about the Oracle 20c database architecture is that non-CDB Oracle Database upgrades to non-CDB architecture are desupported. Meaning you need a container database in 20c and your data will reside within a pluggable database. But then how about if you need to restore one...

Continue reading

A Look at the Oracle Group-by Bug

• 
• 

PrevNext

Oracle introduced a new feature, group by elimination, for queries where the group by column is also the table's unique key. As with many new features this one still has not had all the kinks resolved. The problem arises when key values are manipulated with function calls. The...

Continue reading

Oracle Database 20c Automatic In-Memory Enhancements

In Oracle Database 20c the Database In-Memory feature Automatic In-Memory (AIM) has been significantly enhanced. I wrote about AIM when it first came out in Oracle Database 18c here. Oracle Database 20c adds a new HIGH option to the INMEMORY_AUTOMATIC_LEVEL initialization parameter. With this setting all objects that...

Continue reading

What is a Converged Database?

• 
• 
• 

PrevNext

As a database administrator or manager, you may have had one or more of these conversations with your application teams? We need to build a new mobile app so customers can submit and retrieve documents, so I’m going to need a specialized database to store the documents, right?...

Continue reading

Oracle Database 20c Preview

• 
• 
• 

PrevNext

Innovations in Oracle Database In this blog entry we'll take a look at some of the new features inside Oracle Database 20c which has just been refreshed to version 20.3 on the Oracle Cloud's DBCS platform. Oracle Database 20c is the next release of Oracle's multi-model database. Like...

Continue reading