Dyalog Forums

vectorial database in memory is currently spoken so much, especially with the BI tool called QLIKVIEW
Try to go to www.qlikview.com. Could we use a kind of database with APL? It looks like interesting
because all data are in memory. There is no longer access to disk. What do you think of this?
Now especially we can have many RAMS with 64 bits configuration

The tools preceded the cheap RAM that now makes RAM-based column-store databases popular.

A+ was an APL derivative implemented for Morgan Stanley and for many years used as a platform for real-time trading applications. Now open source:

http://www.aplusdev.org

These days the original author of A+ offers kdb+, now a market-leading ultrafast database sold through his Kx Systems Inc:

http://www.kx.com

The Carlisle Group offers FlipDB, a modern RDBMS implemented in Dyalog:

http://www.carlislegroup.com/products/flipdb

SJT

As Stephen notes, the in-memory column-store databases go way, way back, back at least to the 1970's. And there have been countless in-house APL implementations of these.

Oddly enough, with respect to FlipDB, while it is a column store, it is not an in-memory database. We only read in what we need, when we need it. For certain applications, the importance is really the column-store, not the in-memory part.

Thank you Stephen. Now everything is clear. Besides I would like knowing where in Dyalog APL, I can find FlipDB? Is a tutorial available?

If you want to know more about FlipDB, and get a copy play around with, feel free to email me directly at paul@carlislegroup.com.

Paul Mansour