Embedding database analytics as stored external procedures - Seguridad Mania.com - España y América Latina

Inside or outside, which is better? You know that embedding analytics in databases offer several benefits including security, performance, and enabling users to take advantage of the analytics more readily. But how do you do it? In this installment of our embedded analytics series we discuss embedding analytics using stored external procedures – an option provided by all major commercial RDBMS providers. These procedures are invoked in the same manner as internal stored SQL procedures but they run in a process space separate from that of the database itself. This separation can be advantageous in certain scenarios. In particular, if a data set is selected for analysis that pushes the limits of physical memory then the database is isolated from any issues that arise in running the analytics on this problematic data. In this webinar, you will see detailed steps on how to implement the analytics as a shared library using IMSL Libraries for C for illustration. If you missed part one of the series, watch the recording here: https://www.brighttalk.com/webcast/12285/164525