Thanks very much, that's fantastic, will give it a try as soon as I can. Regards, Mike
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of K. John Wu Sent: Saturday, July 02, 2011 9:09 AM To: FastBit Users Subject: Re: [FastBit-users] creating in-memory tables Hi, Mike and Tobias, I have just checked in SVN revision 424 with a new function in ibis::tablex class, ibis::tablex::toTable to convert an tablex object to a table object. There is a small example of using this in examples/ardea.cpp. Please give it a try and let me know if you have any comment or suggestions. John PS: You can check out the latest SVN revision with svn checkout https://codeforge.lbl.gov/anonscm/fastbit If you have a copy of code checked out of SVN previous, you simply need to do svn update On 6/17/11 12:10 AM, emsfeld wrote: > 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
