I am looking at some DB2 performance-tuning notes where I am seeing a phrase
I've not seen before.  The notes speak of a test in a WHERE clause that
allows a row to be definitely exluded being a "Boolean Term".  The converse
is referred to a non-Boolean term.

I am reseaching into the best method for implementing a booking system
data structure. My booking system in full will be used to store
details on landlords apartments .. this part isnt too big an issue for
me as I can have a table called 'landlord' and a table called

I'm a bit studying join types and trying to make a visualisation of
relations among them. As a result I've created an ER diagram
describing relations among them and it can be found here
http://gplivna.blogspot.com/2008/01/sql-join-types-im-studying-bit-sql.html

I know how to suppress a normal tree but I meet the following kind of
situation :
r1
   -> b1

E-harmony.com  claims to match you with another across 29 dimensions. Well,
3 dimensions are still hard for me to think about. But in  with data
warehouses,  29 dimensions might make sense..

So impressed was I by mAsterdam's japanese 'reference' symbols, I
decided to add them to my list of useful unicode. Yes, I am indeed,
that cool, and hereby post said list partly as a google-group test,
and partly (perhaps) to assist in the more mathematical cdt

vldm10 wrote:

Actually, i have a need to store the numbers like "AS2303",
TS3381"(first 2 alphabets,next 3 numbers). What i want is, i have to
assign the integrity which can check the following values,
     23334, ASDER, SDE23, 233A4 and like this.

If you have a chance, please take a look on my website at this page:
http://www.sfdbs.com/toplevel/fasttrack/fasttrack.shtml
You will see a completely new way to use foreign keys
to represent relationships in relational databases.

Is there a good program to create ER diagrams for you? I know
DBVisuaziler can do it, but are there any other tools?
TIA

Always a physical issue. Never a theory issue.Agree?
Evan

I'd like to end the thread I started 1/1/08 ("Something new for the
New Year (2008)") and begin a new post that is not about RM or any
other specific data model, but rather, the real and perceived
differences between them. As a starting point, I recommend Codd's 1980

Is there a commercial RDBMS that allows one to create indices on
views?
I'm asking this partly because of BCNF.
A typical BCNF problem is (where -> is a FD)

Instead of hijacking another topic,  I'll start this topic.
David BL suggested that a way to quantify information is the number of bits
needed to encode, allowing for compression. I said I preferred entropy as
the measure of information,  and suggested that the two measures might in

I am trying to find out how you deal with variable prices, so when I query
[annual unit sales] * [price] I don't get [annual unit sales] * [current
price]. Is there a rule of thumb for this type of issue?
graeme