Re: null values value

["Douglas Olson" <dlolson@lbl.gov>]

I don't think we can come up with a standard null value but
should let that be application specific.  I.e., the physicists working
with some data "know" that ave_pt = -99 means a null value
and will just take that into account for any range queries.
The storage manager would not have to care for query estimation
or execution.

Other opinions?

Doug

-----Original Message-----
From: Henrik Nordberg <henrikn@math.lbl.gov>
To: challenge@sseos.lbl.gov <challenge@sseos.lbl.gov>
Date: Tuesday, May 05, 1998 1:41 PM
Subject: null values value


>Hello All,
>
>if the event database contains null values, how are they represented?
>
>Background: sometimes there might not be enough statistics to calculate
>some of the event parameters. In the first dataset I received to work on
>(from Fuqiang Wang about a year ago) those data were represented as -999.
>for floats and there were no null integers. Is this still true?
>
>Regards, Henrik
>___________________________________________________________
>Henrik Nordberg <HNordberg@lbl.gov> http://nordberg.lbl.gov
>Scientific Data Management Research & Development Group
>Lawrence Berkeley Laboratory
>
>