Content deleted Content added
Added History, Types sections; added new info to intro paragraph; split existing info into Uses, Vendors and Related Technologies |
|||
Line 20:
===Loading C or C++ Libraries into the database process space===
With C or C++ UDF libraries that run in process, the functions are typically registered as built-in functions within the database server and called like any other built-in function in a SQL statement. Running in process allows the function to have full access to the database server’s memory, parallelism and processing management capabilities. Because of this, the functions must be well-behaved so as not to negatively impact the database or the engine. This type of UDF gives the highest performance out of any method for OLAP, mathematical, statistical, univariate distributions and data mining algorithms. Vendors such as [http://www.FuzzyL.com Fuzzy Logix] (DBLytix) and RogueWave (IMSL) have pre-built libraries available. IBM Netezza, EMC Greenplum, Sybase and Teradata (AsterData) have the capability to do this type of in-database analytics. Some of these vendors allow customers to write their own custom in-process UDFs.
===Out-of-Process===
| |||