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
