Metadata-based translation of natural language queries into database queries

摘要

A system may include: a database table, a grammar containing metadata-referencing non-terminals, and metadata mapping the metadata-referencing non-terminals into alternative terms for the table and a column therein. The system may also include a server device configured to: (i) receive a natural language query, the grammar, and the metadata, wherein the natural language query contains a first alternative term for the table and a second alternative term for the column; (ii) parse, using the grammar, the natural language query into a series of terminals and non-terminals including a first metadata-referencing non-terminal that the metadata maps to the first alternative term and a second metadata-referencing non-terminal that the metadata maps to the second alternative term; (iii) identify, based on the first metadata-referencing non-terminal, the table; (iv) identify, based on the second metadata-referencing non-terminal, the column; and (v) generate, based on the table and the column as identified, a database language query.