Wednesday, October 29, 2008

Java DB Table Functions

A very nice white paper on a new Java DB feature - table functions. This feature allows you to take any external data source (csv file, a telemetry stream, XML, JSON, in-memory objects) that can be represented as tabular results and make it look like a table in Java DB.

Then you can do anything read-only with it that you would do with regular tables: filter with WHERE clause, subqueries, aggregation, join with other tables, etc. Pretty darn nice.

No comments: