EXTENDING THE SQL LANGUAGE TO ALLOW THE REFERENCE OF A NAMED DATA MODEL

摘要

A method and system for extending a structured query language to allow reference of a named data model are provided. In some embodiments, a substitute SELECT statement having at least one JOIN statement based on an abbreviated SELECT statement having no JOIN statements is created by a translation module. The process of translation includes identifying tables of a data model referenced by an abbreviated SELECT statement having no JOIN statements. The process further includes determining relationships between the tables referenced by the abbreviated SELECT statement. The process also includes generating a substitute SELECT statement having a sequence of JOIN statements based on the determined relationships.