Patent ID: 10572485

Abstract:
Systems for database query processors. In a method embodiment, processing commences upon receiving a first set of a plurality of database language queries that reference a normalized column in an RDF table and that also includes a JOIN clause that references both the normalized column in the RDF table and a corresponding lookup table (e.g., a denormalization dictionary) that contains both normalized RDF data and denormalized RDF data. An in-memory table is allocated and formatted to comprise virtual columns that correspond to denormalized RDF data. Virtual columns of the in-memory table are populated with denormalized RDF data. In case of receipt of a SPARQL query, the incoming query is first translated into non-SPARQL database statements which are in turn recoded into database language statements that use lookup functions to lookup the denormalized RDF data from the virtual columns of the in-memory table rather than by incurring expensive disk I/O operations.