Hi,

Is there any guidelines for building a simple database consisting of
rows which can support
basic sql select statements,

I want some thing like
createTableAPI(xx,xx,xxx) ---->Create a schema in BDB
select(xxx,xxx,xxx)------>based on fileds specified.

For doing above stuff, how to organize the table data so that the
search is very fast.
Brute force way is to duplicate the records based on the keys indexed.

Appreciate if any one can give some direction.

regards
ragha