Re: End-to-end 2VL and non-1NF
- From: "dawn" <dawnwolthuis@xxxxxxxxx>
- Date: 31 Oct 2005 05:15:35 -0800
John wrote:
> dawn wrote:
>
> > Is anyone writing applications using two-valued logic (no SQL
> > three-valued logic, for example) and non-first-normal-form in the GUI,
> > the database API, and everywhere else? If so, what database and other
> > tools are you using? I'm looking for big bang for the buck solutions
> > with no speck of SQL or Object-relational mappings.
> >
> > Thanks. --dawn
> >
>
> Does that even count as a database any more?
I predict it will again if it doesn't today ;-) XML lends itself to
such an approach.
> I have come across products developed using this sort of technology, and
> they generally use 70s multi-value stuff like PICK.
Yes, I'm quite familiar with the various flavors of PICK. I think
Cache'/MUMPS also has these features. Sleepcat tools like Berkeley DB
and Berkeley DB XML and other embedded databases likely do too. I'm
guessing there are some newer tools out there, including various "XML
databases" so I thought I'd check what comp.databases folks might be
using.
> If you are set on the requirements you have outlined, i'd use something
> like PICK or just forget about database products and go back to direct
> file manipulation.
>
> I'd be interested to know what you are modelling,
Anything -- basic data processing 101 applications (each with many
nuances, of course).
> because I'm sure we
> could come up with a solution that uses relational databases.
Definitely. I suspect I could too, but I don't want to tie my hands
that way. ;-)
> 2VL and the relational model can work quite happily together BTW.
I realize that a schema can be set up prohibiting NULLs so that the 3VL
doesn't "kick in". I'm not familiar with putting SQL into some 2VL
mode -- is that what you are suggesting? I want to permit an attribute
to have no specified value, but have that treated as if it were a "null
set" value. Two null sets are equal to each other, for example. Did
that clarify?
Thanks. --dawn
> John
.
- References:
- End-to-end 2VL and non-1NF
- From: dawn
- Re: End-to-end 2VL and non-1NF
- From: John
- End-to-end 2VL and non-1NF
- Prev by Date: Re: End-to-end 2VL and non-1NF
- Next by Date: How to transfer info automatically from an excel data base to a word document OR an excel document?
- Previous by thread: Re: End-to-end 2VL and non-1NF
- Next by thread: How to transfer info automatically from an excel data base to a word document OR an excel document?
- Index(es):
Relevant Pages
|
