IP Library Granted Patent US 11,403,293
Granted Patent B1
US 11,403,293 · App. 15/888,259 · Granted Aug 2, 2022

Database scanning tool for optimizing queries

Inventors: Lakshmi T. Borra (Omaha, NE); Joshua K. Cordoba (Omaha, NE); Steven A. Heithoff (Omaha, NE); Roger Henson (Ralston, NE); Prashanth Katakam (Omaha, NE); Sneha S. Vairagade (Omaha, NE); Gregory A. Weigner (Bellevue, NE)
Assignee: Intrado Corporation
G06F16/24535G06F16/2423G06F16/8365
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,403,293
App. No.
15/888,259
Granted
Aug 2, 2022
Kind
B1
Abstract

A query management application provides performing an initial query to retrieve records stored in a database, storing the records as initial query content in a memory, creating a file with a list of commands used during the initial query, initiating a subsequent query to obtain updated information for the records, retrieving the file and applying the list of commands to the subsequent query, performing the subsequent query, and updating the memory with results of the subsequent query.

Claims (40)

1. A method comprising:

creating, by a server device, a file comprising a list of commands used in an initial query made by a user device, the initial query to retrieve initial query content comprising a plurality of records, wherein the initial query content is to be stored in a memory associated with the server device;

creating, by the server device, and for each subsequent query, a temporary query file comprising the list of commands based on the file;

receiving, by the server device, a particular subsequent query to obtain updated information for the initial query content;

retrieving, by the server device, a temporary query file associated with the particular subsequent query;

applying, by the server device, the list of commands to the particular subsequent query;

performing, by the server device, the particular subsequent query to generate content from the particular subsequent query; and

updating, by the server device, the memory with the content from the particular subsequent query.

2. The method of claim 1 , wherein the file is an extensible markup language (XML) file.

3. The method of claim 2 , further comprising:

storing retrieved data from the initial query and the list of commands in the XML file, wherein the list of commands were used to perform the initial query.

4. The method of claim 1 , further comprising:

populating a user interface with differences between the initial query content and the content from the particular subsequent query.

5. An apparatus, comprising:

a processor configured to:

create a file comprising a list of commands used in an initial query made by a user device, the initial query to retrieve initial query content comprising a plurality of records, wherein the initial query content is to be stored in a memory associated with the processor;

create, for each subsequent query, a temporary query file comprising the list of commands based on the file;

receive a particular subsequent query to obtain updated information for the initial query content;

retrieve a temporary query file associated with the particular subsequent query;

apply the list of commands to the particular subsequent query;

perform the particular subsequent query to generate content from the particular subsequent query; and

update the memory with the content from the particular subsequent query.

6. The apparatus of claim 5 , wherein the file is an extensible markup language (XML) file.

7. The apparatus of claim 6 , wherein the processor is further configured to:

store retrieved data from the initial query and the list of commands in the XML file, wherein the list of commands were used to perform the initial query.

8. The apparatus of claim 5 , wherein the processor is further configured to:

populate a user interface with differences between the initial query content and the content from the particular subsequent query.

9. A non-transitory computer readable storage medium configured to store one or more instructions that when executed by a processor of a server device causes the processor to perform:

creating a file comprising a list of commands used in an initial query made by a user device, the initial query to retrieve initial query content comprising a plurality of records, wherein the initial query content is to be stored in a memory associated with the server device;

creating, for each subsequent query, a temporary query file comprising the list of commands based on the file;

receiving a particular subsequent query to obtain updated information for the initial query content;

retrieving a temporary query file associated with the particular subsequent query;

applying the list of commands to the particular subsequent query;

performing the particular subsequent query to generate content from the particular subsequent query; and

updating the memory with the content from the particular subsequent query.

10. The non-transitory computer readable storage medium of claim 9 , wherein the file is an extensible markup language (XML) file.

11. The non-transitory computer readable storage medium of claim 10 , wherein the one or more instructions further cause the processor to perform:

storing retrieved data from the initial query and the list of commands in the XML file, wherein the list of commands were used to perform the initial query.

12. The non-transitory computer readable storage medium of claim 9 , wherein one or more instructions further cause the processor to perform:

populating a user interface with differences between the initial query content and the content from the subsequent query.

Assignments (6)
OMNIBUS ASSIGNMENT OF SECURITY INTEREST IN INTELLECTUAL PROPERTY Recorded Nov 25, 2024
From: UBS AG, STAMFORD BRANCH (AS SUCCESSOR TO CREDIT SUISSE AG, CAYMAN ISLANDS BRANCH IN ITS CAPACITY AS COLLATERAL AGENT)
To: WILMINGTON TRUST, NATIONAL ASSOCIATION, AS THE SUCCESSOR COLLATERAL AGENT
Reel/Frame 069438/0775 →
CHANGE OF NAME Recorded Apr 3, 2023
From: INTRADO CORPORATION
To: WEST TECHNOLOGY GROUP, LLC
Reel/Frame 063239/0876 →
CHANGE OF NAME Recorded Apr 3, 2023
From: WEST CORPORATION
To: INTRADO CORPORATION
Reel/Frame 063239/0900 →
NOTICE OF GRANT OF SECURITY INTEREST (SECOND LIEN) IN PATENTS Recorded Jan 31, 2023
From: CX360, INC.; WEST TECHNOLOGY GROUP, LLC (FKA INTRADO CORPORATION, FKA WEST CORPORATION); INTRADO INTERACTIVE SERVICES CORPORATION (FKA WEST INTERACTIVE SERVICES CORPORATION, FKA COBALT ACQUISITION COMPANY)
To: U.S. BANK TRUST COMPANY, NATIONAL ASSOCIATION, AS COLLATERAL AGENT
Reel/Frame 062571/0018 →
NOTICE OF GRANT OF SECURITY INTEREST IN PATENTS - FIRST LIEN Recorded May 22, 2019
From: WEST CORPORATION
To: CREDIT SUISSE AG, CAYMAN ISLANDS BRANCH, AS COLLATERAL AGENT
Reel/Frame 049255/0843 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Feb 5, 2018
From: BORRA, LAKSHMI T.; CORDOBA, JOSHUA K.; HEITHOFF, STEVEN A.; HENSON, ROGER; KATAKIM, PRASHANTH; VAIRAGADE, SNEHA S.; WEIGNER, GREGORY A.
To: WEST CORPORATION
Reel/Frame 044830/0084 →