Plugins and Extensions
LucidDB is an extraordinarily flexible and extensible BI database. For the the LucidDB user, this means you can:
Download and install cool plugins easilyThe LucidDB community is able to pump out lots of cool stuff easily because our extensions are written in Java and require ZERO platform specific building, debugging and testing. It’s also very easy for us to write cool new extensions because there exists vast and extensive libraries of functionality, typically in Open Source in Java.
Write your own pluginsWant to write reports against your mainframe, and also your Salesforce.com data? You’d be hamstrung to get BI tools to connect and collect/join data from these systems. How about a custom Java method calculation that you’ve spent hundreds of man hours QA’ing and testing to know it produces the correct result? You can plug your own stuff into LucidDB extending it to make it do EXACTLY what you want it to do. No other analytic database provides such an easy to use, accessible, Java based extension system!
Installing plugins is exceptionally easy! A simple command loads your new routines and they’re immediately ready for use:
CREATE JAR udf_jar LIBRARY ‘my-custom-functions.jar’
Extension Points:
User Defined Functions (UDF) in Java and also (SQL)
You can write your own, scalar functions.
You can write your own, scalar functions.
SELECT MY_FUNCTION(X,Y) FROM MY_TABLE WHERE MY_OTHER_FUNCTION(A,B) > 100
User Defined Table Functions (UDX)
You can write your own table functions, which can both read and output ROWs of data.
You can write your own table functions, which can both read and output ROWs of data.
SELECT * FROM TABLE( MY_FUNCTION_WHICH_PRODUCES_ROWS(‘INPUT_DATA’)
User Defined Procedures (UDP)
You can write your procedures that can be executed and run inside of LucidDB.
You can write your procedures that can be executed and run inside of LucidDB.
CALL PROCESS_FILES_EXTERNALLY(‘/directory’)
Connectors (SQL/MED data wrappers)
You can present your foreign data source, such as mainframe or your applications web service APIs as tables and columns.
You can present your foreign data source, such as mainframe or your applications web service APIs as tables and columns.
SELECT COL1 FROM MAINFRAME_TABLE1
Advanced Extension Points (Catalog objects, etc)
You can write your own catalog objects, and expose them in the data dictionary. OEM partners can add objects to the database that walk, talk and jive like other first class objects in our catalog.
You can write your own catalog objects, and expose them in the data dictionary. OEM partners can add objects to the database that walk, talk and jive like other first class objects in our catalog.
