REWRITING TABLE FUNCTIONS AS SQL STRINGS

Patent №

US 7,680,862

Granted

2010-03-16

Filed 2005

Owner

ORACLE INTERNATIONAL CORPORATION

Lab

AI components

4

nlp · kr · planning · hardware

Assignment

Recorded

Dataset

AIPD

2023_r1 edition

Application

11108242

The TABLE function mechanism available in a RDBMS is used to integrate RDF models into SQL queries. The table function invocation takes parameters including an RDF pattern, an RDF model, and an RDF rule base and returns result rows to the SQL query that contain RDF triples resulting from the application of the pattern to the triples of the model and the triples inferred by applying the rule base to the model. The RDBMS includes relational representations of the triples and the rules. Optimizations include indexes and materialized views of the representations of the triples, precomputed inferred triples, and a method associated with the TABLE function that rewrites the part of the SQL query that contains the TABLE function invocation as an equivalent SQL string. The latter technique is generally applicable to TABLE functions.

AI classification

Natural language1.00
Knowledge representation1.00
Planning0.99
AI hardware0.64
Speech0.00
Vision0.00
Evolutionary computation0.00
Machine learning0.00

Ownership

ORACLE INTERNATIONAL CORPORATION

assignment · 164840057

Assignors

CHONG, EUGENE INSEOK, DAS, SOURIPRIYA, EADON, GEORGE, SRINIVASAN, JAGANNATHAN

On an employer assignment, the assignors are typically the inventors.

© 2026 NYSGPT2525 LLC