Re: 3vl 2vl and NULL
Date: Wed, 07 Dec 2005 06:12:19 GMT
Message-ID: <73vlf.13540$ea6.11384_at_news-server.bigpond.net.au>
dawn wrote:
> Frank Hamersley wrote:
>
>>dawn wrote: >> >>>David Cressey wrote: >>>
[..]
>>> >>>Every language has pros & cons. SQL's big pro is its wide use, >>>adoption in client-server approaches such as odbc & jdbc, and by most >>>database vendors. Maybe once those who have only worked with SQL start >>>working with other tools (perhaps related to data in XML documents), >>>there will be a move toward 2VLs end-to-end in software development. >>>Then Mike can be in the mainstream and we won't need to change HIS >>>mind. cheers! --dawn >> >>I for one am not holding my breath on this one! >> >>The 2VL offerings have had plenty of time for market forces to make a >>reliable judgement (viz Darwins Theory of Natural Selection). They are >>certainly not dodo's but they are definitely not a top order success story.
>
> What do you use with XML structured data? A 2 or a 3VL? Answer: 2VL,
> right?
Nope - but a poor question anyway - to my way of thinking XML is not "structured data" - period. That said it seems to present no problems to the SQL vendors AFAICT.
It is a handy way of transferring information between disparate systems, but just because it carries its schema embedded in the data stream, does not make it "structured". In fact XML has to be 2VL, not because 2VL is desirable, but because it has no capacity to record "special" values.
Fortunately for my psyche I haven't had to engage XML in a "do or die" project as a A/P or C, although I have been ops manager of a multi-tiered app that used the MS object for a 1/2+Gb in memory database. It was nothing but trouble - average uptime was in the order of 4 hours! The developers should have been on the wall before the lawyers in this case.
> List all languages that employ a 3VL that are in common use today.
> 1. SQL
> 2. ?
>
> What am I missing? --dawn
BTW - I did giggle at the use of the generic term "languages" to expand the domain in your favour by letting the "database" aspect of DC's post fade.
Cheers, Frank. Received on Wed Dec 07 2005 - 07:12:19 CET