Yes it is strange and counterintuitive. Hugh Darwen theorises about how this state of affairs came about:
Do you take SELECT-FROM-WHERE for granted, or do you, like me, find it rather curious that the System R team should have spurned the normal way of writing expressions of arbitrary complexity in favour of something utterly idiosyncratic and, one might say, rather dictatorial...?
The fact is that in the 1960s various scripting languages (as we tend to call such things these days) had come about for the purposes of report generation, especially ad hoc report generation. We had one such language in the prerelational DBMS called Terminal Business System (TBS) that I worked on for IBM from 1969-77. Our language required the user to specify the required report in a series of steps that had to be given in the prescribed order...
A somewhat similar but much more sophisticated report generator was later developed by IBM in the US, as part of a product called (prosaically, as was IBM's style in those days) Generalized Information System (GIS)... when I first looked at SQL, my immediate reaction was "Oh no! Son of GIS? Please not that!" I might have been quite wrong about this. The similarity I perceived might have been illusory and even if it was not, I have no firm evidence that anybody in the System R team was familiar with GIS. The fact remains that the general style of a fixed order of actions was the order of the day at the time. I postulate that SQL's SELECT-FROM-WHERE arose out of this fashion.
It was our first attempt to base the language exclusively on English keywords so that you could read a query from an intuitive understanding of the English words. A query might say something like, ‘Select salary from employee where manager equals John Smith.’ From the English words like ‘select,’ ‘from’ and ‘where’, you can get a pretty good idea for what the query is about.
发布评论
评论（2）
是的，这很奇怪而且违反直觉。休·达文（Hugh Darwen）对这种情况如何发生提出了理论：
来自
拥有错误的时间Yes it is strange and counterintuitive. Hugh Darwen theorises about how this state of affairs came about:
From
HAVINGa Blunderful Time根据 唐纳德·D·张伯伦 (Donald D. Chamberlin) 的口述历史采访，其语法类似于英语：
The syntax was to resemble English, according to an oral history interview with Donald D. Chamberlin: