Is there a way to communicate DBMS with raw memory block or binaries
        Posted  
        
            by 
                darkcminor
            
        on Server Fault
        
        See other posts from Server Fault
        
            or by darkcminor
        
        
        
        Published on 2011-03-18T06:35:35Z
        Indexed on 
            2011/03/18
            8:11 UTC
        
        
        Read the original article
        Hit count: 394
        
I am trying to communicate a numerical matrix operations library like LAPACK with any DBMS.
Is it possible to send/receive complete matrices as binary or as a direct memory pointers to process them (it will be something like: The Outside library processes data stored in DBMS, then it computes some huge matrix stuff and then via memory block or a binary DBMS get the result from library)? 
The main purpose is speed and avoid passing through a flat file, and last but not least, use library toefficiently do some operations DBMS are not designed to.
* Is it possible that Oracle, SQL Server, MySQL support this technique?.
        © Server Fault or respective owner