Inline. Sent from my iPhone
On Aug 30, 2011, at 2:15 AM, Sonal Goyal <[email protected]> wrote: This part I understand. And in essence the would be a key for each product a grocer sells, yes? > How about a table which has <product code><grocerCode> as the key, and > column family items with qualifier quantity. I'm not sure what you mean here. > You can have other column > families like grocer(columns name etc) Then you can scan for productCode and > return those grocers whose items:quantiy > 0. > You mean use the productCode as the key and the value would depend on the integer of the column and those matching >0 are returned as valid (the value) and delivered to the UI? > Best Regards, > Sonal > Crux: Reporting for HBase <https://github.com/sonalgoyal/crux> > Nube Technologies <http://www.nubetech.co> > > <http://in.linkedin.com/in/sonalgoyal> > > > > > > On Tue, Aug 30, 2011 at 12:27 PM, high pointe <[email protected]>wrote: > >> Thanks for the response Sonal. Here is an example. >> >> The client (backend) is online grocers. The front end client is shoppers / >> consumers. >> >> The grocers have an interface that they can log into and enter their >> inventory. Example: Apple = 9 >> >> The front end is simple; two values the users enter: >> >> Product: Apples >> Delivers to zip code: 90210 >> >> Once the query is submitted, the search results will display all the >> grocers >> that deliver apples to the users area code. >> >> Whenever a grocer's supply (for any product) decreases to zero, they need >> to >> be dropped our of the results. We do not want grocers showing quantity >> zero. We only want grocers with a supply on hand. >> >> Now... Should the grocer that was dropped out because of a 0 value get a >> shipment and now have product on hand, once they enter the amount of their >> product, the non zero value should trigger the Db / search to include the >> grocer in the search again. >> >> How would I go about doing this without have multiple tables for the same >> grocer or constantly re-indexing? >> >> Am I going at this the wrong way completely? >> >> Thanks again for the response and for and suggestions. >> >> H-p >> >> >> >> As orders come through for apples and the number decreases, one it hits 0, >> the clients >> >> >> >> >> On Tue, Aug 30, 2011 at 12:35 AM, Sonal Goyal <[email protected]> >> wrote: >> >>> Hi, >>> >>> Can you please give an example or explain in more detail what you are >>> trying >>> to achieve. >>> >>> Best Regards, >>> Sonal >>> Crux: Reporting for HBase <https://github.com/sonalgoyal/crux> >>> Nube Technologies <http://www.nubetech.co> >>> >>> <http://in.linkedin.com/in/sonalgoyal> >>> >>> >>> >>> >>> >>> On Tue, Aug 30, 2011 at 11:59 AM, highpointe <[email protected]> >>> wrote: >>> >>>> We are attempting to build what is akin to a CRM (but not). >>>> >>>> Our backend is an interface in which clients can control the variables >> of >>>> their assets offering; the variables of the template they use act as >> the >>>> over call on the Db. >>>> >>>> Within the UI, they have the ability to set thresholds for variables >>> (once >>>> reached the variable is ejected and in essence a completely new >> template >>> is >>>> created). >>>> >>>> The variables can change rapidly throughout the day so speed on updates >>> and >>>> being able to always have the latest template data sets on the front >> end >>> (as >>>> simple search engine) is a priority. >>>> >>>> I have gone through numerous schema in my head but cannot seem to >> figure >>>> our the automating of the process of expiring data and introducing new >>>> variables on the fly without a complete reindex of the table. >>>> >>>> Any help with architecture ideas would be greatly greatly appreciated. >>>> >>>> Cheers. >>>> >>>> H-p >>>> >>>> >>>> >>>> >>>> Sent from my iPhone >>>> >>> >>
