Use Cases

S3 Migration

AsterionDB recently participated in a conference call with a potential Oracle Cloud migration customer.   The customer has built a custom application implemented on a RAC cluster.  They also store images taken by IOT devices within a MongoDB application.  Our initial conversation focused on the feasibility of migrating the images out of MongoDB and into AsterionDB/Oracle.  A POC project has been proposed.

Cloud Migration

The aforementioned potential customer presents an illustrative use-case that is relevant to cloud migration.  The customer has, on premises, a RAC installation of Oracle and a sharded implementation of MongoDB using commodity hardware.  They are reluctant to embrace cloud computing.  Doing so would require the migration of both systems or in the alternative, a network link back to the on premises MongoDB installation.

The customer is now expressing interest driven by the fact that all assets can be combined in Oracle.

Digital Asset Management

Digital Asset Management can be thought of in broad terms where AsterionDB/Oracle is employed to replace an organization’s over reliance upon file-system methods and structures to manage assets.  Here are some examples:

  • I-node contention and content access latency when too many assets are stored within the legacy file system.  The database, with it’s ability to manage millions of rows, is a more robust architecture to store and provide efficient access to digital assets.
  • Limited content meta-data capabilities restricted by the unsophisticated, two-dimensional hierarchical nature of the file system.  In this instance, organizations frequently use symbolic links or may have to store an object in two places in order to properly describe it’s use and relevance.  In comparison, AsterionDB provides a dynamic keyword/tagging mechanism that can adapt to many meta-data description requirements.
  • Hard association between the meta-data describing how a file is stored (the file name and path) and the physical location on disk.  In comparison, AsterionDB utilizes an immutable object-id that is used for direct access while still providing dynamic access via the advanced keyword/tagging capabilities.

There are many instances where the lightweight capabilities of AsterionDB are more preferable to a fully featured ECM system.

Unifying Fabric

AsterionDB turns the DB into a virtual file system and provides a modern interface to share unstructured data.  While it is possible to store unstructured content within an application’s schema, that forces to much ‘awareness’ in other applications.  Collaborative applications have to know how the schema is laid out and how to access the content.

In contrast, AsterionDB allows applications to describe and thus access content in the manner best suited for its needs.

In addition, the ‘black box’ capabilities of AsterionDB allow non-Oracle based applications to access content owned and managed by Oracle based systems.

Security, Audit, Compliance

As discussed, AsterionDB provides a centralized environment for security, audit and regulatory compliance activities.  AsterionDB can eliminate and render redundant these issues for digital assets that are managed outside of the database.  We provide granular security to all data as defined by audited and secure SQL statements.

Data Type Intelligence

One of the opportunities we are exploring requires the integration of OCR capabilities.  AsterionDB is a unique platform that not only stores image and meta-data in the same environment but we are also able add intelligence and directly integrate OCR capabilities at the data-layer.  This is an example of enhancing the database’s intelligence so that it can understand ‘unstructured’ data.

We have completed an initial POC implementation and can demonstrate integrated OCR capabilities.  Here is an example:

(cleaned up for presentation….)

select  tesseract.process_image(‘/blahblahblah.png’)
  from  dual;



PO BOX 4045
SACRAMENTO CA 95812-9925

Data Layer Intelligence

Another unique capability, related to data type intelligence, is enhanced data-layer intelligence.  This is actually central to AsterionDB’s approach.  Simply put, if all of your data is in the database, you want all of your logic there too. 

AsterionDB’s technology makes it easy to incorporate logic in the database that formerly had to be expressed in the middle-tier.  An example is integration to Google’s Oauth server.  Over the last week we implemented a solution that enables the sending of emails from logic in the database using Gmail.  This required compliance to the authorization, access and refresh mechanisms used by Oauth in order to send emails via SMTP.

There are many other instances where it will be desirable to migrate logic from the middle tier to the data-layer.  This results in an ultra-slim middle-tier architecture that easily adapts to dynamic operational user requirements.