search

microsoft / IRNet

An algorithm for cross-domain NL2SQL
MIT License
269 stars 80 forks source link

Which parts of SQL are simplified by IR? #9

Closed guotong1988 closed 4 years ago

guotong1988 commented 4 years ago

https://github.com/microsoft/IRNet/issues/7

We know that: As IR simplify the logic form, so IR improve the experiment results.

Then what parts of SQL are simplified by IR?

substill commented 4 years ago

Although SQL is a declarative language, it still contains clauses that are directly related to the data storage schema, e.g., JOIN, From. These clauses are designed for implementation purpose rather than meaning representation, they do not have their corresponding surfaces in users NL questions. Given a well defined database schema, e.g., Star Schema, these part can be derived.

guotong1988 commented 4 years ago

Thank you.