Vectorial Database In Memory

No need to worry about going "off topic" here
Forum rules
This forum is for general chit-chat, not necessarily APL-related. However, it's not for spam or for offensive or illegal comments.

Vectorial Database In Memory

Postby andriambololona on Mon Feb 25, 2013 10:58 am

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
andriambololona
 
Posts: 6
Joined: Tue Jun 15, 2010 10:06 am

Re: Vectorial Database In Memory

Postby StephenTaylor on Tue Feb 26, 2013 11:57 am

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
User avatar
StephenTaylor
 
Posts: 31
Joined: Thu May 28, 2009 8:20 am

Re: Vectorial Database In Memory

Postby paulmansour on Tue Feb 26, 2013 1:11 pm

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.
paulmansour
 
Posts: 282
Joined: Fri Oct 03, 2008 4:14 pm

Re: Vectorial Database In Memory

Postby andriambololona on Tue Feb 26, 2013 1:44 pm

Thank you Stephen. Now everything is clear. Besides I would like knowing where in Dyalog APL, I can find FlipDB? Is a tutorial available?
andriambololona
 
Posts: 6
Joined: Tue Jun 15, 2010 10:06 am

Re: Vectorial Database In Memory

Postby paulmansour on Thu Feb 28, 2013 7:55 pm

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
paulmansour
 
Posts: 282
Joined: Fri Oct 03, 2008 4:14 pm


Return to Chat

Who is online

Users browsing this forum: No registered users and 1 guest