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 > > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
