# US 2019/0377742 A1 · Method for providing a client computer device with access to a database management system

> Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt

- Number: US 2019/0377742 A1
- Document ID: US20190377742A1
- Status: Published application
- Kind: A1
- Application number: 16/479,316
- Filed: 2018-01-12
- Published: 2019-12-12
- Earliest claimed: 2017-01-25
- Inventors: Nicolas De Pomereu d'Aligre
- Web page: https://patentgrep.com/patent/US20190377742A1

## CPC

- G06F 16/252: {between a Database Management System and a front-end application}
- G06F 16/2433: {Query languages}
- G06F 16/2458: Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F 16/972: {Access to data in other repository systems, e.g. legacy data or dynamic Web page generation}
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## Abstract

A method for providing a client computer device with access to a database management system via an http connection with an agent server, comprising a step of generating a query by said client device; a step of processing said query by said agent server to search said database, according to the parameters contained in said query, wherein said query is an SQL query; said agent server has a security module parametrizable by code injection, to analyze the content of said query and the parameters thereof; and conditionally ensure the transmission of said query to an extraction module; said extraction module converting the query into JDBC instructions transmitted to said database management system; said extraction module receiving in response the data in JDBC format and converting it into a JSON stream; and the agent server transmits said JSON stream to the client device.

## Claims

### Claim 1

A method for providing a client computer device with access to a database management system via an http connection with an agent server, comprising
a step of generating a query by said client device
a step of processing said query by said agent server to search said database, according to the parameters contained in said query, wherein said query is an SQL query
said agent server has a security module parametrizable by code injection,
to analyze the content of said query and the parameters thereof; and
conditionally ensure the transmission of said query to an extraction module;
said extraction module converting the query into JDBC instructions transmitted to said database management system;
said extraction module receiving in response the data in JDBC format and converting it into a JSON stream; and
the agent server transmits said JSON stream to the client device.

### Claim 2 (depends on 1)

The method for providing a client computer device with access to a database management system according to claim 1, wherein said parametrizable security module includes means for limiting the number of transmitted lines.

### Claim 3 (depends on 1)

The method for providing a client computer device with access to a database management system according to claim 1, wherein said parametrizable security module includes means for triggering an action according to said analyzed query.

### Claim 4 (depends on 3)

The method for providing a client computer device with access to a database management system according to claim 3, wherein said action comprises sending a message of revocation of a user.

### Claim 5 (depends on 3)

The method for providing a client computer device with access to a database management system according to claim 3, wherein said action comprises sending of an alert message.

### Claim 6 (depends on 1)

The method for providing a client computer device with access to a database management system according to claim 1, wherein said parametrizable security module includes a default configuration file.
