can I query raw bits using bit logic in a huge RS database?

[Ruslan Zasukhin]

On 6/10/12 1:47 AM, "Kem Tekinay" <ktekinay at mactechnologies.com> wrote:

Hi Aaron,
Hi Kem,

Can you describe in more details your db parameters as you see that now.

* 3 billion records ... In single table?  Or this is total for e.g. 100
tables?

> I need to store variable-lengths of raw bits in a database, and query them

* What is expected size of this bits ?

* such query will go without index, so will not be very fast ...
 do you have any time limits on query ?

* what hardware you going to use for this db?
      RAID?  CPU? ...

* this will be single db in some office or you need install hundreds copies
of it worldwide?


> This page may help you:
> 
> http://www.sqlite.org/lang_expr.html#binaryops
> 
> I don't think you can do XOR with SQLite.
> 
> However, with that many records, you might be better off looking at something
> faster than SQLite, perhaps something like Valentina.
> 
> http://www.valentina-db.com/
> 
> If a faster database than Valentina exists anywhere, I'd like to hear about
> it...
> 
> 
> On Jun 9, 2012, at 5:13 PM, Aaron Andrew Hunt wrote:
> 
>> I need to store variable-lengths of raw bits in a database, and query them
>> using standard bit operations AND, OR, and especially XOR in the query. Can I
>> do that with RS and SQL queries?

>> Have been looking at the examples and reading the docs. Any advice and help
>> pointing me to other docs would be appreciated. So far I've discovered a BIT
>> VARYING datatype in SQL, but I don't see this in RS database classes.
>> 
>> Disclaimer: this is my first database project, so I've been searching through
>> all the forums and reading up best I can, but can't seem to find the answers
>> I  need; hence, I'm asking the experts here.


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]