Re: Forthcoming SQL standards about JSON and Multi-Dimensional Arrays (FYI)

Hi Stefan,

On 07/09/2016 04:03 PM, Stefan Keller wrote:
> Hi Peter, hi all,
>
> I wrote 2016-07-06 13:19 GMT+02:00:
>> ...
>> 2016-07-04 6:44 GMT+02:00 Thomas Munro <thomas.munro@enterprisedb.com>:
>>> ... But ISO/IEC CD 9075-15
>>> (Multi-Dimensional Arrays) is in stage 30.92 "CD referred back to
>>> Working Group".  Is that how they say "returned with feedback"?
>>> ISO/IEC PDTR 19075-5 (Row Pattern Recognition) has also reached stage
>>> 30.60.  Does anyone know what that one is about?  ...
> @Peter B. Can you clarify the stage?

there were comments from the national delegations which have to be worked
through by providing a draft that implements changes where considered
applicable, and justifying when not implemented. This is in accordance with ISO
"bureaucracy", if you will, which defines a fine-grain, therefore transparent,
process. Personally, I find this many-eyes principle very fruitful.

> Regarding the differences of array functions of the ISO proposal, I
> have no clue why the working group did not follow the implementation
> of PostgreSQL.
>
> @Peter B. You know PostgreSQL well. Can you explain?

the WG has discussed all relevant approaches and decided in favour of the one it
found most suitable.

cheers,
Peter

>
> :Stefan
>
> P.S. 2016-07-02 17:11 GMT+02:00 Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> Peter E. had observer status at one point, don't know if he still does.
> @Peter E.: Do you still have observer status at the ISO committee?
>
>
>
> 2016-07-06 13:19 GMT+02:00 Stefan Keller <sfkeller@gmail.com>:
>> Thomas
>>
>> 2016-07-04 6:44 GMT+02:00 Thomas Munro <thomas.munro@enterprisedb.com>:
>>> ... But ISO/IEC CD 9075-15
>>> (Multi-Dimensional Arrays) is in stage 30.92 "CD referred back to
>>> Working Group".  Is that how they say "returned with feedback"?
>>> ISO/IEC PDTR 19075-5 (Row Pattern Recognition) has also reached stage
>>> 30.60.  Does anyone know what that one is about?  Maybe something like
>> Peter surely would know: https://www.jacobs-university.de/directory/pbaumann
>>
>> :Stefan
>>
>> 2016-07-04 6:44 GMT+02:00 Thomas Munro <thomas.munro@enterprisedb.com>:
>>> On Wed, Jun 29, 2016 at 11:51 AM, Stefan Keller <sfkeller@gmail.com> wrote:
>>>> Hi,
>>>>
>>>> FYI: I'd just like to point you to following two forthcoming standard
>>>> parts from "ISO/IEC JTS 1/SC 32" comittee: one on JSON, and one on
>>>> "Multi-Dimensional Arrays" (SQL/MDA).
>>>>
>>>> They define there some things different as already in PG. See also
>>>> Peter Baumann's slides [1] and e.g. [2]
>>>>
>>>> :Stefan
>>>>
>>>> [1] https://www.unibw.de/inf4/professors/geoinformatics/agile-2016-workshop-gis-with-nosql
>>>> [2] http://jtc1sc32.org/doc/N2501-2550/32N2528-WG3-Tutorial-Opening-Plenary.pdf
>>> Thanks for these pointers.  On the "standards under development"
>>> page[1], I see that ISO/IEC PDTR 19075-6 (SQL/JSON) is at stage 30.60
>>> "Close of voting/ comment period".  But ISO/IEC CD 9075-15
>>> (Multi-Dimensional Arrays) is in stage 30.92 "CD referred back to
>>> Working Group".  Is that how they say "returned with feedback"?
>>> ISO/IEC PDTR 19075-5 (Row Pattern Recognition) has also reached stage
>>> 30.60.  Does anyone know what that one is about?  Maybe something like
>>> MATCH_RECOGNIZE in Oracle?
>>>
>>> [1] http://www.iso.org/iso/home/store/catalogue_tc/catalogue_tc_browse.htm?commid=45342&development=on
>>>
>>> --
>>> Thomas Munro
>>> http://www.enterprisedb.com

-- 
Dr. Peter Baumann- Professor of Computer Science, Jacobs University Bremen  www.faculty.jacobs-university.de/pbaumann
mail:p.baumann@jacobs-university.de  tel: +49-421-200-3178, fax: +49-421-200-493178- Executive Director, rasdaman GmbH
Bremen(HRB 26793)  www.rasdaman.com, mail: baumann@rasdaman.com  tel: 0800-rasdaman, fax: 0800-rasdafax, mobile:
+49-173-5837882
"Si forte in alienas manus oberraverit hec peregrina epistola incertis ventis
dimissa, sed Deo commendata, precamur ut ei reddatur cui soli destinata, nec
preripiat quisquam non sibi parata." (mail disclaimer, AD 1083)