parallel lineal numerical string comparison algorithm

[Ruslan Zasukhin]

on 5/19/03 9:09 PM, Mark Brownell at gizmotron at earthlink.net wrote:

> Ruslan Zasukhin wrote:
> 
>> Marc, I am sorry, but I still do not understand you idea.
>> 
>> So let you have Table with one TEXT field, and you store here XML
>> record of
>> a SALES. Let table have million of records.
>> 
>> How you see now search:
>>     find all sales with total < $100  ?
>> 
>> In your way, you MSUT iterate million records, parse them to extract
>> attribute TOTAL and read its value.
>> 
>> So where is advantage ???
> 
> There would not be an advantage, SQL is already the best way. I was
> talking about the easy to use Query Language that would be for those
> that don't want to learn SQL. In a small enough database parsing the
> XML would be fast enough with PNLP. I guess it would still reguire an
> easy to use Query Language to use this as well.
> 
> This is what I would do if Valentina were mine, ... :-)
> 
> I would create a framework or set of classes that would transform human
> readable commands into SQL commands so that interface developers could
> use the easy to use Query Language to carry out the already developed
> SQL.
> 
> How about this:

:-) but here no XML.

And I afraid that it only looks that it is easy invent new query language.


> get All (lessThan, price, $100), include(name, transaction number,
> product, price, date)

    get All (price < 100)


> get All (range, price, $100, $200), include(name, transaction number,
> product, price, date)

    get All (price is [100, 200] )
    

> get Next( valueLast +1 ) (lessThan, price, $100), include(name,
> transaction number, product, price, date)

As for me, I cannot read logic of this query.

> get DateRange (after 12/11/02), (lessThan, price, $100), include(name,
> transaction number, product, price, date)

   this can read 


-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------