AsterionDB is a horizontally aligned technology. AsterionDB can be used as the basis for a wide variety of solutions. Here is a partial list of things ‘we can do’ with AsterionDB.

DICOM – Medical Imaging

Digital Imaging and Communications in Medicine (DICOM) is the standard for the communication and management of medical imaging information and related data. DICOM support has been dropped from the Oracle database since version 18.

AsterionDB can provide a drop-in replacement for Oracle DICOM. We do this by extending the logical capability of the database. With AsterionDB, we can incorporate any number of DICOM SDKs or library. This broad capability allows AsterionDB to support existing Oracle DICOM users and also attract other DICOM users that may be interested in migrating to the Oracle database.

As with all of AsterionDB’s solutions, our DICOM support is available for both cloud and on-premises use.

SMTP Email Support

Sending Emails from PL/SQL code in the database can be a cumbersome and difficult – both for cloud and on-premises installations. AsterionDB provides a drop-in for UTL_SMTP allowing you to send Email from PL/SQL code in the database. Our solution works equally well in both on-premises and cloud based installations.

AsterionDB supports Google Gmail. Other SMTP services can be supported as well.

Google OAuth Integration

Google’s OAuth service was integrated into AsterionDB in order to enable SMTP support. The mechanisms implemented in AsterionDB can also be leveraged by your applications

Optical Character Recognition

AsterionDB can integrate OCR capabilities implemented by the open-source Tesseract OCR project. This allows programmers to integrate OCR functions directly into PL/SQL and SQL statements. Here is an example:

select  tesseract.process_image(image_data)
  from  image_files;

Metadata Extraction

AsterionDB provides support for FFMpeg. FFMpeg is an open-source multimedia toolkit. With FFMpeg, we can extract metadata information from media files.

Other metadata extraction mechanisms and libraries can be incorporated into AsterionDB. This allows the database to ‘know something’ about the unstructured data. Interacting with these ‘plugins’ is as simple as making a PL/SQL call.

The metadata can be incorporated directly into columns in the tables that hold the unstructured data. This greatly simplifies querying and indexing.

The metadata can also be accessed directly from SQL as this example shows:

select  ffprobe.get_audio_coded(audio_data)
  from  audio_files;