Thank you very much Sanjit. I got the answer of my first point. But the answer of the 2nd point is still unclear to me. Here I had asked to search on employeename instead of ID.
Name can repeat in many rows. So how can we create the name as rowkey? Do we need to take the distinct of the employee name and insert in this EmployeeName table? In the EmployeeName table, the value should be the rowkey of employee table (means EmployeeId). There can be many employees with different IDs and with same names. So in the value, do we need to store the EmployeeId in comma seperated or what else? Regards, Sachin On Jun 3, 9:50 pm, Sanjit Jhala <[email protected]> wrote: > Responses inline below. > > -Sanjit > On Jun 3, 2009, at 6:10 AM, Sachin wrote: > > > > > > > > > Hi, > > > One of my team mate Sanyama raised few queries in this group. I wanted > > to raise few more queries regarding this. > > > First of all, I am MS SQL Server developer and unfortunately think > > according to that. We are using C#.net as a development language. > > > Searching through net, we are highly impressed with Hybertable and so > > want to use this (instead of SQL Server) in our new project in which > > massive search operations are there. > > > Before starting the project we are studying hypertable and would like > > to know how the following things can be achieved: > > > 1. Joining the tables - In hypertable joining of the tables is not > > there. So do we require to get the data from more than one table and > > do the joining in frond end (C#) code? > > Doing the join on the front end might not be very efficient depending > on the volume of data returned by your queries. The general idea is to > design around the lack of "join" functionality by denormalizing your > data. Another option could be using a map-reduce system to do joins > over large datasets although this is an offline solution. > > > > > 2. Searching on non-key fields - Suppose I have employee table which > > have 2 columns: EmployeeId and EmployeeName, and want to search based > > on employee name such as "Show me all employees whose name is Sachin > > or all employees in which Sachin exists in EmployeeName". How can we > > achieve this? > > You could create a separate table with the EmployeeName in the rowkey > and the value would be the rowkey(s) of the Employee table. This table > is basically an index you create. However, Hypertable does not provide > transactions across tables, so the application code needs to be > designed to handle potential inconsistency. > > > > > Eager to get response on the above queries. > > > Regards, > > Sachin- Hide quoted text - > > - Show quoted text -- Hide quoted text - > > - Show quoted text - --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Hypertable Development" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/hypertable-dev?hl=en -~----------~----~----~----~------~----~------~--~---
