IP Library › Granted Patent US 12,361,025
Granted Patent B2
US 12,361,025 · App. 17/128,020 · Granted Jul 15, 2025

Hierarchical data

Inventors: Andrew John Coleman (Petersfield, GB); John Anthony Reeve (Winchester, GB); Trevor Clifford Dolby (Southampton, GB)
Assignee: International Business Machines Corporation
G06F16/282G06F16/2246G06F16/2448G06F16/2458
View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 12,361,025
App. No.
17/128,020
Granted
Jul 15, 2025
Kind
B2
Abstract

A computer-implemented method, system and computer program product for identifying ancestor objects in hierarchical data configured for processing with a query, the query having an associated abstract syntax tree. The abstract syntax tree may be processed so as to generate an augmented abstract syntax tree which includes parent identifiers configured to identify the parent nodes of the query. In this way, a need to pre-parse the data may be alleviated. Instead, the identification of a parent node of a query may be encoded into the abstract syntax tree of the query.

Claims (19)

1. A computer-implemented method for identifying ancestor objects in hierarchical data stored in a database configured for processing with a query according to a query language, the query having an associated abstract syntax tree, AST, the method comprising:

processing, by a processing unit of a computing device, the AST associated with the query to determine a parent node of the AST relating to the query; and

augmenting, by an augmentation component of the computing device, the AST with metadata containing a parent identifier configured to identify the determined parent node of the query so as to generate an augmented AST thereby eliminating a need to pre-parse input data,

wherein the augmenting of the AST with the parent identifier configured to identify the determined parent node so as to generate the augmented AST comprises:

adding an ancestor attribute to the parent node of the AST,

wherein the adding of the ancestor attribute to the parent node of the AST comprises:

setting a value of the ancestor attribute to a predetermined value,

wherein the predetermined value is based on a counter value, the counter value being incremented for each parent node that is identified.

2. The method as recited in claim 1 , wherein the processing of the AST associated with the query to determine the parent node of the AST relating to the query comprises:

traversing the AST to determine a node of the AST that represents a parent node of the query.

3. The method as recited in claim 1 , wherein the parent identifier is configured to instruct a query processor to save a reference to the parent node.

4. The method as recited in claim 1 further comprising:

generating the abstract syntax tree by parsing the query.

5. The method as recited in claim 1 further comprising:

storing the augmented AST; and

associating the stored augmented AST with the hierarchical data.

6. The method as recited in claim 1 , wherein the hierarchical data comprises JSON data, wherein the query language is JSONata query language.

7. The method as recited in claim 1 further comprising:

creating a uniquely named label upon encountering an operator in the AST.

Assignments (1)
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Dec 19, 2020
From: COLEMAN, ANDREW JOHN; REEVE, JOHN ANTHONY; DOLBY, TREVOR CLIFFORD
To: INTERNATIONAL BUSINESS MACHINES CORPORATION
Reel/Frame 054702/0127 →
Continuity (2)
Continuation 16745582 · Jan 17, 2020
Related Publication 20210224295A1 · Jul 22, 2021
References Cited (73)
US 6263332B1 · Nasr et al. · 2001 [cited by applicant]
US 8260784B2 · Beyer et al. · 2012 [cited by applicant]
US 9230040B2 · Shukla et al. · 2016 [cited by applicant]
US 9659045B2 · Liu et al. · 2017 [cited by applicant]
US 10416972B1 · Forghani · 2019 [cited by examiner]
US 10803083B2 · Budhiraja · 2020 [cited by examiner]
US 20040205082A1 · Fontoura et al. · 2004 [cited by applicant]
US 20060161559A1 · Bordawekar et al. · 2006 [cited by applicant]
US 20070244865A1 · Gordon et al. · 2007 [cited by applicant]
US 20080082974A1 · Ellison · 2008 [cited by examiner]
US 20090089268A1 · Benedikt et al. · 2009 [cited by applicant]
US 20090112905A1 · Mukerjee · 2009 [cited by examiner]
US 20090240675A1 · Asai et al. · 2009 [cited by applicant]
US 20110035398A1 · Lee et al. · 2011 [cited by applicant]
US 20110107316A1 · Gutz et al. · 2011 [cited by applicant]
US 20140283081A1 · Sheridan · 2014 [cited by examiner]
US 20150046492A1 · Balachandran · 2015 [cited by examiner]
US 20160124723A1 · Ma · 2016 [cited by applicant]
US 20160210332A1 · Milton et al. · 2016 [cited by applicant]
US 20170060910A1 · Budhiraja et al. · 2017 [cited by applicant]
US 20170060973A1 · Liu et al. · 2017 [cited by applicant]
US 20170257385A1 · Overson et al. · 2017 [cited by applicant]
US 20180074792A1 · Goergens et al. · 2018 [cited by applicant]
US 20180165336A1 · Venkateswarulu et al. · 2018 [cited by applicant]
US 20180232404A1 · Bhatti · 2018 [cited by examiner]
US 20180288468A1 · Yamagishi · 2018 [cited by examiner]
US 20180365201A1 · Hunn et al. · 2018 [cited by applicant]
US 20190007753A1 · Yang · 2019 [cited by examiner]
US 20190079974A1 · Goergens · 2019 [cited by examiner]
US 20190278572A1 · Yoshida · 2019 [cited by examiner]
US 20190294610A1 · Naidu · 2019 [cited by examiner]
US 20200019722A1 · Li et al. · 2020 [cited by applicant]
US 20200057671A1 · Bailey · 2020 [cited by examiner]
US 20200117664A1 · Kondiles et al. · 2020 [cited by applicant]
US 20200177589A1 · Mangalvedkar et al. · 2020 [cited by applicant]
US 20200192662A1 · Hu · 2020 [cited by examiner]
US 20200301917A1 · Niu · 2020 [cited by examiner]
US 20200319856A1 · Loria · 2020 [cited by examiner]
US 20210056107A1 · Kondiles et al. · 2021 [cited by applicant]
US 20210224294A1 · Coleman et al. · 2021 [cited by applicant]
CN 101667190A · 2010 [cited by applicant]
CN 105335402A · 2016 [cited by applicant]
CN 107506247A · 2017 [cited by applicant]
CN 110443059A · 2019 [cited by applicant]
CN 114981802A · 2022 [cited by applicant]
DE 112021000573T5 · 2022 [cited by applicant]
GB 2607518A · 2022 [cited by applicant]
JP 2008084028A · 2008 [cited by applicant]
JP 2009230569A · 2009 [cited by applicant]
JP 2023510104A · 2023 [cited by applicant]
JP 7546674B2 · 2024 [cited by applicant]
KR 1020220092942A · 2022 [cited by applicant]
WO 2019210758A1 · 2019 [cited by applicant]
WO 2021144689A1 · 2021 [cited by applicant]
Office Action for U.S. Appl. No. 16/745,582 dated May 20, 2022, pp. 1-23. [cited by applicant]
Office Action for U.S. Appl. No. 16/745,582 dated Jul. 28, 2021, pp. 1-20. [cited by applicant]
List of IBM Patents or Patent Applications Treated as Related, Jan. 14, 2021, pp. 1-2. [cited by applicant]
International Search Report and Written Opinion of the International Searching Authority for International Application No. PCT/IB2021/050191 dated Apr. 15, 2021, pp. 1-7. [cited by applicant]
Chen et al., “Indexing Keys in Hierarchical Data,” University of Pennsylvania ScholarlyCommons, Jan. 2001, pp. 1-22. [cited by applicant]
Pardede et al., “SQL/XML Hierarchical Query Performance Analysis in an XML-Enabled Database System,” Journal of Universal Computer Science, vol. 15, No. 10, 2009, pp. 2058-2077. [cited by applicant]
Office Action for U.S. Appl. No. 16/745,582 dated Mar. 3, 2021, pp. 1-21. [cited by applicant]
Office Action for U.S. Appl. No. 16/745,582 dated Nov. 5, 2021, pp. 1-27. [cited by applicant]
Response to Examination Report for UK Patent Application No. 2211979.6 dated Apr. 13, 2023, pp. 1-4. [cited by applicant]
Examination Report for United Kingdom Application No. GB2211979.6 dated Feb. 20, 2023, pp. 1-6. [cited by applicant]
Examination Report for Australian Patent Application No. 2021208982 dated Apr. 6, 2023, pp. 1-4. [cited by applicant]
Examination Report from The Intellectual Property Office of the United Kingdom for United Kingdom Application No. GB2211979.6 dated Jun. 14, 2023, pp. 1-5. [cited by applicant]
Office Action for Korean Application No. 10-2022-7018365 dated Oct. 30, 2024, pp. 1-5. [cited by applicant]
Decision to Grant a Patent for Japanese Patent Application No. 2022-537263 dated Jul. 30, 2024, pp. 1-2. [cited by applicant]
Intellectual Property Office of Singapore, “Invitation To Respond To Written Opinion,” Feb. 10, 2025, 7 Pages, SG Application No. 11202250609N. [cited by applicant]
Examination Report for Australian Patent Application No. 202120892 dated Jan. 10, 2024, pp. 1-3. [cited by applicant]
Examination Report for Australian Patent Application No. 2021208982 dated Feb. 12, 2024, pp. 1-4. [cited by applicant]
Intellectual Property Office, “Notice of Allowance,” Apr. 27, 2025, 09 Pages, KR Application No. 10-2022-7018365. [cited by applicant]
The State Intellectual Property Office of People's Republic of China, “First Office Action”, May 13, 2025, 17 Pages, CN Application No. 202180009579.6. [cited by applicant]