Invention Grant
- Patent Title: Systems and methods for accessing a database management system
-
Application No.: US16334507Application Date: 2017-09-06
-
Publication No.: US11204918B2Publication Date: 2021-12-21
- Inventor: Peter Kyra Aylett , David Gregory Quint , Scott Hopwood
- Applicant: GLOBAL SOFTWARE INNOVATION PTY LTD
- Applicant Address: AU Baulkham Hills
- Assignee: GLOBAL SOFTWARE INNOVATION PTY LTD
- Current Assignee: GLOBAL SOFTWARE INNOVATION PTY LTD
- Current Assignee Address: AU Baulkham Hills
- Agency: Dority & Manning, P.A.
- Priority: AU2016231506 20160920
- International Application: PCT/AU2017/000186 WO 20170906
- International Announcement: WO2018/053568 WO 20180329
- Main IPC: G06F16/2452
- IPC: G06F16/2452 ; G06F16/2453 ; G06F16/242 ; G06F40/205 ; G06F16/28

Abstract:
Disclosed is a method of accessing a network of relationship instances and data field values of entity instances in a combined entity relationship- and relational-model database management system. The method comprises the steps of receiving a query that natively references relationship types including data fields to be accessed; parsing the query into a parse tree; converting the parse tree to a query graph; optimising the query graph by consolidating equivalent nodes in the query graph; analysing the nodes in the optimised query graph; codifying each node of the optimised query graph into a first table of state transition rules; codifying the data fields to be accessed into a second table of field rules; preparing a query that includes the first and second tables; identifying entity instances to be accessed by the prepared query by iteratively following relationship instances according to the first table; and loading data fields of the identified entity instances according to the second table.
Public/Granted literature
- US20210286815A1 SYSTEMS AND METHODS FOR ACCESSING A DATABASE MANAGEMENT SYSTEM Public/Granted day:2021-09-16
Information query