2 Serge Rielau: please, repost bitwise ops implementation (udfbit)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Konstantin Andreev - 26 May 2006 12:12 GMT

Hello, Serge.

A while ago

SR> Subject: Re: poor query performance
SR> Date: Thu, 08 Sep 2005 06:31:52 -0400
SR> Message-ID: <3oaiamF50mntU1@individual.net>

you have posted here your implementation of the bitwise operations
functions. For BIGINT case the both declarations and implementations
present, but VARCHAR case missed implementation (Bit_AndVc, Bit_OrVc
and so on). Could you post your VARCHAR bitwise functions'
implementation ?

Thank you in advance.
--
Konstantin Andreev.

Reply to this Message

Serge Rielau - 26 May 2006 14:41 GMT

> Hello, Serge.
>
[quoted text clipped - 9 lines]
> and so on). Could you post your VARCHAR bitwise functions'
> implementation ?

I'd have to code them up myself.... Is it that hard to adapt?

Cheers
Serge

Signature

Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

Reply to this Message

Konstantin Andreev - 26 May 2006 17:14 GMT

SR> > Could you post your VARCHAR bitwise functions' (Bit_AndVc,
Bit_OrVc) implementation ?
SR> >
SR> I'd have to code them up myself....
Don't it :)

SR> Is it that hard to adapt?
Definitely no. I was just thinking you already have this
implementation.
Thank you.
--
Konstantin Andreev.

Reply to this Message

Serge Rielau - 26 May 2006 17:46 GMT

> SR> > Could you post your VARCHAR bitwise functions' (Bit_AndVc,
> Bit_OrVc) implementation ?
[quoted text clipped - 5 lines]
> Definitely no. I was just thinking you already have this
> implementation.

Post them when you have them. :-)

Signature

Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

Reply to this Message

--CELKO-- - 28 May 2006 13:26 GMT

>> you have posted here your implementation of the bitwise operations functions.\<<

A better question is why are you doing BIT operations in SQL? This
language was never meant to be used as a replacement for Assembly
Language and doing this low-level work in it is a sign of very, very
poor DDL and programming.

Reply to this Message

Serge Rielau - 28 May 2006 20:20 GMT

>>> you have posted here your implementation of the bitwise operations functions.\<<
>
> A better question is why are you doing BIT operations in SQL? This
> language was never meant to be used as a replacement for Assembly
> Language and doing this low-level work in it is a sign of very, very
> poor DDL and programming.

or a sign of a missing boolean data type.
When I think of some warehouses with lots of binary properties in the
row, I see no harm...

Cheers
Serge

Signature

Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

Reply to this Message

--CELKO-- - 29 May 2006 23:33 GMT

>> When I think of some warehouses with lots of binary properties in the row, I see no harm... <<

And I see the need for a status code to replace "a bit vector" of
assorted related attributes that have be split out of a single
attribute.

Reply to this Message

Serge Rielau - 30 May 2006 11:41 GMT

>>> When I think of some warehouses with lots of binary properties in the row, I see no harm... <<
>
> And I see the need for a status code to replace "a bit vector" of
> assorted related attributes that have be split out of a single
> attribute.

How are:
"Owns house" (Y/N), "Gender" (M/F), etc, etc related?
Joe I see your point that technology can and is abused. But you appear
to be unwilling to accept that not everyone is an idiot.

Cheers
Serge

Signature

Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

Reply to this Message

--CELKO-- - 31 May 2006 11:58 GMT

>> How are: "Owns house" (Y/N), "Gender" (M/F), etc, etc related? <<

Those are not, but you will see gender and pregnant flags which need to
have a constraint to be sure that you do not get a pregnant male. But
nobody bothers to write the constaint.

My favorite was yes/no questions -- the most binary of all -- that also
needs to have "n/a", "not answered", "yes implied by previous answers",
"no implied by previous answers" for a survey DB model.

Reply to this Message