A temporary solution might be to just build a RAM disk out of a portion of your memory. Then you could write to the RAM disk with tablex and read from it using table to do your queries.
Cheers, Teryl On Fri, Jun 17, 2011 at 3:18 AM, <[email protected]> wrote: > John, > > Yes, I think that would be extremely useful feature. > > > Rds, > Mike > > ----- Original Message ----- > From: [email protected] < > [email protected]> > To: FastBit Users <[email protected]> > Sent: Fri Jun 17 08:10:02 2011 > Subject: Re: [FastBit-users] creating in-memory tables > > I'd be quite keen on having this functionality as well. Could you let us > know once you've implemented this, John? > > Thanks heaps. > Tobias > > On 16/06/11 12:53 AM, K. John Wu wrote: > > Hi, Mike, > > > > Thanks for your interest in FastBit. > > > > At this point, ibis::tablex has only functions that accept data, there > > is no function that can perform queries. Looks like you are looking > > to combine them. A simple thing for me to do might be to add a > > function to convert an existing ibis::tablex object into an > > ibis::table object. This will support the following scenario > > > > - Build an ibis::tablex object to receive the content from your Oracle > > query, > > - Convert the ibis::tablex object into an ibis::table object, > > - Query the ibis::table object > > > > Is this something useful enough? Any alternative suggestions? > > > > John > > > > PS: It might take a week or two before the propose function can be > > implemented. > > > > > > On 6/15/11 4:11 AM, [email protected] wrote: > >> Hi, > >> > >> I’ve only just downloaded fastbit: so please excuse the newbie > >> question .. I’d like to find out how feasible/thoughts on the following: > >> > >> I have a large Oracle db with star-schema, I query this and get back > >> result sets – On the client side as a cache, I’d like to create tablex > >> objects > >> > >> that hold the result sets and then build interface using query objects. > >> > >> Any potential problems with this? Can I create tables on-the-fly like > >> this? (i.e. don’t need to read them from a flat file). > >> > >> In essence on a powerful client, I can use fastbit to essentially > >> replace what would have been an OLAP Cube, Materialised View or less > >> efficient c-store than > >> > >> Fastbit. > >> > >> Rds, > >> > >> Mike > >> > >> _______________________________________________ > >> > >> This e-mail may contain information that is confidential, privileged > >> or otherwise protected from disclosure. If you are not an intended > >> recipient of this e-mail, do not duplicate or redistribute it by any > >> means. Please delete it and any attachments and notify the sender that > >> you have received it in error. Unless specifically indicated, this > >> e-mail is not an offer to buy or sell or a solicitation to buy or sell > >> any securities, investment products or other financial product or > >> service, an official confirmation of any transaction, or an official > >> statement of Barclays. Any views or opinions presented are solely > >> those of the author and do not necessarily represent those of > >> Barclays. This e-mail is subject to terms available at the following > >> link: www.barcap.com/emaildisclaimer > >> <http://www.barcap.com/emaildisclaimer>. By messaging with Barclays > >> you consent to the foregoing.Barclays Capital is the investment > >> banking division of Barclays Bank PLC, a company registered in England > >> (number 1026167) with its registered office at 1 Churchill Place, > >> London, E14 5HP.This email may relate to or be sent from other members > >> of the Barclays Group.// > >> > >> _______________________________________________ > >> > >> > >> > >> _______________________________________________ > >> FastBit-users mailing list > >> [email protected] > >> https://hpcrdm.lbl.gov/cgi-bin/mailman/listinfo/fastbit-users > > _______________________________________________ > > FastBit-users mailing list > > [email protected] > > https://hpcrdm.lbl.gov/cgi-bin/mailman/listinfo/fastbit-users > > > > > > _______________________________________________ > FastBit-users mailing list > [email protected] > https://hpcrdm.lbl.gov/cgi-bin/mailman/listinfo/fastbit-users > _______________________________________________ > FastBit-users mailing list > [email protected] > https://hpcrdm.lbl.gov/cgi-bin/mailman/listinfo/fastbit-users >
_______________________________________________ FastBit-users mailing list [email protected] https://hpcrdm.lbl.gov/cgi-bin/mailman/listinfo/fastbit-users
