IP Library Granted Patent US 12,326,862
Granted Patent B2
US 12,326,862 · App. 18/455,454 · Granted Jun 10, 2025

Source independent query language for application layer

Inventor: Thomas R. Kennedy (Miami Beach, FL)
Assignee: JITTERBIT, INC.
G06F16/24549G06F16/2448G06F16/252
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,326,862
App. No.
18/455,454
Granted
Jun 10, 2025
Kind
B2
Abstract

The data processing system described in this specification enables a user to generate non-application specific statements for controlling execution of an application that executes on a user device (client device). The application can include a browser. The statements can be written to control behavior of a webpage or application at the user. The data processing system enables a user to provide non-application specific statements, such as SQL queries or commands. These non-application specific commands are uniform in syntax an enable the user to access other systems, such as web services, databases, and so forth, using the commands with a uniform syntax.

Claims (47)

1. A computer-implemented method, the method comprising:

receiving, by a computer system, a statement to perform operations on data of an application, wherein the statement comprises a MySQL statement;

transforming the received statement into an application-specific statement;

identifying at least one operation of the operations that is not supported by the application-specific statement;

obtaining a function to replace the unsupported operation;

applying the function to a query language specific statement; and

providing the application-specific statement to the application for processing;

causing the application to perform the operations on the data; and

causing, based on the processing, the application to display an updated user interface of the application, wherein the updated user interface is responsive to performing the operations on the data of the application.

2. The computer-implemented method of claim 1 , wherein the application comprises a browser, and wherein the application-specific statement comprises a Javascript statement.

3. The computer implemented method of claim 1 , wherein the function changes the value of a data element absent changing the type of the data element.

4. The computer-implemented method of claim 1 , wherein the function changes the format of a data element.

5. The computer implemented method of claim 1 , wherein the statement is a SQL statement and the data storing application is a NoSQL database.

6. The computer-implemented method of claim 1 , wherein the function is obtained from a function library external to the data storing application.

7. The computer implemented method of claim 1 , wherein the function accepts multiple inputs and produces a single output.

8. A system, comprising:

at least one processor; and

a memory storing instructions that, when executed by the at least one processor, cause the at least one processor to perform operations comprising:

receiving, by a computer system, a statement to perform operations on data of an application, wherein the statement comprises a MySQL statement;

transforming the received statement into an application-specific statement;

identifying at least one operation of the operations that is not supported by the application-specific statement;

obtaining a function to replace the unsupported operation;

applying the function to a query language specific statement; and

providing the application-specific statement to the application for processing;

causing the

application to perform the operations on the data; and

causing, based on the processing, the application to display an updated user interface of the application, wherein the updated user interface is responsive to performing the operations on the data of the application.

9. The system of claim 8 , wherein the application comprises a browser, and wherein the application-specific statement comprises a Javascript statement.

10. The system of claim 8 , wherein the function changes the value of a data element absent changing the type of the data element.

11. The system of claim 8 , wherein the function changes the format of a data element.

12. The system of claim 8 , wherein the statement is a SQL statement and the data storing application is a NoSQL database.

13. The system of claim 8 , wherein the function is obtained from a function library external to the data storing application.

14. The system of claim 8 , wherein the function accepts multiple inputs and produces a single output.

15. One or more non-transitory computer readable media storing instructions that, when executed by at least one processor, cause the at least one processor to perform operations comprising:

receiving, by a computer system, a statement to perform operations on data of an application, wherein the statement comprises a MySQL statement;

transforming the received statement into an application-specific statement;

identifying at least one operation of the operations that is not supported by the application-specific statement;

obtaining a function to replace the unsupported operation;

applying the function to a query language specific statement; and

providing the application-specific statement to the application for processing;

causing the application to perform the operations on the data; and

causing, based on the processing, the application to display an updated user interface of the application, wherein the updated user interface is responsive to performing the operations on the data of the application.

16. The one or more non-transitory computer readable media of claim 15 , wherein the application comprises a browser, and wherein the application-specific statement comprises a Javascript statement.

17. The one or more non-transitory computer readable media of claim 15 , wherein the function changes the value of a data element absent changing the type of the data element.

18. The one or more non-transitory computer readable media of claim 15 , wherein the function changes the format of a data element.

19. The one or more non-transitory computer readable media of claim 15 , wherein the statement is a SQL statement and the data storing application is a NoSQL database.

20. The one or more non-transitory computer readable media of claim 15 , wherein the function is obtained from a function library external to the data storing application.

Assignments (2)
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Sep 8, 2023
From: KENNEDY, THOMAS R., JR.
To: VINYL DEVELOPMENT LLC
Reel/Frame 064840/0917 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Sep 8, 2023
From: VINYL DEVELOPMENT LLC
To: JITTERBIT, INC.
Reel/Frame 064841/0115 →
Continuity (2)
Provisional Application 63403521 · Sep 2, 2022
Related Publication 20240078236A1 · Mar 7, 2024
References Cited (58)
US 7062502B1 · Kesler · 2006 [cited by applicant]
US 7299493B1 · Burch et al. · 2007 [cited by applicant]
US 7657881B2 · Nagendra et al. · 2010 [cited by applicant]
US 7676499B2 · Dorsett, Jr. · 2010 [cited by applicant]
US 7809694B2 · Nelson · 2010 [cited by examiner]
US 8032509B2 · Piedmonte · 2011 [cited by applicant]
US 8417715B1 · Bruckhaus et al. · 2013 [cited by applicant]
US 8863156B1 · Lepanto et al. · 2014 [cited by applicant]
US 9185125B2 · Varsanyi et al. · 2015 [cited by applicant]
US 9275099B1 · Kennedy, Jr. · 2016 [cited by applicant]
US 9547687B2 · Kennedy, Jr. · 2017 [cited by applicant]
US 9705918B2 · Porras et al. · 2017 [cited by applicant]
US 9886483B1 · Harrison et al. · 2018 [cited by applicant]
US 10496632B2 · Kennedy, Jr. · 2019 [cited by examiner]
US 10558644B2 · Kennedy, Jr. · 2020 [cited by applicant]
US 11586607B2 · Kennedy, Jr. · 2023 [cited by applicant]
US 20040226031A1 · Zimmerman et al. · 2004 [cited by applicant]
US 20050289013A1 · Goldberg · 2005 [cited by applicant]
US 20050289125A1 · Liu et al. · 2005 [cited by applicant]
US 20060020582A1 · Dettinger et al. · 2006 [cited by applicant]
US 20060134712A1 · Stromgren et al. · 2006 [cited by applicant]
US 20070027905A1 · Warren et al. · 2007 [cited by applicant]
US 20070038985A1 · Meijer et al. · 2007 [cited by applicant]
US 20070169017A1 · Coward · 2007 [cited by applicant]
US 20080046981A1 · Philyaw · 2008 [cited by applicant]
US 20080120286A1 · Dettinger et al. · 2008 [cited by applicant]
US 20080222616A1 · Cheng et al. · 2008 [cited by applicant]
US 20080256082A1 · Davies et al. · 2008 [cited by applicant]
US 20090254516A1 · Meiyyappan et al. · 2009 [cited by applicant]
US 20100036801A1 · Pirvali et al. · 2010 [cited by applicant]
US 20100114932A1 · Whitcher et al. · 2010 [cited by applicant]
US 20100185645A1 · Pazdziora · 2010 [cited by applicant]
US 20100306220A1 · Sthanikam et al. · 2010 [cited by applicant]
US 20100325122A1 · Yassin · 2010 [cited by applicant]
US 20110209131A1 · Hohenstein et al. · 2011 [cited by applicant]
US 20110246415A1 · Li et al. · 2011 [cited by applicant]
US 20120166238A1 · Mohanty et al. · 2012 [cited by applicant]
US 20130066801A1 · Phillips · 2013 [cited by applicant]
US 20130166539A1 · Clark et al. · 2013 [cited by applicant]
US 20130282710A1 · Raghavan et al. · 2013 [cited by applicant]
US 20130311445A1 · Narita · 2013 [cited by applicant]
US 20130339293A1 · Witten et al. · 2013 [cited by applicant]
US 20140075519A1 · Porras et al. · 2014 [cited by applicant]
US 20140095814A1 · Marden et al. · 2014 [cited by applicant]
US 20140172833A1 · Taylor · 2014 [cited by applicant]
US 20140214890A1 · Johnson · 2014 [cited by applicant]
US 20140214897A1 · Zhu et al. · 2014 [cited by applicant]
US 20140244680A1 · Chandran et al. · 2014 [cited by applicant]
US 20140258341A1 · Mazoue · 2014 [cited by applicant]
US 20140279837A1 · Guo · 2014 [cited by examiner]
US 20140379693A1 · May et al. · 2014 [cited by applicant]
US 20150212864A1 · Scrimo, Jr. · 2015 [cited by applicant]
US 20150227135A1 · Mcadam et al. · 2015 [cited by applicant]
US 20150317361A1 · Battaglia et al. · 2015 [cited by applicant]
US 20160026680A1 · Banerjee et al. · 2016 [cited by applicant]
US 20170169068A1 · Kennedy, Jr. · 2017 [cited by applicant]
US 20170262498A1 · Kennedy · 2017 [cited by applicant]
US 20210081389A1 · Liu · 2021 [cited by examiner]