Invention Grant
- Patent Title: Direct table association in in-memory databases
-
Application No.: US15279015Application Date: 2016-09-28
-
Publication No.: US10853364B2Publication Date: 2020-12-01
- Inventor: Nikola Vujic , Aleksandar Vujic
- Applicant: Microsoft Technology Licensing, LLC
- Applicant Address: US WA Redmond
- Assignee: Microsoft Technology Licensing, LLC
- Current Assignee: Microsoft Technology Licensing, LLC
- Current Assignee Address: US WA Redmond
- Agency: Alleman Hall Creasman & Tuttle LLP
- Main IPC: G06F16/00
- IPC: G06F16/00 ; G06F16/2453 ; G06F16/22 ; G06F16/2455 ; G06F16/23

Abstract:
To address the issue of latency in relational database systems, a computerized database management system comprising a database server, a processor, and associated random access memory is provided. The processor may configure an in-memory database in the random access memory to have tables, each containing a plurality of cells associated memory addresses, establish a direct table association between an origin cell and a target cell within the tables, receive a request to perform a join database operation of a first table including the origin cell on a second table including the target cell, dereference the direct table association for the origin cell to obtain a value of the target cell stored at the memory address for the target cell, execute the join database operation to produce a joined table including the value, and store the joined table at a new location in the random access memory.
Public/Granted literature
- US20180089266A1 DIRECT TABLE ASSOCIATION IN IN-MEMORY DATABASES Public/Granted day:2018-03-29
Information query