IP Library Granted Patent US 11,327,986
Granted Patent B2
US 11,327,986 · App. 16/908,598 · Granted May 10, 2022

Retrieving and presenting data in a structured view from a non-relational database

Inventors: Nicholas Joseph Keller (Acworth, GA); Arvin Bhatnagar (Cary, NC); Jason Howard Cornpropst (Raleigh, NC)
Assignee: International Business Machines Corporation
G06F16/248G06F16/2237G06F16/2282G06F16/258G06Q10/10
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 11,327,986
App. No.
16/908,598
Granted
May 10, 2022
Kind
B2
Abstract

In an approach for retrieving and presenting data in a structured view from a database, a processor receives a request from a user for accessing data in the database based on a business object. The business object may be a configuration file that defines the data and how the data is to be retrieved from the database. A processor retrieves the business object. A processor determines, based on the business object, a location in the database to get the data. A processor retrieves the data from the database based on the business object. A processor formats the data based on the business object. A processor performs a post process on the data based on the business object. A processor returns the data to the user.

Claims (40)

1. A computer-implemented method comprising:

receiving, by one or more processors, a request from a user for accessing data in a database based on a business object, the business object being a configuration file that defines the data and how the data is to be retrieved from the database by the user;

retrieving, by one or more processors, the business object;

retrieving, by one or more processors, a definition specified in the business object about what data and how the data is to be retrieved from the database and is to be presented to the user, wherein the definition defines a level of detail of the data to present to the user;

determining, by one or more processors, based on the business object, a location in the database to get the data;

retrieving, by one or more processors, the data from the database based on the business object;

formatting, by one or more processors, the data based on the business object;

performing, by one or more processors, a post process on the data based on the business object; and

returning, by one or more processors, the data to the user by presenting a structured view of the data based on the definition specified in the business object.

2. The computer-implemented method of claim 1 , wherein the business object specifies the location to get the data from the database, the location including tables and columns in the database and linkages among the tables and columns.

3. The computer-implemented method of claim 1 , wherein formatting the data includes generating an array and a group in the data.

4. The computer-implemented method of claim 1 , wherein performing the post process including merging fields of the data.

5. The computer-implemented method of claim 1 , wherein the database is a non-relational database including unstructured data, wherein returning the data includes presenting the structured view of the unstructured data.

6. A computer program product comprising:

one or more computer readable storage media, and program instructions collectively stored on the one or more computer readable storage media, the program instructions comprising:

program instructions to receive a request from a user for accessing data in a database based on a business object, the business object being a configuration file that defines the data and how the data is to be retrieved from the database by the user;

program instructions to retrieve the business object;

program instructions to retrieve a definition specified in the business object about what data and how the data is to be retrieved from the database and is to be presented to the user, wherein the definition defines a level of detail of the data to present to the user;

program instructions to determine, based on the business object, a location in the database to get the data;

program instructions to retrieve the data from the database based on the business object;

program instructions to format the data based on the business object;

program instructions to perform a post process on the data based on the business object; and

program instructions to return the data to the user by presenting a structured view of the data based on the definition specified in the business object.

7. The computer program product of claim 6 , wherein the business object specifies the location to get the data from the database, the location including tables and columns in the database and linkages among the tables and columns.

8. The computer program product of claim 6 , wherein instructions to format the data include instructions to generate an array and a group in the data.

9. The computer program product of claim 6 , wherein instructions to perform the post process includes instructions to merge fields of the data.

10. The computer program product of claim 6 , wherein the database is a non-relational database including unstructured data, wherein instructions to return the data include instructions to present the structured view of the unstructured data.

11. A computer system comprising:

one or more computer processors, one or more computer readable storage media, and program instructions stored on the one or more computer readable storage media for execution by at least one of the one or more computer processors, the program instructions comprising:

program instructions to receive a request from a user for accessing data in a database based on a business object, the business object being a configuration file that defines the data and how the data is to be retrieved from the database by the user;

program instructions to retrieve the business object;

program instructions to retrieve a definition specified in the business object about what data and how the data is to be retrieved from the database and is to be presented to the user, wherein the definition defines a level of detail of the data to present to the user;

program instructions to determine, based on the business object, a location in the database to get the data;

program instructions to retrieve the data from the database based on the business object;

program instructions to format the data based on the business object;

program instructions to perform a post process on the data based on the business object; and

program instructions to return the data to the user by presenting a structured view of the data based on the definition specified in the business object.

12. The computer system of claim 11 , wherein the business object specifies the location to get the data from the database, the location including tables and columns in the database and linkages among the tables and columns.

13. The computer system of claim 11 , wherein instructions to format the data include instructions to generate an array and a group in the data.

14. The computer system of claim 11 , wherein the database is a non-relational database including unstructured data, wherein instructions to return the data include instructions to present the structured view of the unstructured data.

Assignments (2)
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Mar 12, 2025
From: INTERNATIONAL BUSINESS MACHINES CORPORATION
To: MONDAY.COM LIMITED
Reel/Frame 070477/0799 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Jun 22, 2020
From: KELLER, NICHOLAS JOSEPH; BHATNAGAR, ARVIN; CORNPROPST, JASON HOWARD
To: INTERNATIONAL BUSINESS MACHINES CORPORATION
Reel/Frame 053006/0123 →
Continuity (1)
Related Publication 20210397608A1 · Dec 23, 2021