<html><head><meta http-equiv="Content-Type" content="text/html charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">I see a bit use-case for JSONiq every day: its data integration, cleaning, sanity checking, publishing.<div class="">More and more people are building data-driven products, i.e. data that is productised in APIs and then used in simple Web Apps.</div><div class="">They start with dirty data that nicely fits into JSON paradigm, and then goes thought lots of stages, before it’s exported by API, this time definitely in JSON format.</div><div class="">There are many steps to collect, clean, refine, transform, merge, etc., and all of them will need to operate on the structure of the data, not just the fields.</div><div class="">So schemas are a must, all sorts of schema operations are extremely useful (compute statistics on what the common values for such and such fields are, how many JSONs contain this field)….</div><div class=""><br class=""></div><div class="">Right now there are no good tools for doing this, so actually I’m trying to start such a project (no fancy JSONiq processing, just basic interpreter, but with schema operations).</div><div class=""><br class=""><div><blockquote type="cite" class=""><div class="">On 23 Jun 2015, at 19:14, Ihe Onwuka <<a href="mailto:ihe.onwuka@gmail.com" class="">ihe.onwuka@gmail.com</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div dir="ltr" class=""><div class="">Well he didn't comment on SQL for JSON per se but saying that RDBMS are sub-optimal for everything is a tacit repudiation of SQL is it not?</div><div class=""><br class=""></div><div class="">He buys into the notion that there will be swarms of data scientists doing clever things with data which will need a different language. I am continually surprised that people this smart believe that there is such a pool of people to draw from.<br class=""></div><div class=""><br class=""></div><div class="">He is right that statistical packages suck at data management but that won't isn't going to deter the R community. </div><div class=""><br class=""></div><div class="">Do you see XQuery fitting anywhere in this vision. It has potential as a pipeling technology as does for that matter SQL. I think it will always be problematic to do analytics on the source data because it is too dirty.</div></div><div class="gmail_extra"><br class=""><div class="gmail_quote">On Tue, Jun 23, 2015 at 11:51 AM, daniela florescu <span dir="ltr" class=""><<a href="mailto:dflorescu@me.com" target="_blank" class="">dflorescu@me.com</a>></span> wrote:<br class=""><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div style="word-wrap:break-word" class="">Ihe,<div class=""><br class=""></div><div class=""><br class=""></div><div class="">I had discussions with Michael Stonebreaker for 20 years about about the fact that</div><div class="">XML “exists” or not. With Jim Gray too, before he disappeared. They were both extremely</div><div class="">supportive for me, yet were both thinking that I am crazy to waste my research career on XML.</div><div class=""><br class=""></div><div class="">Stonebreaker’s opinion: he doesn’t believe that XML “exists” in industry.</div><div class=""><br class=""></div><div class="">So he will not mention it, because it doesn’t exist :-)</div><div class=""><br class=""></div><div class="">But you have to remember that Stonebreaker is a database person. Probably he will not</div><div class="">understand the facet of XML which is “XML as documents”. It took me and the other database </div><div class="">people involved in XQuery years before we swallowed it. (Don Chamberlin of SQL fame</div><div class="">famously once said “who in the world would care about such a corner case as mixed content !?").</div><div class=""><br class=""></div><div class="">Don’t blame the database people that they don’t “get” XML. On one hand, it has never been explained</div><div class="">to them properly.</div><div class=""><br class=""></div><div class="">And again, Stonebreaker, being a database person, he will look at “XML as data” aspect of the story.</div><div class="">And this today is INDEED non-existing in industry, or almost. Or, when t is, it is mostly for log analysis.</div><div class=""><br class=""></div><div class="">============</div><div class=""><br class=""></div><div class="">JSON will completely change the landscape, in surprising ways, that none of us can predict.</div><div class=""><br class=""></div><div class="">And no, I trust that Michael Stonebreaker is too smart to believe that SQL is a solution to process JSON.</div><div class=""><br class=""></div><div class="">But time will tell.</div><div class=""><br class=""></div><div class="">Best regards</div><div class="">Dana</div><div class=""><br class=""></div><div class=""><br class=""></div><div class=""><br class=""></div><div class=""><br class=""></div><div class=""><br class=""><div class=""><blockquote type="cite" class=""><span class=""><div class="">On Jun 23, 2015, at 12:15 AM, Ihe Onwuka <<a href="mailto:ihe.onwuka@gmail.com" target="_blank" class="">ihe.onwuka@gmail.com</a>> wrote:</div><br class=""></span><div class=""><span class=""><div dir="ltr" class=""><a href="https://www.youtube.com/watch?v=9K0SWs1mOD0" target="_blank" class="">https://www.youtube.com/watch?v=9K0SWs1mOD0</a><br class=""><div class=""><br class=""></div><div class="">By implication it puts the kibosh on SQL as the basis of a solution for the future.</div></div></span>
_______________________________________________<br class=""><a href="mailto:talk@x-query.com" target="_blank" class="">talk@x-query.com</a><br class=""><a href="http://x-query.com/mailman/listinfo/talk" target="_blank" class="">http://x-query.com/mailman/listinfo/talk</a></div></blockquote></div><br class=""></div></div></blockquote></div><br class=""></div>
_______________________________________________<br class=""><a href="mailto:talk@x-query.com" class="">talk@x-query.com</a><br class="">http://x-query.com/mailman/listinfo/talk</div></blockquote></div><br class=""><div apple-content-edited="true" class="">
<div class="">С уважением,</div><div class="">Павел Велихов</div><div class=""><a href="mailto:pavel.velikhov@gmail.com" class="">pavel.velikhov@gmail.com</a></div>
</div>
<br class=""></div></body></html>