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 mo...

Full description

Saved in:
Bibliographic Details
Main Authors ARNETT, Kenneth D, ARNETT, Paul J
Format Patent
LanguageEnglish
Published 22.04.2021
Subjects
CALCULATING
COMPUTING
COUNTING
ELECTRIC DIGITAL DATA PROCESSING
PHYSICS
Online AccessGet full text

Cover

More Information
Summary: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.
Bibliography:Application Number: US202017034452