- Patent Title: SQL interceptor for use with third party data analytics packages
-
Application No.: US15352550Application Date: 2016-11-15
-
Publication No.: US10380139B2Publication Date: 2019-08-13
- Inventor: Marius Adamut
- Applicant: Spirent Communications, Inc.
- Applicant Address: US CA Sunnyvale
- Assignee: Spirent Communications, Inc.
- Current Assignee: Spirent Communications, Inc.
- Current Assignee Address: US CA Sunnyvale
- Agency: Haynes Beffel & Wolfeld
- Agent Ernest J. Beffel, Jr.; Andrew L. Dunlap
- Main IPC: G06F17/30
- IPC: G06F17/30 ; G06F16/25 ; H04L29/08 ; H04L29/06 ; G06F16/2455

Abstract:
An SQL interceptor inserted as a proxy between a database client and the corresponding database server intercepts a constrained application-generated SQL query and composes a new data request. Parameter values in the SQL query determine whether the new data request is sent to a database server or a web service provider. A reserved table name specified in the SQL query triggers a rewrite of the data request. Parameter values in the query are used to select among a plurality of executable modules to use for rewriting the data request. Special data encoding and formats need to be used based on the source of data that will receive and respond to the rewritten data request. For example, communication between a database client and server may use a vendor-specific, non-standard binary encoding, and XML and JSON response data must be reformatted as an SQL response for processing by the database client.
Public/Granted literature
- US20180137184A1 SQL INTERCEPTOR FOR USE WITH THIRD PARTY DATA ANALYTICS PACKAGES Public/Granted day:2018-05-17
Information query