© 2017 by Asterion DB Inc.

  • Grey Twitter Icon
  • Grey Facebook Icon

May 18, 2017

September 23, 2016

Please reload

Recent Posts

DB Streamer: New Patent Granted!

August 26, 2017

Please reload

Featured Posts

Asterion dbVault: "Drop and Forget"

May 20, 2016

We had a client this week that needed greater security in his document sharing system and wanted a "drop and forget" solution. We customized our software to address his needs with minimal disruption to his system while dramatically increasing security. CTO Steve Guilford configured our Asterion dbVault software to run the entire document system within an Oracle database thereby enabling a host of workflow and security advantages. 




One of the challenges was to be able to ingest a wide range of file types and sizes. No problem. 


So far we are providing code and data structure templates for over 40 different types of files - 160+ file extensions and mime-types !!!


The user can choose which file types can be allowed and if they want to add additional types. At the same time, each file's meta data can be automatically extracted!  


For you tech savvy types, here's a partial list -- 



DESCRIPTION                                                  DATA_COLUMN_TYPE 

------------------------------------------------------------ ------------------ 

AAC format-compliant audio files                            DBSTREAMER_AUDIO_T 

AIFF format-compliant audio files                            DBSTREAMER_AUDIO_T 

Adobe Acrobat format-compliant files                      BLOB 

Adobe Flash format-compliant video files                DBSTREAMER_VIDEO_T 

Adobe Photoshop format-compliant files                 BLOB 

Apple M4V format-compliant video files                   DBSTREAMER_VIDEO_T 

Apple Quicktime format-compliant files                    DBSTREAMER_VIDEO_T 

Archive/Compressed files                                        BLOB 

Audio Files (metagroup)                                           DBSTREAMER_AUDIO_T 

Autodesk/Autocad format-compliant files                 BLOB 

BMP format-compliant image files                            ORDIMAGE 


DESCRIPTION                                                  DATA_COLUMN_TYPE 

------------------------------------------------------------ ------------------ 

Document (MSWord, OpenDoc) format-compliant files   BLOB 

Doom WAD files                                                         BLOB 

Excel Spreadsheet Files                                             BLOB 

FLAC format-compliant compressed audio files         DBSTREAMER_AUDIO_T 

GIF format-compliant image files                                ORDIMAGE 

H26x variant format-compliant video files                   DBSTREAMER_VIDEO_T 

ISO-9660 format-compliant image files                       BLOB 

Image files of various formats (metagroup)                ORDIMAGE 

Intuit QuickBooks files                                                BLOB 

JPEG Compliant Images                                            ORDIMAGE 

MP4 format-compliant audio files                               DBSTREAMER_AUDIO_T 


DESCRIPTION                                                  DATA_COLUMN_TYPE 

------------------------------------------------------------ ------------------ 

MP4 format-compliant video files                             DBSTREAMER_VIDEO_T 

MPEG format-compliant compressed audio files     DBSTREAMER_AUDIO_T 

MPEG format-compliant compressed video files     DBSTREAMER_VIDEO_T 

Matroska format-compliant video files                      DBSTREAMER_VIDEO_T 

Media Exchange Format compliant archives            BLOB 

Microsoft (proprietary) format-compliant video files  DBSTREAMER_VIDEO_T 

Microsoft Powerpoint Files                                       BLOB 

Ogg format-compliant audio files                             DBSTREAMER_AUDIO_T 

Ogg format-compliant video files                             DBSTREAMER_VIDEO_T 

Open Format (non-proprietary) files                        BLOB 

PGP files                                                                  CLOB 


DESCRIPTION                                                  DATA_COLUMN_TYPE 

------------------------------------------------------------ ------------------ 

PKCS files                                                               CLOB 

PNG format-compliant image files                           ORDIMAGE 

Quark files                                                                BLOB 

SVG format-compliant image files                            ORDIMAGE 

TIFF format-compliant image files                            ORDIMAGE 

Text (generic) files                                                    CLOB 

Video files (metagroup)                                            DBSTREAMER_VIDEO_T 

Visio format-compliant files                                      BLOB 

WAVE format-compliant compressed audio files     DBSTREAMER_AUDIO_T 

WebM format-compliant video files                          DBSTREAMER_VIDEO_T 

XML files                                                                  CLOB


Share on Facebook
Share on Twitter
Please reload

Follow Us

I'm busy working on my blog posts. Watch this space!

Please reload

Search By Tags
Please reload

  • Facebook Basic Square
  • Twitter Basic Square
  • Google+ Basic Square